#582 Unknown column 'sts.rating' in 'order clause'

CVS
open
nobody
Wiki (64)
5
2010-12-15
2010-12-15
harimix
No

BW 2.8.1 release. /stars/ from distro used as rating package.

Browse Orphan Pages in WIKI, click on column Rating to sort by rating.
--> Internal Server Error (500)
+ Email to admin:

[ - 2.8.0 - ] [ Wed Dec 15 01:35:29 2010 ]
-----------------------------------------------------------------------------------------------
#### USER AGENT: Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)
#### ACCT: ID: -1 - Login: guest - e-mail: guest@localhost
#### URL: http://www.harim.at/wiki/orphan_pages.php?sort_mode=sts.rating_asc&list_page=1
#### HOST: www.harim.at
#### IP: 66.249.71.215
#### SQL: SELECT uue.`login` AS modifier_user, uue.`real_name` AS modifier_real_name, uuc.`login` AS creator_user, uuc.`real_name` AS creator_real_name, wp.`page_id`, wp.`wiki_page_size` AS `len`,lcds.`data` AS `summary`, wp.`edit_comment`, wp.`content_id`, wp.`flag`, lc.`title`, lc.`format_guid`, lc.`last_modified`, lc.`created`, lc.`ip`, lc.`version`, lch.`hits` ,gks.`security_id`, gks.`security_description`, gks.`is_private`, gks.`is_hidden`, gks.`access_question`, gks.`access_answer` FROM `wiki_pages` wp INNER JOIN `liberty_content` lc ON (lc.`content_id` = wp.`content_id`) INNER JOIN `users_users` uuc ON ( uuc.`user_id` = lc.`user_id` ) INNER JOIN `users_users` uue ON ( uue.`user_id` = lc.`user_id` ) LEFT OUTER JOIN `liberty_content_links` lcl ON (wp.`content_id` = lcl.`to_content_id`) LEFT OUTER JOIN `liberty_content_hits` lch ON (lc.`content_id` = lch.`content_id`) LEFT OUTER JOIN `liberty_content_data` lcds O
N (lc.`content_id` = lcds.`content_id` AND lcds.`data_type`='summary') 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 lc.`content_type_guid`='bitpage' AND lcl.`to_content_id` is NULL AND (cg.`security_id` IS NULL OR lc.`user_id`='-1') ORDER BY sts.`rating` ASC LIMIT 0,20
#### ERROR CODE: Errno: 1054 Message: Unknown column 'sts.rating' in 'order clause'

}}}}}}}} LINE: 667, /var/www/virtual/harim.at/htdocs/cms/kernel/BitDbAdodb.php
}}}}}}}} -> bit_error_string(Array[6])
}}}}}}} LINE: 231, /var/www/virtual/harim.at/htdocs/cms/util/adodb/adodb.inc.php
}}}}}}} -> bit_error_handler(mysql, bit_error_handler, 1054, Unknown column 'sts.rating' in 'order clause', SELECT
uue.`login` AS modifier_user, uue.`real_name` AS mo..., false, Object:ADODB_mysql)
}}}}}} LINE: 1035, /var/www/virtual/harim.at/htdocs/cms/util/adodb/adodb.inc.php
}}}}}} -> ADODB_TransMonitor(mysql, EXECUTE, 1054, Unknown column 'sts.rating' in 'order clause', SELECT
uue.`login` AS modifier_user, uue.`real_name` AS mo..., false, Object:ADODB_mysql)
}}}}} LINE: 991, /var/www/virtual/harim.at/htdocs/cms/util/adodb/adodb.inc.php
}}}}} -> ADOConnection::_Execute(SELECT
uue.`login` AS modifier_user, uue.`real_name` AS mo...)
}}}} LINE: 498, /var/www/virtual/harim.at/htdocs/cms/util/adodb/drivers/adodb-mysql.inc.php
}}}} -> ADOConnection::ADOConnection::Execute(SELECT
uue.`login` AS modifier_user, uue.`real_name` AS mo..., Array[2])
}}} LINE: 263, /var/www/virtual/harim.at/htdocs/cms/kernel/BitDbAdodb.php
}}} -> ADOConnection::ADOConnection::ADODB_mysql::SelectLimit(SELECT
uue.`login` AS modifier_user, uue.`real_name` AS mo..., 20, 0, Array[2])
}} LINE: 672, /var/www/virtual/harim.at/htdocs/cms/wiki/BitPage.php
}} -> ADOConnection::ADOConnection::ADODB_mysql::BitDbAdodb::query(SELECT
uue.`login` AS modifier_user, uue.`real_name` AS mo..., Array[2], 20, 0)
} LINE: 77, /var/www/virtual/harim.at/htdocs/cms/wiki/orphan_pages.php
} -> ADOConnection::ADOConnection::ADODB_mysql::BitDbAdodb::BitPage::getList(Array[15])

$_GET:
array (
'sort_mode' => 'sts.rating_asc',
'list_page' => '1',
)

Discussion

  • harimix
    harimix
    2010-12-15

    • summary: Unknown coumn 'sts.rating' in 'order clause' --> Unknown column 'sts.rating' in 'order clause'