Author Topic: Trouble editing WIKI  (Read 10896 times)

0 Members and 1 Guest are viewing this topic.

Offline SteveC

  • Senior Member
  • Getting the hang of things.
  • *****
  • Posts: 79
Trouble editing WIKI
« on: March 18, 2007, 03:47:01 am »
I'm trying to add a page to the WIKI, and am getting the following error:

Database error
From PhatHack Wiki
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 "SearchUpdate::doUpdate". MySQL returned error "145: Table './phathackwikidb/phw_searchindex' is marked as crashed and should be repaired (localhost)".


Any ideas?

Edit: This appears to be a non-critical error. The new WIKI page (http://wiki.phathack.com/Windows_Hack_Procedure) is working just fine.
« Last Edit: March 18, 2007, 03:56:49 am by SteveC »

Offline sbingner

  • Administrator
  • Veteran.
  • *****
  • Posts: 1301
Re: Trouble editing WIKI
« Reply #1 on: March 18, 2007, 07:41:33 am »
I've had that happen a few times... but I can't track down what causes it...

Offline SteveC

  • Senior Member
  • Getting the hang of things.
  • *****
  • Posts: 79
Re: Trouble editing WIKI
« Reply #2 on: March 18, 2007, 12:16:22 pm »
I'm sure you've seen this already, but it sounds like you need to run the CHECK TABLE procedure against the database (or at least the tables referenced in that script). Also, you may want to update your MySQL install if it is an older version - there appear to have been several bugs related to this message.

http://mail.directfb.org/pipermail/directfb-dev/2006-March/001564.html
http://www.databasejournal.com/features/mysql/article.php/3300511
http://mysqld.active-venture.com/Repair.html

Sorry if this is all stuff you've seen before.

Offline sbingner

  • Administrator
  • Veteran.
  • *****
  • Posts: 1301
Re: Trouble editing WIKI
« Reply #3 on: March 18, 2007, 09:41:56 pm »
Yea, I run check table on it... and sometimes it makes a difference, but it often just still has the error... very strange... what I don't understand is what's making it get marked as crashed

Offline sbingner

  • Administrator
  • Veteran.
  • *****
  • Posts: 1301
Re: Trouble editing WIKI
« Reply #4 on: March 18, 2007, 10:09:23 pm »
I Updated MediaWiki to the newest version and moved it to the faster/newer box that's running the forums -- hopefully that'll more permanently fix it ;)