Gossamer Forum
Home : Products : Gossamer Forum : Discussion :

Just upgraded from 1.1.5 to 1.1.8 - NEW

Quote Reply
Just upgraded from 1.1.5 to 1.1.8 - NEW
Smile

Just upgraded from 1.1.5 to 1.1.8 - NEW Quote | Reply
I get this when trying to enter a forum from the category list:

Quote:
A fatal error has occurred:

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

Please enable debugging in setup for more details.

The upgrade seemed to go ok, but when I click a forum from http://example.com/...bin/forum/gforum.cgi I get the above. Any ideas? I restored all the templates in case that had anything to do with it, but still no luck.

Moved on behalf of Jason

Quote Reply
Re: [It Sasquatch] Just upgraded from 1.1.5 to 1.1.8 - NEW In reply to
Can you enable debugging, and look for the "$GT::SQL::error" message?

Jason Rhinelander
Gossamer Threads
jason@gossamer-threads.com
Quote Reply
Re: [Jagerman] Just upgraded from 1.1.5 to 1.1.8 - NEW In reply to
I get this:

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 = '3')
ORDER BY post_latest_reply ASC LIMIT 0, 25
' Reason: Key column 'p_rfl' doesn't exist in table

Jason
Quote Reply
Re: [wickedmoon] Just upgraded from 1.1.5 to 1.1.8 - NEW In reply to
Anything on this? I'm still waiting to get my forum back up and running after the upgrade.

Jason
Quote Reply
Re: [wickedmoon] Just upgraded from 1.1.5 to 1.1.8 - NEW In reply to
Hi,

I've seen the problem before, and it is most often the result of errors during the upgrade process. In any event, I recommend you go into the SQL Monitor and type this query:

create index p_rfl on gforum_Post (post_root_id, forum_id_fk, post_latest_reply);

It seems that some upgrades, for some unknown reason, don't properly add the p_rfl index.

Jason Rhinelander
Gossamer Threads
jason@gossamer-threads.com
Quote Reply
Re: [Jagerman] Just upgraded from 1.1.5 to 1.1.8 - NEW In reply to
That seems to have done it, thanks for the tip. The output said "Rows affected: 62671". Are there any downsides to this method, or will that have fixed it completely now?

Jason
Quote Reply
Re: [wickedmoon] Just upgraded from 1.1.5 to 1.1.8 - NEW In reply to
That will have fixed it - the query just makes the database how it should have been already.

Jason Rhinelander
Gossamer Threads
jason@gossamer-threads.com