Jump to content

[SOLVED] CakePHP: $belongsTo sql error with scaffolding, need help


Recommended Posts

Hi all


I am a newbie to cakePHP and need some help


I am using the $belongsto association variable in my User module, and $scaffold in my controller.


User Module

class User extends AppModel
var $name = 'User';
var $belongsTo = array (
				'Town' => array(
							'className' => 'Town',
							'conditions'=> '',
							'order'=> '',


When I run /users/add in the browser, I get this Error message:


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 'towns` AS `Town` WHERE 1 = 1' at line 1


and this is the sql query:

SELECT `Town`.`id`, Town`. FROM `towns` AS `Town` WHERE 1 = 1


All my other $belongsTo associations are working, except this one... I have dropped the table and recreated it, changed the table name from cities to towns, but I still get the same error over and over...


please help

Link to post
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.