Last modified: 2010-05-15 15:56:41 UTC
Hi im using mysql 5.0.22 as a backend for mediawiki latest rev. We already have a wiki in place but im changing servers and therefore im backing up the data from mysql v 4.1 and restoring it to a new mysql 5 installation on a different box. Im getting consistent errors however that I am sure to do with the dbase structure, though I could be completely wrong in this as my experience with both mysql and media wiki is 1 whole afternoon.. Im getting: 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 "Block::loadRange". MySQL returned error "1054: Unknown column 'ipb_range_start' in 'where clause' (localhost)". and having a google around im finding that its a problem with the way that 5 handles 4.1's data though there really isnt much on the net about this error. This error occurs whenever I try to manipulate ('edit' discussion' etc) the data in any way - viewing is fine, but anything else is not. This error does NOT occur before I restore my data from mysql v 4.1 can you help? Thanks Alastair Jones Methodology Group
You aren't changing MediaWiki version each time? Could you post a little bit more information about what your process of migrating to and from 4.1/5.0 entails to allow reproduction of the error? Thanks. Also, when you originally set up MediaWiki, did you select "backwards-compatible UTF-8 handling", or are you using the experimental UTF-8 stuff?
Hi my legacy server runs: MYSQL 4.1.11 server / 5.0.11 Client Apache Http server 2.0.55 Media Wiki 1.5.2 and PHP, though I dont know what version - it would have been the latest available mid november last year (which is when this wiki went live) my new server will run: MYSQL 5.0.22 / client 5.0.4 IIS v 6 (server 2003 sp1) Media Wiki 1.6.7 (Current stable rev) PHP 5.1.4 all im doing to get the data from the old sql to the new is to backup the data to file, and the to restore it to the new DB. I am selecting the backup defaults when I dump the data out from the old box - these are: Backup execution method - innoDB Online Backup Output file soptions - SQL files / Add DROP statements / Complete INSERTS / Comment / Disable Keys. I am following the install guide located at: http://meta.wikimedia.org/wiki/Installing_MediaWiki_on_Windows_Server_2003_SP1 Though the second half of section 5 - adding of additional commands - fails. The original mediawiki would have been setup with defaults and whatever was a recommended config at that time - the person that I have inherited this from knew as much about this subject as I do (though my knowledge is growing exponentially) and therefore wouldnt not have strayed from any default options. Thanks Alastair Jones
Hi after dumping everything, I started again with a fresh install of mediawiki & PHP but this time using a new install of mysql 4.1 and a restore of the datsa from the production mysql server...I get the same error, so it would appear to not be a mysql error... Thanks Alastair
Please run the maintenance/update.php script to upgrade your database schema. It can also be done by renaming LocalSettings.php and redoing the installation (in case you dont have a shell access).
yes - fantastic. this works. i create the wiki, restore my db, dump the local settings and let in upgrade the schema. So (as im testing all this in a VM) i dump the machine, build another and start again so that I have a nice fresh install of everything without any hint of problems that I may have created by mucking around with it. Only now I get: MediaWiki 1.6.7 Installation Don't forget security updates! Keep an eye on the low-traffic release announcements mailing list. Checking environment... Please include all of the lines below when reporting installation problems. Warning: dl() [function.dl]: Unable to load dynamic library './mysql.so' - The specified module could not be found. in C:\mediawiki-1.6.7\install-utils.inc on line 19 Could not load MySQL driver! Please compile php --with-mysql or install the mysql.so module. Every single time, yet I am doing nothing different from the first time I install and im following the same instructions. I have copied libmysql.dll into the PHP folder, and I even went and found a copy of php_mysql.dll and copied to same - no effect. so I copied everything from the PHP zip to C:\php and c:\mediawiki, and I stuck some components in system32 as another blog I found suggested the same. still the same error. With every file in every location, this still doesnt work and its driving me nuts!.... alastair jones
Your last error is PHP related. You're not having mysql installed. On PHP5 mysql extension is not enabled by default. See the manual but i give you the trick: you need to edit your php.ini and uncomment the line for mysql ;) Closing this old bug.
