phpBB and MySQL acting screwy

Discuss Applications

phpBB and MySQL acting screwy

Postby X11 » Thu Mar 10, 2005 1:29 am

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: 674
Joined: Sun Jan 19, 2003 11:09 pm
Location: Australia

Postby X11 » Thu Mar 10, 2005 1:34 am

It only applies to editing one specific topic: https://kintarolabs.sytes.net/forum/viewtopic.php?t=49
X11
guru
guru
 
Posts: 674
Joined: Sun Jan 19, 2003 11:09 pm
Location: Australia

Postby Void Main » Thu Mar 10, 2005 6:35 am

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)?
User avatar
Void Main
Site Admin
Site Admin
 
Posts: 5705
Joined: Wed Jan 08, 2003 5:24 am
Location: Tuxville, USA

Postby X11 » Thu Mar 10, 2005 6:46 am

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: 674
Joined: Sun Jan 19, 2003 11:09 pm
Location: Australia

Postby X11 » Thu Mar 10, 2005 6:58 am

Ok, that was fixed simple enough.
X11
guru
guru
 
Posts: 674
Joined: Sun Jan 19, 2003 11:09 pm
Location: Australia

Postby X11 » Thu Mar 10, 2005 7:03 am

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: 674
Joined: Sun Jan 19, 2003 11:09 pm
Location: Australia

Postby X11 » Thu Mar 10, 2005 7:38 am

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.
X11
guru
guru
 
Posts: 674
Joined: Sun Jan 19, 2003 11:09 pm
Location: Australia


Return to Applications

Who is online

Users browsing this forum: No registered users and 0 guests

cron