Bug Database Error When Editing Usergroup

[Bullmama DeLano]

Help!!! I cannot edit the usergroups at all....

Database error in vBulletin 4.2.0:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
	`title` = '4 Paw Member h',
	`description` = '',
	`usertitle` = '',
	`opentag` = '',
	`closetag` = '',
	`passwordexpires` = '0',
	`passwordhistory` = '0',
	`ispublicgroup` = '0',
	`canoverride` = '0',
	`market_permissions` = '1',
	`market_discount` = '0.2500',
	`market_maxdonate` = '0.00000',
	`market_undo_time` = '24',
	`market_undo_penalty` = '0.5000',
	`market_gift_minimum` = '100.85',
	`market_gift_maximum` = '3500.45',
	`market_steal_percent` = '85',
	`market_convert_permissions` = '0',
	`market_history_permissions` = '0',
	`market_bank_permissions` = '1',
	`market_interest_rate` = '0.0215',
	`market_min_deposit` = '10.95',
	`market_deposit_fee` = '0.0299',
	`market_min_withdrawel` = '5.95',
	`market_withdrawel_fee` = '0.0149',
	`awardpermissions` = '3',
	`dbtech_vbactivitypermissions` = '2',
	`dbtech_usertagpermissions` = '0',
	`vbblog_general_permissions` = '523262',
	`vbblog_customblocks` = '5',
	`vbblog_custompages` = '5',
	`vbblog_entry_permissions` = '49151',
	`vbblog_comment_permissions` = '4046',
	`dbtech_livewallpermissions` = '7',
	`forumpermissions` = '12317183',
	`genericpermissions` = '1579687879',
	`attachlimit` = '0',
	`pmquota` = '500',
	`pmpermissions` = '3',
	`pmsendmax` = '5',
	`pmthrottlequantity` = '0',
	`calendarpermissions` = '63',
	`wolpermissions` = '1',
	`adminpermissions` = '0',
	`genericpermissions2` = '7',
	`genericoptions` = '62',
	`asenh_permissions` = '0',
	`profilepicmaxwidth` = '250',
	`profilepicmaxheight` = '250',
	`profilepicmaxsize` = '75535',
	`avatarmaxwidth` = '175',
	`avatarmaxheight` = '175',
	`avatarmaxsize` = '75535',
	`signaturepermissions` = '507903',
	`sigpicmaxwidth` = '500',
	`sigpicmaxheight` = '150',
	`sigpicmaxsize` = '45535',
	`sigmaxrawchars` = '1000',
	`sigmaxchars` = '500',
	`sigmaxlines` = '0',
	`sigmaxsizebbcode` = '4',
	`sigmaximages` = '1',
	`sigmaxvideos` = '1',
	`albumpermissions` = '255',
	`albumpicmaxwidth` = '800',
	`albumpicmaxheight` = '800',
	`albummaxpics` = '100',
	`albummaxsize` = '104857600',
	`usercsspermissions` = '191',
	`visitormessagepermissions` = '62',
	`socialgrouppermissions` = '260087',
	`maximumsocialgroups` = '5',
	`groupiconmaxsize` = '65535',
	`dbtech_classifiedspermissions` = '6',
	`dbtech_classifieds_featured_listings` = '1'
WHERE usergroupid=10;

MySQL Error   : Unknown column 'dbtech_usertagpermissions' in 'field list'
Error Number  : 1054
Request Date  : Saturday, January 25th 2014 @ 05:03:46 PM
Error Date    : Saturday, January 25th 2014 @ 05:03:46 PM
Script        : http://www.englishbulldognews.com/forums/admincp/usergroup.php?do=update
Referrer      : http://www.englishbulldognews.com/forums/admincp/usergroup.php?do=edit&usergroupid=10
IP Address    : 107.4.97.254
Username      : desertskybulldogs
Classname     : vB_Database
MySQL Version : 5.1.72-cll

I have always had an issue updating Administrator persmissions with the lite version as well. This is the db error I always got. I would just turn it off so I could change them.

Database error in vBulletin 4.2.0:

