MyBB-Plugins Forums

Full Version: MySQL Error
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
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.

No Permission

Unfortunately you do not have sufficient rights to view replies in this thread.