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 14075 Jul 11, 2002, 3:00 PM
Thread Moving trails aren't working
ellipsiiis 13384 Jul 11, 2002, 4:34 PM
Post Re: [ellipsiiis] Moving trails aren't working
Jagerman 13267 Jul 11, 2002, 4:37 PM
Thread Re: [ellipsiiis] Moving trails aren't working
Jagerman 13341 Jul 11, 2002, 4:39 PM
Post Re: [Jagerman] Moving trails aren't working
ellipsiiis 13251 Jul 11, 2002, 4:42 PM
Thread Re: [Jagerman] Gossamer Forum 1.1.7 Released
ArmyAirForces 13406 Jul 11, 2002, 4:41 PM
Post Re: [ArmyAirForces] Gossamer Forum 1.1.7 Released
backdream 13166 Jul 12, 2002, 12:54 AM
Thread Re: [Jagerman] Gossamer Forum 1.1.7 Released
yogi 13385 Jul 12, 2002, 12:56 AM
Thread Re: [yogi] Gossamer Forum 1.1.7 Released
Jagerman 13552 Jul 12, 2002, 9:49 AM
Post Re: [Jagerman] Gossamer Forum 1.1.7 Released
yogi 13076 Jul 12, 2002, 10:38 PM
Post Re: [Jagerman] Gossamer Forum 1.1.7 Released
yogi 13218 Jul 12, 2002, 3:31 AM
Thread Post deleted by ArmyAirForces
ArmyAirForces 13240 Jul 12, 2002, 6:48 AM
Post Post deleted by ArmyAirForces
ArmyAirForces 13198 Jul 12, 2002, 6:49 AM
Thread Re: [Jagerman] Gossamer Forum 1.1.7 Released
ArmyAirForces 13243 Jul 12, 2002, 10:13 AM
Thread Re: [ArmyAirForces] Gossamer Forum 1.1.7 Released
Jagerman 13272 Jul 12, 2002, 11:20 AM
Thread Re: [Jagerman] Gossamer Forum 1.1.7 Released
yogi 13147 Jul 13, 2002, 6:52 AM
Post Re: [yogi] Gossamer Forum 1.1.7 Released
Jagerman 13158 Jul 14, 2002, 12:11 PM
Thread Re: [Jagerman] Gossamer Forum 1.1.7 Released
ArmyAirForces 13428 Jul 12, 2002, 10:29 AM
Thread Re: [ArmyAirForces] Gossamer Forum 1.1.7 Released
Jagerman 13380 Jul 12, 2002, 10:32 AM
Post Re: [Jagerman] Gossamer Forum 1.1.7 Released
ArmyAirForces 13166 Jul 12, 2002, 11:02 AM
Thread Re: [Jagerman] Gossamer Forum 1.1.7 Released
ArmyAirForces 13378 Jul 13, 2002, 6:13 AM
Thread Re: [ArmyAirForces] Gossamer Forum 1.1.7 Released
ArmyAirForces 13179 Jul 15, 2002, 10:08 AM
Thread Re: [ArmyAirForces] Gossamer Forum 1.1.7 Released
ellipsiiis 13412 Jul 15, 2002, 10:11 AM
Post Re: [ellipsiiis] Gossamer Forum 1.1.7 Released
ArmyAirForces 13111 Jul 15, 2002, 10:17 AM
Thread Re: [ellipsiiis] Gossamer Forum 1.1.7 Released
ArmyAirForces 13126 Jul 15, 2002, 11:02 AM
Thread Re: [ArmyAirForces] Gossamer Forum 1.1.7 Released
ellipsiiis 8728 Jul 15, 2002, 11:21 AM
Post Re: [ellipsiiis] Gossamer Forum 1.1.7 Released
ArmyAirForces 8665 Jul 15, 2002, 11:56 AM
Thread Re: [ellipsiiis] Gossamer Forum 1.1.7 Released
ArmyAirForces 8763 Jul 15, 2002, 12:02 PM
Thread Re: [ArmyAirForces] Gossamer Forum 1.1.7 Released
ellipsiiis 8791 Jul 15, 2002, 5:39 PM
Post Re: [ellipsiiis] Gossamer Forum 1.1.7 Released
ArmyAirForces 8682 Jul 16, 2002, 11:40 AM
Thread This something to ask our DBA about or...?
agaffin 8655 Jul 19, 2002, 9:42 AM
Thread Re: [agaffin] This something to ask our DBA about or...?
Jagerman 8651 Jul 26, 2002, 12:26 PM
Thread Re: [Jagerman] This something to ask our DBA about or...?
fulcan 8530 Apr 20, 2003, 6:06 AM
Thread Re: [fulcan] This something to ask our DBA about or...?
Paul 8544 Apr 20, 2003, 6:15 AM
Thread Re: [Paul] This something to ask our DBA about or...?
fulcan 8593 Apr 20, 2003, 6:25 AM
Post Re: [fulcan] This something to ask our DBA about or...?
Paul 8594 Apr 20, 2003, 7:03 AM
Thread Re: [fulcan] This something to ask our DBA about or...?
Jagerman 8568 Apr 20, 2003, 4:05 PM
Thread Re: [Jagerman] This something to ask our DBA about or...?
fulcan 8588 Apr 20, 2003, 5:15 PM
Thread Re: [fulcan] This something to ask our DBA about or...?
Jagerman 8705 Apr 20, 2003, 7:59 PM
Thread Re: [Jagerman] This something to ask our DBA about or...?
fulcan 8580 Apr 21, 2003, 12:08 AM
Thread Re: [fulcan] This something to ask our DBA about or...?
Jagerman 8599 Apr 21, 2003, 12:45 AM
Thread Re: [Jagerman] This something to ask our DBA about or...?
fulcan 8522 Apr 22, 2003, 5:15 AM
Thread Re: [fulcan] This something to ask our DBA about or...?
Jagerman 8490 Apr 22, 2003, 2:43 PM
Thread Re: [Jagerman] This something to ask our DBA about or...?
fulcan 8684 Apr 23, 2003, 4:27 AM
Thread Re: [fulcan] This something to ask our DBA about or...?
Jagerman 8594 Apr 23, 2003, 5:01 AM
Post Re: [Jagerman] This something to ask our DBA about or...?
fulcan 8446 Apr 23, 2003, 5:56 AM