Gossamer Forum: Products: Gossamer Forum: Discussion: Gossamer Forum 1.1.7 Released

Staff / Moderator (2198 posts)

Jul 11, 2002, 3:00 PM

Post #1 of 46

Shortcut

Gossamer Forum 1.1.7 Released

Gossamer Forum 1.1.7 is now available for download from the Gossamer Forum download page.

1.1.6 -> 1.1.7 CHANGES
======================
Moved thread tracking - forums can now be configured (enabled by default) to
leave a pointer in the old forum indicating that the post has been moved.
The move thread page now contains a checkbox to allow you to move a thread
without leaving a pointer.
Template diffs - The admin panel now contains template diffs for all versions
going back to the initial 1.0.0 release. The diffs are found in the
Templates menu.
Edit reason - when editting a post, a reason for editing can now be entered.
The reason is visible when viewing the editlog (clicking the word "edited"
in the "This post was edited by ..." message).
Duplicate e-mail prevention - a new admin option exists in the Setup -> Users
section that allows an installation to prevent people signing up with an
e-mail address that has already been used. If enabled, the signup is
prevented giving the existing username in the error message.
Several small bug fixes and minor improvements are also included.

NOTE: Due to the handling of moved threads in 1.1.7, some template changes
are necessary for proper operation. It is recommended that you look at the
diff provided and make the necessary changes in any templates that you
have customized.

Jason Rhinelander
Gossamer Threads
jason@gossamer-threads.com

Last edited by:

Jagerman: Jul 11, 2002, 3:01 PM

Jul 11, 2002, 4:34 PM

User (225 posts)

Jul 11, 2002, 4:34 PM

Post #2 of 46

Shortcut

Moving trails aren't working In reply to

I moved a post and there is no trail left. I tried several different forums, I tried checking and unchecking the box, nothing worked.

Realiiity.com Forums

Jul 11, 2002, 4:37 PM

Staff / Moderator (2198 posts)

Jul 11, 2002, 4:37 PM

Post #3 of 46

Shortcut

Re: [ellipsiiis] Moving trails aren't working In reply to

Check the value of the forum move pointer for the forums in question - they have to be set to yes before the move pointer will show up.

Jason Rhinelander
Gossamer Threads
jason@gossamer-threads.com

Jul 11, 2002, 4:39 PM

Staff / Moderator (2198 posts)

Jul 11, 2002, 4:39 PM

Post #4 of 46

Shortcut

Re: [ellipsiiis] Moving trails aren't working In reply to

You may also be running into template problems. 1.1.7 requires some template changes in order for the moved posts to properly show up. Take a look at the diff - the required changes are in forum_view.html. The only one absolutely required is basically adding: <%if post_moved%>Moved: <%endif%> in front of the linked post subject.

Jason Rhinelander
Gossamer Threads
jason@gossamer-threads.com

Jul 11, 2002, 4:41 PM

Veteran (1104 posts)

Jul 11, 2002, 4:41 PM

Post #5 of 46

Shortcut

Re: [Jagerman] Gossamer Forum 1.1.7 Released In reply to

Good deal Jason. This version has some handy and user/owner friendly stuff in it.

My little board popped the 1,000 subscriber mark this morning. After four months of operation it's all going pretty smoothly and overall I'm happy with the product.

Only significant thing left on my wish list is the "Pin to Top" or "Note" feature. Tongue

Thanks for 1.1.7!

Jul 11, 2002, 4:42 PM

User (225 posts)

Jul 11, 2002, 4:42 PM

Post #6 of 46

Shortcut

Re: [Jagerman] Moving trails aren't working In reply to

I just checked and the forums are all set to 1. I did make all the template changes before I tried it.

Edit: I did a query on the row for the post I moved, and there is nothing in post_moved. I noticed in the def that there is a post_moved_id column, but this column doesn't exist on my post table. I'll try adding it and see what happens.

Edit 2: That fixed it. :)

Realiiity.com Forums

Last edited by:

ellipsiiis: Jul 11, 2002, 4:54 PM

Jul 12, 2002, 12:54 AM

backdream

User (117 posts)

Jul 12, 2002, 12:54 AM

Post #7 of 46

Shortcut

Re: [ArmyAirForces] Gossamer Forum 1.1.7 Released In reply to

In Reply To:

Only significant thing left on my wish list is the "Pin to Top" or "Note" feature. Tongue

Thanks for 1.1.7!

Yes , Can I see the "Pin to Top" feature next version ? It 's the most feature I need !

Jul 12, 2002, 12:56 AM

