[LightBringer]

Groovesalad,

Database error in vBulletin Control Panel 2.2.8:

Invalid SQL: ALTER TABLE thread ADD tpostid int( 10 ) unsigned DEFAULT '0' NOT NULL
mysql error: Duplicate column name 'tpostid'

mysql error number: 1060

Date: Thursday 24th of October 2002 05:42:48 PM
Script: http://groove-salad.com/forum/forum...step=upgrade201
Referer: http://www.groove-salad.com/forum/admin/vbi_install.php

What this code is telling you is that MYSQL is attempting to alter a table known as THREAD by adding a column called TPOSTID to it. Notice the error: "Duplicate column name 'tpostid'"?
This means that it already exists.

Here's what you do:
Go into myphpadmin or sql server admin of choice, drop that table.

Run the install for 2.1 THEN do setpostid.php if and only if your news doesn't show up.

Hope that helps.