Quote by Dirk:
Quote by heidialyssa: Has anyone discovered a fix for this?
Well, apparently you have 2 options:
- Install the MySQL binary from mysql.com
- Yell at Apple to fix it
bye, Dirk
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.
Text Formatted Code
ln -s /usr/local/mysql-standard-4.0.17-apple-darwin6.8-powerpc
/usr/local/mysql
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:
Text Formatted Code
ln -s /var/mysql /usr/local/mysql/data
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