Announcement

Collapse
No announcement yet.

I have problem whit register

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • I have problem whit register

    Hello.. i have problem whit register of users :S ..

    Users are register but acept this data base error .. :

    There seems to have been a problem with the database.
    Please try again by clicking the Refresh button in your web browser.
    An E-Mail has been dispatched to our Techincal staff whom you can also contact if the problem persists.


    and in my mail (i the admin):

    Database error in vBulletin 3.5.4:

    Invalid SQL:
    INSERT INTO userfield
    (userid)
    VALUES
    (12179);

    MySQL Error : Duplicate entry '12179' for key 1
    Error Number : 1062


    Help me please ..
    Last edited by headshotx; Sat 13 May '06, 3:22pm.

  • #2
    Did you install any hacks or plugins? Did you recently backup and restore this database?
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      Hi

      My forums have just developed a similar problem:

      MySQL Error : Duplicate entry '0' for key 1
      Error Number : 1062

      They have just been moved from a MySQL 4.1 dedi to MySQL 4.0 shared.

      Any ideas?
      The East Anglia Web Forums
      A discussion forum for all things entertainment,
      leisure and business related in the East Anglia region of the UK.

      Check out my suggestions thread, it’s ace!

      Comment


      • #4
        This is a problem with your backup. Please see this post for the queries to run to reset auto-incrementing:

        http://www.vbulletin.com/forum/showt...50#post1079950
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment

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