I have had another go with this today but the same message keeps coming back about permissions I can't see what other permissions the maintenance scripts need
Arthur
arthur@astarsolutions.co.uk -----Original Message----- From: Arthur Guy [mailto:arthur@astarsolutions.co.uk] Sent: 29 June 2005 19:48 To: 'MediaWiki announcements and site admin list' Subject: RE: [Mediawiki-l] Database Corruption
Thanks for replying, I hadn't filled out the details in adminsettings.php.
I created a new database user and put the account details in that file and re-ran the rebuild script, it came back with a message saying the user I had created didn't have permission.
I gave the user the following privileges SELECT INSERT UPDATE DELETE INDEX ALTER Are there any other privileges it needs?
Thanks Arthur
arthur@astarsolutions.co.uk
-----Original Message-----
Make sure AdminSettings.php is present and contains correct username and password settings as per AdminSettings.sample.
Note that rebuildIndex.php requires ALTER TABLE permission (iirc) to drop and re-add the fulltext index.
-- brion vibber (brion @ pobox.com)
'a star solutions' disclaimer The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If you are not the intended recipient of this message you are hereby notified that any use, review, retransmission, dissemination, distribution, reproduction or any action taken in reliance upon this message is prohibited. If you received this in error, please contact the sender and delete the material from any computer. Any views expressed in this message are those of the individual sender and may not necessarily reflect the views of the company. We believe that this communication is free from viruses and other potentially dangerous programmes, but the recipient opens this communication at their own risk. We assume no responsibility for any loss or damage arising from the receipt or use of this communication
I get the same error message: "SearchUpdate::doUpdate". MySQL returned error "1034: Incorrect key file for table :(
And to get rid of that (at least to be able to perform some searches in the database) I DROP the seract index database, and recreate it using a cron job every 24H.
The search function then works fine and I get no errors, but as soon as someone edits one page, the error pop out and the search index table gets corrupted. No search is possible until the next time the cron job runs :(
I'm on MySQL 3.23.58 with PHP 5.0.4 and MW 1.4.10
Can someone help me ?
Amilcar Lucas wrote:
I get the same error message: "SearchUpdate::doUpdate". MySQL returned error "1034: Incorrect key file for table :(
And to get rid of that (at least to be able to perform some searches in the database) I DROP the seract index database, and recreate it using a cron job every 24H.
The search function then works fine and I get no errors, but as soon as someone edits one page, the error pop out and the search index table gets corrupted. No search is possible until the next time the cron job runs :(
I'm on MySQL 3.23.58 with PHP 5.0.4 and MW 1.4.10
Can someone help me ?
1) Check MySQL's error log. 2) Upgrade to MySQL 4.0 or higher.
-- brion vibber (brion @ pobox.com)
mediawiki-l@lists.wikimedia.org