vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Vbulletin error on fresh install! (https://vborg.vbsupport.ru/showthread.php?t=323416)

rockerzteam 09-06-2016 03:18 AM
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

Sarah. 09-06-2016 10:11 AM
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.

RichieBoy67 09-08-2016 07:58 AM
Quote:
Originally Posted by rockerzteam (Post 2575619)
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.


All times are GMT. The time now is 05:34 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.00910 seconds
  • Memory Usage 1,732KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (3)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete