Gossamer Forum
Home : Gossamer Threads Inc. : Official Bug Fixes :

[GForum 1.1.4] - Fatal error after detaching

Quote Reply
[GForum 1.1.4] - Fatal error after detaching
Sometimes when detaching a post, the post_depth would be set to a negative value. This causes display problems and may sometimes result in a fatal error. This does not, however, affect MySQL, but does affect MS SQL, postgres, and Oracle installations.

The attached file should replace admin/GT/SQL/Tree.pm and fixes the problem. All users using the above-mentioned databases should replace this file as soon as possible to prevent display problems and/or fatal errors. Note that this file requires Gossamer Forum 1.1.4 and will not work with earlier versions of Gossamer Forum.

The following query will fix any broken threads that already exist due to this bug. It is easiest to enter this query in the SQL Monitor (Admin panel -> Tools -> SQL Monitor), although you may need to change the "gforum_" prefix if you installed with a different prefix.

Code:


UPDATE gforum_Post SET post_depth = 0 WHERE post_depth < 0


After running the query, you'll get output something like:

Rows affected: 3

This is the number of threads that had the problem and have been fixed. After replacing the GT/SQL/Tree.pm file and run the above query, you shouldn't see this problem again.

Jason Rhinelander
Gossamer Threads
jason@gossamer-threads.com

Last edited by:

Jagerman: Apr 28, 2002, 4:16 PM
Quote Reply
Re: [Jagerman] [GForum 1.1.4] - Fatal error after detaching In reply to
This means there will be a v1.1.5 version released soon?

Best regards,
Webmaster33


Paid Support
from Webmaster33. Expert in Perl programming & Gossamer Threads applications. (click here for prices)
Webmaster33's products (upd.2004.09.26) | Private message | Contact me | Was my post helpful? Donate my help...
Quote Reply
Re: [webmaster33] [GForum 1.1.4] - Fatal error after detaching In reply to
This isn't serious enough to warrant a new release - more likely we'll update the 1.1.4 package with this and a few other minor fixes we've found in a few days.

Jason Rhinelander
Gossamer Threads
jason@gossamer-threads.com