Some issues before and after the upgrade

[Gumble]

This was before updated to the beta version while setting a user to admin level.

Guess it is related to the prefix...

Database error in vBulletin 4.1.0:

Invalid SQL:
UPDATE vb_administrator SET
	### Bitfield: vb_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, adminpermissions + 32),
		adminpermissions = IF(adminpermissions & 64, adminpermissions, adminpermissions + 64),
		adminpermissions = IF(adminpermissions & 128, adminpermissions, adminpermissions + 128),
		adminpermissions = IF(adminpermissions & 256, adminpermissions - 256, adminpermissions),
		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,
	vbcmspermissions = 0,
	### Bitfield: vb_administrator.dbtech_thanksadminperms ###
		dbtech_thanksadminperms = IF(dbtech_thanksadminperms & 1, dbtech_thanksadminperms - 1, dbtech_thanksadminperms),
	cssprefs = '',
	dismissednews = '81,90,91,93,94,95,97,98'
WHERE userid = 264;

MySQL Error   : Unknown column 'dbtech_thanksadminperms' in 'field list'
Error Number  : 1054
Request Date  : Friday, December 3rd 2010 @ 06:36:05 AM
Error Date    : Friday, December 3rd 2010 @ 06:36:05 AM
Script        : http://www.xxx.com/stack/adminpermissions.php?do=update
Referrer      : http://www.xxx.com/stack/adminpermissions.php?do=edit&u=264
IP Address    : xxx
Username      : xxx
Classname     : vB_Database_MySQLi
MySQL Version : 5.0.77-log

After I noticed there was a new version (beta) I get this if I enable the mod:

Fatal error: Class 'THANKS' not found in /var/www/vhosts/xxx.com/httpdocs/dbtech/thanks/hooks/showthread_query.php on line 40

Also my admincp and modcp folders are renamed maybe that can have something to do it too.

Also im running the 4.1.0 PL1


Greetings

 

[Gumble]

Ok its working on 4.1.0 PL1

Just the issue setting the permissions to a admin user keep the problem...

Database error in vBulletin 4.1.0:

Invalid SQL:
UPDATE vb_administrator SET
	### Bitfield: vb_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 - 256, adminpermissions),
		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,
	vbcmspermissions = 0,
	### Bitfield: vb_administrator.dbtech_thanksadminperms ###
		dbtech_thanksadminperms = IF(dbtech_thanksadminperms & 1, dbtech_thanksadminperms - 1, dbtech_thanksadminperms),
	cssprefs = '',
	dismissednews = '81,90,91,93,94,95,97,98'
WHERE userid = 264;

MySQL Error   : Unknown column 'dbtech_thanksadminperms' in 'field list'
Error Number  : 1054
Request Date  : Friday, December 3rd 2010 @ 12:42:13 PM
Error Date    : Friday, December 3rd 2010 @ 12:42:13 PM
Script        : http://www.xxx.com/stack/adminpermissions.php?do=update
Referrer      : http://www.xxx.com/stack/adminpermissions.php?do=edit&u=264
IP Address    : xxx
Username      : xxx
Classname     : vB_Database_MySQLi
MySQL Version : 5.0.77-log

 

[Fillip H.]

Run this:

ALTER TABLE vb_administrator ADD dbtech_thanksadminperms INT(10) UNSIGNED NOT NULL DEFAULT '0'