Jump to content

Archived

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

Scholtzz

[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'=> '',
							'foreignKey'=>'town_id'
				),

 

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

Share this post


Link to post
Share on other sites

Hi

 

I solved the problem...

 

My table towns, primary field was called town_id and not id

Share this post


Link to post
Share on other sites

×
×
  • 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.