saba_kamali
November 8th, 2014, 01:05
سلام من تازه دارم با مفهوم migration در yii آشنا میشم بعد از اینکه با دستور php yiic migrate create create_news_table یه فایل migration ساختم
توی تابع up دستورات اسکیوال برای ساخت جدول رونوشتم حالا وقتی دستورphp yiic migrate up را وارد میکنم با خطای زیر مواجه میشم ممنون میشم اگه کسی میدونه مشکل چیه راهنماییم کنه
C:\Users>cd C:\xampp\htdocs\Yii Project\migration\protected C:\xampp\htdocs\Yii Project\migration\protected>php yiic migrate up Yii Migration Tool v1.0 (based on Yii v1.1.13) Total 1 new migration to be applied: m141107_194416_create_project_table Apply the above migration? (yes|no) [no]:yes*** applying m141107_194416_create_project_table > create table tbl_project ...exception 'CDbException' with message 'CDbCommand failed to execute the SQL statement: CDbCommand failed to prepare the SQL statement: SQLSTATE[HY000]: General error: 1 near "ENGINE": syntax error. The SQLstatement executed was: CREATE TABLE 'tbl_project' ( "id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "description" text NOT NULL, "create_time" datetime DEFAULT NULL, "create_user_id" int(11) DEFAULT NULL, "update_time" datetime DEFAULT NULL, "update_user_id" int(11) DEFAULT NULL) ENGINE=InnoDB' in C:\xampp\htdocs\framework\db\CDbCommand.php:357Sta ck trace:#0 C:\xampp\htdocs\framework\db\CDbCommand.php(1321): CDbCommand->execute()#1 C:\xampp\htdocs\framework\db\CDbMigration.php(228) : CDbCommand->createTable('tbl_project', Array, 'ENGINE=InnoDB')#2 C:\xampp\htdocs\Yii Project\migration\protected\migrations\m141107_194 416_create_project_table.php(15): CDbMigration->createTable('tbl_project', Array, 'ENGINE=InnoDB')#3 C:\xampp\htdocs\framework\cli\commands\MigrateComm and.php(385): m141107_194416_create_project_table->up()#4 C:\xampp\htdocs\framework\cli\commands\MigrateComm and.php(109): MigrateCommand->migrateUp('m141107_194416_...')#5 [internal function]: MigrateCommand->actionUp(Array)#6 C:\xampp\htdocs\framework\console\CConsoleCommand. php(172): ReflectionMethod->invokeArgs(Object(MigrateCommand), Array)#7 C:\xampp\htdocs\framework\console\CConsoleCommandR unner.php(67): CConsoleCommand->run(Array)#8 C:\xampp\htdocs\framework\console\CConsoleApplicat ion.php(91): CConsoleCommandRunner->run(Array)#9 C:\xampp\htdocs\framework\base\CApplication.php(16 9): CConsoleApplication->processRequest()#10 C:\xampp\htdocs\framework\yiic.php(33): CApplication->run()#11 C:\xampp\htdocs\Yii Project\migration\protected\yiic.php(7): require_once('C:\xampp\htdocs...')#12 C:\xampp\htdocs\Yii Project\migration\protected\yiic(4): require_once('C:\xampp\htdocs...')#13 {main}
توی تابع up دستورات اسکیوال برای ساخت جدول رونوشتم حالا وقتی دستورphp yiic migrate up را وارد میکنم با خطای زیر مواجه میشم ممنون میشم اگه کسی میدونه مشکل چیه راهنماییم کنه
C:\Users>cd C:\xampp\htdocs\Yii Project\migration\protected C:\xampp\htdocs\Yii Project\migration\protected>php yiic migrate up Yii Migration Tool v1.0 (based on Yii v1.1.13) Total 1 new migration to be applied: m141107_194416_create_project_table Apply the above migration? (yes|no) [no]:yes*** applying m141107_194416_create_project_table > create table tbl_project ...exception 'CDbException' with message 'CDbCommand failed to execute the SQL statement: CDbCommand failed to prepare the SQL statement: SQLSTATE[HY000]: General error: 1 near "ENGINE": syntax error. The SQLstatement executed was: CREATE TABLE 'tbl_project' ( "id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "description" text NOT NULL, "create_time" datetime DEFAULT NULL, "create_user_id" int(11) DEFAULT NULL, "update_time" datetime DEFAULT NULL, "update_user_id" int(11) DEFAULT NULL) ENGINE=InnoDB' in C:\xampp\htdocs\framework\db\CDbCommand.php:357Sta ck trace:#0 C:\xampp\htdocs\framework\db\CDbCommand.php(1321): CDbCommand->execute()#1 C:\xampp\htdocs\framework\db\CDbMigration.php(228) : CDbCommand->createTable('tbl_project', Array, 'ENGINE=InnoDB')#2 C:\xampp\htdocs\Yii Project\migration\protected\migrations\m141107_194 416_create_project_table.php(15): CDbMigration->createTable('tbl_project', Array, 'ENGINE=InnoDB')#3 C:\xampp\htdocs\framework\cli\commands\MigrateComm and.php(385): m141107_194416_create_project_table->up()#4 C:\xampp\htdocs\framework\cli\commands\MigrateComm and.php(109): MigrateCommand->migrateUp('m141107_194416_...')#5 [internal function]: MigrateCommand->actionUp(Array)#6 C:\xampp\htdocs\framework\console\CConsoleCommand. php(172): ReflectionMethod->invokeArgs(Object(MigrateCommand), Array)#7 C:\xampp\htdocs\framework\console\CConsoleCommandR unner.php(67): CConsoleCommand->run(Array)#8 C:\xampp\htdocs\framework\console\CConsoleApplicat ion.php(91): CConsoleCommandRunner->run(Array)#9 C:\xampp\htdocs\framework\base\CApplication.php(16 9): CConsoleApplication->processRequest()#10 C:\xampp\htdocs\framework\yiic.php(33): CApplication->run()#11 C:\xampp\htdocs\Yii Project\migration\protected\yiic.php(7): require_once('C:\xampp\htdocs...')#12 C:\xampp\htdocs\Yii Project\migration\protected\yiic(4): require_once('C:\xampp\htdocs...')#13 {main}