Error - Payment Gateway

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Hummie
    Senior Member
    • Nov 2007
    • 223

    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 :
  • Wayne Luke
    vBulletin Technical Support Lead
    • Aug 2000
    • 74154

    #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

    Comment

    • Hummie
      Senior Member
      • Nov 2007
      • 223

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

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

      Comment

      • Hummie
        Senior Member
        • Nov 2007
        • 223

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

        Comment

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