Posted 29 октября, 201212 yr comment_13096 Заметил что появилась ошибка на форуме: 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 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' С чем может быть связанно? Link to comment https://ipbmafia.ru/topic/2038-sql-oshibka/ Share on other sites Больше вариантов
29 октября, 201212 yr comment_13108 С приложением CCS. Link to comment https://ipbmafia.ru/topic/2038-sql-oshibka/?&do=findComment&comment=13108 Share on other sites Больше вариантов
29 октября, 201212 yr Author comment_13117 _Dark_, А поподробнее можно, а что-то не догоняю. Link to comment https://ipbmafia.ru/topic/2038-sql-oshibka/?&do=findComment&comment=13117 Share on other sites Больше вариантов
29 октября, 201212 yr comment_13159 wensont, IP.Content последней версии стоит? Link to comment https://ipbmafia.ru/topic/2038-sql-oshibka/?&do=findComment&comment=13159 Share on other sites Больше вариантов
30 октября, 201212 yr Author comment_13171 2.3.3 Link to comment https://ipbmafia.ru/topic/2038-sql-oshibka/?&do=findComment&comment=13171 Share on other sites Больше вариантов
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.