Upgrading problems

[canyoncomposite]

Hi,
I'm having a database problem when updating from vb 3.6.0 to vb 3.8.6. I'm experienced with database errors and management and I am unable to interpret it myself. Any help at all would be appreciated!
Below is the error message.

Database error in vBulletin 3.7.0 Beta 2: Invalid SQL: ALTER TABLE groupmessage
CHANGE groupid groupid INT UNSIGNED NOT NULL DEFAULT '0',
CHANGE postuserid postuserid INT UNSIGNED NOT NULL DEFAULT '0',
CHANGE postusername postusername VARCHAR(100) NOT NULL DEFAULT '',
CHANGE dateline dateline INT UNSIGNED NOT NULL DEFAULT '0',
CHANGE ipaddress ipaddress INT UNSIGNED NOT NULL DEFAULT '0';

MySQL Error : Unknown column 'groupid' in 'groupmessage'
Error Number : 1054
Request Date : Thursday, September 23rd 2010 @ 12:10:45 PM
Error Date : Thursday, September 23rd 2010 @ 12:10:45 PM
Script : http://compositescentral.net/install...0b3.php?step=2
Referrer : http://compositescentral.net/install...0b3.php?step=1
IP Address : 134.71.145.156
Username : Classname : vB_Database MySQL Version : 5.1.47-community-log

[borbole]

Originally Posted by canyoncomposite

Hi,
I'm having a database problem when updating from vb 3.6.0 to vb 3.8.6. I'm experienced with database errors and management and I am unable to interpret it myself. Any help at all would be appreciated!
Below is the error message.

Database error in vBulletin 3.7.0 Beta 2: Invalid SQL: ALTER TABLE groupmessage
CHANGE groupid groupid INT UNSIGNED NOT NULL DEFAULT '0',
CHANGE postuserid postuserid INT UNSIGNED NOT NULL DEFAULT '0',
CHANGE postusername postusername VARCHAR(100) NOT NULL DEFAULT '',
CHANGE dateline dateline INT UNSIGNED NOT NULL DEFAULT '0',
CHANGE ipaddress ipaddress INT UNSIGNED NOT NULL DEFAULT '0';

MySQL Error : Unknown column 'groupid' in 'groupmessage'
Error Number : 1054
Request Date : Thursday, September 23rd 2010 @ 12:10:45 PM
Error Date : Thursday, September 23rd 2010 @ 12:10:45 PM
Script : http://compositescentral.net/install...0b3.php?step=2
Referrer : http://compositescentral.net/install...0b3.php?step=1
IP Address : 134.71.145.156
Username : Classname : vB_Database MySQL Version : 5.1.47-community-log

I am not familiar with the db structure of that old version but from the error it looks like groupid field is missing from the groupmessage table. I don''t know if that is a default field but added from a mod. But if I were to guess is that it is a default field that either has been dropped or no longer exists in the groupmessage table in the newer version.