Serious and URGENT MySql Help needed High PAY

Hello
I am having serious problems with database. I just moved to a new server and there are some errors with database the main one is that i cannot see the member list in the forum. This is error i get
When i click on members,Admins, or even search posts...Please let me know here or you can contact me at luckyy626 at yahoo and i will even pay high bucks if somebody can give me a good solution or can do this for me Site is www.getskinned.co.uk


IPB WARNING [2] mysql_query(): Unable to save result set (Line: 481 of /ips_kernel/class_db_mysql.php)


There appears to be an error with the database.
You can try to refresh the page by clicking here.
Error Returned
mySQL query error: SELECT m.*,me.*,p.*,g.g_hide_from_list,g.g_id FROM ibf_members m
LEFT JOIN ibf_member_extra me ON me.id=m.id
LEFT JOIN ibf_pfields_content p ON (p.member_id=m.id)
LEFT JOIN ibf_groups g ON (g.g_id=m.mgroup)
WHERE g.g_hide_from_list <> 1 AND m.mgroup='4'
ORDER BY m.name asc
LIMIT 0, 30
mySQL error: Got error 124 from table handler
mySQL error code:
Date: Friday 28th of April 2006 09:48:27 PM
We apologise for any inconvenience

 

would ou happen to know what version of mysql is running on your old server and the new server?

 

Use the repair function of mysql on ALL tables.

 

Have you solved your problem yet??? You can try to repair and optimize your tables as tomzx suggested.

If this does not work, I am willing to help you. Please send me a PM.