News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

Database Error, Please help

Started by Valiant1213, July 29, 2014, 01:40:32 PM

Previous topic - Next topic

Valiant1213

I just downloaded and installed the new package which is version 2.0.8 and it installed successfully.
Then I receive this message:

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 'ORDER BY b.board_order' at line 21
File: /home/vajrayan/public_html/gurujiforum.com/Sources/Subs-BoardIndex.php
Line: 72

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 2.0.8, while your database is at version 2.0.2. The above error might possibly go away if you execute the latest version of upgrade.php.


Please help. I'm really not familiar on how to do this.

Thank you in advance.

Arantor

So what mods did you have installed beforehand?

The MySQL Order By Fix mod, or perhaps PMx SubForums?

Valiant1213

It seems I have this mod installed:
MySQL Board Order Fix

Do I need to uninstall it and it will be fixed?

Thanks a lot.

Arantor

You can uninstall it since 2.0.8 contains the same fix. (The exact same code, in fact)

Valiant1213

Thanks for your help, it now works.

Advertisement: