search

davedevelopment / phpmig

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

status command show 2147483647 at missing. #80

Closed kuwa72 closed 9 years ago

kuwa72 commented 9 years ago 
$ bin/phpmig --version
phpmig version dev

$ bin/phpmig status

 Status   Migration ID    Migration Name
-----------------------------------------
   up  20150427162348  CreatePickupProduct
   up      2147483647  ** MISSING **
davedevelopment commented 9 years ago

Could you possibly ls -las your migrations dir and dump the migrations table/file?

kuwa72 commented 9 years ago 
-[4268]% bin/phpmig status -b staging_phpmig.php

 Status   Migration ID    Migration Name
-----------------------------------------
     up  20150423225527  AddConstantsForXXXXAPI
     up  20150427162348  CreatePickupProducts
     up  20150430122653  AddXXXXBatchToOutputCSV
     up  20150514132907  AddMetaKeywordsToCategoryAndGroup
     up  20150514165216  AddSystemParamaterSmallStock
     up  20150521144541  ChangeColumnNameProductCsv
     up  20150522144347  AddBreadcrumbFlag
   up      2147483647  ** MISSING **
   up      2147483647  ** MISSING **
   up      2147483647  ** MISSING **
-[4267]% ls -laf1 migrations/*.php
migrations/20150423225527_AddConstantsForXXXXAPI.php
migrations/20150427162348_CreatePickupProducts.php
migrations/20150430122653_AddXXXXBatchToOutputCSV.php
migrations/20150514132907_AddMetaKeywordsToCategoryAndGroup.php
migrations/20150514165216_AddSystemParamaterSmallStock.php
migrations/20150521144541_ChangeColumnNameProductCsv.php
migrations/20150522144347_AddBreadcrumbFlag.php
mysql> select * from migrations;
+----------------+
| version        |
+----------------+
| 20150422191817 |
| 20150423225527 |
| 20150424110954 |
| 20150427162348 |
| 20150430122653 |
| 20150514132907 |
| 20150514165216 |
| 20150520200035 |
| 20150521144541 |
| 20150522144347 |
+----------------+
10 rows in set (0.00 sec)
[4271]% php -v
PHP 5.4.39 (cli) (built: Mar 19 2015 06:25:23)
Copyright (c) 1997-2014 The PHP Group
Zend Engine v2.4.0, Copyright (c) 1998-2014 Zend Technologies
    with Zend OPcache v7.0.4, Copyright (c) 1999-2014, by Zend Technologies
    with Xdebug v2.3.2, Copyright (c) 2002-2015, by Derick Rethans

-[4272]% uname -a
Linux localhost.localdomain 2.6.32-504.12.2.el6.i686 #1 SMP Wed Mar 11 19:05:53 UTC 2015 i686 i686 i386 GNU/Linux

Limit by PHP_INT_MAX? http://stackoverflow.com/a/864402

davedevelopment commented 9 years ago

Oh it probably is max int, that's annoying. We can probably avoid casting to int somewhere and things should still work.

kuwa72 commented 9 years ago

Please close this issue, same as #81.

davedevelopment commented 9 years ago

@kuwa72 no problem! For future reference, as the original author, you should be able to close an issue yourself :)