Wedge

Public area => Bug reports => The Pub => Archived fixes => Topic started by: NonSecwitter on February 24th, 2014, 03:08 AM

Title: Database Error: Got error 22
Post by: NonSecwitter on February 24th, 2014, 03:08 AM
I was messing around with my test installation and after modifying the "General Discussion" board type to "Blog" i tried to go back to the home page as admin and received the error message

Database Error: Got error 22 from storage engine
File: %WWWDir%\gz\app\Subs-BoardIndex.php
Line: 69

I then tried to access the "General Discussion" blog from as a user and the error log turned up

Database Error: Incorrect key file for table '.\wedge\wedge_log_boards.MYI'; try to repair it
File: %WWWDir%\gz\app\MessageIndex.php
Line: 119

I used the "Back" link under the message and clicked the board again and got this message:

Database Error: Duplicate entry '4-1' for key 'PRIMARY'
File: %WWWDir%\gz\app\MessageIndex.php
Line: 119
Title: Re: Database Error: Got error 22
Post by: NonSecwitter on February 24th, 2014, 03:43 AM
If I try to delete the board I get:

Got error 22 from storage engine
File: %WWWDir%\gz\app\Subs-Boards.php
Line 985
Title: Re: Database Error: Got error 22
Post by: Nao on February 24th, 2014, 04:01 PM
"Incorrect key file for table '.\wedge\wedge_log_boards.MYI'; try to repair it"

This should be enough of a hint... Your filesystem or something else screwed up your tables. Just launch phpMyAdmin and ask it to repair your tables! (At the very least, wedge_log_boards... Also, this table isn't related to the board type, so it's definitely not a problem with blogs.)
Title: Re: Database Error: Got error 22
Post by: NonSecwitter on February 24th, 2014, 06:00 PM
Not so obvious. I did that and it worked.
Thanks.