2018-04-22, 07:02 PM
I ave been trying for weeks now to get Advanced Ads Manager (1.1.0) work with Newpoints without success.
The problem is when ever a user wants to place adverts that amount of point to spend is up to 1,000.00 points I get the following error;
Please help
I work on Windows localhost with MyBB Version 1.8.15
PHP Version 7.1.11
SQL Engine MySQLi 10.1.28
The problem is when ever a user wants to place adverts that amount of point to spend is up to 1,000.00 points I get the following error;
Quote: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 MariaDB server version for the right syntax to use near '000.00 WHERE uid = '5'' at line 2Query:UPDATE mybb_users SETnewpoints
=newpoints + -1,000.00 WHERE uid = '5'
Please contact the MyBB Group for technical support.
Please help
I work on Windows localhost with MyBB Version 1.8.15
PHP Version 7.1.11
SQL Engine MySQLi 10.1.28