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

sounds like you may have run out of allocated space.

It seems your database is corupted.

Try following commands in a mysql shell

check table <your_table>

and if you find some errors try:

repair table <your table>

Rergards

Disk space or file permsision is my guess too.

Check out the line -> Unable to save result set (Line: 481 of /ips_kernel/class_db_mysql.ph).
What is it attempting to do, write to file???, do you have the correct file permisions???

Ibbo