Welcome to Geeklog, Anonymous Thursday, October 10 2024 @ 10:40 pm EDT
Geeklog Forums
Sort order isn't by date - panther fix
Page navigation
Status: offline
dreness
Forum User
Newbie
Registered: 08/06/03
Posts: 11
Quote by Dirk:
Well, apparently you have 2 options:
bye, 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
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/dataThat 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
31
31
Quote
Status: offline
das
Forum User
Newbie
Registered: 01/03/04
Posts: 11
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.
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.
32
26
Quote
dreness
Anonymous
Quote by das: 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
http://docs.info.apple.com/article.html?artnum=107851#sql
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 **
22
29
Quote
Page navigation
All times are EDT. The time is now 10:40 pm.
- Normal Topic
- Sticky Topic
- Locked Topic
- New Post
- Sticky Topic W/ New Post
- Locked Topic W/ New Post
- View Anonymous Posts
- Able to post
- Filtered HTML Allowed
- Censored Content