{"action":"created","issue":{"url":"https://api.github.com/repos/humhub/humhub/issues/1935","repository_url":"https://api.github.com/repos/humhub/humhub","labels_url":"https://api.github.com/repos/humhub/humhub/issues/1935/labels{/name}","comments_url":"https://api.github.com/repos/humhub/humhub/issues/1935/comments","events_url":"https://api.github.com/repos/humhub/humhub/issues/1935/events","html_url":"https://github.com/humhub/humhub/issues/1935","id":171699763,"number":1935,"title":"Still trying to update.. to the last version , no luck","user":{"login":"devcline","id":617020,"avatar_url":"https://avatars.githubusercontent.com/u/617020?v=3","gravatar_id":"","url":"https://api.github.com/users/devcline","html_url":"https://github.com/devcline","followers_url":"https://api.github.com/users/devcline/followers","following_url":"https://api.github.com/users/devcline/following{/other_user}","gists_url":"https://api.github.com/users/devcline/gists{/gist_id}","starred_url":"https://api.github.com/users/devcline/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/devcline/subscriptions","organizations_url":"https://api.github.com/users/devcline/orgs","repos_url":"https://api.github.com/users/devcline/repos","events_url":"https://api.github.com/users/devcline/events{/privacy}","received_events_url":"https://api.github.com/users/devcline/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2016-08-17T16:18:21Z","updated_at":"2016-08-17T17:33:42Z","closed_at":null,"body":"Ok i will try to structure everything i do.\r\n1. i have a  1.0.1 version with all modules updated, self test is ok and everything is upto date\r\n2. I do a update to v1.1.0-beta.1\r\n3. i get the error.\r\n\r\n```\r\nError!\r\nSQLSTATE[42S01]: Base table or view already exists: 1050 Table 'user_auth' already exists The SQL being executed was: CREATE TABLE `user_auth` ( `id` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, `user_id` int(11) NOT NULL, `source` varchar(255) NOT NULL, `source_id` varchar(255) NOT NULL )\r\n```\r\n\r\n4. I do _php yii migrate/up --includeModuleMigrations=1_ command in protected folder throu a console and i get a \r\n\r\n```\r\nYii Migration Tool (based on Yii v2.0.8)\r\n\r\nTotal 14 new migrations to be applied:\r\n        m151226_164234_authclient\r\n        m160216_160119_initial\r\n        m160217_161220_addCanLeaveFlag\r\n        m160220_013525_contentcontainer_id\r\n        m160221_222312_public_permission_change\r\n        m160225_180229_remove_website\r\n        m160229_162959_multiusergroups\r\n        m160309_141222_longerUserName\r\n        m160408_100725_rename_groupadmin_to_manager\r\n        m160507_202611_settings\r\n        m160508_005740_settings_cleanup\r\n        m160509_214811_spaceurl\r\n        m160517_132535_group\r\n        m160523_105732_profile_searchable\r\n\r\nApply the above migrations? (yes|no) [no]:yes\r\n*** applying m151226_164234_authclient\r\n    > create table user_auth ...Exception 'yii\\db\\Exception' with message 'SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'user_auth' already exists\r\nThe SQL being executed was: CREATE TABLE `user_auth` (\r\n        `id` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,\r\n        `user_id` int(11) NOT NULL,\r\n        `source` varchar(255) NOT NULL,\r\n        `source_id` varchar(255) NOT NULL\r\n)'\r\n\r\nin /home/host/public_html/host/lab/protected/vendor/yiisoft/yii2/db/Schema.php:633\r\n\r\nError Info:\r\nArray\r\n(\r\n    [0] => 42S01\r\n    [1] => 1050\r\n    [2] => Table 'user_auth' already exists\r\n)\r\n\r\nStack trace:\r\n#0 /home/host/public_html/host/lab/protected/vendor/yiisoft/yii2/db/Command.php(854): yii\\db\\Schema->convertException(Object(PDOException), 'CREATE TABLE `u...')\r\n#1 /home/host/public_html/host/lab/protected/vendor/yiisoft/yii2/db/Migration.php(260): yii\\db\\Command->execute()\r\n#2 /home/host/public_html/host/lab/protected/humhub/modules/user/migrations/m151226_164234_authclient.php(16): yii\\db\\Migration->createTable('user_auth', Array)\r\n#3 /home/host/public_html/host/lab/protected/vendor/yiisoft/yii2/console/controllers/BaseMigrateController.php(509): m151226_164234_authclient->up()\r\n#4 /home/host/public_html/host/lab/protected/vendor/yiisoft/yii2/console/controllers/BaseMigrateController.php(130): yii\\console\\controllers\\BaseMigrateController->migrateUp('m151226_164234_...')\r\n#5 [internal function]: yii\\console\\controllers\\BaseMigrateController->actionUp(0)\r\n#6 /home/host/public_html/host/lab/protected/vendor/yiisoft/yii2/base/InlineAction.php(55): call_user_func_array(Array, Array)\r\n#7 /home/host/public_html/host/lab/protected/vendor/yiisoft/yii2/base/Controller.php(154): yii\\base\\InlineAction->runWithParams(Array)\r\n#8 /home/host/public_html/host/lab/protected/vendor/yiisoft/yii2/console/Controller.php(119): yii\\base\\Controller->runAction('up', Array)\r\n#9 /home/host/public_html/host/lab/protected/vendor/yiisoft/yii2/base/Module.php(454): yii\\console\\Controller->runAction('up', Array)\r\n#10 /home/host/public_html/host/lab/protected/vendor/yiisoft/yii2/console/Application.php(176): yii\\base\\Module->runAction('migrate/up', Array)\r\n#11 /home/host/public_html/host/lab/protected/vendor/yiisoft/yii2/console/Application.php(143): yii\\console\\Application->runAction('migrate/up', Array)\r\n#12 /home/host/public_html/host/lab/protected/vendor/yiisoft/yii2/base/Application.php(375): yii\\console\\Application->handleRequest(Object(yii\\console\\Request))\r\n#13 /home/host/public_html/host/lab/protected/yii(29): yii\\base\\Application->run()\r\n#14 {main}\r\n\r\n```\r\n\r\nAnd if i delete user_auth\r\n\r\ni get \r\n\r\n```\r\n\r\nApply the above migrations? (yes|no) [no]:yes\r\n*** applying m151226_164234_authclient\r\n    > create table user_auth ... done (time: 0.047s)\r\n    > add foreign key fk_user_id: user_auth (user_id) references user (id) ...Exception 'yii\\db\\Exception' with message 'SQLSTATE[HY000]: General error: 1005 Can't create table `host_lab`.`#sql-85080_1141a3f` (errno: 150 \"Foreign key constraint is incorrectly formed\")\r\nThe SQL being executed was: ALTER TABLE `user_auth` ADD CONSTRAINT `fk_user_id` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE'\r\n\r\nin /home/host/public_html/host/lab/protected/vendor/yiisoft/yii2/db/Schema.php:633\r\n\r\nError Info:\r\nArray\r\n(\r\n    [0] => HY000\r\n    [1] => 1005\r\n    [2] => Can't create table `host_lab`.`#sql-85080_1141a3f` (errno: 150 \"Foreign key constraint is incorrectly formed\")\r\n)\r\n\r\nStack trace:\r\n#0 /home/host/public_html/host/lab/protected/vendor/yiisoft/yii2/db/Command.php(854): yii\\db\\Schema->convertException(Object(PDOException), 'ALTER TABLE `us...')\r\n#1 /home/host/public_html/host/lab/protected/vendor/yiisoft/yii2/db/Migration.php(414): yii\\db\\Command->execute()\r\n#2 /home/host/public_html/host/lab/protected/humhub/modules/user/migrations/m151226_164234_authclient.php(17): yii\\db\\Migration->addForeignKey('fk_user_id', 'user_auth', 'user_id', 'user', 'id', 'CASCADE', 'CASCADE')\r\n#3 /home/host/public_html/host/lab/protected/vendor/yiisoft/yii2/console/controllers/BaseMigrateController.php(509): m151226_164234_authclient->up()\r\n#4 /home/host/public_html/host/lab/protected/vendor/yiisoft/yii2/console/controllers/BaseMigrateController.php(130): yii\\console\\controllers\\BaseMigrateController->migrateUp('m151226_164234_...')\r\n#5 [internal function]: yii\\console\\controllers\\BaseMigrateController->actionUp(0)\r\n#6 /home/host/public_html/host/lab/protected/vendor/yiisoft/yii2/base/InlineAction.php(55): call_user_func_array(Array, Array)\r\n#7 /home/host/public_html/host/lab/protected/vendor/yiisoft/yii2/base/Controller.php(154): yii\\base\\InlineAction->runWithParams(Array)\r\n#8 /home/host/public_html/host/lab/protected/vendor/yiisoft/yii2/console/Controller.php(119): yii\\base\\Controller->runAction('up', Array)\r\n#9 /home/host/public_html/host/lab/protected/vendor/yiisoft/yii2/base/Module.php(454): yii\\console\\Controller->runAction('up', Array)\r\n#10 /home/host/public_html/host/lab/protected/vendor/yiisoft/yii2/console/Application.php(176): yii\\base\\Module->runAction('migrate/up', Array)\r\n#11 /home/host/public_html/host/lab/protected/vendor/yiisoft/yii2/console/Application.php(143): yii\\console\\Application->runAction('migrate/up', Array)\r\n#12 /home/host/public_html/host/lab/protected/vendor/yiisoft/yii2/base/Application.php(375): yii\\console\\Application->handleRequest(Object(yii\\console\\Request))\r\n#13 /home/host/public_html/host/lab/protected/yii(29): yii\\base\\Application->run()\r\n#14 {main}\r\n\r\n\r\n\r\n```\r\n\r\nand the the error after log in \r\n\r\n```\r\nPHP Strict Warning – yii\\base\\ErrorException\r\n\r\nNon-static method humhub\\modules\\user\\models\\Setting::getModule() should not be called statically\r\n\r\n```\r\n_i want to properly install a new version with all my user and data databases and files._\r\nthanks"},"comment":{"url":"https://api.github.com/repos/humhub/humhub/issues/comments/240486634","html_url":"https://github.com/humhub/humhub/issues/1935#issuecomment-240486634","issue_url":"https://api.github.com/repos/humhub/humhub/issues/1935","id":240486634,"user":{"login":"devcline","id":617020,"avatar_url":"https://avatars.githubusercontent.com/u/617020?v=3","gravatar_id":"","url":"https://api.github.com/users/devcline","html_url":"https://github.com/devcline","followers_url":"https://api.github.com/users/devcline/followers","following_url":"https://api.github.com/users/devcline/following{/other_user}","gists_url":"https://api.github.com/users/devcline/gists{/gist_id}","starred_url":"https://api.github.com/users/devcline/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/devcline/subscriptions","organizations_url":"https://api.github.com/users/devcline/orgs","repos_url":"https://api.github.com/users/devcline/repos","events_url":"https://api.github.com/users/devcline/events{/privacy}","received_events_url":"https://api.github.com/users/devcline/received_events","type":"User","site_admin":false},"created_at":"2016-08-17T17:33:42Z","updated_at":"2016-08-17T17:33:42Z","body":"```\r\nServer: Localhost via UNIX socket\r\nServer type: MariaDB\r\nServer version: 10.1.14-MariaDB - MariaDB Server\r\nProtocol version: 10\r\nUser: host@localhost\r\nServer charset: UTF-8 Unicode (utf8)\r\nWeb server\r\n\r\ncpsrvd 11.58.0.20\r\nDatabase client version: libmysql - 5.1.73\r\nPHP extension: mysqli Documentation\r\n```"}}
{"actor":{"display_login":"devcline"}}