MySQL issue with 'on clause'


#1

I recently moved my site on dreamhost.com and after setting up everything I get this error on my forum:

[code]SELECT m.mgroup_others, m.id, m.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 boardboard_members m, board_groups g
LEFT JOIN board_member_extra me ON (m.id=me.id)
WHERE LOWER(m.name) IN (‘username’)
AND m.mgroup=g.g_id

mySQL error: Unknown column ‘m.id’ in ‘on clause’
[/code]All mentioned tables exist in the database and all the requested columns (id, name, …) are set and not empty.

All hell can’t stop us now…


#2

I’m pretty sure you will need to wrap the table names listed in the FROM clause in parentheses. This is because the join syntax was updated in more recent versions of MySQL 5.0.


si-blog | Keystone Websites
Save $97 on yearly plans with promo code [color=#CC0000]SCJESSEY97[/color]


#3

Thanks a lot. This was the problem. I think I have to upgrade the forum to a newer version.

All hell can’t stop us now…