#374 /blogs/rankings.php WSOD

[Jan Kucera]

[ - 2.0.0 - ] [ Wed Oct 03 11:39:10 2007 ]
-----------------------------------------------------------------------------------------------
#### USER AGENT: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.6) Gecko/20061201 Firefox/2.0.0.6 (Ubuntu-feisty)
#### ACCT: ID: 2 - Login: kozuch - e-mail:
#### URL: http://www.opensuper.com/blogs/rankings.php
#### REFERRER: http://www.google.com/search?q=kozuch82&hl=en&client=firefox-a&rls=com.ubuntu:en-US:official&hs=976&pwst=1&start=10&sa=N
#### HOST: www.opensuper.com
#### IP: 85.207.244.160
#### SQL: SELECT uue.`login` AS `modifier_user`, uue.`real_name` AS `modifier_real_name`, uue.`user_id` AS `modifier_user_id`, uuc.`login` AS `creator_user`, uuc.`real_name` AS `creator_real_name`, uuc.`user_id` AS `creator_user_id`, lch.`hits`, lch.`last_hit`, lc.`event_time`, lc.`title`, lc.`last_modified`, lc.`content_type_guid`, lc.`ip`, lc.`created`, lc.`content_id` ,gks.`security_id`, gks.`security_description`, gks.`is_private`, gks.`is_hidden`, gks.`access_question`, gks.`access_answer` FROM `liberty_content` lc INNER JOIN `users_users` uuc ON (lc.`modifier_user_id`=uuc.`user_id`) INNER JOIN `users_users` uue ON (lc.`modifier_user_id`=uue.`user_id`) LEFT OUTER JOIN `liberty_content_hits` lch ON( lc.`content_id` = lch.`content_id`) LEFT OUTER JOIN `gatekeeper_security_map` cg ON (lc.`content_id`=cg.`content_id`) LEFT OUTER JOIN `gatekeeper_security` gks ON (gks.`security_id`=cg.`security_id` ) WHERE `content_type_guid`='bitblogpost' ORDER BY lc.lch.`hits` DESC LIMIT 0,10
#### ERROR CODE: Errno: 1109 Message: Unknown table 'lc.lch' in order clause

}}}}}}}} -> bit_error_string(Array[6])
}}}}}}}} LINE: 638, /home/kozuch82/public_html/opensuper/kernel/BitDbAdodb.php
}}}}}}} -> bit_error_handler(mysql, EXECUTE, 1109, Unknown table 'lc.lch' in order clause, SELECT
uue.`login` AS `modifier_user`,
uue.`real_name` A..., false, Object:adodb_mysql)
}}}}}}} LINE: 916, /home/kozuch82/public_html/opensuper/util/adodb/adodb.inc.php
}}}}}} -> adodb_mysql::_execute(SELECT
uue.`login` AS `modifier_user`,
uue.`real_name` A...)
}}}}}} LINE: 872, /home/kozuch82/public_html/opensuper/util/adodb/adodb.inc.php
}}}}} -> adodb_mysql::adodb_mysql::execute(SELECT
uue.`login` AS `modifier_user`,
uue.`real_name` A..., Array[1])
}}}}} LINE: 490, /home/kozuch82/public_html/opensuper/util/adodb/drivers/adodb-mysql.inc.php
}}}} -> adodb_mysql::adodb_mysql::adodb_mysql::selectlimit(SELECT
uue.`login` AS `modifier_user`,
uue.`real_name` A..., 10, 0, Array[1])
}}}} LINE: 253, /home/kozuch82/public_html/opensuper/kernel/BitDbAdodb.php
}}} -> adodb_mysql::adodb_mysql::adodb_mysql::bitdbadodb::query(
SELECT
uue.`login` AS `modifier_user`,
uue.`real_nam..., Array[1], 10, 0)
}}} LINE: 1922, /home/kozuch82/public_html/opensuper/liberty/LibertyContent.php
}} -> adodb_mysql::adodb_mysql::adodb_mysql::bitdbadodb::libertycontent::getcontentlist(Array[6])
}} LINE: 1702, /home/kozuch82/public_html/opensuper/liberty/LibertyContent.php
} -> adodb_mysql::adodb_mysql::adodb_mysql::bitdbadodb::libertycontent::libertycontent::getcontentranking(Array[5])
} LINE: 69, /home/kozuch82/public_html/opensuper/blogs/rankings.php

$_COOKIE:
array (
'bit-user-opensupercom' => '6743a4833cecdde6aabd2ffc14b3abf0',

[wjames5]

Logged In: YES
user_id=1358218
Originator: NO

rankings are old and crusty and either need love or death. they came from tiki.

[Nick Palmer]

Logged In: YES
user_id=1281813
Originator: NO

This was fixed by spider. It was a bad order by.