Hi guys... I've a "little" problem in my IPB forum with pm... I've read you also had it and resolve:


mySQL query error: SELECT m.mgroup_others, m.id, m.name, m.members_disable_pm, m.members_display_name, m.msg_total, m.view_pop, m.email_pm, m.language, m.email, me.vdirs, g.g_max_messages, g.g_use_pm FROM ibf_members m, ibf_groups g
LEFT JOIN ibf_member_extra me ON (m.id=me.id)
WHERE LOWER(m.members_display_name) IN ('shiryu86')
AND m.mgroup=g.g_id

SQL error: Unknown column 'm.id' in 'on clause'
SQL error code:
Date: Monday 30th of July 2007 09:33:13 PM


please...could you help me? I know I've to modify with this code:
FROM ibf_groups g, ( ibf_members m
LEFT JOIN ibf_member_extra me ON (m.id=me.id) )

but, I really don't know WHERE I've to go to modify it =_="""

Thank you ....

if you are getting errors like that, it's probably a fault with the db not in the code itself. Try repairing the database before you do anything else

Is the key field in the members table really called "id"

Repair or restore the database, then check the table structure