« New minimum Perl version: 5.6.1 | Main | Possible category/entry archive URL breakage »

SQLSetNames for MySQL 3.x and 4.0.x users

NOTE: This is no longer relevant with Beta-2

If you are installing (not upgrading) Movable Type v3.3 (Beta 1) and running a version of MySQL older than 4.1, you must add a new configuration directive to your mt-config.cgi to disable the set names command sent when your database driver is initialized by Movable Type. To do so, simply add this to mt-config.cgi:

SQLSetNames 0

If you do not do this, you will receive an error upon install. We try very hard to make sure that you don't have to care about such things, but this issue came up very recently and we decided to document this here instead of postponing the beta until a fix had been applied. Explicitly setting this directive will not be necessary in Beta-2.

If you don't know your MySQL version, check your web host's configuration web interface (e.g. cPanel) or, if you have phpMyAdmin installed, it will be listed at the top of the main page.

Comments

The description above is confusing. It starts out with "If you are installing (not upgrading)" and then further down states "you will receive an error upon upgrade"...

So does this issue affect upgrades, fresh installs, or both? ;)

Thanks Mark. Fixed now. A simple typo.

Ran into this problem on JaguarPC, but they are currently working their way through an upgrade to all servers so it will not be a problem in the long run.

Post a comment



Six Apart
Makers of weblog software and services for individuals, organizations and businesses.
This website is powered by Movable Type.