Announcement

Collapse
No announcement yet.

SQL Error

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

  • SQL Error

    Help?

    Code:
    Database error in vBulletin 3.8.4:
    
    Invalid SQL:
    UPDATE Forum_usergroup SET
    
    ### UPDATE QUERY GENERATED BY fetch_query_sql() ###
        `title` = 'Unregistered / Not Logged In',
        `description` = '',
        `usertitle` = 'Guest',
        `opentag` = '',
        `closetag` = '',
        `passwordexpires` = '0',
        `passwordhistory` = '0',
        `forumpermissions` = '131073',
        `genericpermissions` = '0',
        `pmquota` = '50',
        `pmpermissions` = '0',
        `pmsendmax` = '0',
        `pmthrottlequantity` = '0',
        `calendarpermissions` = '1',
        `wolpermissions` = '0',
        `genericpermissions2` = '0',
        `genericoptions` = '96',
        `profilepicmaxwidth` = '100',
        `profilepicmaxheight` = '100',
        `profilepicmaxsize` = '65535',
        `avatarmaxwidth` = '80',
        `avatarmaxheight` = '80',
        `avatarmaxsize` = '20000',
        `signaturepermissions` = '0',
        `sigpicmaxwidth` = '500',
        `sigpicmaxheight` = '100',
        `sigpicmaxsize` = '10000',
        `sigmaxrawchars` = '1000',
        `sigmaxchars` = '500',
        `sigmaxlines` = '0',
        `sigmaxsizebbcode` = '7',
        `sigmaximages` = '4',
        `albumpermissions` = '192',
        `albumpicmaxwidth` = '600',
        `albumpicmaxheight` = '600',
        `albumpicmaxsize` = '',
        `albummaxpics` = '100',
        `albummaxsize` = '0',
        `usercsspermissions` = '0',
        `visitormessagepermissions` = '16',
        `socialgrouppermissions` = '64',
        `maximumsocialgroups` = '0',
        `groupiconmaxsize` = '65535',
        `adminpermissions` = '0'
    WHERE usergroupid=1;
    
    MySQL Error   : Unknown column 'albumpicmaxsize' in 'field list'
    Error Number  : 1054
    Request Date  : Sunday, December 20th 2009 @ 10:45:56 AM
    Error Date    : Sunday, December 20th 2009 @ 10:45:56 AM
    Script        : http://delifed.com/admincp/usergroup.php?do=update
    Referrer      : http://delifed.com/admincp/usergroup.php?do=edit&usergroupid=1
    IP Address    : 68.54.192.191
    Username      : Delifed
    Classname     : vB_Database
    MySQL Version : 5.0.77-community

  • #2
    That error comes from a modification which is in the modification graveyard. BFC-Download? I suggest that you contact the modification author regarding this at vbulletin.org
    Shamil Nunhuck, - Radon Systems Ltd.
    VPS + Dedicated Server Hosting and Management
    vBulletin Hosting and Services
    Server / Website Consultation

    Comment


    • #3
      nope don't have that mod. mods that i have are

      Automatic Thread Tagger
      Extended reputation display
      Inferno vBShout
      Members who have Visited
      most popular admin index
      Usergroup Color Bar
      vBadvanced CMPS

      Comment


      • #4
        Can you look at your database? Look at your usergroup table and see if the field albumpicmaxsize is there. It is a valid field for the 3.8 series.

        Something else to try.... disable your modifications/plugins and see if you still have this problem.
        Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

        PHP Code:
        define('DISABLE_HOOKS'true); 

        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


        • #5
          Originally posted by Lynne View Post
          Can you look at your database? Look at your usergroup table and see if the field albumpicmaxsize is there. It is a valid field for the 3.8 series.

          Something else to try.... disable your modifications/plugins and see if you still have this problem.
          Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

          PHP Code:
          define('DISABLE_HOOKS'true); 
          Lol its not their.

          Comment


          • #6
            Here is the info to create the field from the mysql-schema.php file:

            Code:
                albumpicmaxsize INT UNSIGNED NOT NULL DEFAULT '0'
            You should be able to go in and add that field if you are comfortable with phpMyAdmin (or whatever you are using to look at your tables).

            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


            • #7
              Originally posted by Lynne View Post
              Here is the info to create the field from the mysql-schema.php file:

              Code:
                  albumpicmaxsize INT UNSIGNED NOT NULL DEFAULT '0'
              You should be able to go in and add that field if you are comfortable with phpMyAdmin (or whatever you are using to look at your tables).

              Thanks.

              Comment

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