Geeklog Forums

I installed the binary from mysql.com, and it does appear to sort messages properly, with one BIG caveat: all stories seemed to have lost their date stamp. In my case, not a big deal since I don't have a lot; I just manually re-dated them all, and now they sort properly.

The basic process for installing the binary went about like this:

1) Download the binary release and unzip / untar it, then move the resulting directory to /usr/local.

2) Follow the installation steps in the INSTALL-BINARY file for creating a symbolic link to /usr/local/mysql from the mysql directory, e.g. and also follow the 'chown' steps.

3) Rename /usr/local/mysql/data to data.new or something, then symlink from /var/mysql (which is where the existing databases live) to /usr/local/mysql/data as follows:

That should be about it. In my case, I had to also revert to a 'stock' geeklog distribution, free of the various hacks I'd attempted to fix this sorting problem, so I just took the opportunity to upgrade to the latest version.

Note that if you're upgrading, you can skip the creation of the mysql user / group, and also skip the install_db (since you'll be using your existing one).

Hope this helps,
-Andre

This issue is now fixed in the Mac OS X Server 10.3.3 update:

http://docs.info.apple.com/article.html?artnum=107851#sql

Mac OS X Server 10.3.3 includes a new binary of MySQL 4.0.18 that fixes the issue that was present in the included MySQL in Mac OS X Server 10.3, 10.3.1, and 10.3.2.

Though it's mentioned in the document linked above, since some people never read before installing, I will add this:

** Be sure to dump your mysql db before the update, and then load it after **