Posted 8 февраля, 20159 yr comment_80304 Помогите исправить, постоянно слетают права у пользователей и модераторов, помоему с этой ошибкой связано и то что все группы кроме гостей не могут прокомментировать новости в 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 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' Link to comment https://ipbmafia.ru/topic/10475-sletayut-prava-u-polzovatelej-i-moderatorov/ 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.