vb.org Archive - View Single Post - Miscellaneous Hacks

PakFuse · #**763** 05-17-2009, 06:20 PM

when setting permissions for group, getting the following database error:

PHP Code:


			
Database error in vBulletin 3.8.2:



Invalid SQL:

UPDATE pftest_usergroup SET



### UPDATE QUERY GENERATED BY fetch_query_sql() ###

    `title` = 'Administrators',

    `description` = '',

    `usertitle` = 'Administrator',

    `opentag` = '',

    `closetag` = '',

    `passwordexpires` = '180',

    `passwordhistory` = '360',

    `ms_findmyposts_permissions` = '0',

    `ms_leaders_ugp_permissions` = '0',

    `ms_search_all_unanswered_permissions` = '0',

    `ms_searchsocialgroups_permissions` = '0',

    `forumpermissions` = '16777215',

    `genericpermissions` = '2147483583',

    `attachlimit` = '0',

    `pmquota` = '50',

    `pmpermissions` = '7',

    `pmsendmax` = '5',

    `pmthrottlequantity` = '0',

    `calendarpermissions` = '63',

    `wolpermissions` = '31',

    `adminpermissions` = '3',

    `genericpermissions2` = '1',

    `genericoptions` = '55',

    `profilepicmaxwidth` = '100',

    `profilepicmaxheight` = '100',

    `profilepicmaxsize` = '65535',

    `avatarmaxwidth` = '80',

    `avatarmaxheight` = '80',

    `avatarmaxsize` = '20000',

    `signaturepermissions` = '237567',

    `sigpicmaxwidth` = '500',

    `sigpicmaxheight` = '100',

    `sigpicmaxsize` = '10000',

    `sigmaxrawchars` = '0',

    `sigmaxchars` = '0',

    `sigmaxlines` = '0',

    `sigmaxsizebbcode` = '7',

    `sigmaximages` = '0',

    `albumpermissions` = '255',

    `albumpicmaxwidth` = '600',

    `albumpicmaxheight` = '600',

    `albumpicmaxsize` = '100000',

    `albummaxpics` = '100',

    `albummaxsize` = '0',

    `usercsspermissions` = '63',

    `visitormessagepermissions` = '63',

    `socialgrouppermissions` = '65535',

    `maximumsocialgroups` = '5',

    `groupiconmaxsize` = '65535',

    `uscpermissions` = '2'

WHERE usergroupid=6;



MySQL Error   : Unknown column 'ms_findmyposts_permissions' in 'field list'

Error Number  : 1054

Request Date  : Sunday, May 17th 2009 @ 03:15:06 PM

Error Date    : Sunday, May 17th 2009 @ 03:15:08 PM

Script        : http://www.pakfuse.com/testsite/admincp/usergroup.php?do=update

Referrer      : http://www.pakfuse.com/testsite/admincp/usergroup.php?do=edit&usergroupid=6

IP Address    : xx.xxx.xxx.xxx

Username      : Admin

Classname     : vB_Database

MySQL Version : 5.0.51a-log

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02044 seconds Memory Usage 1,808KB Queries Executed 11 (?)
More Information
Template Usage: (1)SHOWTHREAD_SHOWPOST (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_php (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_box (1)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (1)post_thanks_postbit_info (1)postbit (1)postbit_onlinestatus (1)postbit_wrapper (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit reputationlevel showthread	Included Files: ./showpost.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 showpost_start bbcode_fetch_tags bbcode_create postbit_factory showpost_post postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start showpost_complete
Messages: