Gossamer Forum
Home : Products : Gossamer Forum : Discussion :

Upgrade failure

Quote Reply
Upgrade failure
Performing Gossamer Forum 1.1.8 -> 1.2.0 upgrades...
Making sure you have the required p_rfl index...
Okay!
Adding column post_sticky to Post table...
Okay!
Adding index 'p_sf'...
Okay!
Adding column user_payment_expiry to User table...
Okay!
Making user_payment_expiry a protected field...
Okay!
Adding column user_payment_donations to User table...
Okay!
Making user_payment_donations a protected field...
Okay!
Change ban_reason column to allow an empty value for a ban reason...
An error occurred: Failed to execute query: 'ALTER TABLE gforum_ForumBan ALTER COLUMN ban_reason TEXT ' Reason: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot alter column 'ban_reason' because it is 'text'. (SQL-37000)(DBD: st_execute/SQLExecute err=-1)Adding Payment table...
Okay!
Adding PaymentLog table...
Okay!
Scanning for and repairing incorrect post reply counts...
Scanning for post tree inconsistencies...






Error




An error occured:

Failed to execute query: ' SELECT gforum_Post.post_id, gforum_Post.post_depth, COUNT(tree_id_fk) AS tree_recs FROM gforum_Post LEFT OUTER JOIN gforum_Post_tree ON gforum_Post_tree.tree_id_fk = gforum_Post.post_id GROUP BY post_id HAVING tree_recs != post_depth ORDER BY post_depth ' Reason: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'tree_recs'. (SQL-S0022) [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared. (SQL-37000)(DBD: st_execute/SQLExecute err=-1) at
.....edited\install.cgi line 8883.


Subject Author Views Date
Thread Upgrade failure ArmyAirForces 4128 May 23, 2003, 9:07 PM
Post Re: [ArmyAirForces] Upgrade failure
tsingson 4024 May 23, 2003, 9:40 PM
Thread Re: [ArmyAirForces] Upgrade failure
Jagerman 4018 May 23, 2003, 10:46 PM
Thread Re: [Jagerman] Upgrade failure
Jagerman 4031 May 23, 2003, 10:55 PM
Thread Re: [Jagerman] Upgrade failure
jaltuve 4016 May 23, 2003, 11:33 PM
Post Re: [jaltuve] Upgrade failure
jaltuve 4002 May 23, 2003, 11:39 PM
Post Re: [Jagerman] Upgrade failure
jaltuve 4000 May 24, 2003, 6:26 AM
Thread Re: [Jagerman] Upgrade failure
pugdog 4022 May 23, 2003, 11:31 PM
Post Re: [pugdog] Upgrade failure
Jagerman 3982 May 24, 2003, 3:19 PM