Veteran / Moderator (2199 posts)

Jul 12, 2002, 12:56 AM

Post #8 of 46

Shortcut

Re: [Jagerman] Gossamer Forum 1.1.7 Released In reply to

Hi Jason,

after upgrading, I got the following error when trying to view forums:

Can't call method "fetchrow_hashref" on an undefined value at /home/yoga/html/forum/admin/GForum/Forum.pm line 85.

The debugging says:

GT::SQL::error = Failed to execute query: '
SELECT *
FROM gforum_Post /*!32312 USE INDEX (p_rfl) */ LEFT OUTER JOIN gforum_User ON gforum_Post.user_id_fk = gforum_User.user_id
WHERE (gforum_Post.post_root_id = '0' AND gforum_Post.forum_id_fk = '4')
ORDER BY post_latest_reply ASC LIMIT 0, 25
' Reason: Key column 'p_rfl' doesn't exist in table

So, I commented out line 60 in GForum/Forum.pm, i.e.

# local $PostUser->{tables_ord}->[0] = "$PostUser->{tables_ord}->[0] /*!32312 USE INDEX (p_rfl) */"; # MySQL hack to use the intended index

and now it seems to work fine.

Ivan
-----
Iyengar Yoga Resources / GT Plugins

Jul 12, 2002, 3:31 AM

Veteran / Moderator (2199 posts)

Jul 12, 2002, 3:31 AM

Post #9 of 46

Shortcut

Re: [Jagerman] Gossamer Forum 1.1.7 Released In reply to

I really like the template diffs! Nice job, and very useful.

Ivan
-----
Iyengar Yoga Resources / GT Plugins

Jul 12, 2002, 6:48 AM

Veteran (1104 posts)

Jul 12, 2002, 6:48 AM

Post #10 of 46

Shortcut

Post deleted by ArmyAirForces In reply to

Jul 12, 2002, 6:49 AM

Veteran (1104 posts)

Jul 12, 2002, 6:49 AM

Post #11 of 46

Shortcut

Post deleted by ArmyAirForces In reply to

Jul 12, 2002, 9:49 AM

Staff / Moderator (2198 posts)

Jul 12, 2002, 9:49 AM

Post #12 of 46

Shortcut

Re: [yogi] Gossamer Forum 1.1.7 Released In reply to

That's strange - you should have the p_rfl index, and we found we were running into speed problems in some cases without it. Try running this query:

Code:

ALTER TABLE gforum_Post ADD INDEX p_rfl (post_root_id, forum_id_fk, post_latest_reply)

Jason Rhinelander
Gossamer Threads
jason@gossamer-threads.com

Jul 12, 2002, 10:13 AM

Veteran (1104 posts)

Jul 12, 2002, 10:13 AM

Post #13 of 46

Shortcut

Re: [Jagerman] Gossamer Forum 1.1.7 Released In reply to

Jason,

Is there a way of having a clickable bit of text that would send a user to the "Lost Password?" page from SIGNUP_EMAIL_EXISTS?

Users are inherently lazy and I'd like to trim a step if possible.

Also how does SIGNUP_EMAIL_EXISTS? print out the e-mail address and then the user name with the same - %s - statement ? Is it the preceeding text that defines what %s is?

Hmmm, no it must be determined some other way as my experiment failed. Little help?

Last edited by:

ArmyAirForces: Jul 12, 2002, 10:19 AM

Jul 12, 2002, 10:29 AM

Veteran (1104 posts)

Jul 12, 2002, 10:29 AM

Post #14 of 46

Shortcut

Re: [Jagerman] Gossamer Forum 1.1.7 Released In reply to

Jason,

Should there be some changes for post_move_select.htm ? Believe I've made all listed template differences but am not seeing this moved post pointer or the check box to select it when moving a thread.

-Scott

Jul 12, 2002, 10:32 AM

Staff / Moderator (2198 posts)

Jul 12, 2002, 10:32 AM

Post #15 of 46

Shortcut

Re: [ArmyAirForces] Gossamer Forum 1.1.7 Released In reply to

Uh oh - the post_move_select.html template change was made only a few minutes before release - after I had made the diffs. It's a simple three lines added after the "Move Thread" button:

Code:


        <%if forum_move_pointer%><br> 
        <input type="checkbox" name="skip_pointer" value="1"> Don't leave moved post pointer 
        <%endif%>

Jason Rhinelander
Gossamer Threads
jason@gossamer-threads.com

Jul 12, 2002, 11:02 AM

Veteran (1104 posts)

