[Mediawiki-l] MySQL error when upgrading from 1.4.11 to 1.5.6

[Patricia Barden]

Hello,

I'm doing a test upgrade of our SourceWatch site from MediaWiki  
v1.4.1.1 to v1.5.6, using PHP 5.1.1, MySQL 4.1.15 and FreeBSD O/S.

I've stepped through the upgrade several times and each time the  
process jams when the script tries to create the "validate" table  
resulting in a MySQL 'Can't create table' error message (errno: 121).

I recently have successfully done a couple of new installs of  
MediaWiki v1.5.5 but, in each case, I assigned a database prefix to  
the tables. So, just as a test, I added a database prefix to the  
tables in the database for the upgrade. This seems to work.

I think that perhaps 'validate' is a reserved word in this version of  
MySQL and that this is the reason why MySQL stops when asked to  
create a table called 'validate'.

Any thoughts on this?

Thanks,

Tricia Barden