davedevelopment / phpmig

Simple migrations system for php
Other
569 stars 92 forks source link

All migrations down #116

Closed rayoplateado closed 8 years ago

rayoplateado commented 8 years ago

Hi. I have implemented phpmig in my project long time ago.

Everything goes fine, but today, i've tried to migrate a new database migration to my server, in local it works pretty well, but in my RC server i've found ALL the migrations seems to be down in 'phpmig check':

$ bin/phpmig check
PHP Warning:  array_map(): Argument #2 should be an array in /var/www/api/vendor/davedevelopment/phpmig/src/Phpmig/Adapter/Illuminate/Database.php on line 62
PHP Warning:  in_array() expects parameter 2 to be array, null given in /var/www/api/vendor/davedevelopment/phpmig/src/Phpmig/Console/Command/CheckCommand.php on line 44
PHP Warning:  in_array() expects parameter 2 to be array, null given in /var/www/api/vendor/davedevelopment/phpmig/src/Phpmig/Console/Command/CheckCommand.php on line 44
PHP Warning:  in_array() expects parameter 2 to be array, null given in /var/www/api/vendor/davedevelopment/phpmig/src/Phpmig/Console/Command/CheckCommand.php on line 44
PHP Warning:  in_array() expects parameter 2 to be array, null given in /var/www/api/vendor/davedevelopment/phpmig/src/Phpmig/Console/Command/CheckCommand.php on line 44
PHP Warning:  in_array() expects parameter 2 to be array, null given in /var/www/api/vendor/davedevelopment/phpmig/src/Phpmig/Console/Command/CheckCommand.php on line 44
PHP Warning:  in_array() expects parameter 2 to be array, null given in /var/www/api/vendor/davedevelopment/phpmig/src/Phpmig/Console/Command/CheckCommand.php on line 44
PHP Warning:  in_array() expects parameter 2 to be array, null given in /var/www/api/vendor/davedevelopment/phpmig/src/Phpmig/Console/Command/CheckCommand.php on line 44
PHP Warning:  in_array() expects parameter 2 to be array, null given in /var/www/api/vendor/davedevelopment/phpmig/src/Phpmig/Console/Command/CheckCommand.php on line 44
PHP Warning:  in_array() expects parameter 2 to be array, null given in /var/www/api/vendor/davedevelopment/phpmig/src/Phpmig/Console/Command/CheckCommand.php on line 44
PHP Warning:  in_array() expects parameter 2 to be array, null given in /var/www/api/vendor/davedevelopment/phpmig/src/Phpmig/Console/Command/CheckCommand.php on line 44
PHP Warning:  in_array() expects parameter 2 to be array, null given in /var/www/api/vendor/davedevelopment/phpmig/src/Phpmig/Console/Command/CheckCommand.php on line 44
PHP Warning:  in_array() expects parameter 2 to be array, null given in /var/www/api/vendor/davedevelopment/phpmig/src/Phpmig/Console/Command/CheckCommand.php on line 44
PHP Warning:  in_array() expects parameter 2 to be array, null given in /var/www/api/vendor/davedevelopment/phpmig/src/Phpmig/Console/Command/CheckCommand.php on line 44
PHP Warning:  in_array() expects parameter 2 to be array, null given in /var/www/api/vendor/davedevelopment/phpmig/src/Phpmig/Console/Command/CheckCommand.php on line 44
PHP Warning:  in_array() expects parameter 2 to be array, null given in /var/www/api/vendor/davedevelopment/phpmig/src/Phpmig/Console/Command/CheckCommand.php on line 44
PHP Warning:  in_array() expects parameter 2 to be array, null given in /var/www/api/vendor/davedevelopment/phpmig/src/Phpmig/Console/Command/CheckCommand.php on line 44
PHP Warning:  in_array() expects parameter 2 to be array, null given in /var/www/api/vendor/davedevelopment/phpmig/src/Phpmig/Console/Command/CheckCommand.php on line 44
PHP Warning:  in_array() expects parameter 2 to be array, null given in /var/www/api/vendor/davedevelopment/phpmig/src/Phpmig/Console/Command/CheckCommand.php on line 44
PHP Warning:  in_array() expects parameter 2 to be array, null given in /var/www/api/vendor/davedevelopment/phpmig/src/Phpmig/Console/Command/CheckCommand.php on line 44
PHP Warning:  in_array() expects parameter 2 to be array, null given in /var/www/api/vendor/davedevelopment/phpmig/src/Phpmig/Console/Command/CheckCommand.php on line 44
PHP Warning:  in_array() expects parameter 2 to be array, null given in /var/www/api/vendor/davedevelopment/phpmig/src/Phpmig/Console/Command/CheckCommand.php on line 44
PHP Warning:  in_array() expects parameter 2 to be array, null given in /var/www/api/vendor/davedevelopment/phpmig/src/Phpmig/Console/Command/CheckCommand.php on line 44
PHP Warning:  in_array() expects parameter 2 to be array, null given in /var/www/api/vendor/davedevelopment/phpmig/src/Phpmig/Console/Command/CheckCommand.php on line 44
PHP Warning:  in_array() expects parameter 2 to be array, null given in /var/www/api/vendor/davedevelopment/phpmig/src/Phpmig/Console/Command/CheckCommand.php on line 44
PHP Warning:  in_array() expects parameter 2 to be array, null given in /var/www/api/vendor/davedevelopment/phpmig/src/Phpmig/Console/Command/CheckCommand.php on line 44
PHP Warning:  in_array() expects parameter 2 to be array, null given in /var/www/api/vendor/davedevelopment/phpmig/src/Phpmig/Console/Command/CheckCommand.php on line 44
PHP Warning:  in_array() expects parameter 2 to be array, null given in /var/www/api/vendor/davedevelopment/phpmig/src/Phpmig/Console/Command/CheckCommand.php on line 44
PHP Warning:  in_array() expects parameter 2 to be array, null given in /var/www/api/vendor/davedevelopment/phpmig/src/Phpmig/Console/Command/CheckCommand.php on line 44
PHP Warning:  in_array() expects parameter 2 to be array, null given in /var/www/api/vendor/davedevelopment/phpmig/src/Phpmig/Console/Command/CheckCommand.php on line 44
PHP Warning:  in_array() expects parameter 2 to be array, null given in /var/www/api/vendor/davedevelopment/phpmig/src/Phpmig/Console/Command/CheckCommand.php on line 44
PHP Warning:  in_array() expects parameter 2 to be array, null given in /var/www/api/vendor/davedevelopment/phpmig/src/Phpmig/Console/Command/CheckCommand.php on line 44
PHP Warning:  in_array() expects parameter 2 to be array, null given in /var/www/api/vendor/davedevelopment/phpmig/src/Phpmig/Console/Command/CheckCommand.php on line 44

 Status   Migration ID    Migration Name
