Announcement

Collapse
No announcement yet.

User Registration Errors...

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

  • User Registration Errors...

    I upgraded my forum to 2.3.0 and am now suddenly getting a bunch of MySQL errors. I have also been working on other scripts, but really don't think this is the problem. I checked the templates I had modified and reverted anything that seemed related to the registration process, but am still getting errors.

    Here's what was stated in the email I got:

    Database error in vBulletin 2.3.0:

    Invalid SQL:
    INSERT INTO useractivation
    (useractivationid, userid, dateline, activationid, type, usergroupid)
    VALUES
    (NULL, 25365, 1050077637, '87047941', 0, 2)

    mysql error: Unknown column 'usergroupid' in 'field list'

    mysql error number: 1054

    Date: Friday 11th of April 2003 12:13:57 PM
    Script: http://www.12ozprophet.com/forum/forum/register.php
    Referer: http://www.12ozprophet.com/forum/register.php

    Anyone have any ideas?

    Thanks for the help.

  • #2
    Make sure you run the upgrade scripts:
    http://vbulletin.com/members/upgrade.html

    Comment


    • #3
      Originally posted by Cary
      Make sure you run the upgrade scripts:
      http://vbulletin.com/members/upgrade.html
      I did run the upgarde scripts as directed.

      I uploaded all the files except those specified (install.php) and then ran:

      From 2.2.9
      http://www.mysite.com/forum/admin/upgrade23.php

      (with the correct URL)

      Comment


      • #4
        I just uploaded upgrade23.php and went to it with my browser and got: Warning: you are currently running version 2.3.0 and this script upgrades from version 2.2.9. If you are sure you want to continue, please click here otherwise please consult the upgrade instructions.

        I didnt run it again and I deleted the file, but like I said earlier I believe I did everything correctly.

        Comment


        • #5
          I disabled my forum in the meantime...

          Anyone have any clues at all? I'm stumped.

          Comment


          • #6
            I have the same problem. The column exists in the table, but the query seems to be failing.

            The two insert queries in register.php don't have data to be inserted for that column, in my copy ... would that be the problem? Haven't tested it yet ...

            Comment


            • #7
              I'm not sure what exactly th eissue is or how to fix, though I'm considering restoring my backup copy and trying again from scratch.

              Before i do it, anyone have any insight into this issue?

              Comment


              • #8
                Originally posted by Misteraven
                I'm not sure what exactly th eissue is or how to fix, though I'm considering restoring my backup copy and trying again from scratch.

                Before i do it, anyone have any insight into this issue?
                I fixed it by uploading a fresh copy of register.php ... doesn't seem to be a problem any more (strange)

                Comment


                • #9
                  I just noticed something else... I enabled the Image Verification feature and tried to register a new name and it didn's show up.

                  I tried uploading a fresh copy of register.php and it worked once and the stopped. However, I also noticed no email was sent out despite the fact that I make email verification required.

                  Anyone have any clues?

                  Comment


                  • #10
                    Got the image verification working. (hadnt set the GD version).

                    The rest still isnt working though.

                    Comment


                    • #11
                      I keep trying to re-register and noticed that it works maybe 25% of the time, but no emails are ever sent.

                      Help, please?!

                      Comment


                      • #12
                        If you have not installed any hacks, fill out a support ticket at:

                        http://www.vbulletin.com/members/support_form.php

                        Be sure to include the login info to your Admin CP and FTP.

                        If you have installed hacks, then remove the hacks first before filling out the support request.
                        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


                        • #13
                          vBulletin tech support was able to solve the issue. Turned out to be a MySQL user permission problem in which the user didn't have permission to Alter tables. I guess this wasnt an issue before. Once I added this permission, it worked fine.

                          Comment

                          Loading...
                          Working...
                          X