Database problems when upgrading
 

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

The screenshot of the email is easier to read so here it is
Attachment 47693
Attached Images

• http://vb.ma7room.com/png.gif error.png‎ (28.7 KB)