No announcement yet.

Error - Payment Gateway

  • Filter
  • Time
  • Show
Clear All
new posts

  • Error - Payment Gateway

    I upgraded to vB 5 last night.

    Now I am getting this error in an email and I'm worried the subscription payments are not working right. Please help. What should I check.

    Database error in vBulletin 5.1.1:

    Invalid SQL:
    INSERT INTO access (`userid`,`forumid`,`accessmask`) VALUES (5670,61,1)
    /**access- payment_gateway**/;

    MySQL Error : Duplicate entry '5670-61' for key 'PRIMARY'
    Error Number : 1062
    Request Date : Tuesday, July 1st 2014 @ 09:19:01 AM
    Error Date : Tuesday, July 1st 2014 @ 09:19:01 AM
    Script : http:///forum/payment_gateway.php?method=paypal
    Referrer :
    IP Address : (redacted for posting purposes)
    Username : Guest
    Classname : vB_Database_MySQL
    MySQL Version :

  • #2
    Did you delete your vBulletin 4 files before uploading the vBulletin 5 ones?

    To resolve the error, need to know which of the two numbers is "duplicate". You would need to find the max value in the database.
    Last edited by Wayne Luke; Wed 2 Jul '14, 12:00pm.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API


    • #3
      Yes. I deleted all vB4 files before upgrading.

      Finding a "max value" in the database is beyond my scope of ability.


      • #4
        Can you tell me how to find the max value in the database? Is that just a database search?


        widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.