Log in

View Full Version : Easy question


mrtroybaker
04-02-2009, 05:14 PM
What is the advantage or disadvantage of moving my members primary user group? If I have a regestered member who wants a "gold subscription" is it better to move the primary usergroup or make it a secondary usergroup? If moved does it effect the registered member count?

Thanks in advance

--------------- Added 1238696523 at 1238696523 ---------------

When trying to update a usergroup I get this

Database error in vBulletin 3.8.2:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Administrators',
`description` = '',
`usertitle` = 'Administrator',
`opentag` = '<i><font color=\"#0000FF\"><font face=\"Comic Sans MS\">',
`closetag` = '</font></font></i>',
`passwordexpires` = '180',
`passwordhistory` = '360',
`forumpermissions` = '16777215',
`genericpermissions` = '2147483583',
`attachlimit` = '0',
`pmquota` = '500',
`pmpermissions` = '7',
`pmsendmax` = '0',
`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` = '100000',
`usercsspermissions` = '63',
`visitormessagepermissions` = '63',
`socialgrouppermissions` = '65535',
`maximumsocialgroups` = '5',
`groupiconmaxsize` = '65535',
`classifieds` = '31',
`maxfeaturedads` = '5',
`maxboldads` = '5',
`maxphotosads` = '100',
`mgc_cb_evo_permissions` = '0',
`mgc_cb_evo_refreshrate` = '30',
`mgc_cb_evo_nbmsg_show` = '',
`mgc_cb_evo_nbmsg_perday_show` = '',
`mgc_cb_evo_max_chats_perday` = '0',
`trgpermissions` = '15',
`micromembers` = '63',
`trmperms` = '15'
WHERE usergroupid=6;

MySQL Error : Unknown column 'mgc_cb_evo_permissions' in 'field list'
Error Number : 1054
Request Date : Thursday, April 2nd 2009 @ 11:20:31 AM
Error Date : Thursday, April 2nd 2009 @ 11:20:31 AM

IP Address : 99.9.205.26
Username : Kahunadog
Classname : vb_database
MySQL Version : 4.1.22-max-log

snakes1100
04-02-2009, 05:32 PM
rm the old xml file for mgc's hack that you uninstalled. includes/xml

mrtroybaker
04-02-2009, 05:35 PM
rm the old xml file for mgc's hack that you uninstalled. includes/xml


Your a life saver. Thank you so much man!!!!

Lynne
04-02-2009, 05:39 PM
That error is from a mod - some permission mod that you didn't completely uninstall. Make sure when you uninstall modifications, that you also remove all files you uploaded - like ones in the /xml directory.

mrtroybaker
04-02-2009, 05:50 PM
That error is from a mod - some permission mod that you didn't completely uninstall. Make sure when you uninstall modifications, that you also remove all files you uploaded - like ones in the /xml directory.

Thank you. May I ask for your answer to the first part of the post? LOL It wasnt supposed to be a double post but I got the error after making the first post.
Thank You

Lynne
04-02-2009, 07:49 PM
I don't know that I have some definitive answer to your first question. I like having a Primary group and then adding permissions through Secondary groups. That just works best on my site. However, I do have a Primary group I have moved some users into that takes away permissions because you can't do that with a secondary group.