Jul 12, 2002, 11:02 AM

Post #16 of 46

Shortcut

Re: [Jagerman] Gossamer Forum 1.1.7 Released In reply to

Okay that fixed that bit. I'm still not seeing the pointers though. Do you have an example on the forums here I could look at?

I want to see if it might not be showing up because of other modifications I've made.

-Scott

Jul 12, 2002, 11:20 AM

Staff / Moderator (2198 posts)

Jul 12, 2002, 11:20 AM

Post #17 of 46

Shortcut

Re: [ArmyAirForces] Gossamer Forum 1.1.7 Released In reply to

There are two %s's in the variable - the first gets the e-mail, the second gets the username.

I'd do it using a global like this:

In the template, inside <%loop errors%>, just after <%error%>, add this:

<%if error contains 'has already been used with another username'%> - <%show_existing($user_email)%><%endif%>

The "show_existing" global is going to be:

sub { my $email = shift; my $username = $DB->table('User')->select(user_username => { user_email => $email })->fetchrow; return \(qq|<a href="gforum.cgi?do=lost_password;user_username=| . $IN->escape($username) . qq|">Click here to e-mail your password</a>|); }

Jason Rhinelander
Gossamer Threads
jason@gossamer-threads.com

Jul 12, 2002, 10:38 PM

Veteran / Moderator (2199 posts)

Jul 12, 2002, 10:38 PM

Post #18 of 46

Shortcut

Re: [Jagerman] Gossamer Forum 1.1.7 Released In reply to

Jason,

I ran your query, uncommented the line again, and it now works.

Thanks.

Ivan
-----
Iyengar Yoga Resources / GT Plugins

Jul 13, 2002, 6:13 AM

Veteran (1104 posts)

Jul 13, 2002, 6:13 AM

Post #19 of 46

Shortcut

Re: [Jagerman] Gossamer Forum 1.1.7 Released In reply to

Where there any other template changes made in relation to this feature?

I do have the check box to disable the pointer now, but there are no pointers being left in my forum at this time.

What should I check?

Jul 13, 2002, 6:52 AM

Veteran / Moderator (2199 posts)

Jul 13, 2002, 6:52 AM

Post #20 of 46

Shortcut

Re: [Jagerman] Gossamer Forum 1.1.7 Released In reply to

Jason,

is <%if foo contains 'bar'%> a new function in the template parser? Any other new (hidden) features? (I guess I should study the ChangeLog...)

Ivan
-----
Iyengar Yoga Resources / GT Plugins

Jul 14, 2002, 12:11 PM

Staff / Moderator (2198 posts)

Jul 14, 2002, 12:11 PM

Post #21 of 46

Shortcut

Re: [yogi] Gossamer Forum 1.1.7 Released In reply to

Nope, it's been there forever - it just isn't used very often ;)

Jason Rhinelander
Gossamer Threads
jason@gossamer-threads.com

Jul 15, 2002, 10:08 AM

Veteran (1104 posts)

Jul 15, 2002, 10:08 AM

Post #22 of 46

Shortcut

Re: [ArmyAirForces] Gossamer Forum 1.1.7 Released In reply to

Bump.

Where there any other template changes made in relation to this feature?

I do have the check box to disable the pointer now, but there are no pointers being left in my forum at this time.

What should I check?

Last edited by:

ArmyAirForces: Jul 15, 2002, 10:08 AM

Jul 15, 2002, 10:11 AM

User (225 posts)

Jul 15, 2002, 10:11 AM

Post #23 of 46

Shortcut

Re: [ArmyAirForces] Gossamer Forum 1.1.7 Released In reply to

There's a list of template changes in your Admin via the Templates menu.

Realiiity.com Forums

Jul 15, 2002, 10:17 AM

Veteran (1104 posts)

Jul 15, 2002, 10:17 AM

Post #24 of 46

Shortcut

Re: [ellipsiiis] Gossamer Forum 1.1.7 Released In reply to

Yeah I followed that. You have the pointer working?

Guess I'll have to go back over it line by line. Fun! Wink

Jul 15, 2002, 11:02 AM

Veteran (1104 posts)

Jul 15, 2002, 11:02 AM

Post #25 of 46

Shortcut

Re: [ellipsiiis] Gossamer Forum 1.1.7 Released In reply to

I retored forum_view.html where I thought my problem was, back to baseline and still no joy.

New ideas?

Jul 15, 2002, 11:21 AM

User (225 posts)

Jul 15, 2002, 11:21 AM

Post #26 of 46

Shortcut

