Announcement

Collapse
No announcement yet.

Database errors

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

  • [Forum] Database errors

    After upgrading, I'm receiving this database errors:

    Code:
    Database error in vBulletin 4.0.0:
    
    Invalid SQL:
    
                        SELECT languageid,
                phrasegroup_global AS phrasegroup_global,
                phrasegroup_video AS phrasegroup_video,
                phrasegroup_posting AS phrasegroup_posting,
                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_video' in 'field list'
    Error Number  : 1054
    Request Date  : Wednesday, December 23rd 2009 @ 06:45:23 AM
    Error Date    : Wednesday, December 23rd 2009 @ 06:45:23 AM
    Script        : http://www.m3xital.com/forum/video.php?
    Referrer      : 
    IP Address    : 67.218.116.164
    Username      : 
    Classname     : vB_Database
    MySQL Version :
    Code:
    Database error in vBulletin 4.0.0:
    
    Invalid SQL:
    
                        SELECT languageid,
                phrasegroup_global AS phrasegroup_global,
                phrasegroup_ecdownloads AS phrasegroup_ecdownloads,
                phrasegroup_posting AS phrasegroup_posting,
                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_ecdownloads' in 'field list'
    Error Number  : 1054
    Request Date  : Wednesday, December 23rd 2009 @ 06:14:29 AM
    Error Date    : Wednesday, December 23rd 2009 @ 06:14:29 AM
    Script        : http://www.m3xital.com/forum/downloads.php?
    Referrer      : 
    IP Address    : 67.218.116.164
    Username      : 
    Classname     : vB_Database
    MySQL Version :

  • #2
    Those are from a modification as there is no field phrasegroup_video or phrasegroup_ecdownloads in the language table in default vbulletin.

    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


    • #3
      Originally posted by Lynne View Post
      Those are from a modification as there is no field phrasegroup_video or phrasegroup_ecdownloads in the language table in default vbulletin.
      Thanks Lynne for your help,
      I know the are from modifications, but how can i fix this.
      Before upgrading i unistalled all the mods i had on 3.8.4., but didn't deleted files on server.

      Comment


      • #4
        Disable all hooks via config.php

        Comment


        • #5
          Check your includes/xml directory for extra files from modification. Uninstalling modifications means uninstalling the product AND removing all files that you had to upload for the modification.

          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


          • #6
            Originally posted by Lynne View Post
            Check your includes/xml directory for extra files from modification. Uninstalling modifications means uninstalling the product AND removing all files that you had to upload for the modification.
            Thanks Lynne!!

            It worked, i deleted all files, in includes/xml, from old modifications. It also solved another problem i had here

            Comment


            • #7
              Glad it's fixed.

              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

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