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
Subject Author Views Date
Thread [GForum 1.1.4] - Fatal error after detaching Jagerman 4069 Apr 28, 2002, 4:16 PM
Thread Re: [Jagerman] [GForum 1.1.4] - Fatal error after detaching
webmaster33 4011 Apr 28, 2002, 4:50 PM
Post Re: [webmaster33] [GForum 1.1.4] - Fatal error after detaching
Jagerman 3976 Apr 28, 2002, 4:53 PM