Can't run migration without foreign key error

[newscloud]

What steps will reproduce the problem?

codeception/bin/yii migrate
Yii Migration Tool (based on Yii v2.0.8)

Creating migration history table "migration"...Done.
Total 7 new migrations to be applied:
m141201_013120_create_status_table
m150128_003709_extend_status_table_for_created_by
m150128_233458_extend_status_table_for_slugs
m150209_200619_extend_status_table_for_updated_by
m150209_204852_create_status_log_table
m150219_235923_create_sample_table
m160316_201654_extend_status_table_for_image

Apply the above migrations? (yes|no) [no]:yes
*** applying m141201_013120_create_status_table
> create table {{%status}} ... done (time: 0.006s)
*** applied m141201_013120_create_status_table (time: 0.023s)

*** applying m150128_003709_extend_status_table_for_created_by
> add column created_by integer NOT NULL to table {{%status}} ... done (time: 0.008s)
> add foreign key fk_status_created_by: {{%status}} (created_by) references {{%user}} (id) ...Exception 'yii\db\Exception' with message 'SQLSTATE[HY000]: General error: 1005 Can't create table 'yii2_basic_tests.#sql-98f_22' (errno: 150)
The SQL being executed was: ALTER TABLE status ADD CONSTRAINT fk_status_created_by FOREIGN KEY (created_by) REFERENCES user (id) ON DELETE CASCADE ON UPDATE CASCADE'

What's expected?

Completed migration

What do you get instead?

error above

Additional info

Adding foreign keys for the test fails.

I did a composer self-update and composer-update before re-testing. The db permissions do work, status table is created okay.

Also codeception is installed properly.

Q	A
Yii vesion
PHP version
Operating system

[samdark]

The error comes from MySQL, not from Yii. I guess you have more than a single fk_status_created_by and it should be unique.

[samdark]

Or it could be type mismatch...

[samdark]

Execute "SHOW ENGINE INNODB STATUS" right after error and look for "LATEST FOREIGN KEY ERROR".

[newscloud]

Sam, thanks for the quick reply.

Does this have to do with me running the yii tests on yii2_basic_tests db vs. my app's hello db? Hello db has user table, yii2_b_t does not. But, I was following instructions...

160630 11:48:18 INNODB MONITOR OUTPUT

LATEST FOREIGN KEY ERROR

160629 17:50:00 Error in foreign key constraint of table yii2_basic_tests/#sql-98f_2c:
FOREIGN KEY (created_by) REFERENCES user (id) ON DELETE CASCADE ON UPDATE CASCADE:
Cannot resolve table name close to:

(id) ON DELETE CASCADE ON UPDATE CASCADE

TRANSACTIONS

Trx id counter 103777
Purge done for trx's n:o < 103775 undo n:o < 0
History list length 1686
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0, not started
MySQL thread id 52, OS thread handle 0x7000007ae000, query id 773 localhost root

SHOW ENGINE INNODB STATUS

[samdark]

Based on the error, it's using correct database and another one can't affect it.

[samdark]

Reading what it says it seems it can't resolve user table name. Does user table exists at the moment you're trying to reference it?

[newscloud]

Sorry Sam, I thought these were internal codeception-oriented Yii migrations because following the documentation, I did
cd tests
codeception/bin/yii migrate

However, it is instead running my apps own migrations.

a) Is there documentation for exact steps for running codeception tests against Yii Framework and properly configuring yii2_basic_tests?

b) Also from my email, I'm unable to get functional or unit tests working either. It would be helpful to see documentation for creating an example functional test or unit test. Simple acceptance tests work fine.

[samdark]

a) Yes: https://github.com/yiisoft/yii2-app-basic/blob/master/tests/README.md

b) There were some errors in unit tests caused by phpunit deprecations. I've fixed that.

Other than that it seems to be fine:

Install basic app, then install codeception and plugins (you may have these globally, I did not so installed these locally):

composer require codeception/codeception 
composer require codeception/verify
composer require codeception/specify

Build codeception actors:

cd app_dir/tests
./../vendor/codeception/codeception/codecept build (it could be just codecept build if you have it installed globally) 
cd app_dir
./yii serve (running web server is required for acceptance tests to work)

Now open another shell w/o closing web server.

cd app_dir/tests
./../vendor/codeception/codeception/codecept run

[newscloud]

Sam, running ./yii serve fixes running the tests when I run them from the /hello directory - but not when I try to run actual login code and access the default login test library

a) Are you supposed to codecept run from app-basic/tests all the time? why are there app-basic/tests/acceptance, functional and unit directories as well as app-basic/tests/codeception/acceptance, functional and unit ? What's the difference? Should I delete some?

b) The migration error still occurs but it may be due to dektrium usage. See http://pastebin.com/hyHbgK6y . I deleted all the tables in the hello db and ran migration from scratch again. And, then, I deleted all the tables in yii2-app-basic as well.

c) When I try to add real code to the app-basic/tests/functional LoginCept.php, it breaks.

see('Login', 'h1'); $ cd ~/sites/hello $ codecept run Codeception PHP Testing Framework v2.1.11 Powered by PHPUnit 5.3.5 by Sebastian Bergmann and contributors. Acceptance Tests (1) --------------------------------------------------------------------------------------- ## Ensure that frontpage works (WelcomeCept) Ok Functional Tests (1) ---------------------------------------------------------- Running LoginCept ... FATAL ERROR. TESTS NOT FINISHED. Class 'tests\codeception_pages\LoginPage' not found in /Users/Jeff/Sites/hello/tests/functional/LoginCept.php:5 If I go to $cd ~/sites/hello/tests, then I get the error in the PasteBin that's specific to Dektrium. d) Note: on https://github.com/yiisoft/yii2-app-basic/blob/master/tests/README.md, I suggest rewriting the instruction for "cd tests" ahead of codeception/bin/yii migrate. "The command needs to be run in the tests directory. " isn't as clear as it could be.