Database error help me please urgent

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • SherYjuTT
    Member
    • Jan 2008
    • 44
    • 3.0.0 Release Candidate 3

    Database error help me please urgent

    Code:
    Database error in vBulletin 3.7.0 Release Candidate 3:
    
    Invalid SQL:
    
                                    SELECT forum.forumid, lastpost, lastposter, lastthread, lastthreadid, lasticonid, threadcount, replycount, lastpostid, lastprefixid
    
                                    FROM forum AS forum;
    
    MySQL Error   : Unknown column 'lastthread' in 'field list'
    Error Number  : 1054
    Date          : Thursday, April 17th 2008 @ 05:39:26 PM
    Script        : [URL]http://www.paki-gang.com/index.php[/URL]
    Referrer      :
    IP Address    : [URL="http://116.71.164.205/"]11*********[/URL]
    Username      : __The.Killer__
    Classname     : vB_Database
    MySQL Version : 5.0.45-community
    Help me PLEASE ANY ONE HELP ME IT'S URGENT( Y I SEE ERROR WHEN I TRY TO OPEN MY SITE

    WELL I HAVE UPGRADE MY FORUM
    FROM : vBulletin® 3.7.0 Release Candidate 1
    TO:
    vBulletin® 3.7.0 Release Candidate 3
    SHeRY
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    #2
    Invalid SQL errors are almost always related to modified code.

    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?
    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

    • SherYjuTT
      Member
      • Jan 2008
      • 44
      • 3.0.0 Release Candidate 3

      #3
      Originally posted by Steve Machol
      Invalid SQL errors are almost always related to modified code.

      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?




      WHAT DO YOU MEAN SIR Ill REPAIR ALL MY FORUM

      OR DELETE ALL XML FILE:-??
      SHeRY

      Comment

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

        #4
        You need to follow the instructions I posted.
        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

        • SherYjuTT
          Member
          • Jan 2008
          • 44
          • 3.0.0 Release Candidate 3

          #5
          Mr steev
          I erased all the files
          But not changed anything

          So,
          I do my ftp login passwords

          And password admin

          You can do anything I do not understand


          THANKS IN ADVANCE
          SHeRY

          Comment

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

            #6
            First, you have ignored my PM about you sig. You need to fix this now.

            Second you have not followed my instructions. You will need to do that to fix this error.
            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

            • SherYjuTT
              Member
              • Jan 2008
              • 44
              • 3.0.0 Release Candidate 3

              #7
              Can I Upgeade From 3.7.0 To 3.6.8
              SHeRY

              Comment

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

                #8
                Of course, but that will probably not solve this problem.
                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

                • SherYjuTT
                  Member
                  • Jan 2008
                  • 44
                  • 3.0.0 Release Candidate 3

                  #9
                  I have already done as I told you

                  But not changed anything
                  SHeRY

                  Comment

                  • SherYjuTT
                    Member
                    • Jan 2008
                    • 44
                    • 3.0.0 Release Candidate 3

                    #10
                    Warning: require_once(/home2/crich/public_html/includes/functions_credits.php) [function.require-once]: failed to open stream: No such file or directory in /plugins/credits_plugins.php on line 24

                    Fatal error: require_once() [function.require]: Failed opening required '/home2/crich/public_html/includes/functions_credits.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home2/crich/public_html/plugins/credits_plugins.php on line 24
                    SHeRY

                    Comment

                    • Auction Guy
                      Senior Member
                      • Feb 2007
                      • 167
                      • 3.6.x

                      #11
                      Originally posted by SherYjuTT
                      Warning: require_once(/home2/crich/public_html/includes/functions_credits.php) [function.require-once]: failed to open stream: No such file or directory in /plugins/credits_plugins.php on line 24

                      Fatal error: require_once() [function.require]: Failed opening required '/home2/crich/public_html/includes/functions_credits.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home2/crich/public_html/plugins/credits_plugins.php on line 24
                      Is your config.php filled in with the right info??

                      What mods do you have installed?

                      I think that Steve is right but I'm just asking.

                      Comment

                      • SherYjuTT
                        Member
                        • Jan 2008
                        • 44
                        • 3.0.0 Release Candidate 3

                        #12
                        Originally posted by Auction Guy
                        Is your config.php filled in with the right info??

                        What mods do you have installed?

                        I think that Steve is right but I'm just asking.
                        yes sir CONFIG PHO file is alright

                        and i have disable all mods
                        and i have deleted all xml file :-W
                        Last edited by SherYjuTT; Thu 17 Apr '08, 11:40pm.
                        SHeRY

                        Comment

                        • SherYjuTT
                          Member
                          • Jan 2008
                          • 44
                          • 3.0.0 Release Candidate 3

                          #13
                          No Boddy Want Help me

                          SHeRY

                          Comment

                          • Creepshow
                            Senior Member
                            • May 2005
                            • 2309
                            • 3.5.x

                            #14
                            Have you followed the instructions that Steve posted to the letter? If not, that's what you need to do in order to fix the problem...
                            "CREEPSHOW CREEPS ONLINE" - The first & best online resource dead-icated to Stephen King & George A. Romero's 1982 horror anthology classic!!!!

                            Comment

                            • Gomjaba
                              Senior Member
                              • Jan 2005
                              • 970
                              • 3.5.x

                              #15
                              Originally posted by SherYjuTT
                              No Boddy Want Help me

                              Steve kept telling you what to do and you deleted all the files ? That doesn't make sense - but your error

                              failed to open stream: No such file or directory
                              Does make sense now

                              Why did you delete the files ?
                              I'm not under the alkafluence of inkahol like some thinkle peep I am!

                              Comment

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