Gossamer Forum
Home : Products : Gossamer Forum : Discussion :

Re: [Jagerman] This something to ask our DBA about or...?

Quote Reply
Re: [Jagerman] This something to ask our DBA about or...? In reply to
Hi Jason here are the details from doing another upgrade

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:
  • 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
    Subject Author Views Date
    Thread Gossamer Forum 1.1.7 Released Jagerman 10721 Jul 11, 2002, 3:00 PM
    Thread Moving trails aren't working
    ellipsiiis 10121 Jul 11, 2002, 4:34 PM
    Post Re: [ellipsiiis] Moving trails aren't working
    Jagerman 10003 Jul 11, 2002, 4:37 PM
    Thread Re: [ellipsiiis] Moving trails aren't working
    Jagerman 10066 Jul 11, 2002, 4:39 PM
    Post Re: [Jagerman] Moving trails aren't working
    ellipsiiis 9989 Jul 11, 2002, 4:42 PM
    Thread Re: [Jagerman] Gossamer Forum 1.1.7 Released
    ArmyAirForces 10135 Jul 11, 2002, 4:41 PM
    Post Re: [ArmyAirForces] Gossamer Forum 1.1.7 Released
    backdream 9905 Jul 12, 2002, 12:54 AM
    Thread Re: [Jagerman] Gossamer Forum 1.1.7 Released
    yogi 10095 Jul 12, 2002, 12:56 AM
    Thread Re: [yogi] Gossamer Forum 1.1.7 Released
    Jagerman 10274 Jul 12, 2002, 9:49 AM
    Post Re: [Jagerman] Gossamer Forum 1.1.7 Released
    yogi 9816 Jul 12, 2002, 10:38 PM
    Post Re: [Jagerman] Gossamer Forum 1.1.7 Released
    yogi 9957 Jul 12, 2002, 3:31 AM
    Thread Post deleted by ArmyAirForces
    ArmyAirForces 9975 Jul 12, 2002, 6:48 AM
    Post Post deleted by ArmyAirForces
    ArmyAirForces 9937 Jul 12, 2002, 6:49 AM
    Thread Re: [Jagerman] Gossamer Forum 1.1.7 Released
    ArmyAirForces 9978 Jul 12, 2002, 10:13 AM
    Thread Re: [ArmyAirForces] Gossamer Forum 1.1.7 Released
    Jagerman 9991 Jul 12, 2002, 11:20 AM
    Thread Re: [Jagerman] Gossamer Forum 1.1.7 Released
    yogi 9879 Jul 13, 2002, 6:52 AM
    Post Re: [yogi] Gossamer Forum 1.1.7 Released
    Jagerman 9871 Jul 14, 2002, 12:11 PM
    Thread Re: [Jagerman] Gossamer Forum 1.1.7 Released
    ArmyAirForces 10153 Jul 12, 2002, 10:29 AM
    Thread Re: [ArmyAirForces] Gossamer Forum 1.1.7 Released
    Jagerman 10056 Jul 12, 2002, 10:32 AM
    Post Re: [Jagerman] Gossamer Forum 1.1.7 Released
    ArmyAirForces 9905 Jul 12, 2002, 11:02 AM
    Thread Re: [Jagerman] Gossamer Forum 1.1.7 Released
    ArmyAirForces 10038 Jul 13, 2002, 6:13 AM
    Thread Re: [ArmyAirForces] Gossamer Forum 1.1.7 Released
    ArmyAirForces 9914 Jul 15, 2002, 10:08 AM
    Thread Re: [ArmyAirForces] Gossamer Forum 1.1.7 Released
    ellipsiiis 10037 Jul 15, 2002, 10:11 AM
    Post Re: [ellipsiiis] Gossamer Forum 1.1.7 Released
    ArmyAirForces 9847 Jul 15, 2002, 10:17 AM
    Thread Re: [ellipsiiis] Gossamer Forum 1.1.7 Released
    ArmyAirForces 9861 Jul 15, 2002, 11:02 AM
    Thread Re: [ArmyAirForces] Gossamer Forum 1.1.7 Released
    ellipsiiis 6815 Jul 15, 2002, 11:21 AM
    Post Re: [ellipsiiis] Gossamer Forum 1.1.7 Released
    ArmyAirForces 6759 Jul 15, 2002, 11:56 AM
    Thread Re: [ellipsiiis] Gossamer Forum 1.1.7 Released
    ArmyAirForces 6844 Jul 15, 2002, 12:02 PM
    Thread Re: [ArmyAirForces] Gossamer Forum 1.1.7 Released
    ellipsiiis 6881 Jul 15, 2002, 5:39 PM
    Post Re: [ellipsiiis] Gossamer Forum 1.1.7 Released
    ArmyAirForces 6774 Jul 16, 2002, 11:40 AM
    Thread This something to ask our DBA about or...?
    agaffin 6743 Jul 19, 2002, 9:42 AM
    Thread Re: [agaffin] This something to ask our DBA about or...?
    Jagerman 6739 Jul 26, 2002, 12:26 PM
    Thread Re: [Jagerman] This something to ask our DBA about or...?
    fulcan 6611 Apr 20, 2003, 6:06 AM
    Thread Re: [fulcan] This something to ask our DBA about or...?
    Paul 6628 Apr 20, 2003, 6:15 AM
    Thread Re: [Paul] This something to ask our DBA about or...?
    fulcan 6683 Apr 20, 2003, 6:25 AM
    Post Re: [fulcan] This something to ask our DBA about or...?
    Paul 6685 Apr 20, 2003, 7:03 AM
    Thread Re: [fulcan] This something to ask our DBA about or...?
    Jagerman 6658 Apr 20, 2003, 4:05 PM
    Thread Re: [Jagerman] This something to ask our DBA about or...?
    fulcan 6682 Apr 20, 2003, 5:15 PM
    Thread Re: [fulcan] This something to ask our DBA about or...?
    Jagerman 6794 Apr 20, 2003, 7:59 PM
    Thread Re: [Jagerman] This something to ask our DBA about or...?
    fulcan 6672 Apr 21, 2003, 12:08 AM
    Thread Re: [fulcan] This something to ask our DBA about or...?
    Jagerman 6686 Apr 21, 2003, 12:45 AM
    Thread Re: [Jagerman] This something to ask our DBA about or...?
    fulcan 6611 Apr 22, 2003, 5:15 AM
    Thread Re: [fulcan] This something to ask our DBA about or...?
    Jagerman 6576 Apr 22, 2003, 2:43 PM
    Thread Re: [Jagerman] This something to ask our DBA about or...?
    fulcan 6766 Apr 23, 2003, 4:27 AM
    Thread Re: [fulcan] This something to ask our DBA about or...?
    Jagerman 6665 Apr 23, 2003, 5:01 AM
    Post Re: [Jagerman] This something to ask our DBA about or...?
    fulcan 6531 Apr 23, 2003, 5:56 AM