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

Can you enable debugging, and look for the "$GT::SQL::error" message?

---

Jason Rhinelander
Gossamer Threads
jason@gossamer-threads.com

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

Anything on this? I'm still waiting to get my forum back up and running after the upgrade.

Jason

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

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

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