A second MyISAM check seems to have solved the
problem.
You can all stop worrying about it now ;-)
Paul
On 3/10/06, admin Yellowikis <yellowikis(a)gmail.com> wrote:
Hmmm...
Now we have crashing tables again.
=====
A database query syntax error has occurred. This may indicate a bug in
the software. The last attempted database query was:
SELECT page_id, page_namespace, page_title FROM
`yw_page`,`yw_searchindex` WHERE page_id=si_page AND MATCH(si_title)
AGAINST('+test' IN BOOLEAN MODE) AND page_is_redirect=0 AND
page_namespace IN (0) LIMIT 0,20
from within function "". MySQL returned error "145: Table
'./payo/yw_searchindex' is marked as crashed and should be repaired
(brane-int)".
====
I'll try a re-install/upgrade - maybe that will fix it.
Paul
On 3/9/06, admin Yellowikis <yellowikis(a)gmail.com> wrote:
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
--
Yellowikis is to Yellow Pages, as Wikipedia is to The Encyclopedia Britannica
--
Yellowikis is to Yellow Pages, as Wikipedia is to The Encyclopedia Britannica