Announcement

Collapse
No announcement yet.

I broke my Board - Database error.

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

  • [Forum] I broke my Board - Database error.

    I just uninstalled a mod Guest Warn
    and am now receiving database error, my site is not working again.

    I can't access my admincp and site, am getting database error.

    Please how do i fix this ? ww.naijafinder.com

    MySQL Error : Unknown column 'phrasegroup_global' in 'field list'
    Error Number : 1054
    Request Date : Sunday, August 19th 2012 @ 02:18:00 PM
    Make Money forum | Insurance Forum| Business opportunities| Life Insurance

  • #2
    Did you make a backup before installing this add-on?

    Comment


    • #3
      yes i did, i have my Backup available. Please how do i make my forum to start working again?
      Make Money forum | Insurance Forum| Business opportunities| Life Insurance

      Comment


      • #4
        Originally posted by Naijafinder View Post
        yes i did, i have my Backup available. Please how do i make my forum to start working again?
        You can restore from your backup.

        Comment


        • #5
          Ok thanks, i will try and restore using auto restore wizard on my Hosting Cpanel , i guess they are same function.
          Thanks for your quick feedback

          - - - Updated - - -

          I have restore the Database but am still geting this error below and my site is not working and i can't access my admin cp.

          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,
          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 : Sunday, August 19th 2012 @ 04:47:59 PM
          Error Date : Sunday, August 19th 2012 @ 04:47:59 PM

          Originally posted by Andy View Post
          - - - Updated - - -

          please i need assistance on my database error to be fix
          Make Money forum | Insurance Forum| Business opportunities| Life Insurance

          Comment


          • #6
            If it doesn't work maybe i will just install fresh Vbulletin and start from scratch.
            Vbulletin staff are not helping to resolve the issue at all. They rather keep asking question and nothing has been done.


            It's so painful.
            Make Money forum | Insurance Forum| Business opportunities| Life Insurance

            Comment


            • #7
              Originally posted by Naijafinder View Post
              If it doesn't work maybe i will just install fresh Vbulletin and start from scratch.
              This might be the best idea. A few things to consider.

              1) Learn how to properly backup and restore your database using SSH.
              2) Avoid installing any add-ons
              3) Create a test site where you can practice backing up and restoring the database

              Comment


              • #8
                I have tried to go to your board and I don't get a database error, I get:
                503 Service Unavailable

                No server is available to handle this request.
                It looks like you have more problems than just a database problem. You will need to get that fixed before anybody can look into your database error.

                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 <- awesome site for html/css help

                Comment


                • #10
                  Thanks for the feedback, since the error could not be fix, i will install clean Vbulletin and do away with most of these plugins that might cause Database error.
                  Make Money forum | Insurance Forum| Business opportunities| Life Insurance

                  Comment


                  • #11
                    I did take a look at your table and I added the field but there is still a database error. That table is whacked though - it looks like someone tried to change field names or add non-existant field names or something because there are several fields missing and several field names that have been changed (and thus will give errors). You should at least do a new install somewhere and copy that table over to get all the correct fields.

                    And, as already brought up, get a test site so you can break it all you want without breaking the live site.

                    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 <- awesome site for html/css help

                    Comment


                    • #12
                      Thanks, how do i copy the table to my current Tables on my site?
                      Make Money forum | Insurance Forum| Business opportunities| Life Insurance

                      Comment


                      • #13
                        You would need to drop the current one, then add in the new one. You should be able to do it via phpMyAdmin. Or, you can do a compare between a new database language table and yours and manually go through and fix it. And tell whoever was in there changing field names to stay out of your database for now on.

                        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 <- awesome site for html/css help

                        Comment


                        • #14
                          Thanks Lynne..i will do just that now

                          Thnaks to you all.....am doing fresh installation because i want to do away with plugins..just want to use the default Vb files.

                          Thanks once more
                          Last edited by Trendri; Mon 20 Aug '12, 2:30pm.
                          Make Money forum | Insurance Forum| Business opportunities| Life Insurance

                          Comment

                          Related Topics

                          Collapse

                          Working...
                          X