SQL Error: 1054: Unknown column

Hi everyone!

I have a problem.

Warning (512): SQL Error: 1054: Unknown column 'Usergroup.id' in
'where clause' [CORE\cake\libs\model\datasources\dbo_source.php, line
684]
Query: SELECT `Usergroup`.`jobTitle`, `Usergroup`.`groupId` FROM
`usergroups` AS `Usergroup` WHERE `Usergroup`.`id` =
'administrator' LIMIT 1

The usergroups table has 2 fields: jobTitle & groupId.
Both are VARCHAR type. jobTitle is primary key. no id field and no
association to any other table.

i baked the usergroups table, then, index and add views are ok..i can
add new usergroups and can see the list.
however, when i access view and edit, this error appeared.

Is this problem appear, because of without id field?
Does anyone have an idea why this problem appears?, there's any way
to fix my problem?

Thanks for your atention!!!

--
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+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php