Re: [ArmyAirForces] Gossamer Forum 1.1.7 Released In reply to

Make sure the appropriate columns are in your table, that was what the problem was on my forum. It is working now.

Realiiity.com Forums

Jul 15, 2002, 11:56 AM

Veteran (1104 posts)

Jul 15, 2002, 11:56 AM

Post #27 of 46

Shortcut

Re: [ellipsiiis] Gossamer Forum 1.1.7 Released In reply to

I took forum_view.html back to the default code and did same for post_move_select.html.

The only modifications are in the header and footer includes.

Still no joy. Am at a loss to exlpain why.

Jul 15, 2002, 12:02 PM

Veteran (1104 posts)

Jul 15, 2002, 12:02 PM

Post #28 of 46

Shortcut

Re: [ellipsiiis] Gossamer Forum 1.1.7 Released In reply to

Are you referring the database table here?

Jul 15, 2002, 5:39 PM

User (225 posts)

Jul 15, 2002, 5:39 PM

Post #29 of 46

Shortcut

Re: [ArmyAirForces] Gossamer Forum 1.1.7 Released In reply to

Yes, the database table columns.

Realiiity.com Forums

Jul 16, 2002, 11:40 AM

Veteran (1104 posts)

Jul 16, 2002, 11:40 AM

Post #30 of 46

Shortcut

Re: [ellipsiiis] Gossamer Forum 1.1.7 Released In reply to

The new columns were all present, Jason chased this down as a bug:

http://www.gossamer-threads.com/...i?post=205973#205973

-Scott

Jul 19, 2002, 9:42 AM

agaffin

User (104 posts)

Jul 19, 2002, 9:42 AM

Post #31 of 46

Shortcut

This something to ask our DBA about or...? In reply to

1.16 worked fine with our Oracle database. When I either upgrade to 1.17 or just do a clean install of it, clicking on a forum results in:

Can't call method "fetchrow_hashref" on an undefined value at /export/home/httpd/cgi-bin/forum/admin/GForum/Forum.pm line 85.

Debugging shows:

GT::SQL::error = Failed to prepare query: '
SELECT *
FROM gforum_Post /*!32312 USE INDEX (p_rfl) */ LEFT OUTER JOIN gforum_User ON gforum_Post.user_id_fk = gforum_User.user_id
WHERE (gforum_Post.forum_id_fk = '2' AND gforum_Post.post_root_id = '0')
ORDER BY post_latest_reply ASC
' Reason: ORA-00933: SQL command not properly ended (DBD ERROR: OCIStmtExecute/Describe)

Jul 26, 2002, 12:26 PM

Staff / Moderator (2198 posts)

Jul 26, 2002, 12:26 PM

Post #32 of 46

Shortcut

Re: [agaffin] This something to ask our DBA about or...? In reply to

Hi,

Sorry for the delay. I've fixed this up and posted the bug fix in the Official Bug Fix forum, here:

http://www.gossamer-threads.com/...i?post=207669#207669

Jason Rhinelander
Gossamer Threads
jason@gossamer-threads.com

Apr 20, 2003, 6:06 AM

User (84 posts)

Apr 20, 2003, 6:06 AM

Post #33 of 46

Shortcut

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

Hi Jason,

I have been running 1.1.3 up until now on my site and I have just moved my website to a new server. Therefore I decided to upgrade my version.

I backed up my database and moved it to the new server. I then downloaded the latest version 1.1.8 and installed it using my old database.

The problem I have run into is that I wanted to make a small change to one of my forums and it came up with the following error.

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'

Would you have suggestions on a fix?

Thanks
Webmaster
http://www.e-bannerx.com

Last edited by:

fulcan: Apr 20, 2003, 6:08 AM

Apr 20, 2003, 6:15 AM

Paul

Veteran (19537 posts)

Apr 20, 2003, 6:15 AM

Post #34 of 46

Shortcut

Re: [fulcan] This something to ask our DBA about or...? In reply to

Did you run the installer using the "Upgrade" option?

Apr 20, 2003, 6:25 AM

User (84 posts)

Apr 20, 2003, 6:25 AM

Post #35 of 46

Shortcut

Re: [Paul] This something to ask our DBA about or...? In reply to

No, becuase as I was loading onto my new server I took the opportunity to use the new version straight out of the box.

I did not use my old templates, just made changes to the new ones that came with the install. Therefore the only thing transferred was the database.
Webmaster
http://www.e-bannerx.com

Apr 20, 2003, 7:03 AM

Paul

Veteran (19537 posts)