Invalid SQL:
UPDATE administrator SET
	### Bitfield: administrator.adminpermissions ###
		adminpermissions = IF(adminpermissions & 4, adminpermissions - 4, adminpermissions),
		adminpermissions = IF(adminpermissions & 8, adminpermissions - 8, adminpermissions),
		adminpermissions = IF(adminpermissions & 16, adminpermissions - 16, adminpermissions),
		adminpermissions = IF(adminpermissions & 32, adminpermissions - 32, adminpermissions),
		adminpermissions = IF(adminpermissions & 64, adminpermissions - 64, adminpermissions),
		adminpermissions = IF(adminpermissions & 128, adminpermissions - 128, adminpermissions),
		adminpermissions = IF(adminpermissions & 256, adminpermissions, adminpermissions + 256),
		adminpermissions = IF(adminpermissions & 512, adminpermissions - 512, adminpermissions),
		adminpermissions = IF(adminpermissions & 1024, adminpermissions - 1024, adminpermissions),
		adminpermissions = IF(adminpermissions & 2048, adminpermissions - 2048, adminpermissions),
		adminpermissions = IF(adminpermissions & 4096, adminpermissions - 4096, adminpermissions),
		adminpermissions = IF(adminpermissions & 8192, adminpermissions - 8192, adminpermissions),
		adminpermissions = IF(adminpermissions & 16384, adminpermissions - 16384, adminpermissions),
		adminpermissions = IF(adminpermissions & 65536, adminpermissions - 65536, adminpermissions),
		adminpermissions = IF(adminpermissions & 131072, adminpermissions - 131072, adminpermissions),
		adminpermissions = IF(adminpermissions & 262144, adminpermissions - 262144, adminpermissions),
		adminpermissions = IF(adminpermissions & 524288, adminpermissions - 524288, adminpermissions),
		adminpermissions = IF(adminpermissions & 1048576, adminpermissions - 1048576, adminpermissions),
		adminpermissions = IF(adminpermissions & 2097152, adminpermissions - 2097152, adminpermissions),
		adminpermissions = IF(adminpermissions & 4194304, adminpermissions - 4194304, adminpermissions),
		adminpermissions = IF(adminpermissions & 8388608, adminpermissions - 8388608, adminpermissions),
	blogpermissions = 0,
	### Bitfield: administrator.dbtech_vbactivityadminperms ###
		dbtech_vbactivityadminperms = IF(dbtech_vbactivityadminperms & 1, dbtech_vbactivityadminperms - 1, dbtech_vbactivityadminperms),
	vbcmspermissions = 0,
	### Bitfield: administrator.dbtech_livewalladminperms ###
		dbtech_livewalladminperms = IF(dbtech_livewalladminperms & 1, dbtech_livewalladminperms - 1, dbtech_livewalladminperms),
	### Bitfield: administrator.dbtech_usertagadminperms ###
		dbtech_usertagadminperms = IF(dbtech_usertagadminperms & 1, dbtech_usertagadminperms - 1, dbtech_usertagadminperms),
	### Bitfield: administrator.dbtech_classifiedsadminperms ###
		dbtech_classifiedsadminperms = IF(dbtech_classifiedsadminperms & 1, dbtech_classifiedsadminperms - 1, dbtech_classifiedsadminperms),
	cssprefs = '',
	dismissednews = ''
WHERE userid = 9157;

MySQL Error   : Unknown column 'dbtech_usertagadminperms' in 'field list'
Error Number  : 1054
Request Date  : Saturday, January 25th 2014 @ 05:07:23 PM
Error Date    : Saturday, January 25th 2014 @ 05:07:23 PM
Script        : http://www.englishbulldognews.com/forums/admincp/adminpermissions.php?do=update
Referrer      : http://www.englishbulldognews.com/forums/admincp/adminpermissions.php?do=edit&u=9157
IP Address    : 107.4.97.254
Username      : desertskybulldogs
Classname     : vB_Database
MySQL Version : 5.1.72-cll

 

[Fillip H.]

Run the following 2 queries:

ALTER TABLE usergroup ADD dbtech_usertagpermissions INT(10) UNSIGNED NOT NULL DEFAULT '0'

ALTER TABLE administrator ADD dbtech_usertagadminperms INT(10) UNSIGNED NOT NULL DEFAULT '0'

 

[Bullmama DeLano]

First query: Affected Rows: 17 (0.0206s)

Second query: An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UNSIGNED NOT NULL DEFAULT '0'' at line 1

 

[Fillip H.]

Edited my post, the correct second query is

ALTER TABLE administrator ADD dbtech_usertagadminperms INT(10) UNSIGNED NOT NULL DEFAULT '0'

Sorry about that

 

[Bullmama DeLano]

Thanks!

Not sure if this is related, or what it is related to, but I've only installed DB classifieds and DB Pro user tagging in the past few weeks....

Now I went to create a static html widget and it is not saving or returning anything. You can see on my home page on the right side, scroll down to see the empty box. English Bulldog News Forums - English Bulldog News Forums ~

What is that??! Crazy huh?

 

[Bullmama DeLano]

I found it, it is the Super PM mod, so I will post the bug in that forum. Thanks for your help Fillip H.!