Mysql wierd error

[zero_ZX]

Hi all,

I was hoping that my script was finally working after some work, however as always it didn't work out in first try... i got the following mysql error:

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: 
Date: Thursday 12th 2009f February 2009 07:42:19 AM

 

As you maybe can guess im writing a forum software, i'm however not doing from scratch, ill start out by invision power (i got permission, this is the free 1.3.1 version i managed to find some where on my portable hard drive).

 

So.. as i see i tries to get forum id, but it cant? seems wierd to me as i got something called a forum id..

 

Please help

 

[Maq]

Are you sure these aren't mixed up? - f.id=m.forum_id

 

Seems to make more sense if ibf_forums (f) had a forum_id and ibf_moderators (m) had a plain id.