URGENT! Sudden MySQL Errors

Tree · 03-25-2006, 02:55 PM

I upgraded from MySQL 4.0.25 to MySQL 4.1. Now I am getting errors such as:

Code:

mySQL query error: SELECT mod.mid as is_mod, mod.allow_warn, m.id, m.name, m.mgroup, m.password, m.email, m.restrict_post, m.view_sigs, m.view_avs, m.view_pop, m.view_img, m.auto_track,
						 m.mod_posts, m.language, m.skin, m.new_msg, m.show_popup, m.msg_total, m.time_offset, m.posts, m.joined, m.last_post,
						 m.last_visit, m.last_activity, m.dst_in_use, m.view_prefs, m.org_perm_id, m.temp_ban, m.sub_end, g.*
						FROM ibf_members m
						 LEFT JOIN ibf_groups g ON (g.g_id=m.mgroup)
						 LEFT JOIN ibf_moderators mod ON (mod.member_id=m.id OR mod.group_id=m.mgroup)
						WHERE m.id=1

mySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mod ON (mod.member_id=m.id OR mod.group_id=m.mgroup)
						WHERE m.id=1' at line 6
mySQL error code: 
Date: Saturday 25th of March 2006 05:55:07 PM

How can I fix this?

sdsinc · 03-25-2006, 04:21 PM

From the error message I would guess mysql does not like your left join clause (OR)
(mod.member_id=m.id OR mod.group_id=m.mgroup)
I would try to reformulate the condition in a where clause.

Tree · 03-25-2006, 04:45 PM

This is actually a client of mine, and this is occuring on his IPB 1.0 board.

sdsinc · 03-25-2006, 05:22 PM

If you post the table structure and some data I could try on my test platform (MySQL 4.1.18)

Tree · 03-25-2006, 05:25 PM

We're just going to move the client to another server that does not have 4.1 on it.

If you search Google with that error, you'll find out that IPB 1 just doesn't support 4.1.

03-25-2006, 04:21 PM	#2 (permalink)
sdsinc Domains my Dominion Join Date: Aug 2005 Location: Web 1.0 Posts: 6,285 1,095.94 NP$ (Donate)	From the error message I would guess mysql does not like your left join clause (OR) (mod.member_id=m.id OR mod.group_id=m.mgroup) I would try to reformulate the condition in a where clause. __________________ Buy now - MassDeveloper.com $500

03-25-2006, 05:22 PM	#4 (permalink)
sdsinc Domains my Dominion Join Date: Aug 2005 Location: Web 1.0 Posts: 6,285 1,095.94 NP$ (Donate)	If you post the table structure and some data I could try on my test platform (MySQL 4.1.18) __________________ Buy now - MassDeveloper.com $500

03-25-2006, 04:45 PM	#3 (permalink)
Tree NamePros Regular Join Date: Feb 2006 Location: Atlanta, GA, USA Posts: 335 13.25 NP$ (Donate)	This is actually a client of mine, and this is occuring on his IPB 1.0 board.

03-25-2006, 05:25 PM	#5 (permalink)
Tree NamePros Regular Join Date: Feb 2006 Location: Atlanta, GA, USA Posts: 335 13.25 NP$ (Donate)	We're just going to move the client to another server that does not have 4.1 on it. If you search Google with that error, you'll find out that IPB 1 just doesn't support 4.1.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)