Very often i got this error and i had to do custom query why it's not putting '*'?
$this -> loadModel( 'Company.Role' ); $this -> Role -> useDbConfig = $this -> db_name; $arrRoles = $this -> Role -> find( "all" ); Warning (512): SQL Error: 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 'FROM `roles` AS `Role` WHERE 1 = 1' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 535] Code | Context $sql = "SELECT FROM `roles` AS `Role` WHERE 1 = 1 " $error = "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 'FROM `roles` AS `Role` WHERE 1 = 1' at line 1" -- 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 [email protected] For more options, visit this group at http://groups.google.com/group/cake-php
