Thanks for that. I did as instructed and everthing appeared to have installed properly. However, having made changes in the Shoutbox via User settings and then tried to Save those changes, I get the following error message:
Database error in vBulletin 4.0.4:
Invalid SQL:
UPDATE vb3_user SET
### Bitfield: vb3_user.dbtech_vbshout_settings ###
dbtech_vbshout_settings = IF(dbtech_vbshout_settings & 2048, dbtech_vbshout_settings, dbtech_vbshout_settings + 2048),
dbtech_vbshout_settings = IF(dbtech_vbshout_settings & 32, dbtech_vbshout_settings, dbtech_vbshout_settings + 32),
dbtech_vbshout_settings = IF(dbtech_vbshout_settings & 64, dbtech_vbshout_settings, dbtech_vbshout_settings + 64),
dbtech_vbshout_settings = IF(dbtech_vbshout_settings & 1, dbtech_vbshout_settings, dbtech_vbshout_settings + 1),
dbtech_vbshout_settings = IF(dbtech_vbshout_settings & 2, dbtech_vbshout_settings, dbtech_vbshout_settings + 2),
dbtech_vbshout_settings = IF(dbtech_vbshout_settings & 4, dbtech_vbshout_settings, dbtech_vbshout_settings + 4),
dbtech_vbshout_settings = IF(dbtech_vbshout_settings & 16, dbtech_vbshout_settings, dbtech_vbshout_settings + 16),
dbtech_vbshout_settings = IF(dbtech_vbshout_settings & 8, dbtech_vbshout_settings, dbtech_vbshout_settings + 8),
dbtech_vbshout_settings = IF(dbtech_vbshout_settings & 4096, dbtech_vbshout_settings, dbtech_vbshout_settings + 4096),
dbtech_vbshout_settings = IF(dbtech_vbshout_settings & 128, dbtech_vbshout_settings, dbtech_vbshout_settings + 128),
dbtech_vbshout_settings = IF(dbtech_vbshout_settings & 512, dbtech_vbshout_settings - 512, dbtech_vbshout_settings),
dbtech_vbshout_settings = IF(dbtech_vbshout_settings & 1024, dbtech_vbshout_settings - 1024, dbtech_vbshout_settings),
dbtech_vbshout_settings = IF(dbtech_vbshout_settings & 8192, dbtech_vbshout_settings - 8192, dbtech_vbshout_settings),
dbtech_vbshout_settings = IF(dbtech_vbshout_settings & 16384, dbtech_vbshout_settings - 16384, dbtech_vbshout_settings),
dbtech_vbshout_settings = IF(dbtech_vbshout_settings & 32768, dbtech_vbshout_settings - 32768, dbtech_vbshout_settings),
dbtech_vbshout_settings = IF(dbtech_vbshout_settings & 65536, dbtech_vbshout_settings - 65536, dbtech_vbshout_settings),
dbtech_vbshout_shoutarea = 'default',
dbtech_vbshout_shoutboxsize = 0,
dbtech_vbshout_shoutboxsize_detached = 0,
dbtech_vbshout_displayorder = 'a:1:{i:1;a:4:{s:11:\"shoutnotifs\";s:0:\"\";s:10:\"systemmsgs\";s:0:\"\";s:12:\"shoutreports\";s:0:\"\";s:11:\"chatroom_1_\";s:0:\"\";}}'
WHERE userid = 1;
MySQL Error : Unknown column 'dbtech_vbshout_shoutboxsize' in 'field list'
Error Number : 1054
Request Date : Wednesday, August 11th 2010 @ 01:58:55 PM
Error Date : Wednesday, August 11th 2010 @ 01:58:55 PM
Script :
http://www.rwf-forum.co.uk/vBulletin/profile.php
Referrer :
http://www.rwf-forum.co.uk/vBulletin/profile.php?do=dbtech_vbshout_options
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.0.91-community-log