phpBB and MySQL acting screwy

Discuss Applications
Post Reply
X11
guru
guru
Posts: 676
Joined: Sun Jan 19, 2003 11:09 pm
Location: Australia
Contact:

phpBB and MySQL acting screwy

Post by X11 »

Could not delete word list entry

DEBUG MODE

SQL Error : 1030 Got error 134 from table handler

DELETE FROM phpbb_search_wordlist WHERE word_id IN (8354, 8355, 8356, 8357, 8358, 8359, 8361, 8362, 8363, 8364, 8365, 8366, 8367, 8368, 8369, 8370, 8371, 8372, 8373, 8374, 8375, 8376, 8377, 8378, 8380, 8381, 8382, 8383, 8384, 8385, 8386, 8387, 8388, 8389, 8391, 8392, 8394, 8395, 8396, 8397, 8398)

Line : 382
File : /var/www/html/forum/includes/functions_search.php

Note: I have not done any of the changes to the database as planned for my April Fools Joke

I got the following error after attempting to edit a post.

What do I do?

X11
guru
guru
Posts: 676
Joined: Sun Jan 19, 2003 11:09 pm
Location: Australia
Contact:

Post by X11 »

It only applies to editing one specific topic: https://kintarolabs.sytes.net/forum/viewtopic.php?t=49

User avatar
Void Main
Site Admin
Site Admin
Posts: 5716
Joined: Wed Jan 08, 2003 5:24 am
Location: Tuxville, USA
Contact:

Post by Void Main »

You probably want to do a little more research but a quick search that I just did would indicate you probably have a corrupt table and probably need to run a repair on it:

http://dev.mysql.com/doc/mysql/en/repair.html

Has your machine ever been shut down or powered off uncleanly (without first shuuting down MySQL at least)?

X11
guru
guru
Posts: 676
Joined: Sun Jan 19, 2003 11:09 pm
Location: Australia
Contact:

Post by X11 »

Once, but mysql was shutdown, it was when I thought I had lost everything and went insane for the night and hit the main circuitbreaker, powering down everything.

X11
guru
guru
Posts: 676
Joined: Sun Jan 19, 2003 11:09 pm
Location: Australia
Contact:

Post by X11 »

Ok, that was fixed simple enough.

X11
guru
guru
Posts: 676
Joined: Sun Jan 19, 2003 11:09 pm
Location: Australia
Contact:

Post by X11 »

Now I am getting the following error...

DEBUG MODE

SQL Error : 1033 Incorrect information in file: './phpbb/phpbb_ranks.frm'

SELECT * FROM phpbb_ranks ORDER BY rank_special, rank_min

Line : 454
File : /var/www/html/forum/viewtopic.php

and...

[root@exeleven phpbb]# cat phpbb_ranks.frm
cat: phpbb_ranks.frm: Input/output error

Looks like the old harddrive is fscked, im going to make a loopback cryptoloop and migrate what I can and restore backups.

X11
guru
guru
Posts: 676
Joined: Sun Jan 19, 2003 11:09 pm
Location: Australia
Contact:

Post by X11 »

Okay the harddisk has been fscked but I dont trust it, I have a safe backup, I will migrate the database and stuff to a loopback cryptoloop.

Right now I am going to bed because I am filled with painkillers and getting lightheaded.

Post Reply