PDA

View Full Version : mysql error: Can't open file: 'session.MYD'


DrinkMilk
Mon 11th Feb '02, 7:18am
I get this just getting on the site. I ran the reapir.php file and its not working. PLS help..

Database error in vBulletin: Invalid SQL: INSERT INTO session (sessionhash,userid,host,useragent,lastactivity,lo cation,styleid) VALUES ('5551150ae606e37b2c15fd9ef2bf5330','2','172.139.9 0.143','Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1;','1013426008','/forum/index.php',5)
mysql error: Can't open file: 'session.MYD'. (errno: 145)
mysql error number: 1016
Date: Monday 11th of February 2002 05:13:28 AM
Script: /forum/index.php
Referer:


Database error in vBulletin: Invalid SQL: DELETE FROM session WHERE sessionhash=''
mysql error: Can't open file: 'session.MYD'. (errno: 145)
mysql error number: 1016
Date: Monday 11th of February 2002 05:13:28 AM
Script: /forum/index.php
Referer:

Chris Schreiber
Mon 11th Feb '02, 7:42am
The session table is a HEAP table, so you can't repair it. To fix this problem, you should empty the session table.

DrinkMilk
Mon 11th Feb '02, 7:45am
Originally posted by Chris Schreiber
The session table is a HEAP table, so you can't repair it. To fix this problem, you should empty the session table.

I can't get in it said "IN USE" I used phpMyAdmin

DrinkMilk
Mon 11th Feb '02, 8:01am
Thanks, I keeped at it and it finally let me do this.

I cleared it and just out of curosity. Whats the effect on the forum if I cleared it?

Chris Schreiber
Mon 11th Feb '02, 8:09am
None, it just holds session information for users currently logged in.... after you clear it they will just be re-created.

crapforum
Fri 1st Mar '02, 11:14am
has pconnect something to do with this?