I just got a repeated error related to a subscription. It appears to have happened 10 times. Can someone give me some guidance?
The error in the error log is:
[30-Nov-2017 02:00:39 UTC] PHP Warning: mysqli_query(): (42000/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 'WHERE userid = 25275 AND
subscriptionid = 1' at line 6 in /home/teambuic/public_html/forums/includes/class_core.php on line 1394
I also received an email notification:
Database error in vBulletin 4.2.3:
Invalid SQL:
UPDATE vb3_subscriptionlog
SET status = 1,
pusergroupid = 13,
regdate = 1512007237,
expirydate =
WHERE userid = 25275 AND
subscriptionid = 1;
MySQL 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 'WHERE userid = 25275 AND
subscriptionid = 1' at line 6
Error Number : 1064
Request Date : Thursday, November 30th 2017 @ 02:00:37 AM
Error Date : Thursday, November 30th 2017 @ 02:00:39 AM
Script : http://www.xxxxxxxx.com/forums/payment_gateway.php?method=paypal
Referrer :
IP Address : 173.0.81.1
Username :
Classname : vB_Database_MySQLi
MySQL Version :
On the Script line it shows http: where the site is https:. I thought everything was updated probably not a related problem.
Thanks
The error in the error log is:
[30-Nov-2017 02:00:39 UTC] PHP Warning: mysqli_query(): (42000/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 'WHERE userid = 25275 AND
subscriptionid = 1' at line 6 in /home/teambuic/public_html/forums/includes/class_core.php on line 1394
I also received an email notification:
Database error in vBulletin 4.2.3:
Invalid SQL:
UPDATE vb3_subscriptionlog
SET status = 1,
pusergroupid = 13,
regdate = 1512007237,
expirydate =
WHERE userid = 25275 AND
subscriptionid = 1;
MySQL 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 'WHERE userid = 25275 AND
subscriptionid = 1' at line 6
Error Number : 1064
Request Date : Thursday, November 30th 2017 @ 02:00:37 AM
Error Date : Thursday, November 30th 2017 @ 02:00:39 AM
Script : http://www.xxxxxxxx.com/forums/payment_gateway.php?method=paypal
Referrer :
IP Address : 173.0.81.1
Username :
Classname : vB_Database_MySQLi
MySQL Version :
On the Script line it shows http: where the site is https:. I thought everything was updated probably not a related problem.
Thanks