getherbert / framework

Core Framework
http://getherbert.com/
41 stars 54 forks source link

Create table error when activing example-plug #31

Open hbhe opened 8 years ago

hbhe commented 8 years ago

in wp-config.php

define('DB_CHARSET', 'utf8mb4');
define('DB_COLLATE', ''); 

herberit will use 'utf8_general_ci collate, but it is not matched with utf8mb4 charset, Mysql error occurs

 protected function registerEloquent()
    {
        global $wpdb;

        $capsule = new Capsule($this->app);

        $capsule->addConnection([
            'driver' => 'mysql',
/*            
            'host' => DB_HOST,
            'database' => DB_NAME,
            'username' => DB_USER,
            'password' => DB_PASSWORD,
            'charset' => DB_CHARSET,
            'collation' => DB_COLLATE ?: 'utf8_general_ci',
*/            
            'host' => $wpdb->dbhost,            
            'database' => $wpdb->dbname,            
            'username' => $wpdb->dbuser,            
            'password' => $wpdb->dbpassword,            
            'charset' => $wpdb->charset,            
            'collation' => $wpdb->collate,            

            'prefix' => $wpdb->prefix
        ]);
        ....
    }
kalinichenko88 commented 7 years ago

@hbhe set DB_COLLATE 'utf8mb_unicode_ci'. Herbert will use it