db error on password reset

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • hbalagh
    Senior Member
    • Jun 2005
    • 101

    db error on password reset

    Im having an issue when a user request a pw reset.. email will be reset and when you go to click the link that is sent to you to reset ur pw is gives a db error
  • peterska2
    Senior Member
    • Oct 2003
    • 8869
    • 3.7.x

    #2
    What is the actual error?

    Comment

    • hbalagh
      Senior Member
      • Jun 2005
      • 101

      #3
      doesn't say what the error is just says
      The Jeep Scrambler Forums & Discussions database has encountered a problem. Please try the following:
      • Load the page again by clicking the Refresh button in your web browser.
      • Open the www.cj-8.com home page, then try to open another page.
      • Click the Back button to try another link.

      The www.cj-8.com forum technical staff have been notified of the error, though you may contact them if the problem persists.
      We apologise for any inconvenience.

      Comment

      • Steve Machol
        Former Customer Support Manager
        • Jul 2000
        • 154488

        #4
        We need to see the real error message. Right-click on the error page and go to View/Source. Then copy-n-paste the error message here.
        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

        • hbalagh
          Senior Member
          • Jun 2005
          • 101

          #5
          if i do that, it shows nothing but the html nothing about any errors in it

          Comment

          • peterska2
            Senior Member
            • Oct 2003
            • 8869
            • 3.7.x

            #6
            Its near the bottom. Look for a line that says Database Error and the actual error will be displayed below that. It may also be emailed to you if you put your email address in the technical email address section of config.php

            Comment

            • hbalagh
              Senior Member
              • Jun 2005
              • 101

              #7
              Invalid SQL:
              UPDATE mos_users SET password='d5e2327fc07d3db9c659832ef35b004f' WHERE vb_userid='17243';

              MySQL Error : Table 'forums.mos_users' doesn't exist
              Error Number : 1146
              Request Date : Sunday, June 14th 2009 @ 11:45:42 PM
              Error Date : Sunday, June 14th 2009 @ 11:45:42 PM
              Script : http://www.cj-8.com/forum/login.php?...40f35861ea6681
              Referrer :
              IP Address : edited out
              Username : Unregistered
              Classname : vB_Database
              MySQL Version :

              Comment

              • peterska2
                Senior Member
                • Oct 2003
                • 8869
                • 3.7.x

                #8
                Thats a serious problem. And you only get this when resetting a password?

                Check in phpmyadmin and see what the last table is that you have in your vbulletin database.

                Have you recently restored a database backup or made any other changes to your forums?

                Comment

                • hbalagh
                  Senior Member
                  • Jun 2005
                  • 101

                  #9
                  yes only when resetting the pw as far as i know

                  the last thing we have done to the forums is upgraded from i believe 3.5

                  Comment

                  • hbalagh
                    Senior Member
                    • Jun 2005
                    • 101

                    #10
                    last table is "word"

                    Comment

                    • peterska2
                      Senior Member
                      • Oct 2003
                      • 8869
                      • 3.7.x

                      #11
                      ok.

                      In that case, To troubleshoot this, first reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server. Also be sure to upload the admincp files to whichever directory you have set in your config.php file. Then run 'Suspect File Versions' in Diagnostics to make sure you have all the original files for your version and that none show 'File does not contain expected contents':

                      Admin CP -> Maintenance -> Diagnostics -> Suspect File Versions

                      [Note: In some cases you may also need to remove any of the listed .xml files in the includes/xml directory.]

                      Next, disable all plugins.

                      Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

                      define('DISABLE_HOOKS', true);

                      Then if you still have this problem, create a new style and choose no parent style. This will force it to use the default templates. Finally empty your browser cache, close all browser windows then try again. Make sure you change to the new style and view your forums with it.

                      Do you have the same problem?

                      Comment

                      • Lynne
                        Former vBulletin Support
                        • Oct 2004
                        • 26255

                        #12
                        There is no users table in vbulletin - it's user. I'm gonna guess that is some plugin that is used to register a user to some other application you are using on your forum.

                        Please don't PM or VM me for support - I only help out in the threads.
                        vBulletin Manual & vBulletin 4.0 Code Documentation (API)
                        Want help modifying your vbulletin forum? Head on over to vbulletin.org
                        If I post CSS and you don't know where it goes, throw it into the additional.css template.

                        W3Schools &lt;- awesome site for html/css help

                        Comment

                        • Steve Machol
                          Former Customer Support Manager
                          • Jul 2000
                          • 154488

                          #13
                          I agree with Lynne. That query could not come from vB. This is from a modification.
                          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...