Hi everyone,
I'm a teacher, and use SMF forums in my class that I host with TCH
I ran an SMF upgrade, but I can't get a good upgrade on the SQL database backing each of my class forums. I'm definitely NOT a SQL master user, in fact it has been so worry free for the last three years I don't even know where to start in getting to the root of this issues. To make matters worse, I need my students in these forums like last week...
When I run update.php to get the indexes and database inline with the forums I get:
Updating Settings.php... Successful.
Updating and creating indexes... Unsuccessful!
This query:
ALTER TABLE smf_smileys
ORDER BY LENGTH(code) DESC;
Caused the 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 'LENGTH(code) DESC' at line 2
And the error I keep getting on the front end of the SMF forums is:
Unknown column 'a.file_hash' in 'field list'
File: /home/***/public_html/aboforums/Sources/Display.php
Line: 711
Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.10, while your database is at version 1.1.2. The above error might possibly go away if you execute the latest version of upgrade.php.
Any help would be appreciated!
Thanks,
Jason