2
Maybe this could help in helping me ;)
When I enter 'Admin index' as admin then queries looks like:
SET NAMES 'utf8'
SELECT * FROM xaa2_config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
SELECT sess_data, sess_ip FROM xaa2_session WHERE sess_id = 'bd4af262d1daa6f5ab56ded6b312a3f3'
SELECT * FROM xaa2_users WHERE uid = '1'
DELETE FROM xaa2_protector_access WHERE expire < UNIX_TIMESTAMP()
SELECT COUNT(*) FROM xaa2_protector_access WHERE ip='83.20.40.84' AND request_uri='/modules/wfchannel/admin/index.php'
SELECT COUNT(*) FROM xaa2_protector_access WHERE ip='83.20.40.84'
INSERT INTO xaa2_protector_access SET ip='83.20.40.84',request_uri='/modules/wfchannel/admin/index.php',expire=UNIX_TIMESTAMP()+'60'
SELECT * FROM xaa2_modules WHERE dirname = 'wfchannel'
SELECT * FROM xaa2_config WHERE (conf_modid = '8') ORDER BY conf_order ASC
SELECT * FROM xaa2_modules WHERE dirname = 'wfresource'
SELECT * FROM xaa2_wfcpages
SELECT * FROM xaa2_wfcpages ORDER BY wfc_cid DESC LIMIT 0, 10
SELECT * FROM xaa2_group_permission WHERE (gperm_name = 'module_admin' AND gperm_modid = '1' AND (gperm_groupid = '1' OR gperm_groupid = '2'))
SELECT * FROM xaa2_modules WHERE (hasadmin = '1' AND isactive = '1') ORDER BY weight ASC, mid ASC
SELECT * FROM xaa2_modules WHERE dirname = 'news'
SELECT * FROM xaa2_config WHERE (conf_modid = '13') ORDER BY conf_order ASC
SELECT * FROM xaa2_wfcrefers
And when I do the same as that editor I get:
SET NAMES 'utf8'
SELECT * FROM xaa2_config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
SELECT sess_data, sess_ip FROM xaa2_session WHERE sess_id = '6b48e35c932e7660fd20a3e1f0dd9cb1'
SELECT * FROM xaa2_users WHERE uid = '2'
SELECT COUNT(*) FROM xaa2_group_permission WHERE (gperm_modid = '1' AND gperm_name = 'module_admin' AND gperm_itemid = '1' AND (gperm_groupid = '4'))
SELECT COUNT(*) FROM xaa2_group_permission WHERE (gperm_modid = '1' AND gperm_name = 'module_admin' AND gperm_itemid = '1' AND (gperm_groupid = '4'))
DELETE FROM xaa2_protector_access WHERE expire < UNIX_TIMESTAMP()
SELECT COUNT(*) FROM xaa2_protector_access WHERE ip='83.20.40.84' AND request_uri='/modules/wfchannel/admin/index.php'
SELECT COUNT(*) FROM xaa2_protector_access WHERE ip='83.20.40.84'
INSERT INTO xaa2_protector_access SET ip='83.20.40.84',request_uri='/modules/wfchannel/admin/index.php',expire=UNIX_TIMESTAMP()+'60'
SELECT * FROM xaa2_modules WHERE dirname = 'wfchannel'
SELECT COUNT(*) FROM xaa2_group_permission WHERE (gperm_modid = '1' AND gperm_name = 'module_admin' AND gperm_itemid = '8' AND (gperm_groupid = '4'))
SELECT * FROM xaa2_config WHERE (conf_modid = '8') ORDER BY conf_order ASC
SELECT * FROM xaa2_modules WHERE dirname = 'wfresource'
SELECT * FROM xaa2_wfcpages c LEFT JOIN xaa2_group_permission l ON l.gperm_itemid = c.wfc_cid WHERE ( l.gperm_name = 'wfc_page' AND l.gperm_groupid IN ( 4 ) ) AND
Error number: 1064
Error message: 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 '' at line 1
SELECT DISTINCT c.* FROM xaa2_wfcpages c LEFT JOIN xaa2_group_permission l ON l.gperm_itemid = c.wfc_cid WHERE ( l.gperm_name = 'wfc_page' AND l.gperm_groupid IN ( 4 ) ) AND ORDER BY wfc_cid DESC LIMIT 0, 10
Error number: 1064
Error message: 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 wfc_cid DESC LIMIT 0, 10' at line 1
SELECT * FROM xaa2_group_permission WHERE (gperm_name = 'module_admin' AND gperm_modid = '1' AND (gperm_groupid = '4'))
SELECT * FROM xaa2_modules WHERE (hasadmin = '1' AND isactive = '1') ORDER BY weight ASC, mid ASC
SELECT * FROM xaa2_modules WHERE dirname = 'news'
SELECT COUNT(*) FROM xaa2_group_permission WHERE (gperm_modid = '13' AND gperm_name = 'news_submit' AND (gperm_groupid = '4'))
SELECT * FROM xaa2_config WHERE (conf_modid = '13') ORDER BY conf_order ASC
SELECT * FROM xaa2_wfcrefers
Isn't it some core error?
What should I do to gain ability to have that editors group for managing only contents? Now it doesn't work because of that problem with 'Admin index' of WF-Channel :(
