Subscription Error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • rcull
    Senior Member
    • Jan 2005
    • 336
    • 4.2.x

    Subscription Error

    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
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...