vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Cant create or edit usergroup.. !! :- Database error (https://vborg.vbsupport.ru/showthread.php?t=220232)

sebil 08-05-2009 12:07 PM
Cant create or edit usergroup.. !! :- Database error
 
When i try to edit or create usergroup i m getting database error


Please helppp

Quote:
Database error in vBulletin 3.8.2:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'System Management',
`description` = '',
`usertitle` = 'TECHNICIAN',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`ispublicgroup` = '0',
`canoverride` = '0',
`passivevideo_sig` = '1',
`hhroptions` = '0',
`forumpermissions` = '16777215',
`genericpermissions` = '2147483647',
`attachlimit` = '10000000',
`pmquota` = '5000',
`pmpermissions` = '7',
`pmsendmax` = '5',
`pmthrottlequantity` = '0',
`calendarpermissions` = '63',
`wolpermissions` = '31',
`adminpermissions` = '3',
`genericpermissions2` = '1',
`genericoptions` = '63',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '2500000',
`avatarmaxwidth` = '175',
`avatarmaxheight` = '175',
`avatarmaxsize` = '2000000',
`signaturepermissions` = '245759',
`sigpicmaxwidth` = '0',
`sigpicmaxheight` = '0',
`sigpicmaxsize` = '0',
`sigmaxrawchars` = '0',
`sigmaxchars` = '0',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '3',
`albumpermissions` = '255',
`albumpicmaxwidth` = '0',
`albumpicmaxheight` = '0',
`albumpicmaxsize` = '1000000000',
`albummaxpics` = '200',
`albummaxsize` = '1000000',
`usercsspermissions` = '63',
`visitormessagepermissions` = '63',
`socialgrouppermissions` = '65535',
`maximumsocialgroups` = '10',
`groupiconmaxsize` = '200',
`mp3playergrouppermissions` = '3',
`mgc_cb_evo_permissions` = '0',
`mgc_cb_evo_refreshrate` = '',
`mgc_cb_evo_nbmsg_show` = '',
`mgc_cb_evo_nbmsg_perday_show` = '',
`mgc_cb_evo_max_chats_perday` = '',
`ms_imageshack_upload_permissions` = '16383',
`arcadepermissions` = '255',
`minpoststoplay` = '0',
`minreptoplay` = '0',
`minreglengthtoplay` = '0',
`creditpermissions` = '0',
`credit_induction` = '100',
`credit_referral` = '100',
`credit_refbonus` = '0.05',
`credit_paycheck` = '0',
`credit_active` = '20',
`credit_birthday` = '100',
`credit_repgive` = '0.1',
`credit_reputation` = '2',
`credit_infraction` = '-10',
`credit_thread` = '10',
`credit_threadrate` = '1',
`credit_post` = '5',
`credit_ownthreadpost` = '3',
`credit_postsize` = '0.05',
`credit_ownthreadview` = '0.05',
`credit_ownthreadrate` = '1',
`credit_ownthreadreply` = '2',
`credit_ownprofileview` = '0.05',
`credit_pollmake` = '5',
`credit_pollvote` = '1',
`credit_attachment` = '3',
`credit_sendpm` = '-2',
`credit_addevent` = '3',
`credit_addprofpic` = '3',
`credit_profile` = '0',
`credit_donmaxuser` = '-1',
`credit_pastotpost` = '0',
`credit_pastotuser` = '0',
`credit_pasawuser` = '0',
`credit_pasawthread` = '0',
`credit_saveint` = '0.035',
`credit_maxsave` = '10000',
`credit_loanint` = '0.195',
`credit_maxloan` = '1000',
`credit_totloan` = '5',
`credit_goodgroup` = '0',
`credit_midgroup` = '0',
`credit_badgroup` = '0',
`credit_maxtickets` = '10',
`credit_lotdiscount` = '0',
`videodirectorypermissions` = '0',
`passivevideo_stack0` = '7',
`passivevideo_stack1` = '0'
WHERE usergroupid=31;

MySQL Error : Unknown column 'mgc_cb_evo_permissions' in 'field list'
Error Number : 1054
Request Date : Wednesday, August 5th 2009 @ 03:02:04 PM
Error Date : Wednesday, August 5th 2009 @ 03:02:04 PM
Script : http://www.malludreams.com/admincp/u....php?do=update
Referrer : http://www.malludreams.com/admincp/u...usergroupid=31
IP Address : 78.151.174.120
Username : MalluDreams
Classname : vB_Database
MySQL Version : 5.0.51a-community
Please helppppppppppppp

Marco van Herwaarden 08-05-2009 12:30 PM
You have removed a modifiction but have not removed all the files belonging to the modification. Please remove all the files, especially the ./includes/xml/bitfield_XXX.xml belonging to the product.

PS Please update the URL your license is used on in the Members' Area. Currently your site is unlicensed.

sebil 08-05-2009 12:33 PM
emmm .... it is licensedddddd

and is there any way to find which modification's file is still remain in the server.. :(

--------------- Added [DATE]1249479354[/DATE] at [TIME]1249479354[/TIME] ---------------

updated the URL.. sorry i was using my previous domain name

mcrider 08-05-2009 12:46 PM
It looks like it is a file associated with the MGC Chatbox Evo modification...

Marco van Herwaarden 08-05-2009 12:47 PM
'mgc_cb_evo'

That is most likely the productid.

sebil 08-05-2009 12:49 PM
I removed one bitfield file from xml folder...
which was a blog installation file...


Now the error changed to

Quote:
Database error in vBulletin 3.8.2:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO usergroup
(`title`, `description`, `usertitle`, `opentag`, `closetag`, `passwordexpires`, `passwordhistory`, `ispublicgroup`, `canoverride`, `passivevideo_sig`, `videodirectorypermissions`, `hhroptions`, `forumpermissions`, `genericpermissions`, `attachlimit`, `pmquota`, `pmpermissions`, `pmsendmax`, `pmthrottlequantity`, `calendarpermissions`, `wolpermissions`, `adminpermissions`, `genericpermissions2`, `genericoptions`, `profilepicmaxwidth`, `profilepicmaxheight`, `profilepicmaxsize`, `avatarmaxwidth`, `avatarmaxheight`, `avatarmaxsize`, `signaturepermissions`, `sigpicmaxwidth`, `sigpicmaxheight`, `sigpicmaxsize`, `sigmaxrawchars`, `sigmaxchars`, `sigmaxlines`, `sigmaxsizebbcode`, `sigmaximages`, `albumpermissions`, `albumpicmaxwidth`, `albumpicmaxheight`, `albumpicmaxsize`, `albummaxpics`, `albummaxsize`, `usercsspermissions`, `visitormessagepermissions`, `socialgrouppermissions`, `maximumsocialgroups`, `groupiconmaxsize`, `mp3playergrouppermissions`, `mgc_cb_evo_permissions`, `mgc_cb_evo_refreshrate`, `mgc_cb_evo_nbmsg_show`, `mgc_cb_evo_nbmsg_perday_show`, `mgc_cb_evo_max_chats_perday`, `ms_imageshack_upload_permissions`, `arcadepermissions`, `minpoststoplay`, `minreptoplay`, `minreglengthtoplay`, `creditpermissions`, `credit_induction`, `credit_referral`, `credit_refbonus`, `credit_paycheck`, `credit_active`, `credit_birthday`, `credit_repgive`, `credit_reputation`, `credit_infraction`, `credit_thread`, `credit_threadrate`, `credit_post`, `credit_ownthreadpost`, `credit_postsize`, `credit_ownthreadview`, `credit_ownthreadrate`, `credit_ownthreadreply`, `credit_ownprofileview`, `credit_pollmake`, `credit_pollvote`, `credit_attachment`, `credit_sendpm`, `credit_addevent`, `credit_addprofpic`, `credit_profile`, `credit_donmaxuser`, `credit_pastotpost`, `credit_pastotuser`, `credit_pasawuser`, `credit_pasawthread`, `credit_saveint`, `credit_maxsave`, `credit_loanint`, `credit_maxloan`, `credit_totloan`, `credit_goodgroup`, `credit_midgroup`, `credit_badgroup`, `credit_maxtickets`, `credit_lotdiscount`, `passivevideo_stack0`, `passivevideo_stack1`)
VALUES
('System Management', 'Official MD Technical Support Member', 'System Management', '<strong><font color=\"#CC0033\">', '</font></strong></b>', '180', '360', '0', '0', '1', '511', '0', '16777215', '2147483647', '0', '65535', '7', '10', '0', '63', '31', '3', '1', '55', '140', '190', '65535', '250', '261', '20000000', '245759', '500', '100', '10000', '0', '0', '0', '7', '0', '255', '600', '600', '100000', '100', '0', '63', '63', '65535', '5', '65535', '3', '0', '', '', '', '', '16383', '255', '0', '-1000', '0', '0', '100', '100', '0.05', '0', '20', '100', '0.1', '2', '-10', '10', '1', '5', '3', '0.05', '0.05', '1', '2', '0.05', '5', '1', '3', '-2', '3', '3', '0', '-1', '0', '0', '0', '0', '0.035', '10000', '0.195', '1000', '5', '0', '0', '0', '10', '0', '7', '0');

MySQL Error : Unknown column 'mgc_cb_evo_permissions' in 'field list'
Error Number : 1054
Request Date : Wednesday, August 5th 2009 @ 03:44:44 PM
Error Date : Wednesday, August 5th 2009 @ 03:44:44 PM
Script : http://www.malludreams.com/admincp/u....php?do=update
Referrer : http://www.malludreams.com/admincp/usergroup.php?do=add
IP Address : 78.151.174.120
Username : MalluDreams
Classname : vB_Database
MySQL Version : 5.0.51a-community
--------------- Added [DATE]1249480260[/DATE] at [TIME]1249480260[/TIME] ---------------

Quote:
Originally Posted by Marco van Herwaarden (Post 1861833)
'mgc_cb_evo'

That is most likely the productid.
i removed it and tried...


But now the error is...


Quote:
Database error in vBulletin 3.8.2:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO usergroup
(`title`, `description`, `usertitle`, `opentag`, `closetag`, `passwordexpires`, `passwordhistory`, `ispublicgroup`, `canoverride`, `passivevideo_sig`, `videodirectorypermissions`, `hhroptions`, `forumpermissions`, `genericpermissions`, `attachlimit`, `pmquota`, `pmpermissions`, `pmsendmax`, `pmthrottlequantity`, `calendarpermissions`, `wolpermissions`, `adminpermissions`, `genericpermissions2`, `genericoptions`, `profilepicmaxwidth`, `profilepicmaxheight`, `profilepicmaxsize`, `avatarmaxwidth`, `avatarmaxheight`, `avatarmaxsize`, `signaturepermissions`, `sigpicmaxwidth`, `sigpicmaxheight`, `sigpicmaxsize`, `sigmaxrawchars`, `sigmaxchars`, `sigmaxlines`, `sigmaxsizebbcode`, `sigmaximages`, `albumpermissions`, `albumpicmaxwidth`, `albumpicmaxheight`, `albumpicmaxsize`, `albummaxpics`, `albummaxsize`, `usercsspermissions`, `visitormessagepermissions`, `socialgrouppermissions`, `maximumsocialgroups`, `groupiconmaxsize`, `mp3playergrouppermissions`, `mgc_cb_evo_permissions`, `mgc_cb_evo_refreshrate`, `mgc_cb_evo_nbmsg_show`, `mgc_cb_evo_nbmsg_perday_show`, `mgc_cb_evo_max_chats_perday`, `ms_imageshack_upload_permissions`, `arcadepermissions`, `minpoststoplay`, `minreptoplay`, `minreglengthtoplay`, `creditpermissions`, `credit_induction`, `credit_referral`, `credit_refbonus`, `credit_paycheck`, `credit_active`, `credit_birthday`, `credit_repgive`, `credit_reputation`, `credit_infraction`, `credit_thread`, `credit_threadrate`, `credit_post`, `credit_ownthreadpost`, `credit_postsize`, `credit_ownthreadview`, `credit_ownthreadrate`, `credit_ownthreadreply`, `credit_ownprofileview`, `credit_pollmake`, `credit_pollvote`, `credit_attachment`, `credit_sendpm`, `credit_addevent`, `credit_addprofpic`, `credit_profile`, `credit_donmaxuser`, `credit_pastotpost`, `credit_pastotuser`, `credit_pasawuser`, `credit_pasawthread`, `credit_saveint`, `credit_maxsave`, `credit_loanint`, `credit_maxloan`, `credit_totloan`, `credit_goodgroup`, `credit_midgroup`, `credit_badgroup`, `credit_maxtickets`, `credit_lotdiscount`, `passivevideo_stack0`, `passivevideo_stack1`)
VALUES
('System Management', 'Official MD Technical Support Member', 'System Management', '<strong><font color=\"#CC0033\">', '</font></strong></b>', '180', '360', '0', '0', '1', '511', '0', '16777215', '2147483647', '0', '65535', '7', '10', '0', '63', '31', '3', '1', '55', '140', '190', '65535', '250', '261', '20000000', '245759', '500', '100', '10000', '0', '0', '0', '7', '0', '255', '600', '600', '100000', '100', '0', '63', '63', '65535', '5', '65535', '3', '0', '', '', '', '', '16383', '255', '0', '-1000', '0', '0', '100', '100', '0.05', '0', '20', '100', '0.1', '2', '-10', '10', '1', '5', '3', '0.05', '0.05', '1', '2', '0.05', '5', '1', '3', '-2', '3', '3', '0', '-1', '0', '0', '0', '0', '0.035', '10000', '0.195', '1000', '5', '0', '0', '0', '10', '0', '7', '0');

MySQL Error : Unknown column 'mgc_cb_evo_permissions' in 'field list'
Error Number : 1054
Request Date : Wednesday, August 5th 2009 @ 03:46:45 PM
Error Date : Wednesday, August 5th 2009 @ 03:46:46 PM
Script : http://www.malludreams.com/admincp/u....php?do=update
Referrer : http://www.malludreams.com/admincp/usergroup.php?do=add
IP Address : 78.151.174.120
Username : MalluDreams
Classname : vB_Database
MySQL Version : 5.0.51a-community
--------------- Added [DATE]1249480432[/DATE] at [TIME]1249480432[/TIME] ---------------

yeyeye... problem solved... ;;)


Thank youuuuuuuuu

Marco van Herwaarden and mcrider

PvOwnage 05-01-2011 12:09 PM
This was posted in 2009 but I just had this error and this is how i fixed it

Run this query in phpmyadmin:

Code:
ALTER TABLE `usergroup` ADD `albumpicmaxsize` int (10) unsigned NOT NULL default '0 '


All times are GMT. The time now is 04:28 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.01014 seconds
  • Memory Usage 1,776KB
  • 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
  • (1)bbcode_code_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (7)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