Announcement

Collapse
No announcement yet.

Database error

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

  • Paul M
    replied
    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.

    Leave a comment:


  • Trevor Hannant
    replied
    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'

    Leave a comment:


  • yahsuah
    replied
    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.

    Leave a comment:


  • Blueracer66
    replied
    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.

    Leave a comment:


  • Trevor Hannant
    replied
    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.

    Leave a comment:


  • Blueracer66
    started a topic Database error

    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!
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X