After hours of trying to sniff out the problem, it came down to a model I'd
foolishly created in App/Models (Model/Aco.php). Once deleted, this worked.
My thanks to caggia
<https://groups.google.com/forum/?fromgroups#!searchin/cake-php/caggia/cake-php/j0wgXoj4Ma0/iFA92tzUdiUJ>for
helping me find my error. - RM
On Sunday, May 27, 2012 8:13:31 AM UTC-4, Rob M wrote:
>
> Attempting to migrate my app from 1.3 to 2.1; using xampp. I'm running
> into an error in the console when I use AclExtras to recover aco ('recover
> aro' produces no error). The same error is encountered when attempting
> 'aco_sync'. Would you perhaps recognize the stack trace and suggest where
> to look for solutions? Text follows:
>
> C:\xampp\htdocs\testpeople\people>*cake AclExtras.AclExtras recover aro*
>
>
> Welcome to CakePHP v2.1.3 Console
> ---------------------------------------------------------------
> App : people
> Path: C:\xampp\htdocs\testpeople\people\
> ---------------------------------------------------------------
> Tree has been recovered, or tree did not need recovery.
>
> C:\xampp\htdocs\testpeople\people>*cake AclExtras.AclExtras recover aco*
>
>
> Welcome to CakePHP v2.1.3 Console
> ---------------------------------------------------------------
> App : people
> Path: C:\xampp\htdocs\testpeople\people\
> ---------------------------------------------------------------
> 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 'recover' at line 1
> #0 C:\xampp\htdocs\cakephp\lib\Cake\Model\Datasource\DboSource.php(437):
> PDOStatement->execute(Array)
> #1 C:\xampp\htdocs\cakephp\lib\Cake\Model\Datasource\DboSource.php(403):
> DboSource->_execute('recover', Array)
> #2 C:\xampp\htdocs\cakephp\lib\Cake\Model\Datasource\DboSource.php(647):
> DboSource->execute('recover', Array, Array)
> #3 C:\xampp\htdocs\cakephp\lib\Cake\Model\Datasource\DboSource.php(589):
> DboSource->fetchAll('recover', Array, Array)
> #4 C:\xampp\htdocs\cakephp\lib\Cake\Model\Model.php(775):
> DboSource->query('recover', Array, Object(Aco))
> #5
> C:\xampp\htdocs\testpeople\people\Plugin\AclExtras\Console\Command\AclExtrasShell.php(300):
>
> Model->__call('recover', Array)
> #6
> C:\xampp\htdocs\testpeople\people\Plugin\AclExtras\Console\Command\AclExtrasShell.php(300):
>
> Aco->recover()
> #7 C:\xampp\htdocs\cakephp\lib\Cake\Console\Shell.php(386):
> AclExtrasShell->recover()
> #8 C:\xampp\htdocs\cakephp\lib\Cake\Console\ShellDispatcher.php(177):
> Shell->runCommand('recover', Array)
> #9 C:\xampp\htdocs\cakephp\lib\Cake\Console\ShellDispatcher.php(69):
> ShellDispatcher->dispatch()
> #10 C:\xampp\htdocs\cakephp\lib\Cake\Console\cake.php(41):
> ShellDispatcher::run(Array)
> #11 {main}
> 42000
>
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
