Thread: a mySQL error
View Single Post
Old 08-17-2006, 06:54 AM   #1 (permalink)
JediCavalier
Member
 
JediCavalier's Avatar
 
Join Date: Jun 2006

Posts: 5
Rep Power: 0 JediCavalier is on a distinguished road
fTrader: (0)
fBuck$: 145.0
Bank: 0.0
Total fBuck$: 145.0

My Forumer
My Country:
Default a mySQL error

Hi,

I have a friend who runs a new IPB forum somewhere, and he got a mySQL error that won't let him or anyone else view topics/posts. Can any experienced IPB board runners tell me how he can fix this:

mySQL query error: SELECT p.*,
m.id,m.name,m.mgroup,m.email,m.joined,m.avatar,m.avatar_size,m.posts,m.aim_name,m.icq_number,
m.signature, m.website,m.name_prefix,m.name_suffix,m.yahoo,m.integ_msg,m.title,m.hide_email,m.msnname, m.warn_level, m.warn_lastwarn, m.points,
g.g_id, g.g_title, g.g_icon, g.g_dohtml
FROM theclantokra_posts p
LEFT JOIN theclantokra_members m ON (p.author_id=m.id)
LEFT JOIN theclantokra_groups g ON (g.g_id=m.mgroup)

WHERE p.topic_id=6 and p.queued != 1
ORDER BY p.pid asc LIMIT 0, 40

mySQL error: Unknown column 'm.name_prefix' in 'field list'
mySQL error code:
Date: Thursday 17th of August 2006 08:40:58 AM

HELP!
Thanks,
JediCavalier
JediCavalier is offline   Reply With Quote