-----------------------------------------
   down  20150101160236  CreateDBSeedsTable
   down  20151209133248  CreateRoleTable
   down  20151209160524  CreateUserTable
   down  20151209160530  CreateCompanyTable
   down  20151209160534  CreateTeamTable
   down  20151209175730  CreateTeamUserTable
   down  20151218102533  CreateTeamBeatTable
   down  20151218103048  CreateTeamBeatLabelTable
   down  20151222134913  CreateUserTeamBeatTable
   down  20151222152231  CreateTeamBeatValue
   down  20151222161002  CreateAnnotationTypeTable
   down  20151222161128  CreateAnnotationTable
   down  20151222171550  CreateUserInvitationTable
   down  20160111134935  CreateCommercialFormTable
   down  20160121160131  CreatePriceTable
   down  20160121160155  CreateCouponTable
   down  20160123120518  CreatePaymentTable
   down  20160218153809  AlterPriceTable
   down  20160218153831  AlterPaymentTable
   down  20160304100600  AlterUserTable
   down  20160308172803  AlterTeamTable
   down  20160309123010  CreateTeamBeatQuestionTable
   down  20160324225151  TeamGroup
   down  20160427203510  Goal
   down  20160501174940  StripeOnTeam
   down  20160502232915  NameOnPrice
   down  20160514142910  DynamicTips
   down  20160629123417  Statistics
   down  20160718173455  OnboardingStatus
   down  20160809100753  RoleId
   down  20160826115237  AnnotationDate
   down  20160915122009  CompanySector

But in fact, migrations are on my database except the last one (the new one). What's happening here? Can you help me to understand?

Thanks!!

davedevelopment commented 8 years ago
PHP Warning:  in_array() expects parameter 2 to be array, null given in /var/www/api/vendor/davedevelopment/phpmig/src/Phpmig/Console/Command/CheckCommand.php on line 44

Would suggest phpmig can't fetch the run migrations from the provider, which provider are you using?

rayoplateado commented 8 years ago

Hi dave, thank you for your fast response!

I'm working with mysql. It's weird because if i try to do a migration I get a mysql error about a duplicate table (from the first migration file)

$ bin/phpmig migrate -t 20160915122009
PHP Warning:  array_map(): Argument #2 should be an array in /var/www/api/vendor/davedevelopment/phpmig/src/Phpmig/Adapter/Illuminate/Database.php on line 62
PHP Warning:  sort() expects parameter 1 to be array, null given in /var/www/api/vendor/davedevelopment/phpmig/src/Phpmig/Console/Command/MigrateCommand.php on line 62
PHP Warning:  in_array() expects parameter 2 to be array, null given in /var/www/api/vendor/davedevelopment/phpmig/src/Phpmig/Console/Command/MigrateCommand.php on line 110
 == 20150101160236 CreateDBSeedsTable migrating

  [Illuminate\Database\QueryException]
  SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'db_seeds' a
  lready exists (SQL: create table `db_seeds` (`version` varchar(255) not nul
  l) default character set utf8 collate utf8_general_ci engine = MYISAM)

  [Doctrine\DBAL\Driver\PDOException]
  SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'db_seeds' a
  lready exists

  [PDOException]
  SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'db_seeds' a
  lready exists

migrate [-s|--set SET] [-b|--bootstrap BOOTSTRAP] [-t|--target TARGET]
davedevelopment commented 8 years ago

Ah, if you are using the Illuminate adapter then it could be to do with #115, fixed yesterday.

rayoplateado commented 8 years ago

Thank you dave, gonna check this out right now!

rayoplateado commented 8 years ago

Fixed and working perfectly. Thank you, dave!!