Re: SQL Error: 1054: Unknown column

2011-05-26 Thread thom
> > 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 `Usergr

SQL Error: 1054: Unknown column

2011-05-26 Thread Cathy
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` W

Re: sql error 1054 unknown column in 'on clause'

2010-05-13 Thread Ambika Kulkarni
U r the MASTER sir Thanks to you, for all your kind help On Thu, May 13, 2010 at 12:17 PM, Amit Rawat wrote: > No acknowledgement for me? > > Check out the new CakePHP Questions site http://cakeqs.org and help others > with their CakePHP related questions. > > You received this message becaus

Re: sql error 1054 unknown column in 'on clause'

2010-05-12 Thread Amit Rawat
No acknowledgement for me? Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com T

Re: sql error 1054 unknown column in 'on clause'

2010-05-12 Thread Ambika Kulkarni
Hi John, That prblem got resolved as i changed the storetype model name to store_type. And it worked. Thanks for your kind concern Thank you, On Wed, May 12, 2010 at 8:28 PM, John Andersen wrote: > I'll rephrase my question, can you show me the SQL description of the > store_types table, like

Re: sql error 1054 unknown column in 'on clause'

2010-05-12 Thread John Andersen
I'll rephrase my question, can you show me the SQL description of the store_types table, like this: [code] CREATE TABLE `store_types` ( `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, `name` VARCHAR(40) NOT NULL, PRIMARY KEY (`id`) ) [/code] I ask because I want to be sure t

Re: sql error 1054 unknown column in 'on clause'

2010-05-11 Thread Ambika Kulkarni
In store_types tbl primary key is store_type_id On Tue, May 11, 2010 at 8:04 PM, John Andersen wrote: > As the error says, the table store_types has no column id, which is > expected, as you have defined that the StoreType model has a primary > key named store_type_id! > > What is the name of th

Re: sql error 1054 unknown column in 'on clause'

2010-05-11 Thread John Andersen
As the error says, the table store_types has no column id, which is expected, as you have defined that the StoreType model has a primary key named store_type_id! What is the name of the column which is the primary key in the table store_types? Enjoy, John On May 11, 4:29 pm, Ambika Kulkarni w

Re: sql error 1054 unknown column in 'on clause'

2010-05-11 Thread Ambika Kulkarni
SELECT `Store`.`store_id`, `Store`.`branch_code`, `Store`.`store_code`, `Store`.`store_name`, `Store`.`store_type_id`, `Store`.`grm`, `Store`.`lngbranchmanager`, `Store`.`assistant`, `Store`.`lngconregion`, `Store`.`division_id`, `Store`.`division_zapop_id`, `Store`.`region_id`, `Store`.`telcountry

Re: sql error 1054 unknown column in 'on clause'

2010-05-11 Thread John Andersen
;conditions' => '', >                               'fields' => '', >                               'order' => '')); > > } > > in the controller I put this code > $this->Store->recursive = 0; > >        

sql error 1054 unknown column in 'on clause'

2010-05-11 Thread Ambika Kulkarni
27;foreignKey' => 'store_type_id', 'conditions' => '', 'fields' => '', 'order' => '')); } in the controller I put this code $this->Store->recursive = 0; $st

Re: Problem -> Warning (512): SQL Error: 1054: Unknown column

2009-05-09 Thread Mike
Yeha, it was that in fact, i completely forgot that association hehe, what a dumb Thank you John! --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googleg

Re: Problem -> Warning (512): SQL Error: 1054: Unknown column

2009-05-09 Thread brian
On Sat, May 9, 2009 at 3:30 AM, John Andersen wrote: > > Check that your Category model does not have an association defined > for Freeone (probably a belongsTo association). Also, clear your model cache. Look in app/tmp/cache dir. --~--~-~--~~~---~--~~ You recei

Re: Problem -> Warning (512): SQL Error: 1054: Unknown column

2009-05-09 Thread John Andersen
Check that your Category model does not have an association defined for Freeone (probably a belongsTo association). Enjoy, John On May 9, 10:11 am, Mike wrote: > Hi everyone, i've got this problem: > Warning (512): SQL Error: 1054: Unknown column 'Category.freeone_id' &

Problem -> Warning (512): SQL Error: 1054: Unknown column

2009-05-09 Thread Mike
Hi everyone, i've got this problem: Warning (512): SQL Error: 1054: Unknown column 'Category.freeone_id' in 'on clause' [CORE\cake\libs\model\datasources\dbo_source.php, line 525] The Categories table used to have 3 fields : id, user_id, freeone_id, but i dropped the

AW: SQL Error: 1054: Unknown column 'conditions' in 'where clause'

2008-09-05 Thread Liebermann, Anja Carolin
Im Auftrag von David C. Zentgraf Gesendet: Freitag, 5. September 2008 14:39 An: cake-php@googlegroups.com Betreff: Re: SQL Error: 1054: Unknown column 'conditions' in 'where clause' > It seems my syntax for find isn't ok, but as far as I can see I follow > correc

Re: SQL Error: 1054: Unknown column 'conditions' in 'where clause'

2008-09-05 Thread David C. Zentgraf
aster = $this->Hotelmaster->find($params); > $this->set('hotelmaster', $hotelmaster); > return $hotelmaster ; > } > > Causing following error message > SQL Error: 1054: Unknown column 'conditions' in 'where clause' > >

SQL Error: 1054: Unknown column 'conditions' in 'where clause'

2008-09-05 Thread Liebermann, Anja Carolin
'recursive' => -1 //int ); $hotelmaster = $this->Hotelmaster->find($params); $this->set('hotelmaster', $hotelmaster); return $hotelmaster ; } Causing following error message SQL Error: 1054: Unknown column 'conditions&