MySQL 5.0.12 Compatibility patch

[Compuart]

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 2005
  Since 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.

[Bonk]

Thank you! 

[Saleh]

and I thought MySQL 5 was bad because it gave me errors!
will try this one..
thanks

[CapriSkye]

this might be related to mysql 5?
http://www.simplemachines.org/community/index.php?topic=55642.0
i tried the patch and still receive that error.

[Trekkie101]

Very speedy release

Just out of curiosity, does this run any better than MySQL4, or have you not had time to run benchmarks or quick comparisons?

[Compuart]

Hard to say. It's often a matter of configuration. But in general, newer versions have slightly better query optimizations and might be a little faster. As a downside, they'd probably consume more memory as well

[Trekkie101]

Hard to say. It's often a matter of configuration. But in general, newer versions have slightly better query optimizations and might be a little faster. As a downside, they'd probably consume more memory as well

Thanks, I would try MySQL5 on this machine but memory useage is at 88% (256MB Ram) so ill need to wait until I upgrade a bit.

[RoarinRow]

Do I or should I apply this patch to my existing forum running v.1.05?  If so, any risks?

[Compuart]

The patch works for both 1.0.5 and 1.1 RC1. There are no risks if you do and there are no risks if you don't apply the patch (at least, if the patch doesn't conflict with modifications you might've already installed). However if/when your host decides to upgrade MySQL to version 5, several pages might stop working (but you'll still be able to apply the patch afterwards).

[RoarinRow]

The patch works for both 1.0.5 and 1.1 RC1. There are no risks if you do and there are no risks if you don't apply the patch (at least, if the patch doesn't conflict with modifications you might've already installed). However if/when your host decides to upgrade MySQL to version 5, several pages might stop working (but you'll still be able to apply the patch afterwards).

Great, thanks.

[JayBachatero]

Future versions will be compatible right starting with RC2?

[Compuart]

Definitely

[HEB XI 1]

Is the patch backwards compatible?  As in, can I safely apply it even if my host has not (or does not plan to) upgrade to MySQL 5?

[Compuart]

Yes, it should be safe for all versions of MySQL supported by SMF (> MySQL 3.23.28)

[Aaron]

Update went like a charm! I love that Package Manager!

[RoarinRow]

Update went like a charm! I love that Package Manager!

Ditto.  I was a little nervous, but did it anyway.   

[RoarinRow]

I got this email from my server:

"There has been a problem with the database!
MySQL reported:"

Not sure what the problem is.  There is not other text.

[gijs]

Help!

The patch downloaded well but installation gave an error:
You cannot download or install new packages because the Packages directory or one of the files in it are not writable!

This came after this message:
FTP Information Required
Some of the files the package manager needs to modify are not writable. This needs to be changed by logging into FTP and using it to chmod or create the files and folders. Your FTP information may be temporarily cached for proper operation of the package manager.

[JayBachatero]

You need to make the files writeable.  CHMOD them to 777

How do I use chmod?

[RoarinRow]

Now I get this error:

File './smf/smf_log_online.MYD' not found (Errcode: 13)
File: /forum/Sources/Subs.php
Line: 1347

Note: It appears that your database may require an upgrade. Your forum files are currently at version SMF 1.0.5, whereas your database is at version SMF 1.0.2. It is recommended that you execute the latest version of upgrade.php.