Hi Jason here are the details from doing another upgrade
Removing stale references to Ancestor table...
Gossamer Forum 1.1.2 -> 1.1.3 upgrades performed.
Performing Gossamer Forum 1.1.3 -> 1.1.4 upgrades...
Updating cat_depth column to hidden display...
Okay!
Gossamer Forum 1.1.3 -> 1.1.4 upgrades performed.
Performing Gossamer Forum 1.1.4 -> 1.1.5 upgrades...
Removing extra 'min_forum_permission' tag from message_preview action
Okay!
Gossamer Forum 1.1.4 -> 1.1.5 upgrades performed.
Performing Gossamer Forum 1.1.5 -> 1.1.6 upgrades...
Adding column user_show_user_icons to User table...
Could not add column user_show_user_icons: Unable to add column 'user_show_user_icons' - already exists.
Changing user_icon in admin to a text box...
Okay!
Gossamer Forum 1.1.5 -> 1.1.6 upgrades performed.
Performing Gossamer Forum 1.1.6 -> 1.1.7 upgrades...
Adding column post_moved to Post table...
Could not add column post_moved: Unable to add column 'post_moved' - already exists.
Adding column post_moved_id to Post table...
Could not add column post_moved_id: Unable to add column 'post_moved_id' - already exists.
Adding post_moved_id foreign key... Okay!
Adding user_email index to User table...
An error occured: Failed to execute query: 'ALTER TABLE gforum_User ADD INDEX u_e (user_email)' Reason: Duplicate key name 'u_e'Adding column forum_move_pointer to Forum table...
Could not add column forum_move_pointer: Unable to add column 'forum_move_pointer' - already exists.
Adding column edit_reason to EditLog table...
Could not add column edit_reason: Unable to add column 'edit_reason' - already exists.
Gossamer Forum 1.1.6 -> 1.1.7 upgrades performed.
Performing Gossamer Forum 1.1.7 -> 1.1.8 upgrades...
Adding fileman_root_path configuration variable... Okay!
Looking for invalid excess columns in the Post and Message tables... Okay!
Gossamer Forum 1.1.7 -> 1.1.8 upgrades performed.
From the details above everything looks to have gone ok except for maybe "Adding user_email index to User table...
An error occured: Failed to execute query: 'ALTER TABLE gforum_User ADD INDEX u_e (user_email)' Reason: Duplicate key name 'u_e'Adding column forum_move_pointer to Forum table...".
Otherwise all seem to be just because they already exist.
I then went to replicate the problem with modifying forums and I still get the same error message.
Failed to execute query: 'UPDATE gforum_Forum SET forum_total_threads = ? , forum_last_poster = ? , forum_total = ? , forum_allow_attachments = ? , forum_name = ? , forum_allow_user_edit = ? , forum_attachments = ? , forum_last_id = ? , forum_sort_rank = ? , forum_style = ? , forum_move_pointer = ? , forum_allow_guest_attachments = ? , forum_new_timeout = ? , cat_id_fk = ? , forum_hard_delete = ? , forum_desc = ? , forum_edit_timeout = ? , forum_last = ? WHERE forum_id = ?' Reason: Unknown column 'forum_move_pointer' in 'field list'
Do you have a copy of 1.1.3 that you can send me? What I can do is install 1.1.3 and then try the upgrade.
Thanks
Webmaster
http://www.e-bannerx.com
Quote:
Performing Gossamer Forum 1.1.2 -> 1.1.3 upgrades... Removing stale references to Ancestor table...
Gossamer Forum 1.1.2 -> 1.1.3 upgrades performed.
Performing Gossamer Forum 1.1.3 -> 1.1.4 upgrades...
Updating cat_depth column to hidden display...
Okay!
Gossamer Forum 1.1.3 -> 1.1.4 upgrades performed.
Performing Gossamer Forum 1.1.4 -> 1.1.5 upgrades...
Removing extra 'min_forum_permission' tag from message_preview action
Okay!
Gossamer Forum 1.1.4 -> 1.1.5 upgrades performed.
Performing Gossamer Forum 1.1.5 -> 1.1.6 upgrades...
Adding column user_show_user_icons to User table...
Could not add column user_show_user_icons: Unable to add column 'user_show_user_icons' - already exists.
Changing user_icon in admin to a text box...
Okay!
Gossamer Forum 1.1.5 -> 1.1.6 upgrades performed.
Performing Gossamer Forum 1.1.6 -> 1.1.7 upgrades...
Adding column post_moved to Post table...
Could not add column post_moved: Unable to add column 'post_moved' - already exists.
Adding column post_moved_id to Post table...
Could not add column post_moved_id: Unable to add column 'post_moved_id' - already exists.
Adding post_moved_id foreign key... Okay!
Adding user_email index to User table...
An error occured: Failed to execute query: 'ALTER TABLE gforum_User ADD INDEX u_e (user_email)' Reason: Duplicate key name 'u_e'Adding column forum_move_pointer to Forum table...
Could not add column forum_move_pointer: Unable to add column 'forum_move_pointer' - already exists.
Adding column edit_reason to EditLog table...
Could not add column edit_reason: Unable to add column 'edit_reason' - already exists.
Gossamer Forum 1.1.6 -> 1.1.7 upgrades performed.
Performing Gossamer Forum 1.1.7 -> 1.1.8 upgrades...
Adding fileman_root_path configuration variable... Okay!
Looking for invalid excess columns in the Post and Message tables... Okay!
Gossamer Forum 1.1.7 -> 1.1.8 upgrades performed.
From the details above everything looks to have gone ok except for maybe "Adding user_email index to User table...
An error occured: Failed to execute query: 'ALTER TABLE gforum_User ADD INDEX u_e (user_email)' Reason: Duplicate key name 'u_e'Adding column forum_move_pointer to Forum table...".
Otherwise all seem to be just because they already exist.
I then went to replicate the problem with modifying forums and I still get the same error message.
Quote:
Do you have a copy of 1.1.3 that you can send me? What I can do is install 1.1.3 and then try the upgrade.
Thanks
Webmaster
http://www.e-bannerx.com