Apr 20, 2003, 7:03 AM

Post #36 of 46

Shortcut

Re: [fulcan] This something to ask our DBA about or...? In reply to

An upgrade would have been the way to go. You would have needed to transfer all your 1.1.3 files to the new server and then run the upgrade option. The number of column changes from 1.1.3 to 1.1.8 is probably significant and so it will no work with your old database.

Apr 20, 2003, 4:05 PM

Staff / Moderator (2198 posts)

Apr 20, 2003, 4:05 PM

Post #37 of 46

Shortcut

Re: [fulcan] This something to ask our DBA about or...? In reply to

Paul is right about this one - there are many added columns from 1.1.3 to 1.1.8, and the sole purpose of the upgrade script is to add these new columns and possibly tables to the database. If you want to fake the upgrade, you can manually edit GForum/Config/Data.pm, and search for 'version' - it should be 1.1.8; if you change it to 1.1.3, then run the install.cgi script again giving it your new 1.1.8 admin directory, it'll perform the database upgrades for you, and won't break anything.

Jason Rhinelander
Gossamer Threads
jason@gossamer-threads.com

Apr 20, 2003, 5:15 PM

User (84 posts)

Apr 20, 2003, 5:15 PM

Post #38 of 46

Shortcut

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

Hi Paul and Jason. Thanks for your help. I did as jason suggested and changed the ver number and did the upgrade install.

However, it looks like I am still having problems. Is there something else I have to do?

For example I was trying to update 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'

Do I need to manually add some changes to the tables in mysql?

Thanks
Webmaster
http://www.e-bannerx.com

Apr 20, 2003, 7:59 PM

Staff / Moderator (2198 posts)

Apr 20, 2003, 7:59 PM

Post #39 of 46

Shortcut

Re: [fulcan] This something to ask our DBA about or...? In reply to

Did you get any errors in the upgrade? user_show_user_icons should have been added in the 1.1.5->1.1.6 upgrades.

Jason Rhinelander
Gossamer Threads
jason@gossamer-threads.com

Apr 21, 2003, 12:08 AM

User (84 posts)

Apr 21, 2003, 12:08 AM

Post #40 of 46

Shortcut

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

Hi Jason,

No the upgrade install was perfect.
Webmaster
http://www.e-bannerx.com

Apr 21, 2003, 12:45 AM

Staff / Moderator (2198 posts)

Apr 21, 2003, 12:45 AM

Post #41 of 46

Shortcut

Re: [fulcan] This something to ask our DBA about or...? In reply to

Looks like something went wrong Unsure

Can you try doing the upgrade again?

Jason Rhinelander
Gossamer Threads
jason@gossamer-threads.com

Apr 22, 2003, 5:15 AM

User (84 posts)

Apr 22, 2003, 5:15 AM

Post #42 of 46

Shortcut

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:

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

Apr 22, 2003, 2:43 PM

Staff / Moderator (2198 posts)

Apr 22, 2003, 2:43 PM

Post #43 of 46

Shortcut

Re: [fulcan] This something to ask our DBA about or...? In reply to

Hi,

The problem seems to be here:

Adding column forum_move_pointer to Forum table...
Could not add column forum_move_pointer: Unable to add column 'forum_move_pointer' - already exists.

Can you check the database, and see if this column really does exist? (Given the error, I'd guess that it doesn't). You should be able to fix this up by clicking "Resync Database" (Admin -> Tools -> Table Editor -> Forum -> [bottom of the page]). Then you can rerun the import, which should fix the problem (you don't need to set the version back to 1.1.3 - just back to 1.1.6 will work fine).

Jason Rhinelander
Gossamer Threads
jason@gossamer-threads.com

Apr 23, 2003, 4:27 AM

User (84 posts)

Apr 23, 2003, 4:27 AM

Post #44 of 46

Shortcut

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:

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

Apr 23, 2003, 5:01 AM

Staff / Moderator (2198 posts)

Apr 23, 2003, 5:01 AM

Post #45 of 46

Shortcut

Re: [fulcan] This something to ask our DBA about or...? In reply to

Wow, strange problems happening there - it looks as though the database reported that it properly added the column, but didn't Crazy

. Yeah, resyncing the User table and running the import again seems like the best way to fix this. You might also want to resync the Post table, as there's a column that was added there too. These two resyncs, and jumping back to 1.1.5 ought to do it.

This is indeed a very strange problem. Pirate

Jason Rhinelander
Gossamer Threads
jason@gossamer-threads.com

Apr 23, 2003, 5:56 AM