Announcement

Collapse
No announcement yet.

Database error

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

  • Database error

    Whenever I try to update a user group I get the following database error:
    Code:
    Database error in vBulletin 3.8.6:
    
    Invalid SQL:
    UPDATE usergroup SET
    
    ### UPDATE QUERY GENERATED BY fetch_query_sql() ###
    	`title` = 'Moderators',
    	`description` = 'Moderators keep the community going!',
    	`usertitle` = 'Moderator',
    	`opentag` = '<strong> <span style=\"font: candara; verdana; color: #ff7800;\">',
    	`closetag` = '</span></strong>',
    	`passwordexpires` = '0',
    	`passwordhistory` = '0',
    	`forumpermissions` = '16515071',
    	`genericpermissions` = '1577000655',
    	`attachlimit` = '0',
    	`pmquota` = '150',
    	`pmpermissions` = '7',
    	`pmsendmax` = '10',
    	`pmthrottlequantity` = '0',
    	`calendarpermissions` = '63',
    	`wolpermissions` = '13',
    	`adminpermissions` = '0',
    	`genericpermissions2` = '1',
    	`genericoptions` = '63',
    	`profilepicmaxwidth` = '100',
    	`profilepicmaxheight` = '100',
    	`profilepicmaxsize` = '65535',
    	`avatarmaxwidth` = '80',
    	`avatarmaxheight` = '80',
    	`avatarmaxsize` = '20000',
    	`signaturepermissions` = '237567',
    	`sigpicmaxwidth` = '500',
    	`sigpicmaxheight` = '100',
    	`sigpicmaxsize` = '10000',
    	`sigmaxrawchars` = '1000',
    	`sigmaxchars` = '500',
    	`sigmaxlines` = '0',
    	`sigmaxsizebbcode` = '7',
    	`sigmaximages` = '4',
    	`albumpermissions` = '255',
    	`albumpicmaxwidth` = '650',
    	`albumpicmaxheight` = '650',
    	`albumpicmaxsize` = '100000',
    	`albummaxpics` = '100',
    	`albummaxsize` = '0',
    	`usercsspermissions` = '63',
    	`visitormessagepermissions` = '63',
    	`socialgrouppermissions` = '59263',
    	`maximumsocialgroups` = '5',
    	`groupiconmaxsize` = '65535',
    	`awardpermissions` = '1',
    	`akvbghsfs_akismet_permissions` = '1'
    WHERE usergroupid=7;
    
    MySQL Error   : Unknown column 'akvbghsfs_akismet_permissions' in 'field list'
    Error Number  : 1054
    Request Date  : Sunday, September 26th 2010 @ 10:40:05 PM
    Error Date    : Sunday, September 26th 2010 @ 10:40:05 PM
    Script        : http://allconsolegamers.com/community/admincp/usergroup.php?do=update
    Referrer      : http://allconsolegamers.com/community/admincp/usergroup.php?do=edit&usergroupid=7
    IP Address    : 00.11.222.33
    Username      : Blueracer66
    Classname     : vB_Database
    MySQL Version : 5.1.47-community-log
    Any ideas how to fix this? Thank you!
    AllConsoleGamers (beta)

  • #2
    There's no 'akismet_permissions' column in a default vBulletin install - this comes from a modification.

    If you've removed a modification that dealt with this, make sure you've deleted all it's files (including XML files) and retry.
    Vote for:

    - *Admin Settable Paid Subscription Reminder Timeframe*
    -
    *PM - Add ability to reply to originator only*
    - Add Admin ability to auto-subscribe users to specific channel(s)
    - "Quick Route" Interface...

    Comment


    • #3
      Thanks buddy that worked! I had to delete the file on the XML directory (found in the includes folder). I also manually removed the 'akismet_permissions' column through MyPHPAdmin.
      AllConsoleGamers (beta)

      Comment


      • #4
        Originally posted by Blueracer66 View Post
        Thanks buddy that worked! I had to delete the file on the XML directory (found in the includes folder). I also manually removed the 'akismet_permissions' column through MyPHPAdmin.
        How can I do this via phpmyadmin? I have experiencing same problem.
        incil, turkish christians, hristiyanlık, hristiyan olmak, hristiyan haber

        Comment


        • #5
          Firstly and most importantly, take a full backup of your database before making any "destructive" changes to it!

          Next, in that table in phpMyAdmin, open the 'usergroup' table and click on the 'Structure' tab'. Then, check the tickbox beside 'akismet_permissions' and ONLY that line then click 'Drop' underneath the column listing.

          You'll be asked to confirm the drop with something like this:

          Do you really want to execute the following query?

          ALTER TABLE `usergroup`
          DROP `akismet_permissions`;

          Provided it only says about dropping that column, hit 'Yes'
          Vote for:

          - *Admin Settable Paid Subscription Reminder Timeframe*
          -
          *PM - Add ability to reply to originator only*
          - Add Admin ability to auto-subscribe users to specific channel(s)
          - "Quick Route" Interface...

          Comment


          • #6
            You do not need to drop the column and unless you know exactly what you are doing, you should leave it alone.

            Extra [unused] columns do not do any harm.

            The original error was because someone HAD dropped the column, but they left some files in that meant it was still needed.
            Baby, I was born this way

            Comment

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