Announcement

Collapse
No announcement yet.

db error on password reset

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

  • 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

  • #2
    What is the actual error?
    Kerry-Anne :)

    Twitter Blog

    www.peterska2.com www.worldnewszone.com www.popularusenetgroups.com www.superclickers.co.uk www.forumsforchrist.com www.browsergameplanet.com

    Comment


    • #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


      • #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


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

          Comment


          • #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
            Kerry-Anne :)

            Twitter Blog

            www.peterska2.com www.worldnewszone.com www.popularusenetgroups.com www.superclickers.co.uk www.forumsforchrist.com www.browsergameplanet.com

            Comment


            • #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


              • #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?
                Kerry-Anne :)

                Twitter Blog

                www.peterska2.com www.worldnewszone.com www.popularusenetgroups.com www.superclickers.co.uk www.forumsforchrist.com www.browsergameplanet.com

                Comment


                • #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


                  • #10
                    last table is "word"

                    Comment


                    • #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?
                      Kerry-Anne :)

                      Twitter Blog

                      www.peterska2.com www.worldnewszone.com www.popularusenetgroups.com www.superclickers.co.uk www.forumsforchrist.com www.browsergameplanet.com

                      Comment


                      • #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


                        • #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

                          Working...
                          X