Orca Error

[BodyMen]

Hi,

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/bodymen/public_html/date/orca/classes/BxDb.php on line 199


I got this error when i'm Aministrator Panel - Manage Orca.


Need help please.

[Smoge]

BodyMen's error was in the Orca included in 5.6.2, using MYSQL 5.0.27

We got rid of this error by disable of mysql_pconnect()

But - another error popped up...

QUERY: SELECT DATE_FORMAT(FROM_UNIXTIME(tp.`when`),'%H:%i') AS `when`, tp.`when` AS `ts`, `user`, `post_id`, LEFT(`post_text`, 128) AS `post_text`, tt.`topic_id`, `topic_title`, tf.`forum_id`, `forum_title`, tc.`cat_id`, `cat_name` FROM `pre_forum_post` AS tp INNER JOIN `pre_forum_topic` AS tt USING(`topic_id`) INNER JOIN `pre_forum` AS tf USING(`forum_id`) INNER JOIN `pre_forum_cat` AS tc USING(`cat_id`) WHERE 1 ORDER BY tp.`when` DESC LIMIT 10
SQL ERROR: Column 'forum_id' in from clause is ambiguous
RESULT #
MYSQL VERSION:5.0.27-standard

see: http://bugs.mysql.com/bug.php?id=21576
see: http://bugs.mysql.com/bug.php?id=25575

Noted in 5.0.36, 5.1.16 changelogs.

An error in the name resolution of nested JOIN ... USING constructs
was corrected.

You are running MYSQL 5.0.27 - suggest upgrading to something higher than 5.0.36

Smoge

edited: said PHP when I wanted to say MySQL

[kvik]

Maybe your problem can be this

http://www.expertzzz.com/Wiki/home/309/

Niels

[Smoge]

Here is a similar post on ModMySite which may be more helpful:

Help with orca?

Smoge