Skip to content
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... #206

Open
rizrob66 opened this issue Jul 5, 2019 · 4 comments
Open

migration failed... #206

rizrob66 opened this issue Jul 5, 2019 · 4 comments

Comments

@rizrob66
Copy link

rizrob66 commented Jul 5, 2019

Hello,
when I do migrate this error appear:

m141207_001649_create_basic_user_permissions

Apply the above migrations? (yes|no) [no]:yes
*** applying m140608_173539_create_user_table
> create table ...Exception: SQLSTATE[42000]: Syntax error or access violation: 1103 Incorrect table name ''
The SQL being executed was: CREATE TABLE `` (
id int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,

Could you help me?

@Dezyderyjczyk
Copy link

My database is empty

/new> ./yii migrate --migrationPath=vendor/webvimark/module-user-management/migrations/
Yii Migration Tool (based on Yii v2.0.22)

Total 10 new migrations to be applied:
m140608_173539_create_user_table
m140611_133903_init_rbac
m140808_073114_create_auth_item_group_table
m140809_072112_insert_superadmin_to_user
m140809_073114_insert_common_permisison_to_auth_item
m141023_141535_create_user_visit_log
m141116_115804_add_bind_to_ip_and_registration_ip_to_user
m141121_194858_split_browser_and_os_column
m141201_220516_add_email_and_email_confirmed_to_user
m141207_001649_create_basic_user_permissions

Apply the above migrations? (yes|no) [no]:yes
*** applying m140608_173539_create_user_table
Exception: Trying to get property 'user_table' of non-object (/new/vendor/webvimark/module-user-management/migrations/m140608_173539_create_user_table.php:18)
#0 /new/vendor/yiisoft/yii2/console/controllers/BaseMigrateController.php(725): m140608_173539_create_user_table->up()
#1 /new/vendor/yiisoft/yii2/console/controllers/BaseMigrateController.php(199): yii\console\controllers\MigrateController->migrateUp()
#2 /new/vendor/yiisoft/yii2/base/InlineAction.php(57): yii\console\controllers\MigrateController->actionUp()
#3 /new/vendor/yiisoft/yii2/base/InlineAction.php(57): ::call_user_func_array:{/new/vendor/yiisoft/yii2/base/InlineAction.php:57}()
#4 /new/vendor/yiisoft/yii2/base/Controller.php(157): yii\base\InlineAction->runWithParams()
#5 /new/vendor/yiisoft/yii2/console/Controller.php(148): yii\console\controllers\MigrateController->runAction()
#6 /new/vendor/yiisoft/yii2/base/Module.php(528): yii\console\controllers\MigrateController->runAction()
#7 /new/vendor/yiisoft/yii2/console/Application.php(180): yii\console\Application->runAction()
#8 /new/vendor/yiisoft/yii2/console/Application.php(147): yii\console\Application->runAction()
#9 /new/vendor/yiisoft/yii2/base/Application.php(386): yii\console\Application->handleRequest()
#10 /new/yii(20): yii\console\Application->run()
#11 {main}
*** failed to apply m140608_173539_create_user_table (time: 0.037s)
0 from 10 migrations were applied.
Migration failed. The rest of the migrations are canceled.

@paskuale75
Copy link

Sure you followed all the steps? He does it to me without problems

@paskuale75
Copy link

paskuale75 commented Dec 1, 2019

strangely now I have encountered an exception,

*** applying m141207_001649_create_basic_user_permissions
Exception: Invalid path alias: @ webroot / assets (/var/www/html/test-application/vendor/yiisoft/yii2/BaseYii.php:154)

seems to be a baseUrl problem in the console, then in console -> config-> components add this:

'urlManager' => [
            'baseUrl' => 'http://test-application'
]

and in console->config -> aliases:

'@web'      => dirname(dirname(__DIR__)) . '/frontend/web',
 '@webroot'  => dirname(dirname(__DIR__)) . '/frontend/web'

@donmedo2000
Copy link

My database is empty

/new> ./yii migrate --migrationPath=vendor/webvimark/module-user-management/migrations/
Yii Migration Tool (based on Yii v2.0.22)

Total 10 new migrations to be applied:
m140608_173539_create_user_table
m140611_133903_init_rbac
m140808_073114_create_auth_item_group_table
m140809_072112_insert_superadmin_to_user
m140809_073114_insert_common_permisison_to_auth_item
m141023_141535_create_user_visit_log
m141116_115804_add_bind_to_ip_and_registration_ip_to_user
m141121_194858_split_browser_and_os_column
m141201_220516_add_email_and_email_confirmed_to_user
m141207_001649_create_basic_user_permissions

Apply the above migrations? (yes|no) [no]:yes
*** applying m140608_173539_create_user_table
Exception: Trying to get property 'user_table' of non-object (/new/vendor/webvimark/module-user-management/migrations/m140608_173539_create_user_table.php:18)
#0 /new/vendor/yiisoft/yii2/console/controllers/BaseMigrateController.php(725): m140608_173539_create_user_table->up()
#1 /new/vendor/yiisoft/yii2/console/controllers/BaseMigrateController.php(199): yii\console\controllers\MigrateController->migrateUp()
#2 /new/vendor/yiisoft/yii2/base/InlineAction.php(57): yii\console\controllers\MigrateController->actionUp()
#3 /new/vendor/yiisoft/yii2/base/InlineAction.php(57): ::call_user_func_array:{/new/vendor/yiisoft/yii2/base/InlineAction.php:57}()
#4 /new/vendor/yiisoft/yii2/base/Controller.php(157): yii\base\InlineAction->runWithParams()
#5 /new/vendor/yiisoft/yii2/console/Controller.php(148): yii\console\controllers\MigrateController->runAction()
#6 /new/vendor/yiisoft/yii2/base/Module.php(528): yii\console\controllers\MigrateController->runAction()
#7 /new/vendor/yiisoft/yii2/console/Application.php(180): yii\console\Application->runAction()
#8 /new/vendor/yiisoft/yii2/console/Application.php(147): yii\console\Application->runAction()
#9 /new/vendor/yiisoft/yii2/base/Application.php(386): yii\console\Application->handleRequest()
#10 /new/yii(20): yii\console\Application->run()
#11 {main}
*** failed to apply m140608_173539_create_user_table (time: 0.037s)
0 from 10 migrations were applied.
Migration failed. The rest of the migrations are canceled.

Got thesame errors too but worked around by substituting table names directly in order to keep moving. I think making the table names in the module static might be an option

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

4 participants