Gossamer Forum
Home : Products : Gossamer Forum : Discussion :

fetchrow_hashref

Quote Reply
fetchrow_hashref
Hi,

My forums were working well since a couple of years.

Suddently, last week, I started getting an error message , only in 3 (of the 5) forums in one (of 3) categories.

The message is:


Quote:
A fatal error has occurred:

Can't call method "fetchrow_hashref" on an undefined value at /home/infopsy/infopsy-www/cgi-bin/admin/GT/SQL/Tree.pm line 606.

Please enable debugging in setup for more details.

After consulting other questions about this problem, I note that the debugging message indicates:

Quote:
GT::SQL::error = Failed to execute query: '
SELECT infopsy_Post.post_id, infopsy_Post.post_time, infopsy_Post.user_id_fk, infopsy_Post.post_root_id, infopsy_Post.post_depth, infopsy_Post.post_father_id, infopsy_Post_tree.tree_anc_id_fk
FROM infopsy_Post, infopsy_Post_tree
WHERE infopsy_Post_tree.tree_id_fk = infopsy_Post.post_id AND (infopsy_Post_tree.tree_anc_id_fk IN (1143,1096,1098,1103,1107,1130,1131,1133,1136,1137,1139,1019,1023,1030,1034,1036,1038,938,941,167,173,176,926,763,773,793,795,806,920,824,829,831,833,834,835,843,844,759,737,738,741,740,747,748,749,755,345,346,444,455,611,690,369,559,560,561,572,400,564,360,362,555,490,435,454,436,437,443,447,401,230,174,177,162,163,164,149,150,152,20,44,46))

' Reason: Can't open file: 'infopsy_Post_tree.MYD'. (errno: 145)

Also, a couple of members complained that many messages are lors when they try to post them on the forum. (This problem seem to have appeared at the same time.)


What is wrong ? What should I do ?

Can someone help me fix this ?

(My version is 1.1.5)

Thanks
Jean Garneau
webmaster : redpsy.com, infopsy.com. provirtuel.com
Quote Reply
Re: [redpsyboss] fetchrow_hashref In reply to
It looks like you lost (or the access permissions to the file are incorrect) your MySQL table file: infopsy_Post_tree.MYD.

You should make sure all your tables have correct permissions on them, and also probably do a myiasmchk on them to make sure they aren't corrupt.

Adrian
Quote Reply
Re: [brewt] fetchrow_hashref In reply to
Adrian, many thanks for your reply.

I looked for the properties of infopsy_Post_tree with MySQLMAN and I got this reply:

Quote:

MySQL said: Can't open file: 'infopsy_Post_tree.MYD'. (errno: 145).

Query: describe infopsy_Post_tree

From this, I suspect that your idea is correct, but I can't figure what I should do.

What would the correct permissoins be ? How do I do a "myiasmchk" ? How can this happen to a perfectly working forum ? Is there an unidentified problem I should know about?

I'm really not advanced in this area. I need beginner-friendly advice. Can you help ?

Thanks
Jean Garneau
webmaster : redpsy.com, infopsy.com. provirtuel.com
Quote Reply
Re: [redpsyboss] fetchrow_hashref In reply to
You're going to have to talk to your system administrator about this.

Adrian
Quote Reply
Re: [redpsyboss] fetchrow_hashref In reply to
Hi Jean,

Depending on the version of MySQL installed, you might be able to attempt a table repair by running the following query in the SQL Monitor (Admin panel -> Tools -> SQL Monitor):

REPAIR TABLE infopsy_Post_tree

Depending on the size of your forum, that may take a while.

According to 'perror', 145 is:
Code:
$ perror 145
Error code 145: Unknown error 145
145 = Table was marked as crashed and should be repaired

Jason Rhinelander
Gossamer Threads
jason@gossamer-threads.com
Quote Reply
Re: [Jagerman] fetchrow_hashref In reply to
Thank you very much, Jason.

This worked perfectly. My forums are working normally again.

I would like to be able to do the same for someone else. But I am not competent enough. At least, the members of my forums will be able to communicate again, thanks to you. I told them you provided the solution.

Thanks again.
Jean Garneau
webmaster : redpsy.com, infopsy.com. provirtuel.com

Last edited by:

redpsyboss: Apr 14, 2004, 8:49 PM