MySql Error

[matt89]

ok, i started an IPB forum, and i recently installed a shop mod.

but when i go to the index i get this MySql Error:


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 '.org_perm_id, m.temp_ban, g.*
FROM ibf_member
mySQL error code:
Date: Thursday 31st of March 2005 10:25:37 PM

can you please help me?

 

[TonyGroves]

Can you post the text of your SQL query?

There's no way people can help you otherwise.

 

[matt89]

mySQL query error: SELECT moderator.mid as is_mod, moderator.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.points, g.* m.org_perm_id, m.temp_ban, g.*
FROM ibf_members m
LEFT JOIN ibf_groups g ON (g.g_id=m.mgroup)
LEFT JOIN ibf_moderators moderator ON (moderator.member_id=m.id OR moderator.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 '.org_perm_id, m.temp_ban, g.*
FROM ibf_member
mySQL error code:
Date: Friday 01st of April 2005 04:03:56 PM

thats the full text.

 

[TonyGroves]

Your query includes:[tt]
g.* m.org_perm_id, m.temp_ban, g.*[/tt]
which doesn't make sense.

 

[r937]

the part that doesn't make sense is the missing comma

putting g.* into the query twice is not terribly useful, but it is actually valid syntax



rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts May 8 2005)

 

[TonyGroves]

the part that doesn't make sense is the missing comma

My point exactly.