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