• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
DMZ 1054 problem

#1
[eluser]rootman[/eluser]
Hi, I got a 1054 Error on a query generated by DMZ.

I looked up the error in the troubleshooting section of DMZ and it says to update the mysql_driver ... i've done that but still error ...

Here the generated query
Code:
SELECT `news`.* FROM (`news`) LEFT OUTER JOIN `categories_news` as categories_news ON `news`.`id` = `categories_news`.`news_id` LEFT OUTER JOIN `categories` as categories ON `categories`.`id` = `categories_news`.`category_id` WHERE `categories`.`id` = '2'

Here the error
Code:
A Database Error Occurred

Error Number: 1054

Unknown column 'categories.id' in 'where clause'

SELECT `news`.* FROM (`news`) WHERE `categories`.`id` = '2' ORDER BY `news`.`publish_date` desc LIMIT 12

And the call
Code:
$n->where_related('category','id', $this->session->userdata('news_searchcategory'));

And later i call the get with some more settings.
I cant find an error, maybe i am just missing something, any help would be much appreciated.

cheers! Big Grin


Messages In This Thread
DMZ 1054 problem - by El Forum - 01-02-2010, 01:36 PM
DMZ 1054 problem - by El Forum - 01-02-2010, 02:03 PM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.