SQL Ошибка

Posted 29 октября, 201212 yr

Заметил что появилась ошибка на форуме:


Date: Mon, 29 Oct 2012 10:11:00 +0000 Error: 1054 - Unknown column 'ranking' in 'order clause' IP Address: 66.249.76.199 - /index.php?app=core&module=search&do=search&andor_type=&sid=63cf596e75e417b98511420952595432&search_app_filters%5Bforums%5D%5BsortKey%5D=date&search_tags=%D0%B2%D1%8B%D0%B6%D0%B8%D0%B2%D0%B0%D0%BD%D0%B8%D0%B5&search_app_filters%5Bforums%5D%5BsortKey%5D=date&search_app_filters%5Bforums%5D%5BsearchInKey%5D=&search_term=&search_app=ccs ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- mySQL query error: SELECT r.*,xxx.* FROM kai_ccs_custom_database_1 r LEFT JOIN kai_ccs_database_categories cat ON ( r.category_id=cat.category_id ) LEFT JOIN kai_permission_index p ON ( p.app='ccs' AND p.perm_type='categories' AND p.perm_type_id=cat.category_id ) LEFT JOIN kai_core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('ccs',';','records-1',';',r.primary_id_field)) ) WHERE r.category_id IN(1,4,5,2,3,6,7,8) AND (cat.category_has_perms=0 OR p.perm_view REGEXP ',2,|\\*') AND r.record_approved=1 AND r.primary_id_field=0 ORDER BY ranking desc LIMIT 0,25 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------. | File | Function | Line No. | |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------| | admin/applications_addon/ips/ccs/extensions/search/engines/sql.php | [search_engine_ccs]._searchDatabase | 131 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/sources/classes/search/controller.php | [search_engine_ccs].search | 542 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/applications/core/modules_public/search/search.php | [IPSSearch].search | 654 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/applications/core/modules_public/search/search.php | [public_core_search_search].searchResults | 169 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/sources/base/ipsController.php | [public_core_search_search].doExecute | 306 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

С чем может быть связанно?

Цитата