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,

Ok your solution has fixed the problem with making changes to the forum in admin, however, I have tried to make a change to my profile and got the following error.

Quote:


Failed to execute query: 'SELECT user_username,user_yahoo,user_homepage,user_email,user_disp_email,user_icq,user_message_notify,user_id,user_interests,user_real_name,user_icon,user_show_user_icons,user_msn,user_signature,user_default_reply_notify,user_location,user_invisible,user_accept_privmsg,user_aim,user_occupation FROM gforum_User WHERE user_id = ? ' Reason: Unknown column 'user_show_user_icons' in 'field list'


It seems to be missing Unknown column 'user_show_user_icons' in 'field list'. Should I try resyncing and trying from a higher version again?

Thanks - Below are the details of the upgrade if that helps.

Quote:
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...
Okay!
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.
Webmaster
http://www.e-bannerx.com

Last edited by:

fulcan: Apr 23, 2003, 4:30 AM
Subject Author Views Date
Thread Gossamer Forum 1.1.7 Released Jagerman 12976 Jul 11, 2002, 3:00 PM
Thread Moving trails aren't working
ellipsiiis 12335 Jul 11, 2002, 4:34 PM
Post Re: [ellipsiiis] Moving trails aren't working
Jagerman 12218 Jul 11, 2002, 4:37 PM
Thread Re: [ellipsiiis] Moving trails aren't working
Jagerman 12294 Jul 11, 2002, 4:39 PM
Post Re: [Jagerman] Moving trails aren't working
ellipsiiis 12205 Jul 11, 2002, 4:42 PM
Thread Re: [Jagerman] Gossamer Forum 1.1.7 Released
ArmyAirForces 12355 Jul 11, 2002, 4:41 PM
Post Re: [ArmyAirForces] Gossamer Forum 1.1.7 Released
backdream 12119 Jul 12, 2002, 12:54 AM
Thread Re: [Jagerman] Gossamer Forum 1.1.7 Released
yogi 12311 Jul 12, 2002, 12:56 AM
Thread Re: [yogi] Gossamer Forum 1.1.7 Released
Jagerman 12492 Jul 12, 2002, 9:49 AM
Post Re: [Jagerman] Gossamer Forum 1.1.7 Released
yogi 12028 Jul 12, 2002, 10:38 PM
Post Re: [Jagerman] Gossamer Forum 1.1.7 Released
yogi 12171 Jul 12, 2002, 3:31 AM
Thread Post deleted by ArmyAirForces
ArmyAirForces 12192 Jul 12, 2002, 6:48 AM
Post Post deleted by ArmyAirForces
ArmyAirForces 12153 Jul 12, 2002, 6:49 AM
Thread Re: [Jagerman] Gossamer Forum 1.1.7 Released
ArmyAirForces 12194 Jul 12, 2002, 10:13 AM
Thread Re: [ArmyAirForces] Gossamer Forum 1.1.7 Released
Jagerman 12211 Jul 12, 2002, 11:20 AM
Thread Re: [Jagerman] Gossamer Forum 1.1.7 Released
yogi 12101 Jul 13, 2002, 6:52 AM
Post Re: [yogi] Gossamer Forum 1.1.7 Released
Jagerman 12107 Jul 14, 2002, 12:11 PM
Thread Re: [Jagerman] Gossamer Forum 1.1.7 Released
ArmyAirForces 12380 Jul 12, 2002, 10:29 AM
Thread Re: [ArmyAirForces] Gossamer Forum 1.1.7 Released
Jagerman 12329 Jul 12, 2002, 10:32 AM
Post Re: [Jagerman] Gossamer Forum 1.1.7 Released
ArmyAirForces 12121 Jul 12, 2002, 11:02 AM
Thread Re: [Jagerman] Gossamer Forum 1.1.7 Released
ArmyAirForces 12331 Jul 13, 2002, 6:13 AM
Thread Re: [ArmyAirForces] Gossamer Forum 1.1.7 Released
ArmyAirForces 12130 Jul 15, 2002, 10:08 AM
Thread Re: [ArmyAirForces] Gossamer Forum 1.1.7 Released
ellipsiiis 12360 Jul 15, 2002, 10:11 AM
Post Re: [ellipsiiis] Gossamer Forum 1.1.7 Released
ArmyAirForces 12063 Jul 15, 2002, 10:17 AM
Thread Re: [ellipsiiis] Gossamer Forum 1.1.7 Released
ArmyAirForces 12077 Jul 15, 2002, 11:02 AM
Thread Re: [ArmyAirForces] Gossamer Forum 1.1.7 Released
ellipsiiis 8140 Jul 15, 2002, 11:21 AM
Post Re: [ellipsiiis] Gossamer Forum 1.1.7 Released
ArmyAirForces 8083 Jul 15, 2002, 11:56 AM
Thread Re: [ellipsiiis] Gossamer Forum 1.1.7 Released
ArmyAirForces 8177 Jul 15, 2002, 12:02 PM
Thread Re: [ArmyAirForces] Gossamer Forum 1.1.7 Released
ellipsiiis 8205 Jul 15, 2002, 5:39 PM
Post Re: [ellipsiiis] Gossamer Forum 1.1.7 Released
ArmyAirForces 8097 Jul 16, 2002, 11:40 AM
Thread This something to ask our DBA about or...?
agaffin 8070 Jul 19, 2002, 9:42 AM
Thread Re: [agaffin] This something to ask our DBA about or...?
Jagerman 8066 Jul 26, 2002, 12:26 PM
Thread Re: [Jagerman] This something to ask our DBA about or...?
fulcan 7946 Apr 20, 2003, 6:06 AM
Thread Re: [fulcan] This something to ask our DBA about or...?
Paul 7958 Apr 20, 2003, 6:15 AM
Thread Re: [Paul] This something to ask our DBA about or...?
fulcan 8007 Apr 20, 2003, 6:25 AM
Post Re: [fulcan] This something to ask our DBA about or...?
Paul 8011 Apr 20, 2003, 7:03 AM
Thread Re: [fulcan] This something to ask our DBA about or...?
Jagerman 7984 Apr 20, 2003, 4:05 PM
Thread Re: [Jagerman] This something to ask our DBA about or...?
fulcan 8005 Apr 20, 2003, 5:15 PM
Thread Re: [fulcan] This something to ask our DBA about or...?
Jagerman 8118 Apr 20, 2003, 7:59 PM
Thread Re: [Jagerman] This something to ask our DBA about or...?
fulcan 7994 Apr 21, 2003, 12:08 AM
Thread Re: [fulcan] This something to ask our DBA about or...?
Jagerman 8014 Apr 21, 2003, 12:45 AM
Thread Re: [Jagerman] This something to ask our DBA about or...?
fulcan 7936 Apr 22, 2003, 5:15 AM
Thread Re: [fulcan] This something to ask our DBA about or...?
Jagerman 7905 Apr 22, 2003, 2:43 PM
Thread Re: [Jagerman] This something to ask our DBA about or...?
fulcan 8099 Apr 23, 2003, 4:27 AM
Thread Re: [fulcan] This something to ask our DBA about or...?
Jagerman 7987 Apr 23, 2003, 5:01 AM
Post Re: [Jagerman] This something to ask our DBA about or...?
fulcan 7854 Apr 23, 2003, 5:56 AM