new 3.8.1 installation - DB error on adding member

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • upuaut
    Member
    • Aug 2001
    • 63

    new 3.8.1 installation - DB error on adding member

    This is a clean installation, after which I impex'd into it from 2.0.x vb forum.
    Upon testing adding new members, I get a DB error. I do not get an with the details of the error. And the new user does not get the activation email.

    I can see the the user get created in the DB, sitting in 'awaiting confirmation' user group.



    Where should I look to start trouble shooting this problem.
    thanks.
  • Trevor Hannant
    vBulletin Support
    • Aug 2002
    • 24325
    • 5.7.X

    #2
    Originally posted by upuaut
    This is a clean installation, after which I impex'd into it from 2.0.x vb forum.
    Upon testing adding new members, I get a DB error. I do not get an with the details of the error. And the new user does not get the activation email.

    I can see the the user get created in the DB, sitting in 'awaiting confirmation' user group.



    Where should I look to start trouble shooting this problem.
    thanks.
    Post the details of the error here so we can have a look at it. If you view the source code of the Database Error page, it'll be at the foot of the code...
    Vote for:

    - Admin Settable Paid Subscription Reminder Timeframe (vB6)
    - Add Admin ability to auto-subscribe users to specific channel(s) (vB6)

    Comment

    • upuaut
      Member
      • Aug 2001
      • 63

      #3
      Ah. didn't occur to me the err would be in the source. below..

      Database error in vBulletin 3.8.1:

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

      MySQL Error : Duplicate entry '1390' for key 1
      Error Number : 1062
      Request Date : Saturday, May 2nd 2009 @ 04:33:45 PM
      Error Date : Saturday, May 2nd 2009 @ 04:33:45 PM
      Script : http://www.jannah.com/f/register.php?do=addmember
      Referrer : http://www.jannah.com/f/register.php?do=register
      IP Address : 67.188.61.190
      Username : negentropy
      Classname : vB_Database
      MySQL Version :
      -->

      Comment

      • Floris
        Senior Member
        • Dec 2001
        • 37767

        #4
        I recommend to run optimize/repair on the database,
        then go to the admincp>maintneance> update counters and run them.
        then upgrade to 3.8.2 which is the latest stable, fixing any potential bugs.

        Comment

        • Trevor Hannant
          vBulletin Support
          • Aug 2002
          • 24325
          • 5.7.X

          #5
          Do the following tables have the same number of rows?

          user
          userfiled
          usertextfield
          Vote for:

          - Admin Settable Paid Subscription Reminder Timeframe (vB6)
          - Add Admin ability to auto-subscribe users to specific channel(s) (vB6)

          Comment

          • Floris
            Senior Member
            • Dec 2001
            • 37767

            #6
            I do not know. Sorry.

            Comment

            • Trevor Hannant
              vBulletin Support
              • Aug 2002
              • 24325
              • 5.7.X

              #7
              Originally posted by Floris
              I do not know. Sorry.
              Didn't see your post when I posted that so should really have quoted OP...
              Vote for:

              - Admin Settable Paid Subscription Reminder Timeframe (vB6)
              - Add Admin ability to auto-subscribe users to specific channel(s) (vB6)

              Comment

              • upuaut
                Member
                • Aug 2001
                • 63

                #8
                users:1095
                userfields:2476
                usertextfield:2476

                Comment

                • upuaut
                  Member
                  • Aug 2001
                  • 63

                  #9
                  btw, i followed Floris' suggestion, still get the error

                  Comment

                  • Floris
                    Senior Member
                    • Dec 2001
                    • 37767

                    #10
                    i have no idea if this works, but .. try going to the admincp>maintenance>database repair > browse down adn click on 'remove duplicate id' .. maybe this applies to these fields too.

                    Comment

                    • upuaut
                      Member
                      • Aug 2001
                      • 63

                      #11
                      unfortunately no. the same error happens with the counter incremented by 1.

                      Comment

                      • upuaut
                        Member
                        • Aug 2001
                        • 63

                        #12
                        should i delete the ids from userfield and usertextfield that are not in user?

                        Comment

                        • upuaut
                          Member
                          • Aug 2001
                          • 63

                          #13
                          I resolved it.
                          1- delete from userfield where userid not in (select userid from user);
                          2- delete from usertextfield where userid not int (select userid from user);
                          3- attempt to register. worked.

                          thanks for the pointer.

                          Comment

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