Hello There, Guest! › Register

MySubscriptions 2.2 released.
Looking for a custom plugin for your site? Ask here for a quote.

Solved MySQL Error
#1

When clicking on "Statistics" in the New Points menu, the following error is returned:

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1064 - 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 ') AS newpoints FROM mybb_users ORDER BY newpoints DESC LIMIT 200' at line 1
Query:
SELECT uid,username,newpoints + ROUND(POW(1.05, FLOOR((1354590443-newpoints_bankbasetime) / 86400)) * newpoints_bankoffset, ) AS newpoints FROM mybb_users ORDER BY newpoints DESC LIMIT 200


I do not believe any edits have been made to new points templates.

???

Edit: I recently accessed the statistics page just a couple days ago and it was ok.

I disabled the BANK plugin and all seems fine now.

Unfortunately you do not have sufficient rights to view replies in this thread. For full access, consider upgrading.





Users browsing this thread: 1 Guest(s)