MySQL Database Error with IPB Personal Message System

[Fusion]

Okay, when ever (on Invision Power Board's PM option) we try to send a PM to any other member on the forum, we all get this message...

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 bpass_members m, bpass_groups g
		        LEFT JOIN bpass_member_extra me ON (m.id=me.id)
			   WHERE LOWER(m.members_display_name) IN ('admin')
			   AND m.mgroup=g.g_id

SQL error: Unknown column 'm.id' in 'on clause'
SQL error code: 
Date: Tuesday 25th of April 2006 05:39:56 AM

NOTE: 'admin' is replaced with what ever member's name that is being PMed.

Anybody know how to fix it? :confused:

Thanks SO much for your help!

[Fusion]

Erm.... Anybody out there who is smart? :o

[cmurrayis]

I am also having this problem with my invision power board when trying to send a PM

mySQL query error: SELECT m.mgroup_others , m.id, m.name, m.members_disab le_pm, m.members_displ ay_name, m.msg_total, m.view_pop, m.email_pm, m.language, m.email, me.vdirs, g.g_max_message s, g.g_use_pm FROM ibf_members m, ibf_groups g
LEFT JOIN ibf_member_extr a me ON (m.id=me.id)
WHERE LOWER(m.members _display_name) IN ('admin')
AND m.mgroup=g.g_id

SQL error: Unknown column 'm.id' in 'on clause'
SQL error code:
Date: Tuesday 20th of June 2006 09:16:17 AM


Anyone have any ideas?