Помогите исправить, постоянно слетают права у пользователей и модераторов, помоему с этой ошибкой связано и то что все группы кроме гостей не могут прокомментировать новости в IP.Connect, хотя гости могут.
Вот лог ошибок
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Mon, 02 Feb 2015 21:27:49 +0000
Error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY p.company_add_date desc LIMIT 0,5' at line 7
IP Address: хх.хх.ххх.хх - /
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT p.*,m.*, m.member_id as mid,pp.*,pf.*,s.*,country.*,state.*,city.* FROM sd_cd_companies p LEFT JOIN members m ON ( m.member_id=p.member_id )
LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id )
LEFT JOIN pfields_content pf ON ( pf.member_id=m.member_id )
LEFT JOIN sessions s ON ( s.member_id=m.member_id AND s.running_time > 1422908869 )
LEFT JOIN sd_cd_country country ON ( country.country_id=p.country_id )
LEFT JOIN sd_cd_states state ON ( state.state_id=p.state_id )
LEFT JOIN sd_cd_cities city ON ( city.city_id=p.city_id ) WHERE p.company_approved=1 AND p.category_id IN ( ) ORDER BY p.company_add_date desc LIMIT 0,5
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File | Function | Line No. |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/applications_addon/ips/ccs/sources/blocks/feed/admin.php | [feed_companydirectory].executeFeed | 523 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications_addon/ips/ccs/sources/blocks/adminInterface.php | [adminBlockHelper_feed].recacheBlock | 185 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications_addon/ips/ccs/sources/pages.php | [adminBlockHelper].getBlockContent | 551 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications_addon/ips/ccs/sources/pages.php | [pageBuilder].getBlock | 336 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications_addon/ips/ccs/modules_public/pages/pages.php | [pageBuilder].recachePage | 843 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications_addon/ips/ccs/modules_public/pages/pages.php | [public_ccs_pages_pages]._getPageContent | 540 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications_addon/ips/ccs/modules_public/pages/pages.php | [public_ccs_pages_pages]._view | 120 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php | [public_ccs_pages_pages].doExecute | 306 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'