mysql error

[nottm]

Hello I recently uploaded phpbb to one of my websites on my root server and got the following message

Could not query forums information

DEBUG MODE

SQL Error : 1030 Got error 28 from table handler

SELECT f.*, p.post_time, p.post_username, u.username, u.user_id FROM (( phpbb_forums f LEFT JOIN phpbb_posts p ON p.post_id = f.forum_last_post_id ) LEFT JOIN phpbb_users u ON u.user_id = p.poster_id ) ORDER BY f.cat_id, f.forum_order

Line : 167
File : index.php

can anyone tell me anything about error 28, I know it maybe a mysql issue?

Kindest Regards
Micheal.

[eWebtricity]

Error 127 is just a generic db error stating that it couldn't draw the query data from the DB

Did this ever work or is this a brand new install? Have you checked the MySQL database and try to execute the query from the command line. If that doesn't work, you know the DB is corrupted somehow or incomplete. If it does work from the command line then you know that phpBB settings are incorrect somewhere. Line 167 is just after phpBB decides on what DB to use ie: Oracle or MySQL is this of any significance to you?

[nottm]

Hi, Okay error 28 means no mysql space on server/disk, which I just cant get my head around as I have other databases running and are fine, I have also optamized all tables and still recieve the error 28.

Would you have any idea how to increase the mysql space on the server.

Kindest Regards
Micheal

[eWebtricity]

You can't really increase the MySQL disk space, would you might be running into a limit on the "client" limits in disk space like a quota on their allowable disk space. Check in the control panel for that client to see if they are exceeding the allowed disk space.