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@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@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@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

* MediaWiki: 1.5.7 * PHP: 4.4.2-0.dotdeb.1 (apache) * MySQL: 5.0.18-Debian_3.dotdeb.1-log

MySQL re-started.

still having problems with search.

Any MySQL gurus out there?

On 3/10/06, admin Yellowikis yellowikis@gmail.com wrote:

Spoke too soon - problem has returned.

Will try re-installing.

Paul

On 3/10/06, admin Yellowikis yellowikis@gmail.com wrote:

...

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@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@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@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

-- Yellowikis is to Yellow Pages, as Wikipedia is to The Encyclopedia Britannica

-- Yellowikis is to Yellow Pages, as Wikipedia is to The Encyclopedia Britannica