Ok just compiled mysql and apache and all of that on a new freebsd server and it was going fine even had 100+ users on the box with 0.3 load so it was doing fine then I check to make sure all is still speedy and fine and am getting this error via the phpbb forum.


General Error

Couldn't obtain category list.

DEBUG MODE

SQL Error : 1030 Got error 28 from table handler

SELECT c.cat_id, c.cat_title, c.cat_order FROM phpbb_categories c, phpbb_forums f WHERE f.cat_id = c.cat_id GROUP BY c.cat_id, c.cat_title, c.cat_order ORDER BY c.cat_order

Line : 106
File : /usr/home/username/website.com/forum/includes/functions.php




ok so there is error one, then I have phpmyadmin installed so I try to add a new database to install a new forum for testing and I click add a new database and here is the output of that


Database testing running on localhost

Notice: Undefined index: enable in /usr/home/zac/www/phpmyadminwebiste.com/libraries/sqlparser.lib.php on line 213

Error

SQL-query :


CREATE DATABASE `testing`

MySQL said:


Can't create database 'testing'. (errno: 28)



any ideas as to what is wrong it went from running perfect and then all of a sudden not working at all.

thx, Zac

did you run mysqlcheck on the tables ?

Originally posted by Slidey
did you run mysqlcheck on the tables ?

sorry for not giving an update it seems /var was full and I for the time was saving the apache logs to /var/log and now have since changed that to a /usr path so that it does'nt fill up the /var partition :)

all is fixed now thx ;)