So I thought I'd take a big jump and just go from 1.0 RC2 to 1.1 RC3. Hmm, not so good an idea. Site is http://www.nashvillebellydance.com (http://www.nashvillebellydance.com)
While upgrade.php seemed to run successfully, I'm getting some major weirdness when I try to see 'latest posts since your last visit':
Database Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND IFNULL(lt.ID_MSG, IFNULL(lmr.ID_MSG, 0)) < t.ID_LAST_MSG' at line 7
File: /home/sara/nashvillebellydance.com/smf/Sources/Recent.php
Line: 748
Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.0 RC2, while your database is at version 1.1 RC3. The above error might possibly go away if you execute the latest version of upgrade.php.
When I look in database admin, it says I am still using SMF 1.0 RC2. None of the Forum Maintenance tools seem to help, though they all say they work.
I am running MySQL 4.1.14 on Linux.
Should I try the upgrade to 1.0.8 and see if that helps? The forums mostly work, but things like the above don't work, and the login box for mambo doesn't work either (I'm starting to think I need to start this site over from scratch).
did you download the upgrade package or the update package?