Error in some MySQL

[@how@]

Hello,

After update my MySQL to 5.0.15 i get error in some site

mySQL query error: SELECT f.*, c.id as cat_id, c.position as cat_position, c.state as cat_state, c.name as cat_name, c.description as cat_desc,
        		   c.image, c.url, m.member_name as mod_name, m.member_id as mod_id, m.is_group, m.group_id, m.group_name, m.mid
        		   FROM ibf_forums f, ibf_categories c
        		     LEFT JOIN ibf_moderators m ON (f.id=m.forum_id)
        		   WHERE c.id=f.category
        		   ORDER BY c.position, f.position

mySQL error: Unknown column 'f.id' in 'on clause'
mySQL error code:

any help to fix it .

 

[nobaloney]

Please post in only one location (whichever you feel most appropriate; I can move it if you get it wrong). And please do not post links in other locations.

Many programs don't work with MySQL 5. I believe you can set a flag in MySQL so it'll work simiarly to MySQL 4, but i'm not sure how.

Jeff

 

[@how@]

sorry,


thanks jeff




Wael

 

[@how@]

converted my tables and upgraded my mysql database with mysql_fix_privilege_tables

is this right

/usr/bin/mysql_fix_privilege_tables --user=****** --password=******