-
Notifications
You must be signed in to change notification settings - Fork 1.7k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Migration failed at update 1.9 #5204
Comments
There must have been a previous error during the migration. Can you take a look at the |
Yes of course: |
@smitti Can you please check that all tables are using the same table engine (InnoDB) and the charset Then please try to delete the tables:
And try the migration again. |
@yurabakhtin Can you please take a look here? |
I have the same problem and i have try to delete: The problem isn't fixed yet, the table engine are all InnoDB with the charset utf8mb4_unicode_ci. |
@Bust3r666 Then what do you get for an error? |
this is the error generated after delete contentcontainer_tag and contentcontainer_tag_relation |
Sounds like it's related to the 1.8 migration error for those using normal MySQL instead of InnoDB and MariaDB |
@Bust3r666 Can you please delete: And send us the error message again? |
This issue has been automatically closed because there has been no response to our request for more information from the original author. With only the information that is currently in the issue, we don't have enough information to take action. Please reach out if you have or find the answers we need so that we can investigate further. |
Thank https://github.com/luke- for support. My problem is solved. |
Hi, i have delete: But now give me this error. ` Yii Migration Tool (based on Yii v2.0.40) Total 3 new migrations to be applied: *** applying m210211_051243_container_tag 0 from 3 migrations were applied. Migration failed. The rest of the migrations are canceled.` |
Sorry, i din't understand to implement it. I need to change \humhub\components\Migration.php code? |
@yurabakhtin Thanks! @Bust3r666 With 1.9.1 your issue should be solved. |
Hi, I've updated to 1.9.1 and no have resolved my problem with database. I tried to do a test with test server with latest update and still not working. What can i try to do to solve the problem? The error is below attached:
|
@Bust011r Can you try to update to 1.9.2? |
Yes, i've updated without errors but the error with migration persist and there aren't error in db.
|
What steps will reproduce the problem?
Updating to 1.9 after issue #4946 (propably important?)
What is the expected result?
Total 3 new migrations to be applied:
m210211_051243_container_tag
m210331_115144_default_timezone
m210506_060737_profile_field_directory_filter
*** applying m210211_051243_container_tag
> create table contentcontainer_tag ...Exception: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'contentcontainer_tag' already exists
The SQL being executed was: CREATE TABLE
contentcontainer_tag
(id
int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,name
varchar(100) NOT NULL,contentcontainer_class
char(60) NOT NULL) (/is/htdocs/wp11141389_5VUUJ7N9W6/b-u-p-daheim.de/protected/vendor/yiisoft/yii2/db/Schema.php:678)
#0 /is/htdocs/wp11141389_5VUUJ7N9W6/b-u-p-daheim.de/protected/vendor/yiisoft/yii2/db/Command.php(1304): yii\db\Schema->convertException(Object(PDOException), 'CREATE TABLE
c...') #1 /is/htdocs/wp11141389_5VUUJ7N9W6/b-u-p-daheim.de/protected/vendor/yiisoft/yii2/db/Command.php(1099): yii\db\Command->internalExecute('CREATE TABLE
c...')#2 /is/htdocs/wp11141389_5VUUJ7N9W6/b-u-p-daheim.de/protected/vendor/yiisoft/yii2/db/Migration.php(323): yii\db\Command->execute()
#3 /is/htdocs/wp11141389_5VUUJ7N9W6/b-u-p-daheim.de/protected/humhub/modules/content/migrations/m210211_051243_container_tag.php(23): yii\db\Migration->createTable('contentcontaine...', Array)
#4 /is/htdocs/wp11141389_5VUUJ7N9W6/b-u-p-daheim.de/protected/vendor/yiisoft/yii2/db/Migration.php(114): m210211_051243_container_tag->safeUp()
#5 /is/htdocs/wp11141389_5VUUJ7N9W6/b-u-p-daheim.de/protected/vendor/yiisoft/yii2/console/controllers/BaseMigrateController.php(744): yii\db\Migration->up()
#6 /is/htdocs/wp11141389_5VUUJ7N9W6/b-u-p-daheim.de/protected/vendor/yiisoft/yii2/console/controllers/BaseMigrateController.php(202): yii\console\controllers\BaseMigrateController->migrateUp('m210211_051243_...')
#7 [internal function]: yii\console\controllers\BaseMigrateController->actionUp(0)
#8 /is/htdocs/wp11141389_5VUUJ7N9W6/b-u-p-daheim.de/protected/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array(Array, Array)
#9 /is/htdocs/wp11141389_5VUUJ7N9W6/b-u-p-daheim.de/protected/vendor/yiisoft/yii2/base/Controller.php(181): yii\base\InlineAction->runWithParams(Array)
#10 /is/htdocs/wp11141389_5VUUJ7N9W6/b-u-p-daheim.de/protected/vendor/yiisoft/yii2/console/Controller.php(184): yii\base\Controller->runAction('up', Array)
#11 /is/htdocs/wp11141389_5VUUJ7N9W6/b-u-p-daheim.de/protected/humhub/commands/MigrateController.php(198): yii\console\Controller->runAction('up')
#12 /is/htdocs/wp11141389_5VUUJ7N9W6/b-u-p-daheim.de/protected/humhub/modules/admin/controllers/InformationController.php(95): humhub\commands\MigrateController::webMigrateAll()
#13 [internal function]: humhub\modules\admin\controllers\InformationController->actionDatabase()
#14 /is/htdocs/wp11141389_5VUUJ7N9W6/b-u-p-daheim.de/protected/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array(Array, Array)
#15 /is/htdocs/wp11141389_5VUUJ7N9W6/b-u-p-daheim.de/protected/vendor/yiisoft/yii2/base/Controller.php(181): yii\base\InlineAction->runWithParams(Array)
#16 /is/htdocs/wp11141389_5VUUJ7N9W6/b-u-p-daheim.de/protected/vendor/yiisoft/yii2/base/Module.php(534): yii\base\Controller->runAction('database', Array)
#17 /is/htdocs/wp11141389_5VUUJ7N9W6/b-u-p-daheim.de/protected/vendor/yiisoft/yii2/web/Application.php(104): yii\base\Module->runAction('admin/informati...', Array)
#18 /is/htdocs/wp11141389_5VUUJ7N9W6/b-u-p-daheim.de/protected/vendor/yiisoft/yii2/base/Application.php(392): yii\web\Application->handleRequest(Object(humhub\components\Request))
#19 /is/htdocs/wp11141389_5VUUJ7N9W6/b-u-p-daheim.de/index.php(25): yii\base\Application->run()
#20 {main}
*** failed to apply m210211_051243_container_tag (time: 0.001s)
0 from 3 migrations were applied.
Migration failed. The rest of the migrations are canceled.
What do you get instead?
The section People won´t work, an error is shown
Additional info
The text was updated successfully, but these errors were encountered: