Gossamer Forum
Home : Products : Gossamer Forum : Discussion :

Re: [Jagerman] Gossamer Forum 1.1.7 Released

Quote Reply
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
Subject Author Views Date
Thread Gossamer Forum 1.1.7 Released Jagerman 10867 Jul 11, 2002, 3:00 PM
Thread Moving trails aren't working
ellipsiiis 10264 Jul 11, 2002, 4:34 PM
Post Re: [ellipsiiis] Moving trails aren't working
Jagerman 10147 Jul 11, 2002, 4:37 PM
Thread Re: [ellipsiiis] Moving trails aren't working
Jagerman 10210 Jul 11, 2002, 4:39 PM
Post Re: [Jagerman] Moving trails aren't working
ellipsiiis 10132 Jul 11, 2002, 4:42 PM
Thread Re: [Jagerman] Gossamer Forum 1.1.7 Released
ArmyAirForces 10279 Jul 11, 2002, 4:41 PM
Post Re: [ArmyAirForces] Gossamer Forum 1.1.7 Released
backdream 10048 Jul 12, 2002, 12:54 AM
Thread Re: [Jagerman] Gossamer Forum 1.1.7 Released
yogi 10238 Jul 12, 2002, 12:56 AM
Thread Re: [yogi] Gossamer Forum 1.1.7 Released
Jagerman 10419 Jul 12, 2002, 9:49 AM
Post Re: [Jagerman] Gossamer Forum 1.1.7 Released
yogi 9959 Jul 12, 2002, 10:38 PM
Post Re: [Jagerman] Gossamer Forum 1.1.7 Released
yogi 10100 Jul 12, 2002, 3:31 AM
Thread Post deleted by ArmyAirForces
ArmyAirForces 10119 Jul 12, 2002, 6:48 AM
Post Post deleted by ArmyAirForces
ArmyAirForces 10080 Jul 12, 2002, 6:49 AM
Thread Re: [Jagerman] Gossamer Forum 1.1.7 Released
ArmyAirForces 10122 Jul 12, 2002, 10:13 AM
Thread Re: [ArmyAirForces] Gossamer Forum 1.1.7 Released
Jagerman 10134 Jul 12, 2002, 11:20 AM
Thread Re: [Jagerman] Gossamer Forum 1.1.7 Released
yogi 10023 Jul 13, 2002, 6:52 AM
Post Re: [yogi] Gossamer Forum 1.1.7 Released
Jagerman 10015 Jul 14, 2002, 12:11 PM
Thread Re: [Jagerman] Gossamer Forum 1.1.7 Released
ArmyAirForces 10306 Jul 12, 2002, 10:29 AM
Thread Re: [ArmyAirForces] Gossamer Forum 1.1.7 Released
Jagerman 10229 Jul 12, 2002, 10:32 AM
Post Re: [Jagerman] Gossamer Forum 1.1.7 Released
ArmyAirForces 10049 Jul 12, 2002, 11:02 AM
Thread Re: [Jagerman] Gossamer Forum 1.1.7 Released
ArmyAirForces 10212 Jul 13, 2002, 6:13 AM
Thread Re: [ArmyAirForces] Gossamer Forum 1.1.7 Released
ArmyAirForces 10058 Jul 15, 2002, 10:08 AM
Thread Re: [ArmyAirForces] Gossamer Forum 1.1.7 Released
ellipsiiis 10181 Jul 15, 2002, 10:11 AM
Post Re: [ellipsiiis] Gossamer Forum 1.1.7 Released
ArmyAirForces 9990 Jul 15, 2002, 10:17 AM
Thread Re: [ellipsiiis] Gossamer Forum 1.1.7 Released
ArmyAirForces 10004 Jul 15, 2002, 11:02 AM
Thread Re: [ArmyAirForces] Gossamer Forum 1.1.7 Released
ellipsiiis 6906 Jul 15, 2002, 11:21 AM
Post Re: [ellipsiiis] Gossamer Forum 1.1.7 Released
ArmyAirForces 6851 Jul 15, 2002, 11:56 AM
Thread Re: [ellipsiiis] Gossamer Forum 1.1.7 Released
ArmyAirForces 6933 Jul 15, 2002, 12:02 PM
Thread Re: [ArmyAirForces] Gossamer Forum 1.1.7 Released
ellipsiiis 6972 Jul 15, 2002, 5:39 PM
Post Re: [ellipsiiis] Gossamer Forum 1.1.7 Released
ArmyAirForces 6866 Jul 16, 2002, 11:40 AM
Thread This something to ask our DBA about or...?
agaffin 6835 Jul 19, 2002, 9:42 AM
Thread Re: [agaffin] This something to ask our DBA about or...?
Jagerman 6831 Jul 26, 2002, 12:26 PM
Thread Re: [Jagerman] This something to ask our DBA about or...?
fulcan 6704 Apr 20, 2003, 6:06 AM
Thread Re: [fulcan] This something to ask our DBA about or...?
Paul 6720 Apr 20, 2003, 6:15 AM
Thread Re: [Paul] This something to ask our DBA about or...?
fulcan 6775 Apr 20, 2003, 6:25 AM
Post Re: [fulcan] This something to ask our DBA about or...?
Paul 6777 Apr 20, 2003, 7:03 AM
Thread Re: [fulcan] This something to ask our DBA about or...?
Jagerman 6749 Apr 20, 2003, 4:05 PM
Thread Re: [Jagerman] This something to ask our DBA about or...?
fulcan 6772 Apr 20, 2003, 5:15 PM
Thread Re: [fulcan] This something to ask our DBA about or...?
Jagerman 6885 Apr 20, 2003, 7:59 PM
Thread Re: [Jagerman] This something to ask our DBA about or...?
fulcan 6763 Apr 21, 2003, 12:08 AM
Thread Re: [fulcan] This something to ask our DBA about or...?
Jagerman 6776 Apr 21, 2003, 12:45 AM
Thread Re: [Jagerman] This something to ask our DBA about or...?
fulcan 6701 Apr 22, 2003, 5:15 AM
Thread Re: [fulcan] This something to ask our DBA about or...?
Jagerman 6668 Apr 22, 2003, 2:43 PM
Thread Re: [Jagerman] This something to ask our DBA about or...?
fulcan 6857 Apr 23, 2003, 4:27 AM
Thread Re: [fulcan] This something to ask our DBA about or...?
Jagerman 6755 Apr 23, 2003, 5:01 AM
Post Re: [Jagerman] This something to ask our DBA about or...?
fulcan 6621 Apr 23, 2003, 5:56 AM