MySQL Error : The table 'session' is full

[mentalrz]

I had this error -

MySQL Error : The table 'session' is full


So i ran the query - DELETE FROM session;


Except it just keeps hanging and doesnt finish the job, any other advice? (ps ive reverted the footer)

Edit - i get this error on a crontab -


Daily Digest

Fatal error: Call to a member function on a non-object in /home/ragezone/public_html/x/includes/functions.php on line 4240

[mentalrz]

Update-

I managed to remove the session table and i rebooted webserver and it works fine, but i do still get that crontab error from schedule tasks..


Daily Digest

Fatal error: Call to a member function on a non-object in /home/ragezone/public_html/forum/includes/functions.php on line 4240

[Steve Machol]

Which version are you running?

[mentalrz]

RC2

http://forum.ragezone.com

upgraded it last night

[Steve Machol]

Line 4240:
$vbulletin->db->unlock_tables();

I believe you need to make sure your db user has lock permissions on your database.

[mentalrz]

Which file is that for steve?

[Wayne Luke]

Most likely functions.php since that is where you are reporting the error came from.

[mentalrz]

how do i grant lock permissions as ive set the priv's to "all"

[Floris]

These days I notice more and more hosting providers with LOCK permissions off for user accounts on shared hosting. Please check with your hosting provider and ask them to turn this on for your account.

[mentalrz]

I am the host lol

[Baitona]

Hi,
To solve the full sesseion table, we intend to do:
DELETE FROM session;

//////////
but my question is what is the difference between:

TRUNCATE TABLE session;

and

DELETE FROM session;

Please, i am talking in term of programming point of view, what is the differnce? does the fisrt one affect the structure, the attributes, etc....
or both of them just delete the contents?

thanks