Как изменить версию MySQL?

Question

Space @ruslite

MySQL
Yii

Как изменить версию MySQL?

Создаются таблицы. Выдает в консоле ошибку (ниже). Поискал ответ и нашел такое: "скрипт используется для запуска более старых версий MySQL (где по умолчанию является myisam) а твоя новее (где значение по умолчанию-innodb". Вопрос: как можно это исправить?

Лог ошибок

> create unique index account_unique on {{%account}} (provider,client_id) ...Exception 'yii\db                \Exception' with message 'SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key wa                s too long; max key length is 1000 bytes
The SQL being executed was: CREATE UNIQUE INDEX `account_unique` ON `account` (`provider`, `client                _id`)'

in /var/www/admin/www/mpro.com/vendor/yiisoft/yii2/db/Schema.php:595

Error Info:
Array
(
    [0] => 42000
    [1] => 1071
    [2] => Specified key was too long; max key length is 1000 bytes
)

Stack trace:
#0 /var/www/admin/www/mpro.com/vendor/yiisoft/yii2/db/Command.php(779): yii\db\Schema->convertException(Object(PDOException), 'CREATE UNIQUE I...')
#1 /var/www/admin/www/mpro.com/vendor/yiisoft/yii2/db/Migration.php(420): yii\db\Command->execute()
#2 /var/www/admin/www/mpro.com/vendor/dektrium/yii2-user/migrations/m140403_174025_create_account_table.php(30): yii\db\Migration->createIndex('account_unique', '{{%account}}', Array, true)
#3 /var/www/admin/www/mpro.com/vendor/yiisoft/yii2/console/controllers/BaseMigrateController.php(492): m140403_174025_create_account_table->up()
#4 /var/www/admin/www/mpro.com/vendor/yiisoft/yii2/console/controllers/BaseMigrateController.php(129): yii\console\controllers\BaseMigrateController->migrateUp('m140403_174025_...')
#5 [internal function]: yii\console\controllers\BaseMigrateController->actionUp(0)
#6 /var/www/admin/www/mpro.com/vendor/yiisoft/yii2/base/InlineAction.php(55): call_user_func_array(Array, Array)
#7 /var/www/admin/www/mpro.com/vendor/yiisoft/yii2/base/Controller.php(151): yii\base\InlineAction->runWithParams(Array)
#8 /var/www/admin/www/mpro.com/vendor/yiisoft/yii2/console/Controller.php(91): yii\base\Controller->runAction('up', Array)
#9 /var/www/admin/www/mpro.com/vendor/yiisoft/yii2/base/Module.php(455): yii\console\Controller->runAction('up', Array)
#10 /var/www/admin/www/mpro.com/vendor/yiisoft/yii2/console/Application.php(161): yii\base\Module->runAction('migrate/up', Array)
#11 /var/www/admin/www/mpro.com/vendor/yiisoft/yii2/console/Application.php(137): yii\console\Application->runAction('migrate/up', Array)
#12 /var/www/admin/www/mpro.com/vendor/yiisoft/yii2/base/Application.php(375): yii\console\Application->handleRequest(Object(yii\console\Request))
#13 /var/www/admin/www/mpro.com/yii(23): yii\base\Application->run()
#14 {main}

Вопрос задан более трёх лет назад
2312 просмотров

Комментировать

Подписаться 2 Оценить Комментировать

Решения вопроса 1

2 комментария

Space @ruslite Автор вопроса

Теперь другое

> create table {{%account}} ...Exception 'yii\db\Exception' with message 'SQ                LSTATE[42S01]: Base table or view already exists: 1050 Table 'account' already e                xists
The SQL being executed was: CREATE TABLE `account` (
        `id` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
        `user_id` int(11),
        `provider` varchar(255) NOT NULL,
        `client_id` varchar(255) NOT NULL,
        `properties` text
) CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE=InnoDB'

in /var/www/admin/www/mpro.com/vendor/yiisoft/yii2/db/Schema.php:595

Error Info:
Array
(
    [0] => 42S01
    [1] => 1050
    [2] => Table 'account' already exists
)

Stack trace:
#0 /var/www/admin/www/mpro.com/vendor/yiisoft/yii2/db/Command.php(779): yii\db\S                chema->convertException(Object(PDOException), 'CREATE TABLE `a...')
#1 /var/www/admin/www/mpro.com/vendor/yiisoft/yii2/db/Migration.php(248): yii\db                \Command->execute()
#2 /var/www/admin/www/mpro.com/vendor/dektrium/yii2-user/migrations/m140403_1740                25_create_account_table.php(28): yii\db\Migration->createTable('{{%account}}', A                rray, 'CHARACTER SET u...')
#3 /var/www/admin/www/mpro.com/vendor/yiisoft/yii2/console/controllers/BaseMigra                teController.php(492): m140403_174025_create_account_table->up()
#4 /var/www/admin/www/mpro.com/vendor/yiisoft/yii2/console/controllers/BaseMigra                teController.php(129): yii\console\controllers\BaseMigrateController->migrateUp(                'm140403_174025_...')
#5 [internal function]: yii\console\controllers\BaseMigrateController->actionUp(                0)
#6 /var/www/admin/www/mpro.com/vendor/yiisoft/yii2/base/InlineAction.php(55): ca                ll_user_func_array(Array, Array)
#7 /var/www/admin/www/mpro.com/vendor/yiisoft/yii2/base/Controller.php(151): yii                \base\InlineAction->runWithParams(Array)
#8 /var/www/admin/www/mpro.com/vendor/yiisoft/yii2/console/Controller.php(91): y                ii\base\Controller->runAction('up', Array)
#9 /var/www/admin/www/mpro.com/vendor/yiisoft/yii2/base/Module.php(455): yii\con                sole\Controller->runAction('up', Array)
#10 /var/www/admin/www/mpro.com/vendor/yiisoft/yii2/console/Application.php(161)                : yii\base\Module->runAction('migrate/up', Array)
#11 /var/www/admin/www/mpro.com/vendor/yiisoft/yii2/console/Application.php(137)                : yii\console\Application->runAction('migrate/up', Array)
#12 /var/www/admin/www/mpro.com/vendor/yiisoft/yii2/base/Application.php(375): y                ii\console\Application->handleRequest(Object(yii\console\Request))
#13 /var/www/admin/www/mpro.com/yii(23): yii\base\Application->run()
#14 {main}

Написано более трёх лет назад