MySQL Database problem

[Nero666]

The ROP forums are on a mySQL 5.0.18 database. Didn't run into problems so far, but about a week ago the database started to behave weird. Since there is a huge diversity of people registered on the twc, undoubtedly also ppl with MySQL knowledge are present, and I hope one or more of you can help me out. Here's my problem:


In the admin panel, when doing the check table option, I get this result:

QUOTE

Key in wrong position at page 131072

When trying to use Private Messaging, this is my error:

QUOTE
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 ibf_members m, ibf_groups g
LEFT JOIN ibf_member_extra me ON (m.id=me.id)
WHERE LOWER(m.members_display_name) IN ('nero666')
AND m.mgroup=g.g_id

SQL error: Unknown column 'm.id' in 'on clause'
SQL error code:
Date: Tuesday 25th of April 2006 01:04:34 PM

I've already downloaded ibf_posts.sql and checked it out, but I don't know nothing about databases, I just expect them to work properly. ( )
I've tried dozens of repair options, from the Admin CP and from the website cp, but the bug keeps coming back. The 'page' at which it appears, is always the same though, so I hope it's fixable. It doesn't matter if 20 posts have to be nuked, but it would be 'kinda' crap if all 3000 of them disappear.

[krazykarl]

accroding to that error message, it cant find the column named m.id in the tables you are using. you may wish to check the table to see if this is indeed the correct table name.

[Nero666]

Problem is, I dont know what m.id is, and how to find it. All I know is that the problem is in ipb_posts, but don't know what columns are in the database. Basically, it was just a string of text, followed by numbers, the poster's name, the message, and some more numbers. This is one of the strings:

"INSERT INTO ibf_posts (pid, append_edit, edit_time, author_id, author_name, use_sig, use_emo, ip_address, post_date, icon_id, post, queued, topic_id, post_title, new_topic, edit_name, post_key, post_parent, post_htmlstate) VALUES('3005','0',NULL,'4','rez','1','1','128.240.229.65','1145981068','0','lol','0','362',NULL,'0',NULL,'3f4de38f66ac6f8378e5fe3cafa2e182','0','0');"