MySQL 5.0.12 Compatibility patch

Started by Compuart, November 06, 2005, 09:19:38 PM

Previous topic - Next topic

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.
Hendrik Jan Visser
Former Lead Developer & Co-founder www.simplemachines.org
Personal Signature:
Realitynet.nl -> ExpeditieRobinson.net / PekingExpress.org / WieIsDeMol.Com


Saleh

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

We don't need a reason to help people

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 ;)
Hendrik Jan Visser
Former Lead Developer & Co-founder www.simplemachines.org
Personal Signature:
Realitynet.nl -> ExpeditieRobinson.net / PekingExpress.org / WieIsDeMol.Com

Trekkie101

Quote from: Compuart on November 07, 2005, 01:25:48 PM
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?

SMF 2.0
TP 1.0 RC1.1
Wordpress 3.1.3

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).
Hendrik Jan Visser
Former Lead Developer & Co-founder www.simplemachines.org
Personal Signature:
Realitynet.nl -> ExpeditieRobinson.net / PekingExpress.org / WieIsDeMol.Com

RoarinRow

Quote from: Compuart on November 07, 2005, 01:54:34 PM
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.

SMF 2.0
TP 1.0 RC1.1
Wordpress 3.1.3

JayBachatero

Future versions will be compatible right starting with RC2?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Compuart

Hendrik Jan Visser
Former Lead Developer & Co-founder www.simplemachines.org
Personal Signature:
Realitynet.nl -> ExpeditieRobinson.net / PekingExpress.org / WieIsDeMol.Com

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)
Hendrik Jan Visser
Former Lead Developer & Co-founder www.simplemachines.org
Personal Signature:
Realitynet.nl -> ExpeditieRobinson.net / PekingExpress.org / WieIsDeMol.Com

Aaron

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

RoarinRow

#15
Quote from: Aäron on November 07, 2005, 02:21:24 PM
Update went like a charm! I love that Package Manager! :P

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

SMF 2.0
TP 1.0 RC1.1
Wordpress 3.1.3

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.

SMF 2.0
TP 1.0 RC1.1
Wordpress 3.1.3

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?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

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.

SMF 2.0
TP 1.0 RC1.1
Wordpress 3.1.3

Advertisement: