Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 09-06-2016, 03:18 AM
rockerzteam rockerzteam is offline
 
Join Date: Sep 2009
Posts: 133
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Vbulletin error on fresh install!

Code:
Database error in vBulletin 3.8.7:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
	`title` = 'Elite Member',
	`description` = 'Elite Member Donator!',
	`usertitle` = 'Elite Member',
	`opentag` = '<span style=\"color: red;\">',
	`closetag` = '</span>',
	`passwordexpires` = '0',
	`passwordhistory` = '0',
	`forumpermissions` = '12316927',
	`genericpermissions` = '1575966447',
	`attachlimit` = '0',
	`pmquota` = '50',
	`pmpermissions` = '0',
	`pmsendmax` = '0',
	`pmthrottlequantity` = '0',
	`calendarpermissions` = '55',
	`wolpermissions` = '13',
	`adminpermissions` = '1',
	`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` = '600',
	`albumpicmaxheight` = '600',
	`albumpicmaxsize` = '100000',
	`albummaxpics` = '100',
	`albummaxsize` = '0',
	`usercsspermissions` = '63',
	`visitormessagepermissions` = '55',
	`socialgrouppermissions` = '65535',
	`maximumsocialgroups` = '5',
	`groupiconmaxsize` = '65535',
	`akvbghsfs_akismet_permissions` = '0'
WHERE usergroupid=5;

MySQL Error   : Unknown column 'akvbghsfs_akismet_permissions' in 'field list'
Error Number  : 1054
Request Date  : Tuesday, September 6th 2016 @ 12:15:18 AM
Error Date    : Tuesday, September 6th 2016 @ 12:15:18 AM
Reply With Quote
  #2  
Old 09-06-2016, 10:11 AM
Sarah. Sarah. is offline
 
Join Date: Aug 2016
Location: California
Posts: 6
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

There's no 'akvbghsfs_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.
Reply With Quote
3 благодарности(ей) от:
Dragonsys, In Omnibus, MarkFL
  #3  
Old 09-08-2016, 07:58 AM
RichieBoy67's Avatar
RichieBoy67 RichieBoy67 is offline
 
Join Date: Apr 2004
Location: CT - Down in a hole..
Posts: 3,057
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by rockerzteam View Post
Code:
Database error in vBulletin 3.8.7:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
    `title` = 'Elite Member',
    `description` = 'Elite Member Donator!',
    `usertitle` = 'Elite Member',
    `opentag` = '<span style=\"color: red;\">',
    `closetag` = '</span>',
    `passwordexpires` = '0',
    `passwordhistory` = '0',
    `forumpermissions` = '12316927',
    `genericpermissions` = '1575966447',
    `attachlimit` = '0',
    `pmquota` = '50',
    `pmpermissions` = '0',
    `pmsendmax` = '0',
    `pmthrottlequantity` = '0',
    `calendarpermissions` = '55',
    `wolpermissions` = '13',
    `adminpermissions` = '1',
    `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` = '600',
    `albumpicmaxheight` = '600',
    `albumpicmaxsize` = '100000',
    `albummaxpics` = '100',
    `albummaxsize` = '0',
    `usercsspermissions` = '63',
    `visitormessagepermissions` = '55',
    `socialgrouppermissions` = '65535',
    `maximumsocialgroups` = '5',
    `groupiconmaxsize` = '65535',
    `akvbghsfs_akismet_permissions` = '0'
WHERE usergroupid=5;

MySQL Error   : Unknown column 'akvbghsfs_akismet_permissions' in 'field list'
Error Number  : 1054
Request Date  : Tuesday, September 6th 2016 @ 12:15:18 AM
Error Date    : Tuesday, September 6th 2016 @ 12:15:18 AM
Sure does not seem like a fresh install.

If you have plug ins partially installed then reupload the files, uninstall the plug in using the plug in manager and then delete the files.
Reply With Quote
2 благодарности(ей) от:
Dragonsys, MarkFL
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 08:08 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03671 seconds
  • Memory Usage 2,197KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (2)bbcode_code
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (3)post_thanks_box
  • (5)post_thanks_box_bit
  • (3)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (2)post_thanks_postbit
  • (3)post_thanks_postbit_info
  • (3)postbit
  • (3)postbit_onlinestatus
  • (3)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • fetch_musername
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • post_thanks_function_fetch_thanks_bit_start
  • post_thanks_function_show_thanks_date_start
  • post_thanks_function_show_thanks_date_end
  • post_thanks_function_fetch_thanks_bit_end
  • post_thanks_function_fetch_post_thanks_template_start
  • post_thanks_function_fetch_post_thanks_template_end
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete