Status
Not open for further replies.

TheSonic

Customer
After i installed vbDownloads Lite, when i change a usergroup from Member to Administrator, i get the following DB Error (Workaround: Disbaled vbDownloads, made the change, reenabled vbDownloads)

Is this error also present in Pro?

Database error in vBulletin 4.2.0:

UPDATE user SET
### Bitfield: user.adminoptions ###
adminoptions = IF(adminoptions & 1, adminoptions - 1, adminoptions),
adminoptions = IF(adminoptions & 2, adminoptions - 2, adminoptions),
usertitle = '♥ ChilledFM Babe ♥',
customtitle = 1,
birthday_search = '',
birthday = '',
referrerid = 0,
usergroupid = 6,
joindate = 1341867720,
lastactivity = 1344365700,
lastpost = 0,
membergroupids = '',
displaygroupid = 0,
dbtech_downloads_banned = '0'
WHERE userid = 72;

MySQL Error : Unknown column 'dbtech_downloads_banned' in 'field list'
Error Number : 1054
Request Date : Tuesday, August 7th 2012 @ 08:56:08 PM
Error Date : Tuesday, August 7th 2012 @ 08:56:09 PM
Script : (...)/admincp/user.php?do=update
Referrer : (...)/admincp/user.php?do=edit&u=72
IP Address : 93.231.168.195
Username : TheSonic
Classname : vB_Database
MySQL Version : 5.5.14

Thanks,
Alex
 
Hello again :)

as i plan to buy the Pro-Version on the Weekend:

* Does this error also occur in the Pro Version?
* Is there a fix available (Changing Usergroups is a daily task, so this error is a "Showstopper" for my site)

Thanks again and greets,
Alex
 
Sorry, not sure why that's happening. I double checked and it's in the install files.

To get it to work you can go into the ACP and run a query to create the field

ACP->Maintenance->Execute SQL Query

Run the query

PHP:
ALTER TABLE `user` ADD `dbtech_downloads_banned` ENUM('0','1') NOT NULL DEFAULT '0'
 
+1 to unconfirmed bug

Does this error also occur in the Pro Version?
Installed pro-version and when I tried to change password for one of the administrators throuth the ACP I got quite similar DB error:
Code:
Database error in vBulletin 4.2.0:

Invalid SQL:
UPDATE user SET
	### Bitfield: user.adminoptions ###
		adminoptions = IF(adminoptions & 1, adminoptions - 1, adminoptions),
		adminoptions = IF(adminoptions & 2, adminoptions - 2, adminoptions),
	usertitle = '------------',
	customtitle = 1,
	birthday_search = '',
	birthday = '',
	referrerid = 0,
	displaygroupid = 0,
	membergroupids = '7,13,15,19',
	joindate = 1274517300,
	lastactivity = 1356610560,
	lastpost = 1339236180,
	salt = '}C9`WBU7Sl:as;_r#ui3g)sWC.SJ8c',
	passworddate = FROM_UNIXTIME(1356610708),
	password = 'c85024c99742a5765cdd707c378664c0',
	dbtech_downloads_banned = '0'
WHERE userid = 4;

MySQL Error   : Unknown column 'dbtech_downloads_banned' in 'field list'
Error Number  : 1054
Request Date  : Thursday, December 27th 2012 @ 01:18:28 PM
Error Date    : Thursday, December 27th 2012 @ 01:18:29 PM
Script        : http://www.---------/forum/admincp/user.php?do=update
Referrer      : http://www.---------/forum/admincp/user.php?do=edit&u=4
IP Address    : ------------
Username      : Gecuba
Classname     : vB_Database
MySQL Version : 5.5.22-0ubuntu1
I turned off vbdownloads and changed the password...
 
when i change a usergroup from Member to Administrator, i get the following DB Error (Workaround: Disbaled vbDownloads, made the change, reenabled vbDownloads)
+1 - the same issue, but with enabling user's secondary usergroup. And the same workaround.
1.3.8 pro-version

I hope version 1.4 will be released during next 3 months of my pro-license :eek:
 
Status
Not open for further replies.

Legacy vBDownloads

vBulletin 3.8.x vBulletin 4.x.x
Seller
DragonByte Technologies
Release date
Last update
Total downloads
1,713
Customer rating
0.00 star(s) 0 ratings
Back
Top