PDA

View Full Version : Wiki problems

bubbles
08-12-2007, 07:54 AM
Almost every time I edit a page on the wiki and click 'Save Page' I get these errors instead of seeing the updated page.

The following text appears at the top of the page
Warning: preg_match(): Compilation failed: regular expression too large at offset 0 in /var/www/rpgnet/wiki/extensions/SpamBlacklist/SpamBlacklist_body.php on line 150
And in place of the page, I get this message
Database error
From RPGnetWiki
Jump to: navigation, search
A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:

(SQL query hidden)

from within function "SearchMySQL4::update". MySQL returned error "1016: Can't open file: 'searchindex.MYI'. (errno: 145) (localhost)".
It is impossible to clear this by reloading the page, but navigating away from the page and back to it reveals that the edit has been successful.
bubbles
08-12-2007, 01:34 PM
Update:

* Logging out of the wiki and back in again does not fix the problem.
* There is also a problem with uploading files. The following error occurs when uploading an image, although the image is uploaded correctly
Database error
From RPGnetWiki
Jump to: navigation, search
A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:

(SQL query hidden)

from within function "SearchMySQL4::update". MySQL returned error "1016: Can't open file: 'searchindex.MYI'. (errno: 145) (localhost)".
ShannonA
08-12-2007, 02:08 PM
This is probably a recurring Mediawiki bug. I just repaired the 'searchindex' table which does the trick if that's what it is.
bubbles
08-27-2007, 05:56 AM
It's doing it again
A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:

(SQL query hidden)

from within function "". MySQL returned error "1016: Can't open file: 'searchindex.MYI'. (errno: 145) (localhost)".
This error comes up any time I type anything into the search box (whether clicking 'Search' or 'Go')
ShannonA
08-27-2007, 12:59 PM
Fixed. Again.
tjoneslo
09-10-2007, 06:06 PM
The Wiki is broken again. Same error as before.