Database error on Cpanel and home page (Site not showing)

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Trendri
    Senior Member
    • Mar 2012
    • 221
    • 5.6.4

    [Forum] Database error on Cpanel and home page (Site not showing)

    I have data base error on my admincp and my website homepage.
    I encountered a database error severe enough to cause my site to be completely unaccessable

    I do not know the plugin that i uninstalled

    Please how do i fix this error some website can start working

    Database error in vBulletin 4.2.0:

    Invalid SQL:

    SELECT languageid,
    phrasegroup_global AS phrasegroup_global,
    phrasegroup_posting AS phrasegroup_posting,
    phrasegroup_postbit AS phrasegroup_postbit,
    phrasegroup_showthread AS phrasegroup_showthread,
    phrasegroup_inlinemod AS phrasegroup_inlinemod,
    phrasegroup_reputationlevel AS phrasegroup_reputationlevel,
    phrasegroup_bop5iframer AS phrasegroup_bop5iframer,
    phrasegroup_user AS phrasegroup_user,
    phrasegroupinfo AS lang_phrasegroupinfo,
    options AS lang_options,
    languagecode AS lang_code,
    charset AS lang_charset,
    locale AS lang_locale,
    imagesoverride AS lang_imagesoverride,
    dateoverride AS lang_dateoverride,
    timeoverride AS lang_timeoverride,
    registereddateoverride AS lang_registereddateoverride,
    calformat1override AS lang_calformat1override,
    calformat2override AS lang_calformat2override,
    logdateoverride AS lang_logdateoverride,
    decimalsep AS lang_decimalsep,
    thousandsep AS lang_thousandsep
    FROM language
    WHERE languageid = 1;

    MySQL Error : Unknown column 'phrasegroup_global' in 'field list'
    Error Number : 1054
    Request Date : Saturday, July 28th 2012 @ 09:58:36 PM
    Error Date : Saturday, July 28th 2012 @ 09:58:36 PM
    Script : http://www.naijafinder.com/nigeria-u...ic-season.html
    Referrer :
    IP Address : 74.125.78.82
    Username :
    Classname : vB_Database
    MySQL Version :
    Last edited by Trendri; Sun 29 Jul '12, 1:30am.
    Make Money Forum |Insurance Forum |Personal Finance Forum | Personal Finance Q & Ans
  • AliMadkour
    Senior Member
    • Dec 2004
    • 1588
    • 6.X

    #2
    what was the product ?

    run this sql query :
    Code:
        ALTER TABLE `language` ADD `phrasegroup_global` mediumtext[COLOR=#000000][COLOR=#0000BB]  [/COLOR][/COLOR]
    If problem solved re-import the language xml file again !

    Former vBulletin Support Staff
    Need Help?, Or P.M. Me

    Comment

    • Trendri
      Senior Member
      • Mar 2012
      • 221
      • 5.6.4

      #3
      i do not really take note of the prouct i uninstalled. At moment i can't login to my admincp and the forum is showing Database error.

      Ho do i fix this error?????

      I have also disable all plugin using this procedure but my forum and cpanel is still not work.
      To disable the plugin/hook system completely without accessing the Admin CP options, you need to edit includes/config.php and add the following code:
      define('DISABLE_HOOKS', true);
      Last edited by Trendri; Sat 28 Jul '12, 7:36pm.
      Make Money Forum |Insurance Forum |Personal Finance Forum | Personal Finance Q & Ans

      Comment

      • AliMadkour
        Senior Member
        • Dec 2004
        • 1588
        • 6.X

        #4
        you can run this query via PHPMyAdmin

        Former vBulletin Support Staff
        Need Help?, Or P.M. Me

        Comment

        • Trendri
          Senior Member
          • Mar 2012
          • 221
          • 5.6.4

          #5
          i have run the query via PHPMyAdmin but still bring this result (
          ALTER TABLE `language` ADD `phrasegroup_global` mediumtext)


          - - - Updated - - -

          I run this query via PHPMyAdmin
          Unknown column 'phrasegroup_global' in 'field list'

          Result:
          #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Unknown column 'phrasegroup_global' in 'field list'' at line 1

          Please how do i fix the error to get my forum to start working?
          Make Money Forum |Insurance Forum |Personal Finance Forum | Personal Finance Q & Ans

          Comment

          • borbole
            Senior Member
            • Feb 2010
            • 3074
            • 4.0.0

            #6
            What code exactly did you used for the query? Because from your post above it looks like you enclosed the query between braces and you shouldn''t do that.

            Comment

            • Trendri
              Senior Member
              • Mar 2012
              • 221
              • 5.6.4

              #7
              I run this query via PHPMyAdmin SQL
              Unknown column 'phrasegroup_global' in 'field list'

              - - - Updated - - -

              Is there anyway i could overwritte this error to enable me forum to start working. I have re-uploaded Vb 4.2.0 files but am still getting Db error
              Make Money Forum |Insurance Forum |Personal Finance Forum | Personal Finance Q & Ans

              Comment

              • Paul M
                Former Lead Developer
                vB.Com & vB.Org
                • Sep 2004
                • 9886

                #8
                Originally posted by felixkomo
                Is there anyway i could overwritte this error to enable me forum to start working. I have re-uploaded Vb 4.2.0 files but am still getting Db error
                The error is nothing to do with any files, so uploading them isnt going to make any difference - the language table in your database is broken and needs fixing.
                Baby, I was born this way

                Comment

                • Trendri
                  Senior Member
                  • Mar 2012
                  • 221
                  • 5.6.4

                  #9
                  My forum manage to load but i no links and tab are working on the forum. all the tabs or links on the forum and Admincp are full of code and when ever i click on any link it shows Database error.


                  My forum is 4.2.0. Please how do i upgrade it to enable all the menus on the forum and admincp to be Normal?
                  Click image for larger version

Name:	admincp.PNG
Views:	1
Size:	110.0 KB
ID:	3689721Click image for larger version

Name:	forum.PNG
Views:	1
Size:	17.2 KB
ID:	3689722

                  My forum is broken...please i need quick feedback.
                  Make Money Forum |Insurance Forum |Personal Finance Forum | Personal Finance Q & Ans

                  Comment

                  • AliMadkour
                    Senior Member
                    • Dec 2004
                    • 1588
                    • 6.X

                    #10
                    Originally posted by felixkomo
                    My forum manage to load but i no links and tab are working on the forum. all the tabs or links on the forum and Admincp are full of code and when ever i click on any link it shows Database error.


                    My forum is 4.2.0. Please how do i upgrade it to enable all the menus on the forum and admincp to be Normal?
                    [ATTACH=CONFIG]60759[/ATTACH][ATTACH=CONFIG]60760[/ATTACH]

                    My forum is broken...please i need quick feedback.
                    Import your XML language file

                    you can go to language manager from that URL
                    Choosing the right domain name can be overwhelming. Our personalized customer service helps you get a great domain.

                    Former vBulletin Support Staff
                    Need Help?, Or P.M. Me

                    Comment

                    • Trendri
                      Senior Member
                      • Mar 2012
                      • 221
                      • 5.6.4

                      #11
                      can i use the tools.php to repair the forum....
                      I have sent message to Vbulletin support but no feedback yet.

                      - - - Updated - - -

                      Please what is the function of vbulletin-language.xml. Will that fix my broken board?
                      Originally posted by AliMadkour
                      Import your XML language file

                      you can go to language manager from that URL
                      http://naijafinder.com/admincp/language.php?do=files
                      Make Money Forum |Insurance Forum |Personal Finance Forum | Personal Finance Q & Ans

                      Comment

                      • AliMadkour
                        Senior Member
                        • Dec 2004
                        • 1588
                        • 6.X

                        #12
                        Originally posted by felixkomo
                        can i use the tools.php to repair the forum....
                        I have sent message to Vbulletin support but no feedback yet.

                        - - - Updated - - -

                        Please what is the function of vbulletin-language.xml. Will that fix my broken board?
                        yes that will fix it

                        Former vBulletin Support Staff
                        Need Help?, Or P.M. Me

                        Comment

                        • Trendri
                          Senior Member
                          • Mar 2012
                          • 221
                          • 5.6.4

                          #13
                          Error fixed site is working well now
                          Make Money Forum |Insurance Forum |Personal Finance Forum | Personal Finance Q & Ans

                          Comment

                          • AliMadkour
                            Senior Member
                            • Dec 2004
                            • 1588
                            • 6.X

                            #14
                            Originally posted by felixkomo
                            Error fixed site is working well now
                            Good news

                            Former vBulletin Support Staff
                            Need Help?, Or P.M. Me

                            Comment

                            • TheLastSuperman
                              Senior Member
                              • Sep 2008
                              • 1799

                              #15
                              Originally posted by felixkomo
                              My forum manage to load but i no links and tab are working on the forum. all the tabs or links on the forum and Admincp are full of code and when ever i click on any link it shows Database error.


                              My forum is 4.2.0. Please how do i upgrade it to enable all the menus on the forum and admincp to be Normal?
                              [ATTACH=CONFIG]60759[/ATTACH][ATTACH=CONFIG]60760[/ATTACH]

                              My forum is broken...please i need quick feedback.
                              Originally posted by felixkomo
                              can i use the tools.php to repair the forum....
                              I have sent message to Vbulletin support but no feedback yet.

                              - - - Updated - - -

                              Please what is the function of vbulletin-language.xml. Will that fix my broken board?
                              When you submit a support ticket, then the same night create a topic on the same subject it's always best advised to post a link in the ticket to this thread that way we can see attachments and know exactly what your referring to using the screenshots provided otherwise next time use something along the lines of http://postimage.org/ to upload your images and link to them .

                              I'm glad to see it's working though .


                              Former vBulletin Support Staff
                              Hacked recently? See my blog post "Recovering a Hacked vBulletin Site".
                              Thinking outside the box? Need modification support? Visit www.vBulletin.org and have at it!

                              Comment

                              Related Topics

                              Collapse

                              • nsglazer
                                Database Error
                                by nsglazer
                                I've received hundreds of emails since our upgrade to vBulletin 5.1.3 Patch Level 1 all pretty similar to these. Any idea what's going on?

                                Database error in vBulletin 5.1.3:

                                ...
                                Sun 16 Nov '14, 1:27pm
                              • aelalfey
                                Database error in vBulletin 5.1.8
                                by aelalfey
                                I started getting this error about 6 days "about 10 emails everyday" ago with no certain reason.
                                Code:
                                [COLOR=#222222][FONT=arial]Database error in vBulletin 5.1.8:[/FONT][/COLOR]
                                
                                [COLOR=#222222][FONT=arial]                        Invalid SQL:[/FONT][/COLOR]
                                [COLOR=#222222][FONT=arial]CREATE[/][/]
                                ...
                                Fri 25 Sep '15, 4:00am
                              • Merenguista
                                Database Error in my 5.0.5
                                by Merenguista
                                Hi

                                I received over 200 Database Error messages :

                                Code:
                                [COLOR=#222222][FONT=arial]Database error in vBulletin :[/FONT][/COLOR]
                                
                                [COLOR=#222222][FONT=arial]                       Invalid SQL:[/FONT][/COLOR]
                                [COLOR=#222222][FONT=arial]SELECT * FROM setting;[/FONT][/COLOR]
                                ...
                                Mon 11 Nov '13, 10:21am
                              • Jradar
                                Database error in vBulletin 5.0.5 -
                                by Jradar
                                I have no idea what to do with this? can someone please point me in the right direction? thanks!

                                Database error in vBulletin 5.0.5:


                                Invalid SQL:
                                ...
                                Mon 2 Dec '13, 4:20pm
                              Working...