search

cooperl22 / laravel-db2

laravel-db2 is a simple DB2 service provider for Laravel. It provides DB2 Connection by extending the Illuminate Database component of the laravel framework.
Other
59 stars 65 forks source link

artisan migrate:rollback exception #26

Closed robertocastro closed 2 years ago

robertocastro commented 7 years ago

Artisan command 'migrate:rollback' trigger this error : 

[Illuminate\Database\QueryException]                                                                                                                                                                                                       
  SQLSTATE[42000]: Syntax error or access violation: 0 [IBM][Pilote ODBC System i Access][DB2 for i5/OS]SQL0199 - Le mot clé EXISTS est mal placé. Eléments possibles : <FIN-INSTRUCTIO (SQLPrepare[0] at /usr/src/builddir/ext/pdo_odbc/od  
  bc_driver.c:206) (SQL: drop table if exists password_resets)
pulasthibandara commented 7 years ago

Better use $table->drop() instead of '$table->dropIfExists()' in migrations as DB2 doesn't support DROP IF EXISTS command.