Changes

As of 1.711.10, there are two tables affected by this problem: '''categorylinks''' and '''jobs''' (The key is 2 * (255 255 8) = 1032). Both of these changes need to be made in '''/maintenance/tables.sql''' ''before'' running the initial configuration.

*http://bugzilla.wikimedia.org/show_bug.cgi?id=11428 ==Updating MySQL on Mac OS X==I just went through a prolonged ordeal to upgrade MySQL from 5.1.30 to 5.1.47, so I'm going to write down some steps so that I don't hit so many dead-ends in the future. Note that this presumes that you have already done a DB dump of your wiki database (i.e. SequelPro's Export… command). The installer does not detect the presence of an older installation, and as a result, leaves the old data directory untouched. In retrospect, you could probably just move it and all would be well. Alternatively, you can recreate your databases as well. Here's what I did. * First, to run the <tt>mysql_upgrade</tt> script, enable the root user in Directory Utility (which is now in CoreServices, or accessible from the Accounts prefpane).* <tt>su -</tt>* <tt>su _mysql -c "/usr/local/mysql/mysql_upgrade"</tt>* <tt>logout</tt>* Restart MySQLNow, [http://dev.mysql.com/doc/refman/5.1/en/default-privileges.html secure the root/guest accounts], [http://dev.mysql.com/doc/refman/5.1/en/create-user.html create the wiki user], and [http://www.mediawiki.org/wiki/Manual:Installing_MediaWiki#MySQL create the wiki db and grant privileges]. Go into LocalSettings.php and change the connection settings so that it doesn't try to connect to the DB until you are done with the rest. Then* <tt>sudo mkdir /usr/local/mysql/etc</tt>* <tt>sudo chown -R mysql /usr/local/mysql/etc</tt>* <tt>su -</tt>* <tt>su -m _mysql -c "touch /usr/local/mysql/etc/my.cnf"</tt> (you can safely ignore the <tt>getcwd</tt> error)* <tt>logout</tt>* Turn off root user* Add this to the <tt>my.cnf</tt> file::<code>[mysqld]<br/>max_allowed_packet=10737418</code>* Restart MySQL again* Fire up SequelPro and import the SQL dump made earlier. Errors related to disallowed <tt>DROP</tt> operations are fine.* Change back the connection parameters in LocalSettings.php and refresh the wiki! {{cs projects}}