Topic on Project:Support desk

Error migrating mediawiki built with php5.2 to server with php5.3

Kuxy09 (talkcontribs)

Mediawiki version: 1.14.0 PHP version: 5.2.5 (apache2handler) MYSQL Version: 5.0.26 OS: SUSE Enterprise Linux Server 10


I have a mediawiki built with the above specifications. It is working very perfectly on the current server where it is. However, the server is old as well as the versions of PHP and MYSQL. The mediawiki is in the process of being moved over to a new MAC OS X 10.7 Server with PHP 5.3.15(apache2handler) and MYSQL 5.5.25a-log.

The problem

After successful migration of both the mediawiki site and databases, the pages of the mediawiki cannot be edited and always comes up with the error below

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 "Revision::insertOn". MySQL returned error "1048: Column 'old_text' cannot be null (localhost)".

I was able to fully confirm it was not a database error since the mediawiki works well on MAMP when php 5.2.17 is selected from the preferences and still running well on the SUSE server.


1) How can I upgrade the current mediawiki installation version to more recent versions such as 1.20.4 which works well with php5.3?

2) What steps can I take to achieve this please?

The mediawiki is being moved to a Mac OS X 10.7 Lion Server with PHP 5.3.15(apache2handler) and MYSQL 5.5.25a-log. I have tried different things such as installing mediawiki 1.20.4 and then dropping the tables and importing the tables from the .sql database dump of the old mediawiki 1.14.0 to the 1.20.4 but that did not work at all. I have also tried changing some lines (where the error is being reported) in the main .sql database file of the mediawiki but did not work. I know however that the reason it won't work was because this old version of mediawiki is not compatible with php 5.3 and not a database issue.

I have also tried to manually move some installation folders folders from mediawiki 1.20.4 to the old 1.14.0 to upgrade it but that did not work. I have also ran the /maintenance/update.php script severally but it won't update the 1.14.0 to 1.20.4 or later. I have been trying different things for weeks now but to no avail. Please I need a solution as this is the last stage of the our website migration process at work.

This help and solution will be highly beneficial and appreciated.

Thanks. (talkcontribs)

For information on how to upgrade your wiki see Upgrade.

You should not have to change anything with the old database. Import the complete DB on the new MySQL server, update MediaWiki and run the database updater. Afterwards maybe you still have to update some extensions, but things should work then. :-)

Reply to "Error migrating mediawiki built with php5.2 to server with php5.3"