The upgraded to MySQL 5.0 has caused some problems. When we save an
article we get this error - though the changes do get saved:
===
A database query syntax error has occurred. This may indicate a bug in
the software. The last attempted database query was:
REPLACE INTO `yw_searchindex` (si_page,si_title,si_text) VALUES
('5329','fish',' fish and fishing ')
from within function "SearchMySQL4::update". MySQL returned error
"1062: Duplicate entry ' ' for key 3 (brane-int)".
===
Previously we had a corruped table:
===
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
"145: Table './payo/yw_searchindex' is marked as crashed and should be
repaired (brane-int)".
===
which was repaired and hasn't given any further problems.
We've also run myisamchk against all the tables in the database.
A couple of Wikimedias running 1.4.x are working without any problems
on the upgraded system.
Any suggestions?
Paul
On 2/27/06, admin Yellowikis <yellowikis(a)gmail.com> wrote:
Hi everyone,
We are running:
* MediaWiki: 1.5.5
* PHP: 4.4.2-0.dotdeb.1 (apache)
* MySQL: 4.1.11-Debian_4sarge2-log
Planning to upgrade to MySQL 5.0.
Any issues/problems that we should be aware of?
(yes, we plan to do a full back up first)
Paul
--
Yellowikis is to Yellow Pages, as Wikipedia is to The Encyclopedia Britannica
--
Yellowikis is to Yellow Pages, as Wikipedia is to The Encyclopedia Britannica