MySQL AB recently announced their fifth version of MySQL to be ready for production use. Version 5 comes with a lot of new features, like stored procedures, triggers, and views. As of MySQL 5.0.12, a few changes have been made in the precedence of table joins. This causes some pages of Simple Machines Forum to stop working.
Simple Machines is therefore happy to release a compatibility patch for both 1.0.5 and 1.1 RC1. If you or your provider are planning on upgrading their MySQL server to 5.0.12 or higher, you can easily patch your forum in one of the following ways:
- Use the package manager in your administration center - one click, and you're done.
- Download the modification file, attached to this message, and modify the files manually according to it.
- Download the modified files, also attached to this message and overwrite your current files with them.
Regardless of whether this patch is applied or not, SMF will install without a problem on a MySQL 5.0.12 server and the package manager will remain accessible.
Addition - 12th December 2005Since the first patch another problem with capatibility has been identified. If you had applied the previous patch, and now find sorting in the personal message centre does not work, run the modification attached to this post called smf_mysql_5.0.12_patch2. For all people patching for the first time simply use smf_mysql_5.0.12.