api_generator icon indicating copy to clipboard operation
api_generator copied to clipboard

mysql syntax error running update via shell

Open ghost opened this issue 12 years ago • 0 comments

Created by luke83, 8th Jan 2013. (originally Lighthouse ticket #108):


I'm using ApiGenerator plugin with cakephp 2.2.3.

When i do:

[server]$ cake ApiGenerator.api_index initdb

all things are ok, i checked in db the tables drop and creation are ok, so db config should be ok..

showfiles also work great

then, when i try to update i got this:

[server]$ cake ApiGenerator.api_index update
Clearing index and regenerating class index...
Error: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'fantaclick_v2`.`fc_api_classes``' at line 1
#0 ***/cake/lib/Cake/Model/Datasource/DboSource.php(459): PDOStatement->execute(Array)
#1 ***/cake/lib/Cake/Model/Datasource/DboSource.php(425): DboSource->_execute('TRUNCATE TABLE ...', Array)
#2 ***/cake/lib/Cake/Model/Datasource/DboSource.php(2041): DboSource->execute('TRUNCATE TABLE ...')
#3 ***/dev/plugins/api_generator/Model/ApiGeneratorAppModel.php(47): DboSource->truncate('`fantaclick_v2`...')
#4 ***/dev/plugins/api_generator/Console/Command/ApiIndexShell.php(131): ApiGeneratorAppModel->clearIndex()
#5 ***/cake/lib/Cake/Console/Shell.php(390): ApiIndexShell->update()
#6 ***/cake/lib/Cake/Console/ShellDispatcher.php(201): Shell->runCommand('update', Array)
#7 ***/cake/lib/Cake/Console/ShellDispatcher.php(69): ShellDispatcher->dispatch()
#8 ***/cake/lib/Cake/Console/cake.php(43): ShellDispatcher::run(Array)
#9 {main}

what's wrong? any suggestions?

thanks for time!!!

ghost avatar Oct 11 '13 20:10 ghost