Gossamer Forum
Home : Products : Gossamer Forum : Discussion :

Problem with stats

Quote Reply
Problem with stats
When I click on Stats under Tools, I get back:

Can't call method "fetchall_hashref" on an undefined value at GForum::Stats::threads_top_replies line 293.

Would this be because we're using Oracle instead of MySQL?
Quote Reply
Re: [agaffin] Problem with stats In reply to
Hi,

Possibly. =) Can you turn on debug and see what GT::SQL::error says? Also, if you are not using 1.1.8, it's recommended that you upgrade as it improves Oracle support.

Cheers,

Alex
--
Gossamer Threads Inc.
Quote Reply
Re: [Alex] Problem with stats In reply to
Here goes (yep, we're using 1.18 - our production server didn't like 1.17):

GT::SQL::error = Failed to prepare query: '
SELECT *
FROM gforum_Post LEFT OUTER JOIN gforum_User ON gforum_Post.user_id_fk = gforum_User.user_id

ORDER BY post_replies DESC ' Reason: ORA-00933: SQL command not properly ended (DBD ERROR: OCIStmtExecute/Describe)