Session Errors - Board Won't Work

[sheri]

I'm so lost I don't even know how to explain the problem.

My board is going to the "slight problem with the database" page.


The database is showing the error:

Warning: Supplied argument is not a valid MySQL result resource in /usr/local/cpanel/base/3rdparty/phpMyAdmin/lib.inc.php on line 507


And trying to access any Session file shows:

MySQL said: Can't open file: 'session.MYD'. (errno: 145)

This started when the server (Ventures Online) came back up after upgrading.


Can someone give me a clue?

I appreciate any help you can give

[Mike Sullivan]

If it just happened after they upgraded the server, then they didn't shutdown MySQL properly.

If you look in install.php, you can find the code to recreate the session table (CREATE TABLE session (...)). You'll want to drop it before you run the create query (DROP TABLE session;)

[sheri]

Thanks - but unfortunately I just wiped out the whole sessions file in phpMyAdmin trying to understand your
answer.

Did I just kill it? I have no idea how to put it back -

Who should I contact to fix it ?

[Mike Sullivan]

Then run this query:

CREATE TABLE session (
sessionid MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL,
userid SMALLINT UNSIGNED NOT NULL,
ipaddress CHAR(20) NOT NULL,
lastactivity INT UNSIGNED NOT NULL,
location CHAR(250) NOT NULL,
PRIMARY KEY(sessionid)
);

[sheri]

I was able to get the session table back and can access the first page (index) of the board but it goes to an error when you try to access anything.

[Mike Sullivan]

You have more corrupt tables. Look for a post by eva2000, then go to the links in his sig -- he will tell you how to run (my)isamchk to fix table corruption.

[eva2000]

here's the revised article for repairing corrupt tables for people with root telnet access
http://i4net.tv/marticle/get.php?action=getarticle&articleid=7

Ed: that escape slash bug is annoying me in marticle ;) using \\n works and displays as \n but is there a permanent fix :D


sheri viewing the source code shows you have an error 127 at table handler which is corruption of the thread table

Database error in vBulletin: Invalid SQL: SELECT DISTINCT
threadid,
lastpost
FROM thread
WHERE visible=1 AND (thread.forumid=1 OR thread.forumid=2 OR thread.forumid=3 OR thread.forumid=4 OR thread.forumid=5 OR thread.forumid=6 OR thread.forumid=7 OR thread.forumid=8 OR thread.forumid=9 OR thread.forumid=10 OR thread.forumid=11 OR thread.forumid=12 OR thread.forumid=13 OR thread.forumid=14 OR thread.forumid=15 ) AND thread.lastpost >= 986000302
ORDER BY lastpost DESC
mysql error: Got error 127 from table handler
mysql error number: 1030
Date: Saturday 31st of March 2001 07:58:23 PM
Script: /ydf/search.php?getdaily=yes&action=dosearch&searchdate=1
Referer:

[sheri]

Thank you - I was trying to use your instructions to find problems and couldn't understand what to do.

Now that you have been so helpful telling me what the problem is - how do I correct it?

I'm ready to throw the board and computer out the window :)
this is so far over my head - I'm in total awe of you folks!

[eva2000]

Originally posted by sheri
Thank you - I was trying to use your instructions to find problems and couldn't understand what to do.

Now that you have been so helpful telling me what the problem is - how do I correct it? here's what you do http://i4net.tv/marticle/get.php?action=getarticle&articleid=7

[sheri]

But I still am at a loss. Just how absurd is the fee to do it for me?

[Mike Sullivan]

Try freddie's repair.php: http://www.vbulletin.com/forum/showthread.php?s=&postid=78528#post78528

[sheri]

Thank you so much, so so much!