Closed halfwolf102 closed 9 years ago
LaocheXe
commented
9 years ago I just tried it on my site, was able to do it, however I notice that submitnews.php is lacking in the text area - still using bbtextarea instead of the other method that works on my forums and every thing else (forget what it is called)
halfwolf102
commented
9 years ago If you mean wysiwyg, I have that disabled as far as I know, and I have TinyMCE uninstalled as well.
CaMer0n
commented
9 years ago @halfwolf102 Are you logged in as mainadmin ?
halfwolf102
commented
9 years ago @CaMerOn I am.
CaMer0n
commented
9 years ago @halfwolf102 I'm having trouble reproducing this issue. Are these newly added 'submitnews' items, or older ones left over from v1.x ?
halfwolf102
commented
9 years ago @CaMerOn It's new and I have all the most recent files for v2.
tgtje
commented
9 years ago Did a test too with newest files ( 20 hours), not able to reproduce, all functions as should.
( bbarea = system built in form vs forum is 'templated' > {FORMSTART })
halfwolf102
commented
9 years ago SQL Analysis
30 Good Queries
Index Qtime Query
(msec)
2 0.2811 SELECT * FROM e107_userclass_classes ORDER BY userclass_parent
[Start: Misc resources. Online user tracking, cache - [html_directory]/e107_handlers/userclass_class.php(131)]
4 2.7812 SELECT u.*, ue.* FROM `e107_user` AS u LEFT JOIN `e107_user_extended` as ue ON u.user_id=ue.user_extended_id WHERE user_id=1
[Start: Init session - [html_directory]/e107_handlers/user_model.php(1659)]
5 6.4929 UPDATE e107_user SET user_currentvisit = 1432596482 WHERE user_id='1'
[Start: Init session - [html_directory]/e107_handlers/user_model.php(1760)]
6 5.5389 DELETE FROM e107_tmp WHERE tmp_time < 1432596182 AND tmp_ip!='data' AND tmp_ip!='submitted_link'
[Start: Signup/splash/admin - [html_directory]/class2.php(1009)]
8 0.2699 SELECT * FROM `e107_menus` WHERE menu_location > 0 AND menu_class IN (250,249,254,248,253,247,251,0) AND menu_layout = "" ORDER BY menu_location,menu_order
[Start: Get menus - [html_directory]/e107_handlers/menu_class.php(81)]
10 1.1711 SELECT * FROM e107_online WHERE (`online_ip` = '[REMOVED]' AND `online_user_id` = '0') OR `online_user_id` = '[REMOVED]'
[Start: Go online - [html_directory]/class2.php(1787)]
11 2.6891 UPDATE e107_online SET online_ip='[REMOVED]', online_location='/e107_admin/newspost.php?mode=main&action=edit&id=3', `online_pagecount` = '1' WHERE `online_user_id` = '[REMOVED]'
[Start: Go online - [html_directory]/class2.php(1787)]
12 0.3111 DELETE FROM e107_online WHERE `online_timestamp` < 1432596182
[Start: Go online - [html_directory]/class2.php(1787)]
14 0.5610 SELECT o.*,u.user_image FROM `e107_online` AS o LEFT JOIN `e107_user` AS u ON o.online_user_id = u.user_id WHERE o.online_pagecount > 0 ORDER BY o.online_timestamp DESC
[Start: Go online - [html_directory]/class2.php(1787)]
16 1.0519 SELECT COUNT(*) FROM e107_online WHERE `online_location` = '/e107_admin/newspost.php?mode=main&action=edit&id=3'
[Start: Go online - [html_directory]/e107_handlers/online_class.php(292)]
18 0.3049 SELECT chapter_id,chapter_sef,chapter_name FROM `e107_page_chapters` ORDER BY chapter_id ASC
[Start regular eFront Class - [html_directory]/page.php(154)]
20 3.3000 SELECT p.*, u.user_id, u.user_name, user_login FROM `e107_page` AS p LEFT JOIN `e107_user` AS u ON p.page_author = u.user_id WHERE p.page_id=4
[Start regular eFront Class - [html_directory]/page.php(64)]
22 0.2842 SELECT p.page_id,c.chapter_name,c.chapter_meta_description FROM `e107_page` AS p LEFT JOIN `e107_page_chapters` AS c ON p.page_chapter = c.chapter_id WHERE p.page_id = 4 LIMIT 1
[Start regular eFront Class - [html_directory]/e107_plugins/page/e_shortcode.php(32)]
24 0.2720 SELECT * FROM `e107_page_chapters` ORDER BY chapter_id ASC
[Start regular eFront Class - [html_directory]/e107_core/shortcodes/batch/page_shortcodes.php(29)]
26 3.3350 SELECT banner_id, banner_image, banner_clickurl FROM e107_banner WHERE (banner_startdate=0 OR banner_startdate <= 1432596482) AND (banner_enddate=0 OR banner_enddate > 1432596482) AND (banner_impurchased=0 OR banner_impressions<=banner_impurchased) AND banner_active IN (250,249,254,248,253,247,251,0) ORDER BY RAND(933814323) LIMIT 1
[Main Page Body - ()]
28 0.5059 SELECT * FROM e107_links WHERE link_class IN (250,249,254,248,253,247,251,0) AND link_category=1 ORDER BY link_order ASC
[Main Page Body - [html_directory]/e107_themes/simple/fs_functions.php(251)]
30 0.4561 SELECT * FROM e107_core WHERE e107_name="google_trans"
[googletranslate_menu - [html_directory]/e107_plugins/googletranslate_menu/includes/google_trans_class.php(85)]
31 0.9320 INSERT INTO e107_utrack_history VALUES (0,'1.Zeek',1432596482,'http://halfwolf102.x10host.com/e107_admin/newspost.php?4','[REMOVED]')
[user_track_menu - [html_directory]/e107_plugins/user_tracker/user_track_menu.php(18)]
33 0.8318 SELECT c.*, u.user_name FROM `e107_chatbox2` AS c LEFT JOIN `e107_user` AS u ON SUBSTRING_INDEX(c.cb2_nick,'.',1) = u.user_id ORDER BY c.cb2_datestamp DESC LIMIT 0, 25
[chatbox2_menu - [html_directory]/e107_plugins/chatbox2_menu/chatbox2_menu.php(508)]
35 0.6440 SELECT COUNT(*) FROM e107_chatbox2
[chatbox2_menu - [html_directory]/e107_plugins/chatbox2_menu/chatbox2_menu.php(777)]
37 0.3290 SELECT * FROM `e107_links` WHERE link_category = 2 AND link_class IN (250,249,254,248,253,247,251,0) ORDER BY link_order ASC
[(After chatbox2_menu) - [html_directory]/e107_handlers/sitelinks_class.php(94)]
39 1.1501 SELECT online_ip FROM e107_online WHERE `online_ip` = '[REMOVED]' AND `online_user_id` = '0'
[login_menu - [html_directory]/e107_handlers/menu_class.php(484)]
41 0.3531 SELECT * FROM e107_plugin WHERE plugin_installflag = 1
[admin_menu - [html_directory]/e107_handlers/sitelinks_class.php(930)]
43 0.4599 SELECT plugin_version FROM e107_plugin WHERE plugin_name='UserJournals'
[admin_menu - [html_directory]/e107_plugins/userjournals_menu/plugin.php(97)]
45 1.0130 SELECT user_id, user_name FROM e107_user WHERE user_ban='0' ORDER BY user_join DESC LIMIT 1
[online_menu - ()]
47 0.3669 SELECT count(pm.pm_id) AS total, SUM(pm.pm_size)/1024 size, SUM(pm.pm_read = 0) as unread FROM `e107_private_msg` as pm WHERE pm.pm_to = 1 AND pm.pm_read_del = 0
[private_msg_menu - [html_directory]/e107_plugins/pm/private_msg_menu.php(162)]
49 0.2511 SELECT COUNT(*) FROM e107_private_msg WHERE pm_sent > '1432519741' AND pm_read = 0 AND pm_to = '1' AND pm_read_del != 1
[private_msg_menu - [html_directory]/e107_plugins/pm/pm_func.php(64)]
51 0.2439 SELECT count(pm.pm_from) AS total, SUM(pm.pm_size)/1024 size, SUM(pm.pm_read = 0) as unread FROM `e107_private_msg` as pm WHERE pm.pm_from = 1 AND pm.pm_sent_del = 0
[private_msg_menu - [html_directory]/e107_plugins/pm/pm_shortcodes.php(281)]
53 0.4981 SELECT COUNT(*) FROM e107_private_msg_block WHERE `pm_block_to` = 1
[private_msg_menu - [html_directory]/e107_plugins/pm/pm_shortcodes.php(535)]
55 0.4451 SELECT * FROM `e107_generic` WHERE gen_type ='wmessage' AND gen_intdata IN (250,249,254,248,253,247,251,0)
[(After counter_menu) - ()]
2) Query: [Start: Misc resources. Online user tracking, cache - [html_directory]/e107_handlers/userclass_class.php(131)]
SELECT * FROM e107_userclass_classes ORDER BY userclass_parent
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE e107_userclass_classes ALL 10 Using filesort
Query time: 0.2811 (ms)
4) Query: [Start: Init session - [html_directory]/e107_handlers/user_model.php(1659)]
SELECT u.*, ue.* FROM `e107_user` AS u LEFT JOIN `e107_user_extended` as ue ON u.user_id=ue.user_extended_id WHERE user_id=1
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE u const PRIMARY PRIMARY 4 const 1
1 SIMPLE ue const PRIMARY PRIMARY 4 const 1
Query time: 2.7812 (ms)
5) Query: [Start: Init session - [html_directory]/e107_handlers/user_model.php(1760)]
UPDATE e107_user SET user_currentvisit = 1432596482 WHERE user_id='1'
Query time: 6.4929 (ms)
6) Query: [Start: Signup/splash/admin - [html_directory]/class2.php(1009)]
DELETE FROM e107_tmp WHERE tmp_time < 1432596182 AND tmp_ip!='data' AND tmp_ip!='submitted_link'
Query time: 5.5389 (ms)
8) Query: [Start: Get menus - [html_directory]/e107_handlers/menu_class.php(81)]
SELECT * FROM `e107_menus` WHERE menu_location > 0 AND menu_class IN (250,249,254,248,253,247,251,0) AND menu_layout = "" ORDER BY menu_location,menu_order
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE e107_menus ALL 80 Using where; Using filesort
Query time: 0.2699 (ms)
10) Query: [Start: Go online - [html_directory]/class2.php(1787)]
SELECT * FROM e107_online WHERE (`online_ip` = '[REMOVED]' AND `online_user_id` = '0') OR `online_user_id` = '[REMOVED]'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE e107_online ALL online_ip 1 Using where
Query time: 1.1711 (ms)
11) Query: [Start: Go online - [html_directory]/class2.php(1787)]
UPDATE e107_online SET online_ip='[REMOVED]', online_location='/e107_admin/newspost.php?mode=main&action=edit&id=3', `online_pagecount` = '1' WHERE `online_user_id` = '[REMOVED]'
Query time: 2.6891 (ms)
12) Query: [Start: Go online - [html_directory]/class2.php(1787)]
DELETE FROM e107_online WHERE `online_timestamp` < 1432596182
Query time: 0.3111 (ms)
14) Query: [Start: Go online - [html_directory]/class2.php(1787)]
SELECT o.*,u.user_image FROM `e107_online` AS o LEFT JOIN `e107_user` AS u ON o.online_user_id = u.user_id WHERE o.online_pagecount > 0 ORDER BY o.online_timestamp DESC
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE o ALL 1 Using where; Using filesort
1 SIMPLE u eq_ref PRIMARY PRIMARY 4 halfwol2_hwsite.o.online_user_id 1 Using where
Query time: 0.5610 (ms)
16) Query: [Start: Go online - [html_directory]/e107_handlers/online_class.php(292)]
SELECT COUNT(*) FROM e107_online WHERE `online_location` = '/e107_admin/newspost.php?mode=main&action=edit&id=3'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE e107_online ALL 1 Using where
Query time: 1.0519 (ms)
18) Query: [Start regular eFront Class - [html_directory]/page.php(154)]
SELECT chapter_id,chapter_sef,chapter_name FROM `e107_page_chapters` ORDER BY chapter_id ASC
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE e107_page_chapters system 0 const row not found
Query time: 0.3049 (ms)
20) Query: [Start regular eFront Class - [html_directory]/page.php(64)]
SELECT p.*, u.user_id, u.user_name, user_login FROM `e107_page` AS p LEFT JOIN `e107_user` AS u ON p.page_author = u.user_id WHERE p.page_id=4
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE p const PRIMARY PRIMARY 4 const 1
1 SIMPLE u const PRIMARY PRIMARY 4 const 1
Query time: 3.3000 (ms)
22) Query: [Start regular eFront Class - [html_directory]/e107_plugins/page/e_shortcode.php(32)]
SELECT p.page_id,c.chapter_name,c.chapter_meta_description FROM `e107_page` AS p LEFT JOIN `e107_page_chapters` AS c ON p.page_chapter = c.chapter_id WHERE p.page_id = 4 LIMIT 1
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE c system PRIMARY 0 const row not found
1 SIMPLE p const PRIMARY PRIMARY 4 const 1
Query time: 0.2842 (ms)
24) Query: [Start regular eFront Class - [html_directory]/e107_core/shortcodes/batch/page_shortcodes.php(29)]
SELECT * FROM `e107_page_chapters` ORDER BY chapter_id ASC
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE e107_page_chapters system 0 const row not found
Query time: 0.2720 (ms)
26) Query: [Main Page Body - ()]
SELECT banner_id, banner_image, banner_clickurl FROM e107_banner WHERE (banner_startdate=0 OR banner_startdate <= 1432596482) AND (banner_enddate=0 OR banner_enddate > 1432596482) AND (banner_impurchased=0 OR banner_impressions<=banner_impurchased) AND banner_active IN (250,249,254,248,253,247,251,0) ORDER BY RAND(933814323) LIMIT 1
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE e107_banner ALL 3 Using where; Using temporary; Using filesort
Query time: 3.3350 (ms)
28) Query: [Main Page Body - [html_directory]/e107_themes/simple/fs_functions.php(251)]
SELECT * FROM e107_links WHERE link_class IN (250,249,254,248,253,247,251,0) AND link_category=1 ORDER BY link_order ASC
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE e107_links ALL 18 Using where; Using filesort
Query time: 0.5059 (ms)
30) Query: [googletranslate_menu - [html_directory]/e107_plugins/googletranslate_menu/includes/google_trans_class.php(85)]
SELECT * FROM e107_core WHERE e107_name="google_trans"
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE e107_core const PRIMARY PRIMARY 302 const 1
Query time: 0.4561 (ms)
31) Query: [user_track_menu - [html_directory]/e107_plugins/user_tracker/user_track_menu.php(18)]
INSERT INTO e107_utrack_history VALUES (0,'[REMOVED]',[REMOVED],'http://halfwolf102.x10host.com/e107_admin/newspost.php?4','[REMOVED]')
Query time: 0.9320 (ms)
33) Query: [chatbox2_menu - [html_directory]/e107_plugins/chatbox2_menu/chatbox2_menu.php(508)]
SELECT c.*, u.user_name FROM `e107_chatbox2` AS c LEFT JOIN `e107_user` AS u ON SUBSTRING_INDEX(c.cb2_nick,'.',1) = u.user_id ORDER BY c.cb2_datestamp DESC LIMIT 0, 25
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE Impossible WHERE noticed after reading const tables
Query time: 0.8318 (ms)
35) Query: [chatbox2_menu - [html_directory]/e107_plugins/chatbox2_menu/chatbox2_menu.php(777)]
SELECT COUNT(*) FROM e107_chatbox2
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE Select tables optimized away
Query time: 0.6440 (ms)
37) Query: [(After chatbox2_menu) - [html_directory]/e107_handlers/sitelinks_class.php(94)]
SELECT * FROM `e107_links` WHERE link_category = 2 AND link_class IN (250,249,254,248,253,247,251,0) ORDER BY link_order ASC
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE e107_links ALL 18 Using where; Using filesort
Query time: 0.3290 (ms)
39) Query: [login_menu - [html_directory]/e107_handlers/menu_class.php(484)]
SELECT online_ip FROM e107_online WHERE `online_ip` = '[REMOVED]' AND `online_user_id` = '0'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE e107_online ref online_ip online_ip 137 const 1 Using index condition; Using where
Query time: 1.1501 (ms)
41) Query: [admin_menu - [html_directory]/e107_handlers/sitelinks_class.php(930)]
SELECT * FROM e107_plugin WHERE plugin_installflag = 1
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE e107_plugin ALL 53 Using where
Query time: 0.3531 (ms)
43) Query: [admin_menu - [html_directory]/e107_plugins/userjournals_menu/plugin.php(97)]
SELECT plugin_version FROM e107_plugin WHERE plugin_name='UserJournals'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE e107_plugin ALL 53 Using where
Query time: 0.4599 (ms)
45) Query: [online_menu - ()]
SELECT user_id, user_name FROM e107_user WHERE user_ban='0' ORDER BY user_join DESC LIMIT 1
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE e107_user index user_ban_index join_ban_index 5 1 Using where
Query time: 1.0130 (ms)
47) Query: [private_msg_menu - [html_directory]/e107_plugins/pm/private_msg_menu.php(162)]
SELECT count(pm.pm_id) AS total, SUM(pm.pm_size)/1024 size, SUM(pm.pm_read = 0) as unread FROM `e107_private_msg` as pm WHERE pm.pm_to = 1 AND pm.pm_read_del = 0
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE Impossible WHERE noticed after reading const tables
Query time: 0.3669 (ms)
49) Query: [private_msg_menu - [html_directory]/e107_plugins/pm/pm_func.php(64)]
SELECT COUNT(*) FROM e107_private_msg WHERE pm_sent > '1432519741' AND pm_read = 0 AND pm_to = '1' AND pm_read_del != 1
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE Impossible WHERE noticed after reading const tables
Query time: 0.2511 (ms)
51) Query: [private_msg_menu - [html_directory]/e107_plugins/pm/pm_shortcodes.php(281)]
SELECT count(pm.pm_from) AS total, SUM(pm.pm_size)/1024 size, SUM(pm.pm_read = 0) as unread FROM `e107_private_msg` as pm WHERE pm.pm_from = 1 AND pm.pm_sent_del = 0
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE Impossible WHERE noticed after reading const tables
Query time: 0.2439 (ms)
53) Query: [private_msg_menu - [html_directory]/e107_plugins/pm/pm_shortcodes.php(535)]
SELECT COUNT(*) FROM e107_private_msg_block WHERE `pm_block_to` = 1
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE Impossible WHERE noticed after reading const tables
Query time: 0.4981 (ms)
55) Query: [(After counter_menu) - ()]
SELECT * FROM `e107_generic` WHERE gen_type ='wmessage' AND gen_intdata IN (250,249,254,248,253,247,251,0)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE e107_generic ref gen_type gen_type 242 const 1 Using index condition; Using where
Query time: 0.4451 (ms)Try setting it to 'create another' after posting, before hitting submit. I don't see any INSERT attempt into news there (probably because it redirected afterward)
halfwolf102
commented
9 years ago Ok, I set it to "create another" after posting, here's the SQL debug. Also, I just found out it does the exact same thing when I hit cancel, and if the title field is blank, it stays on that page but goes back up to the top of the summary field.
30 Good Queries
Index Qtime Query
(msec)
2 0.5062 SELECT * FROM e107_userclass_classes ORDER BY userclass_parent
[Start: Misc resources. Online user tracking, cache - [html directory]/e107_handlers/userclass_class.php(131)]
4 0.9601 SELECT u.*, ue.* FROM `e107_user` AS u LEFT JOIN `e107_user_extended` as ue ON u.user_id=ue.user_extended_id WHERE user_id=1
[Start: Init session - [html directory]/e107_handlers/user_model.php(1659)]
5 0.5941 UPDATE e107_user SET user_currentvisit = 1432644855 WHERE user_id='1'
[Start: Init session - [html directory]/e107_handlers/user_model.php(1760)]
6 0.8168 DELETE FROM e107_tmp WHERE tmp_time < 1432644555 AND tmp_ip!='data' AND tmp_ip!='submitted_link'
[Start: Signup/splash/admin - [html directory]/class2.php(1009)]
8 0.4010 SELECT * FROM `e107_menus` WHERE menu_location > 0 AND menu_class IN (250,249,254,248,253,247,251,0) AND menu_layout = "" ORDER BY menu_location,menu_order
[Start: Get menus - [html directory]/e107_handlers/menu_class.php(81)]
10 0.9110 SELECT * FROM e107_online WHERE (`online_ip` = '[removed]' AND `online_user_id` = '0') OR `online_user_id` = '[removed]'
[Start: Go online - [html directory]/class2.php(1787)]
11 1.0951 UPDATE e107_online SET online_ip='[removed]', online_location='/e107_admin/newspost.php?action=edit&id=3', `online_pagecount` = '1' WHERE `online_user_id` = '[removed]'
[Start: Go online - [html directory]/class2.php(1787)]
12 0.7460 DELETE FROM e107_online WHERE `online_timestamp` < 1432644555
[Start: Go online - [html directory]/class2.php(1787)]
14 1.0920 SELECT o.*,u.user_image FROM `e107_online` AS o LEFT JOIN `e107_user` AS u ON o.online_user_id = u.user_id WHERE o.online_pagecount > 0 ORDER BY o.online_timestamp DESC
[Start: Go online - [html directory]/class2.php(1787)]
16 0.7699 SELECT COUNT(*) FROM e107_online WHERE `online_location` = '/e107_admin/newspost.php?action=edit&id=3'
[Start: Go online - [html directory]/e107_handlers/online_class.php(292)]
18 0.4780 SELECT chapter_id,chapter_sef,chapter_name FROM `e107_page_chapters` ORDER BY chapter_id ASC
[Start regular eFront Class - [html directory]/page.php(154)]
20 0.6351 SELECT p.*, u.user_id, u.user_name, user_login FROM `e107_page` AS p LEFT JOIN `e107_user` AS u ON p.page_author = u.user_id WHERE p.page_id=4
[Start regular eFront Class - [html directory]/page.php(64)]
22 0.3202 SELECT p.page_id,c.chapter_name,c.chapter_meta_description FROM `e107_page` AS p LEFT JOIN `e107_page_chapters` AS c ON p.page_chapter = c.chapter_id WHERE p.page_id = 4 LIMIT 1
[Start regular eFront Class - [html directory]/e107_plugins/page/e_shortcode.php(32)]
24 0.3660 SELECT * FROM `e107_page_chapters` ORDER BY chapter_id ASC
[Start regular eFront Class - [html directory]/e107_core/shortcodes/batch/page_shortcodes.php(29)]
26 1.2450 SELECT banner_id, banner_image, banner_clickurl FROM e107_banner WHERE (banner_startdate=0 OR banner_startdate <= 1432644855) AND (banner_enddate=0 OR banner_enddate > 1432644855) AND (banner_impurchased=0 OR banner_impressions<=banner_impurchased) AND banner_active IN (250,249,254,248,253,247,251,0) ORDER BY RAND(170318408) LIMIT 1
[Main Page Body - ()]
28 0.3641 SELECT * FROM e107_links WHERE link_class IN (250,249,254,248,253,247,251,0) AND link_category=1 ORDER BY link_order ASC
[Main Page Body - [html directory]/e107_themes/simple/fs_functions.php(251)]
30 0.3521 SELECT * FROM e107_core WHERE e107_name="google_trans"
[googletranslate_menu - [html directory]/e107_plugins/googletranslate_menu/includes/google_trans_class.php(85)]
31 0.8478 INSERT INTO e107_utrack_history VALUES (0,'[removed]',1432644855,'http://halfwolf102.x10host.com/e107_admin/newspost.php?4','[removed]')
[user_track_menu - [html directory]/e107_plugins/user_tracker/user_track_menu.php(18)]
33 0.7329 SELECT c.*, u.user_name FROM `e107_chatbox2` AS c LEFT JOIN `e107_user` AS u ON SUBSTRING_INDEX(c.cb2_nick,'.',1) = u.user_id ORDER BY c.cb2_datestamp DESC LIMIT 0, 25
[chatbox2_menu - [html directory]/e107_plugins/chatbox2_menu/chatbox2_menu.php(508)]
35 0.3030 SELECT COUNT(*) FROM e107_chatbox2
[chatbox2_menu - [html directory]/e107_plugins/chatbox2_menu/chatbox2_menu.php(777)]
37 0.2971 SELECT * FROM `e107_links` WHERE link_category = 2 AND link_class IN (250,249,254,248,253,247,251,0) ORDER BY link_order ASC
[(After chatbox2_menu) - [html directory]/e107_handlers/sitelinks_class.php(94)]
39 0.8349 SELECT online_ip FROM e107_online WHERE `online_ip` = '[removed]' AND `online_user_id` = '0'
[login_menu - [html directory]/e107_handlers/menu_class.php(484)]
41 0.4129 SELECT * FROM e107_plugin WHERE plugin_installflag = 1
[admin_menu - [html directory]/e107_handlers/sitelinks_class.php(930)]
43 0.3700 SELECT plugin_version FROM e107_plugin WHERE plugin_name='UserJournals'
[admin_menu - [html directory]/e107_plugins/userjournals_menu/plugin.php(97)]
45 1.0779 SELECT user_id, user_name FROM e107_user WHERE user_ban='0' ORDER BY user_join DESC LIMIT 1
[online_menu - ()]
47 0.3929 SELECT count(pm.pm_id) AS total, SUM(pm.pm_size)/1024 size, SUM(pm.pm_read = 0) as unread FROM `e107_private_msg` as pm WHERE pm.pm_to = 1 AND pm.pm_read_del = 0
[private_msg_menu - [html directory]/e107_plugins/pm/private_msg_menu.php(162)]
49 0.1850 SELECT COUNT(*) FROM e107_private_msg WHERE pm_sent > '1432615933' AND pm_read = 0 AND pm_to = '1' AND pm_read_del != 1
[private_msg_menu - [html directory]/e107_plugins/pm/pm_func.php(64)]
51 0.1879 SELECT count(pm.pm_from) AS total, SUM(pm.pm_size)/1024 size, SUM(pm.pm_read = 0) as unread FROM `e107_private_msg` as pm WHERE pm.pm_from = 1 AND pm.pm_sent_del = 0
[private_msg_menu - [html directory]/e107_plugins/pm/pm_shortcodes.php(281)]
53 0.4361 SELECT COUNT(*) FROM e107_private_msg_block WHERE `pm_block_to` = 1
[private_msg_menu - [html directory]/e107_plugins/pm/pm_shortcodes.php(535)]
55 0.3641 SELECT * FROM `e107_generic` WHERE gen_type ='wmessage' AND gen_intdata IN (250,249,254,248,253,247,251,0)
[(After counter_menu) - ()]
2) Query: [Start: Misc resources. Online user tracking, cache - [html directory]/e107_handlers/userclass_class.php(131)]
SELECT * FROM e107_userclass_classes ORDER BY userclass_parent
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE e107_userclass_classes ALL 10 Using filesort
Query time: 0.5062 (ms)
4) Query: [Start: Init session - [html directory]/e107_handlers/user_model.php(1659)]
SELECT u.*, ue.* FROM `e107_user` AS u LEFT JOIN `e107_user_extended` as ue ON u.user_id=ue.user_extended_id WHERE user_id=1
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE u const PRIMARY PRIMARY 4 const 1
1 SIMPLE ue const PRIMARY PRIMARY 4 const 1
Query time: 0.9601 (ms)
5) Query: [Start: Init session - [html directory]/e107_handlers/user_model.php(1760)]
UPDATE e107_user SET user_currentvisit = 1432644855 WHERE user_id='1'
Query time: 0.5941 (ms)
6) Query: [Start: Signup/splash/admin - [html directory]/class2.php(1009)]
DELETE FROM e107_tmp WHERE tmp_time < 1432644555 AND tmp_ip!='data' AND tmp_ip!='submitted_link'
Query time: 0.8168 (ms)
8) Query: [Start: Get menus - [html directory]/e107_handlers/menu_class.php(81)]
SELECT * FROM `e107_menus` WHERE menu_location > 0 AND menu_class IN (250,249,254,248,253,247,251,0) AND menu_layout = "" ORDER BY menu_location,menu_order
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE e107_menus ALL 80 Using where; Using filesort
Query time: 0.4010 (ms)
10) Query: [Start: Go online - [html directory]/class2.php(1787)]
SELECT * FROM e107_online WHERE (`online_ip` = '[removed]' AND `online_user_id` = '0') OR `online_user_id` = '[removed]'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE e107_online ALL online_ip 3 Using where
Query time: 0.9110 (ms)
11) Query: [Start: Go online - [html directory]/class2.php(1787)]
UPDATE e107_online SET online_ip='[removed]', online_location='/e107_admin/newspost.php?action=edit&id=3', `online_pagecount` = '1' WHERE `online_user_id` = '[removed]'
Query time: 1.0951 (ms)
12) Query: [Start: Go online - [html directory]/class2.php(1787)]
DELETE FROM e107_online WHERE `online_timestamp` < 1432644555
Query time: 0.7460 (ms)
14) Query: [Start: Go online - [html directory]/class2.php(1787)]
SELECT o.*,u.user_image FROM `e107_online` AS o LEFT JOIN `e107_user` AS u ON o.online_user_id = u.user_id WHERE o.online_pagecount > 0 ORDER BY o.online_timestamp DESC
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE o ALL 3 Using where; Using filesort
1 SIMPLE u eq_ref PRIMARY PRIMARY 4 halfwol2_hwsite.o.online_user_id 1 Using where
Query time: 1.0920 (ms)
16) Query: [Start: Go online - [html directory]/e107_handlers/online_class.php(292)]
SELECT COUNT(*) FROM e107_online WHERE `online_location` = '/e107_admin/newspost.php?action=edit&id=3'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE e107_online ALL 3 Using where
Query time: 0.7699 (ms)
18) Query: [Start regular eFront Class - [html directory]/page.php(154)]
SELECT chapter_id,chapter_sef,chapter_name FROM `e107_page_chapters` ORDER BY chapter_id ASC
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE e107_page_chapters system 0 const row not found
Query time: 0.4780 (ms)
20) Query: [Start regular eFront Class - [html directory]/page.php(64)]
SELECT p.*, u.user_id, u.user_name, user_login FROM `e107_page` AS p LEFT JOIN `e107_user` AS u ON p.page_author = u.user_id WHERE p.page_id=4
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE p const PRIMARY PRIMARY 4 const 1
1 SIMPLE u const PRIMARY PRIMARY 4 const 1
Query time: 0.6351 (ms)
22) Query: [Start regular eFront Class - [html directory]/e107_plugins/page/e_shortcode.php(32)]
SELECT p.page_id,c.chapter_name,c.chapter_meta_description FROM `e107_page` AS p LEFT JOIN `e107_page_chapters` AS c ON p.page_chapter = c.chapter_id WHERE p.page_id = 4 LIMIT 1
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE c system PRIMARY 0 const row not found
1 SIMPLE p const PRIMARY PRIMARY 4 const 1
Query time: 0.3202 (ms)
24) Query: [Start regular eFront Class - [html directory]/e107_core/shortcodes/batch/page_shortcodes.php(29)]
SELECT * FROM `e107_page_chapters` ORDER BY chapter_id ASC
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE e107_page_chapters system 0 const row not found
Query time: 0.3660 (ms)
26) Query: [Main Page Body - ()]
SELECT banner_id, banner_image, banner_clickurl FROM e107_banner WHERE (banner_startdate=0 OR banner_startdate <= 1432644855) AND (banner_enddate=0 OR banner_enddate > 1432644855) AND (banner_impurchased=0 OR banner_impressions<=banner_impurchased) AND banner_active IN (250,249,254,248,253,247,251,0) ORDER BY RAND(170318408) LIMIT 1
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE e107_banner ALL 3 Using where; Using temporary; Using filesort
Query time: 1.2450 (ms)
28) Query: [Main Page Body - [html directory]/e107_themes/simple/fs_functions.php(251)]
SELECT * FROM e107_links WHERE link_class IN (250,249,254,248,253,247,251,0) AND link_category=1 ORDER BY link_order ASC
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE e107_links ALL 20 Using where; Using filesort
Query time: 0.3641 (ms)
30) Query: [googletranslate_menu - [html directory]/e107_plugins/googletranslate_menu/includes/google_trans_class.php(85)]
SELECT * FROM e107_core WHERE e107_name="google_trans"
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE e107_core const PRIMARY PRIMARY 302 const 1
Query time: 0.3521 (ms)
31) Query: [user_track_menu - [html directory]/e107_plugins/user_tracker/user_track_menu.php(18)]
INSERT INTO e107_utrack_history VALUES (0,'[removed]',1432644855,'http://halfwolf102.x10host.com/e107_admin/newspost.php?4','[removed]')
Query time: 0.8478 (ms)
33) Query: [chatbox2_menu - [html directory]/e107_plugins/chatbox2_menu/chatbox2_menu.php(508)]
SELECT c.*, u.user_name FROM `e107_chatbox2` AS c LEFT JOIN `e107_user` AS u ON SUBSTRING_INDEX(c.cb2_nick,'.',1) = u.user_id ORDER BY c.cb2_datestamp DESC LIMIT 0, 25
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE Impossible WHERE noticed after reading const tables
Query time: 0.7329 (ms)
35) Query: [chatbox2_menu - [html directory]/e107_plugins/chatbox2_menu/chatbox2_menu.php(777)]
SELECT COUNT(*) FROM e107_chatbox2
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE Select tables optimized away
Query time: 0.3030 (ms)
37) Query: [(After chatbox2_menu) - [html directory]/e107_handlers/sitelinks_class.php(94)]
SELECT * FROM `e107_links` WHERE link_category = 2 AND link_class IN (250,249,254,248,253,247,251,0) ORDER BY link_order ASC
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE e107_links ALL 20 Using where; Using filesort
Query time: 0.2971 (ms)
39) Query: [login_menu - [html directory]/e107_handlers/menu_class.php(484)]
SELECT online_ip FROM e107_online WHERE `online_ip` = '[removed]' AND `online_user_id` = '0'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE e107_online ref online_ip online_ip 137 const 1 Using index condition; Using where
Query time: 0.8349 (ms)
41) Query: [admin_menu - [html directory]/e107_handlers/sitelinks_class.php(930)]
SELECT * FROM e107_plugin WHERE plugin_installflag = 1
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE e107_plugin ALL 54 Using where
Query time: 0.4129 (ms)
43) Query: [admin_menu - [html directory]/e107_plugins/userjournals_menu/plugin.php(97)]
SELECT plugin_version FROM e107_plugin WHERE plugin_name='UserJournals'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE e107_plugin ALL 54 Using where
Query time: 0.3700 (ms)
45) Query: [online_menu - ()]
SELECT user_id, user_name FROM e107_user WHERE user_ban='0' ORDER BY user_join DESC LIMIT 1
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE e107_user index user_ban_index join_ban_index 5 1 Using where
Query time: 1.0779 (ms)
47) Query: [private_msg_menu - [html directory]/e107_plugins/pm/private_msg_menu.php(162)]
SELECT count(pm.pm_id) AS total, SUM(pm.pm_size)/1024 size, SUM(pm.pm_read = 0) as unread FROM `e107_private_msg` as pm WHERE pm.pm_to = 1 AND pm.pm_read_del = 0
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE Impossible WHERE noticed after reading const tables
Query time: 0.3929 (ms)
49) Query: [private_msg_menu - [html directory]/e107_plugins/pm/pm_func.php(64)]
SELECT COUNT(*) FROM e107_private_msg WHERE pm_sent > '1432615933' AND pm_read = 0 AND pm_to = '1' AND pm_read_del != 1
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE Impossible WHERE noticed after reading const tables
Query time: 0.1850 (ms)
51) Query: [private_msg_menu - [html directory]/e107_plugins/pm/pm_shortcodes.php(281)]
SELECT count(pm.pm_from) AS total, SUM(pm.pm_size)/1024 size, SUM(pm.pm_read = 0) as unread FROM `e107_private_msg` as pm WHERE pm.pm_from = 1 AND pm.pm_sent_del = 0
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE Impossible WHERE noticed after reading const tables
Query time: 0.1879 (ms)
53) Query: [private_msg_menu - [html directory]/e107_plugins/pm/pm_shortcodes.php(535)]
SELECT COUNT(*) FROM e107_private_msg_block WHERE `pm_block_to` = 1
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE Impossible WHERE noticed after reading const tables
Query time: 0.4361 (ms)
55) Query: [(After counter_menu) - ()]
SELECT * FROM `e107_generic` WHERE gen_type ='wmessage' AND gen_intdata IN (250,249,254,248,253,247,251,0)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE e107_generic ref gen_type gen_type 242 const 1 Using index condition; Using where
Query time: 0.3641 (ms)Thank you @halfwolf102 . I realized that's not going to work, because it redirects every time. However, you should see 'orange' debug info after posting. Please use this link to create an item: e107_admin/newspost.php?[debug=sql+]mode=main&action=create Then post your debug info here. It will start with something looking like this:
Array
(
[e-token] => 0039fe468c0a7a02729d3ca6d413bc53
[news_category] => 5
[news_title] => Bla
[news_summary] => Bla
... etc..... SQL Analysis doesn't show anything after posting, and the only thing I get for a detailed SQL Analysis is the information I posted. Even doing a full debug doesn't show that information. I could send the full debug information if you thing that would help though, but there's probably too much to post here.
willem010
commented
9 years ago confirming issues on the news..
editing article, e107 reports no change, newsitem not saved. no content in newsarticle. image not showing.
CREATING article, item is saved with no content.
halfwolf102
commented
9 years ago @willem010 For both editing and creating, no changes are reported and the item is not saved.
willem010
commented
9 years ago i reported a separate issue as i do not get any redirects,
my issue seems to be related to tinymce.
halfwolf102
commented
9 years ago @willem010 Ok, thank you for checking. @CaMer0n Here's a link to a full debug, hope it helps. http://halfwolf102.x10host.com/Full_e107Site_Debug.txt
CaMer0n
commented
9 years ago @halfwolf102 Are you able to send me a master admin account for the site, as well as FTP access? If so, please make sure you're logged in here: http://e107.org/developers/ and then send the details via the "Contact Us" link at the top. thanks.
halfwolf102
commented
9 years ago Ok, sent. Please let me know if you find anything out.
CaMer0n
commented
9 years ago I renamed your .htaccess file to .htaccess_old (temporarily). After doing this the server returned a "406 Not Acceptable" error when posting a news item. If you have access to the server errors logs you should look for this error to find out what is triggering it. Most likely it is mod_security. So you'll need to find out which Rule is being broken.
halfwolf102
commented
9 years ago @CaMer0n Error logging was disabled by default, my apologies. I have just enabled it and will repeat the steps you've stated and post the log as soon as possible. -UPDATE- Despite being enabled now, no log is being generated. I'm working with my webhost to try to determine the cause of the 406 error. I will update you when I can. Opened forum thread: https://x10hosting.com/community/threads/406-not-accepable-error.196738/
halfwolf102
commented
9 years ago @CaMer0n With regards to the pull request I created earlier for this issue, would changing "$name .= '[]';" to "$name .= 'array()';" break anything? This appears to fix the issue.
CaMer0n
commented
9 years ago @halfwolf102 It could break things. Please ask your host to check the mod_security logs - there should be an entry associated with newspost.php.
willem010
commented
9 years ago after some digging, i think i am experiencing the same issue after all,
i have been asking for the mod_security logs at my provider (twice now. :P patience is not my thing haha) as halfwolf;s host doesnt seem to provide the info required.
btw, my servers php info mentions : : This server is protected with the Suhosin Patch 0.9.9.1 after some reading up on suhosin i think this might possibly be an issue?
halfwolf102
commented
9 years ago Just a quick update to keep this issue up-to-date. @CaMer0n Unfortunately, I've had no luck in obtaining the server error log as of yet. Is there anything further that can be done in the event I am unable to get them?
@willem010 I did find something you could try to see if it's the same issue, but keep in mind that it's not an officially approved fix and is completely at your discretion to try. If you do, it should be reverted immediately after testing. In /e107_handlers/form_handler.php, find this
if(!empty($select_options['multiple']) && substr($name,-1) != ']')
{
$name .= '[]';
}and change $name .= '[]'; to $name .= 'array()'; Afterward. try posting. If it solves the issue, it is the same issue; If not, then it likely isn't. Again though, it is your choice to try it and is not an official fix, so don't forget to revert the change afterward if you do.
willem010
commented
9 years ago @halfwolf102 sure, i will try this evening to see if we have the same issue. (i dont want to break other things as @CaMer0n mentioned.)
and i will try to get those logs myself too. thnx! (Y)
willem010
commented
9 years ago @halfwolf102
that unsupported fix doesnt help for me, issue still the same with array()
so.. separate issues.. makes camerons life even harder :P haha
halfwolf102
commented
9 years ago @CaMer0n Going off of what you did with the .htaccess file, do you think it's possible that index.php can cause the issue? I set up a temporary website on a sub-domain with e107 v1.0.4 and the EXACT same thing is happening. The weird this is that I'm being redirected to the main site's homepage. @Willem010 At least we've narrowed down the possible issues for you. Hope it gets fixed soon.
halfwolf102
commented
9 years ago @CaMer0n Disregard my last question. I found out the reason that it redirects to the home page is because there is no set error page for a 406 error, which is what is happening in the first place. Adding an error page for it and including it in .htaccess, I consistently got the 406 error instead of being redirected.
CaMer0n
commented
9 years ago @halfwolf102 That's correct. Like I said, it's a 406 error which I believe is triggered by mod-security.
When I try to create or post a submitted news item, I get redirected to my home page even though it shows this url: .../e107_admin/newspost.php?mode=main&action=create&sub=2