Joomla 5.2.2 Security & Bugfix Release
Joomla 5.2.2 je nyní k dispozici. Jedná se o bezpečnostní vydání pro Joomla 5.x.
Stránky se nezobrazí
17. říj 2013 15:49 - 17. říj 2013 15:52 #111867
Dobrý den.
Manželka mne poprosila o stránky a tak byť laik jsem něco splácal. Bohužel po nějaké době kouknu a stránky se nezobrazují. Do administrace se dostanu, ale to je vše. Vůbec netuším kam a co se podělalo.
Zapnul jsem alespoň zobrazení chyb jestli to někomu pomůže, budu velice rád za pomoc.
www.ucetnictvi-lb.cz
Joomla! konzole ladění chyb
Sezení
__default
Informace o profilu
Application 0.001 seconds (+0.001); 0.38 MB (+0.384) - afterLoad
Application 0.022 seconds (+0.021); 1.73 MB (+1.344) - afterInitialise
Application 0.022 seconds (+0.000); 1.73 MB (+0.002) - afterRoute
Application 0.035 seconds (+0.013); 2.36 MB (+0.627) - beforeRenderModule mod_logged (Logged-in Users)
Application 0.038 seconds (+0.003); 2.42 MB (+0.067) - afterRenderModule mod_logged (Logged-in Users)
Application 0.038 seconds (+0.000); 2.42 MB (-0.002) - beforeRenderModule mod_popular (Popular Articles)
Application 0.045 seconds (+0.007); 2.67 MB (+0.247) - afterRenderModule mod_popular (Popular Articles)
Application 0.045 seconds (+0.000); 2.65 MB (-0.016) - beforeRenderModule mod_latest (Recently Added Articles)
Application 0.052 seconds (+0.007); 2.83 MB (+0.181) - afterRenderModule mod_latest (Recently Added Articles)
Application 0.053 seconds (+0.002); 2.78 MB (-0.054) - afterDispatch
Application 0.055 seconds (+0.002); 2.84 MB (+0.055) - beforeRenderModule mod_version (Joomla Version)
Application 0.057 seconds (+0.002); 2.84 MB (+0.008) - afterRenderModule mod_version (Joomla Version)
Application 0.057 seconds (+0.000); 2.84 MB (-0.003) - beforeRenderModule mod_quickicon (Quick Icons)
Application 0.064 seconds (+0.007); 2.98 MB (+0.144) - afterRenderModule mod_quickicon (Quick Icons)
Application 0.065 seconds (+0.000); 2.98 MB (-0.001) - beforeRenderModule mod_menu (Admin Menu)
Application 0.109 seconds (+0.044); 3.27 MB (+0.291) - afterRenderModule mod_menu (Admin Menu)
Application 0.109 seconds (+0.000); 3.22 MB (-0.057) - beforeRenderModule mod_status (User Status)
Application 0.111 seconds (+0.003); 3.23 MB (+0.011) - afterRenderModule mod_status (User Status)
Application 0.112 seconds (+0.001); 3.28 MB (+0.048) - afterRender
Využití paměti
3.32 MB (3,477,344 Bytes)
Dotazy do databáze
18 zaznamenaných dotazů
1.SELECT `data`
FROM `q2mct_session`
WHERE `session_id` = 'r27o5e30cu2jd6589jenpjd8j1'
2.DELETE
FROM `q2mct_session`
WHERE `time` < '1382016599'
3.SELECT extension_id AS id, element AS "option", params, enabled
FROM q2mct_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'
4.SELECT folder AS type, element AS name, params
FROM q2mct_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1,2,3)
ORDER BY ordering
5.SELECT template, s.params
FROM q2mct_template_styles as s
LEFT JOIN q2mct_extensions as e
ON e.type='template'
AND e.element=s.template
AND e.client_id=s.client_id
WHERE s.client_id = 1
AND home = 1
ORDER BY home
6.SELECT extension_id AS id, element AS "option", params, enabled
FROM q2mct_extensions
WHERE `type` = 'component'
AND `element` = 'com_cpanel'
7.SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM q2mct_modules AS m
LEFT JOIN q2mct_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN q2mct_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2013-10-17 13:44:59')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2013-10-17 13:44:59')
AND m.access IN (1,1,2,3)
AND m.client_id = 1
AND (mm.menuid = 0 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
8.SELECT s.time, s.client_id, u.id, u.name, u.username
FROM q2mct_session AS s
LEFT JOIN q2mct_users AS u
ON s.userid = u.id
WHERE s.guest = 0
LIMIT 0, 5
9.SELECT a.id, a.title, a.checked_out, a.checked_out_time, a.created, a.hits,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS category_title,ua.name AS author_name
FROM q2mct_content AS a
LEFT JOIN `q2mct_languages` AS l
ON l.lang_code = a.language
LEFT JOIN q2mct_users AS uc
ON uc.id=a.checked_out
LEFT JOIN q2mct_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN q2mct_categories AS c
ON c.id = a.catid
LEFT JOIN q2mct_users AS ua
ON ua.id = a.created_by
ORDER BY a.hits DESC
10.SELECT a.id, a.title, a.checked_out, a.checked_out_time, a.created, a.hits,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS category_title,ua.name AS author_name
FROM q2mct_content AS a
LEFT JOIN `q2mct_languages` AS l
ON l.lang_code = a.language
LEFT JOIN q2mct_users AS uc
ON uc.id=a.checked_out
LEFT JOIN q2mct_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN q2mct_categories AS c
ON c.id = a.catid
LEFT JOIN q2mct_users AS ua
ON ua.id = a.created_by
ORDER BY a.hits DESC
LIMIT 0, 5
11.SELECT a.id, a.title, a.checked_out, a.checked_out_time, a.access, a.created, a.created_by, a.created_by_alias, a.featured, a.state,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS category_title,ua.name AS author_name
FROM q2mct_content AS a
LEFT JOIN `q2mct_languages` AS l
ON l.lang_code = a.language
LEFT JOIN q2mct_users AS uc
ON uc.id=a.checked_out
LEFT JOIN q2mct_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN q2mct_categories AS c
ON c.id = a.catid
LEFT JOIN q2mct_users AS ua
ON ua.id = a.created_by
ORDER BY created DESC
12.SELECT a.id, a.title, a.checked_out, a.checked_out_time, a.access, a.created, a.created_by, a.created_by_alias, a.featured, a.state,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS category_title,ua.name AS author_name
FROM q2mct_content AS a
LEFT JOIN `q2mct_languages` AS l
ON l.lang_code = a.language
LEFT JOIN q2mct_users AS uc
ON uc.id=a.checked_out
LEFT JOIN q2mct_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN q2mct_categories AS c
ON c.id = a.catid
LEFT JOIN q2mct_users AS ua
ON ua.id = a.created_by
ORDER BY created DESC
LIMIT 0, 5
13.SELECT a.*, SUM(b.home) AS home,b.language,l.image,l.sef,l.title_native
FROM q2mct_menu_types AS a
LEFT JOIN q2mct_menu AS b
ON b.menutype = a.menutype
AND b.home != 0
LEFT JOIN q2mct_languages AS l
ON l.lang_code = language
WHERE (b.client_id = 0 OR b.client_id IS NULL)
GROUP BY a.id, a.menutype, a.description, a.title, b.menutype,b.language,l.image,l.sef,l.title_native
14.SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element
FROM q2mct_menu AS m
LEFT JOIN q2mct_extensions AS e
ON m.component_id = e.extension_id
WHERE m.client_id = 1
AND e.enabled = 1
AND m.id > 1
ORDER BY m.lft
15.SELECT COUNT(*)
FROM q2mct_messages
WHERE state = 0
AND user_id_to = 690
16.SELECT COUNT(session_id)
FROM q2mct_session
WHERE guest = 0
AND client_id = 1
17.SELECT COUNT(session_id)
FROM q2mct_session
WHERE guest = 0
AND client_id = 0
18.UPDATE `q2mct_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:24;s:19:\"session.timer.start\";i:1382017100;s:18:\"session.timer.last\";i:1382017498;s:17:\"session.timer.now\";i:1382017499;s:22:\"session.client.browser\";s:71:\"Mozilla/5.0 (compatible; MSIE 10.0; Windows NT 6.1; WOW64; Trident/6.0)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":6:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}s:13:\"com_installer\";O:8:\"stdClass\":2:{s:7:\"message\";s:0:\"\";s:17:\"extension_message\";s:0:\"\";}s:11:\"com_checkin\";O:8:\"stdClass\":1:{s:7:\"checkin\";O:8:\"stdClass\":1:{s:8:\"ordercol\";s:5:\"table\";}}s:9:\"com_cache\";O:8:\"stdClass\":1:{s:5:\"cache\";O:8:\"stdClass\":1:{s:8:\"ordercol\";s:5:\"
group\";}}s:11:\"com_modules\";O:8:\"stdClass\":1:{s:7:\"modules\";O:8:\"stdClass\":4:{s:6:\"filter\";O:8:\"stdClass\":8:{s:18:\"client_id_previous\";i:0;s:6:\"search\";s:0:\"\";s:6:\"access\";i:0;s:5:\"state\";s:0:\"\";s:8:\"position\";s:0:\"\";s:6:\"module\";s:0:\"\";s:9:\"client_id\";i:0;s:8:\"language\";s:0:\"\";}s:10:\"limitstart\";s:2:\"40\";s:8:\"ordercol\";s:8:\"position\";s:9:\"orderdirn\";s:3:\"asc\";}}s:6:\"global\";O:8:\"stdClass\":1:{s:4:\"list\";O:8:\"stdClass\":1:{s:5:\"
limit\";i:20;}}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:3:\"690\";s:4:\"name\";s:10:\"Super User\";s:8:\"username\";s:5:\"admin\";s:5:\"email\";s:24:\"vrbovakarolina@gmail.com\";s:8:\"password\";s:65:\"282ab7c793bb06fe2a6fb9dd7ac98eac:w8YfOumlyOXnsIS9vDYdTXsFbPcp0xo1\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:10:\"deprecated\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2013-03-03 15:57:18\";s:13:\"lastvisitDate\";s:19:\"2013-10-17 13:07:14\";s:10:\"activation\";s:1:\"0\";s:6:\"params\";s:0:\"\";s:6:\"groups\";a:1:{i:8;s:1:\"8\";}s:5:\"guest\";i:0;s:13:\"lastResetTime\";s:19:\"0000-00-00 00:00:00\";s:10:\"resetCount\";s:1:\"0\";s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\0*\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"e3c672e0e9e5797aba6555b377d2bf1e\";}' , `time` = '1382017499'
WHERE `session_id` = 'r27o5e30cu2jd6589jenpjd8j1'
14 zaznamenaných typů dotazu, řazeno dle výskytu
VYBRANÉ tabulky:
1.2 × SELECT a.id, a.title, a.checked_out, a.checked_out_time, a.created, a.hits,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS category_title,ua.name AS author_name
FROM q2mct_content AS a
LEFT JOIN `q2mct_languages` AS l
ON l.lang_code = a.language
LEFT JOIN q2mct_users AS uc
ON uc.id=a.checked_out
LEFT JOIN q2mct_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN q2mct_categories AS c
ON c.id = a.catid
LEFT JOIN q2mct_users AS ua
ON ua.id = a.created_by
2.2 × SELECT a.id, a.title, a.checked_out, a.checked_out_time, a.access, a.created, a.created_by, a.created_by_alias, a.featured, a.state,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS category_title,ua.name AS author_name
FROM q2mct_content AS a
LEFT JOIN `q2mct_languages` AS l
ON l.lang_code = a.language
LEFT JOIN q2mct_users AS uc
ON uc.id=a.checked_out
LEFT JOIN q2mct_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN q2mct_categories AS c
ON c.id = a.catid
LEFT JOIN q2mct_users AS ua
ON ua.id = a.created_by
3.2 × SELECT COUNT(session_id)
FROM q2mct_session
4.2 × SELECT extension_id AS id, element AS "option", params, enabled
FROM q2mct_extensions
5.1 × SELECT a.*, SUM(b.home) AS home,b.language,l.image,l.sef,l.title_native
FROM q2mct_menu_types AS a
LEFT JOIN q2mct_menu AS b
ON b.menutype = a.menutype
AND b.home != 0
LEFT JOIN q2mct_languages AS l
ON l.lang_code = language
6.1 × SELECT COUNT(*)
FROM q2mct_messages
7.1 × SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element
FROM q2mct_menu AS m
LEFT JOIN q2mct_extensions AS e
ON m.component_id = e.extension_id
8.1 × SELECT s.time, s.client_id, u.id, u.name, u.username
FROM q2mct_session AS s
LEFT JOIN q2mct_users AS u
ON s.userid = u.id
9.1 × SELECT folder AS type, element AS name, params
FROM q2mct_extensions
10.1 × SELECT template, s.params
FROM q2mct_template_styles as s
LEFT JOIN q2mct_extensions as e
ON e.type='template'
AND e.element=s.template
AND e.client_id=s.client_id
11.1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM q2mct_modules AS m
LEFT JOIN q2mct_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN q2mct_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
12.1 × SELECT `data`
FROM `q2mct_session`
JINÉ tabulky:
1.1 × UPDATE `q2mct_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:24;s:19:\"session.timer.start\";i:1382017100;s:18:\"session.timer.last\";i:1382017498;s:17:\"session.timer.now\";i:1382017499;s:22:\"session.client.browser\";s:71:\"Mozilla/5.0 (compatible; MSIE 10.0; Windows NT 6.1; WOW64; Trident/6.0)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":6:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}s:13:\"com_installer\";O:8:\"stdClass\":2:{s:7:\"message\";s:0:\"\";s:17:\"extension_message\";s:0:\"\";}s:11:\"com_checkin\";O:8:\"stdClass\":1:{s:7:\"checkin\";O:8:\"stdClass\":1:{s:8:\"ordercol\";s:5:\"table\";}}s:9:\"com_cache\";O:8:\"stdClass\":1:{s:5:\"cache\";O:8:\"stdClass\":1:{s:8:\"ordercol\";s:5:\"
group\";}}s:11:\"com_modules\";O:8:\"stdClass\":1:{s:7:\"modules\";O:8:\"stdClass\":4:{s:6:\"filter\";O:8:\"stdClass\":8:{s:18:\"client_id_previous\";i:0;s:6:\"search\";s:0:\"\";s:6:\"access\";i:0;s:5:\"state\";s:0:\"\";s:8:\"position\";s:0:\"\";s:6:\"module\";s:0:\"\";s:9:\"client_id\";i:0;s:8:\"language\";s:0:\"\";}s:10:\"limitstart\";s:2:\"40\";s:8:\"ordercol\";s:8:\"position\";s:9:\"orderdirn\";s:3:\"asc\";}}s:6:\"global\";O:8:\"stdClass\":1:{s:4:\"list\";O:8:\"stdClass\":1:{s:5:\"
limit\";i:20;}}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:3:\"690\";s:4:\"name\";s:10:\"Super User\";s:8:\"username\";s:5:\"admin\";s:5:\"email\";s:24:\"vrbovakarolina@gmail.com\";s:8:\"password\";s:65:\"282ab7c793bb06fe2a6fb9dd7ac98eac:w8YfOumlyOXnsIS9vDYdTXsFbPcp0xo1\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:10:\"deprecated\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2013-03-03 15:57:18\";s:13:\"lastvisitDate\";s:19:\"2013-10-17 13:07:14\";s:10:\"activation\";s:1:\"0\";s:6:\"params\";s:0:\"\";s:6:\"groups\";a:1:{i:8;s:1:\"8\";}s:5:\"guest\";i:0;s:13:\"lastResetTime\";s:19:\"0000-00-00 00:00:00\";s:10:\"resetCount\";s:1:\"0\";s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\0*\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"e3c672e0e9e5797aba6555b377d2bf1e\";}' , `time` = '1382017499'
2.1 × DELETE
FROM `q2mct_session`
Manželka mne poprosila o stránky a tak byť laik jsem něco splácal. Bohužel po nějaké době kouknu a stránky se nezobrazují. Do administrace se dostanu, ale to je vše. Vůbec netuším kam a co se podělalo.
Zapnul jsem alespoň zobrazení chyb jestli to někomu pomůže, budu velice rád za pomoc.
www.ucetnictvi-lb.cz
Joomla! konzole ladění chyb
Sezení
__default
Informace o profilu
Application 0.001 seconds (+0.001); 0.38 MB (+0.384) - afterLoad
Application 0.022 seconds (+0.021); 1.73 MB (+1.344) - afterInitialise
Application 0.022 seconds (+0.000); 1.73 MB (+0.002) - afterRoute
Application 0.035 seconds (+0.013); 2.36 MB (+0.627) - beforeRenderModule mod_logged (Logged-in Users)
Application 0.038 seconds (+0.003); 2.42 MB (+0.067) - afterRenderModule mod_logged (Logged-in Users)
Application 0.038 seconds (+0.000); 2.42 MB (-0.002) - beforeRenderModule mod_popular (Popular Articles)
Application 0.045 seconds (+0.007); 2.67 MB (+0.247) - afterRenderModule mod_popular (Popular Articles)
Application 0.045 seconds (+0.000); 2.65 MB (-0.016) - beforeRenderModule mod_latest (Recently Added Articles)
Application 0.052 seconds (+0.007); 2.83 MB (+0.181) - afterRenderModule mod_latest (Recently Added Articles)
Application 0.053 seconds (+0.002); 2.78 MB (-0.054) - afterDispatch
Application 0.055 seconds (+0.002); 2.84 MB (+0.055) - beforeRenderModule mod_version (Joomla Version)
Application 0.057 seconds (+0.002); 2.84 MB (+0.008) - afterRenderModule mod_version (Joomla Version)
Application 0.057 seconds (+0.000); 2.84 MB (-0.003) - beforeRenderModule mod_quickicon (Quick Icons)
Application 0.064 seconds (+0.007); 2.98 MB (+0.144) - afterRenderModule mod_quickicon (Quick Icons)
Application 0.065 seconds (+0.000); 2.98 MB (-0.001) - beforeRenderModule mod_menu (Admin Menu)
Application 0.109 seconds (+0.044); 3.27 MB (+0.291) - afterRenderModule mod_menu (Admin Menu)
Application 0.109 seconds (+0.000); 3.22 MB (-0.057) - beforeRenderModule mod_status (User Status)
Application 0.111 seconds (+0.003); 3.23 MB (+0.011) - afterRenderModule mod_status (User Status)
Application 0.112 seconds (+0.001); 3.28 MB (+0.048) - afterRender
Využití paměti
3.32 MB (3,477,344 Bytes)
Dotazy do databáze
18 zaznamenaných dotazů
1.SELECT `data`
FROM `q2mct_session`
WHERE `session_id` = 'r27o5e30cu2jd6589jenpjd8j1'
2.DELETE
FROM `q2mct_session`
WHERE `time` < '1382016599'
3.SELECT extension_id AS id, element AS "option", params, enabled
FROM q2mct_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'
4.SELECT folder AS type, element AS name, params
FROM q2mct_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1,2,3)
ORDER BY ordering
5.SELECT template, s.params
FROM q2mct_template_styles as s
LEFT JOIN q2mct_extensions as e
ON e.type='template'
AND e.element=s.template
AND e.client_id=s.client_id
WHERE s.client_id = 1
AND home = 1
ORDER BY home
6.SELECT extension_id AS id, element AS "option", params, enabled
FROM q2mct_extensions
WHERE `type` = 'component'
AND `element` = 'com_cpanel'
7.SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM q2mct_modules AS m
LEFT JOIN q2mct_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN q2mct_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2013-10-17 13:44:59')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2013-10-17 13:44:59')
AND m.access IN (1,1,2,3)
AND m.client_id = 1
AND (mm.menuid = 0 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
8.SELECT s.time, s.client_id, u.id, u.name, u.username
FROM q2mct_session AS s
LEFT JOIN q2mct_users AS u
ON s.userid = u.id
WHERE s.guest = 0
LIMIT 0, 5
9.SELECT a.id, a.title, a.checked_out, a.checked_out_time, a.created, a.hits,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS category_title,ua.name AS author_name
FROM q2mct_content AS a
LEFT JOIN `q2mct_languages` AS l
ON l.lang_code = a.language
LEFT JOIN q2mct_users AS uc
ON uc.id=a.checked_out
LEFT JOIN q2mct_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN q2mct_categories AS c
ON c.id = a.catid
LEFT JOIN q2mct_users AS ua
ON ua.id = a.created_by
ORDER BY a.hits DESC
10.SELECT a.id, a.title, a.checked_out, a.checked_out_time, a.created, a.hits,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS category_title,ua.name AS author_name
FROM q2mct_content AS a
LEFT JOIN `q2mct_languages` AS l
ON l.lang_code = a.language
LEFT JOIN q2mct_users AS uc
ON uc.id=a.checked_out
LEFT JOIN q2mct_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN q2mct_categories AS c
ON c.id = a.catid
LEFT JOIN q2mct_users AS ua
ON ua.id = a.created_by
ORDER BY a.hits DESC
LIMIT 0, 5
11.SELECT a.id, a.title, a.checked_out, a.checked_out_time, a.access, a.created, a.created_by, a.created_by_alias, a.featured, a.state,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS category_title,ua.name AS author_name
FROM q2mct_content AS a
LEFT JOIN `q2mct_languages` AS l
ON l.lang_code = a.language
LEFT JOIN q2mct_users AS uc
ON uc.id=a.checked_out
LEFT JOIN q2mct_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN q2mct_categories AS c
ON c.id = a.catid
LEFT JOIN q2mct_users AS ua
ON ua.id = a.created_by
ORDER BY created DESC
12.SELECT a.id, a.title, a.checked_out, a.checked_out_time, a.access, a.created, a.created_by, a.created_by_alias, a.featured, a.state,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS category_title,ua.name AS author_name
FROM q2mct_content AS a
LEFT JOIN `q2mct_languages` AS l
ON l.lang_code = a.language
LEFT JOIN q2mct_users AS uc
ON uc.id=a.checked_out
LEFT JOIN q2mct_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN q2mct_categories AS c
ON c.id = a.catid
LEFT JOIN q2mct_users AS ua
ON ua.id = a.created_by
ORDER BY created DESC
LIMIT 0, 5
13.SELECT a.*, SUM(b.home) AS home,b.language,l.image,l.sef,l.title_native
FROM q2mct_menu_types AS a
LEFT JOIN q2mct_menu AS b
ON b.menutype = a.menutype
AND b.home != 0
LEFT JOIN q2mct_languages AS l
ON l.lang_code = language
WHERE (b.client_id = 0 OR b.client_id IS NULL)
GROUP BY a.id, a.menutype, a.description, a.title, b.menutype,b.language,l.image,l.sef,l.title_native
14.SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element
FROM q2mct_menu AS m
LEFT JOIN q2mct_extensions AS e
ON m.component_id = e.extension_id
WHERE m.client_id = 1
AND e.enabled = 1
AND m.id > 1
ORDER BY m.lft
15.SELECT COUNT(*)
FROM q2mct_messages
WHERE state = 0
AND user_id_to = 690
16.SELECT COUNT(session_id)
FROM q2mct_session
WHERE guest = 0
AND client_id = 1
17.SELECT COUNT(session_id)
FROM q2mct_session
WHERE guest = 0
AND client_id = 0
18.UPDATE `q2mct_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:24;s:19:\"session.timer.start\";i:1382017100;s:18:\"session.timer.last\";i:1382017498;s:17:\"session.timer.now\";i:1382017499;s:22:\"session.client.browser\";s:71:\"Mozilla/5.0 (compatible; MSIE 10.0; Windows NT 6.1; WOW64; Trident/6.0)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":6:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}s:13:\"com_installer\";O:8:\"stdClass\":2:{s:7:\"message\";s:0:\"\";s:17:\"extension_message\";s:0:\"\";}s:11:\"com_checkin\";O:8:\"stdClass\":1:{s:7:\"checkin\";O:8:\"stdClass\":1:{s:8:\"ordercol\";s:5:\"table\";}}s:9:\"com_cache\";O:8:\"stdClass\":1:{s:5:\"cache\";O:8:\"stdClass\":1:{s:8:\"ordercol\";s:5:\"
group\";}}s:11:\"com_modules\";O:8:\"stdClass\":1:{s:7:\"modules\";O:8:\"stdClass\":4:{s:6:\"filter\";O:8:\"stdClass\":8:{s:18:\"client_id_previous\";i:0;s:6:\"search\";s:0:\"\";s:6:\"access\";i:0;s:5:\"state\";s:0:\"\";s:8:\"position\";s:0:\"\";s:6:\"module\";s:0:\"\";s:9:\"client_id\";i:0;s:8:\"language\";s:0:\"\";}s:10:\"limitstart\";s:2:\"40\";s:8:\"ordercol\";s:8:\"position\";s:9:\"orderdirn\";s:3:\"asc\";}}s:6:\"global\";O:8:\"stdClass\":1:{s:4:\"list\";O:8:\"stdClass\":1:{s:5:\"
limit\";i:20;}}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:3:\"690\";s:4:\"name\";s:10:\"Super User\";s:8:\"username\";s:5:\"admin\";s:5:\"email\";s:24:\"vrbovakarolina@gmail.com\";s:8:\"password\";s:65:\"282ab7c793bb06fe2a6fb9dd7ac98eac:w8YfOumlyOXnsIS9vDYdTXsFbPcp0xo1\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:10:\"deprecated\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2013-03-03 15:57:18\";s:13:\"lastvisitDate\";s:19:\"2013-10-17 13:07:14\";s:10:\"activation\";s:1:\"0\";s:6:\"params\";s:0:\"\";s:6:\"groups\";a:1:{i:8;s:1:\"8\";}s:5:\"guest\";i:0;s:13:\"lastResetTime\";s:19:\"0000-00-00 00:00:00\";s:10:\"resetCount\";s:1:\"0\";s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\0*\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"e3c672e0e9e5797aba6555b377d2bf1e\";}' , `time` = '1382017499'
WHERE `session_id` = 'r27o5e30cu2jd6589jenpjd8j1'
14 zaznamenaných typů dotazu, řazeno dle výskytu
VYBRANÉ tabulky:
1.2 × SELECT a.id, a.title, a.checked_out, a.checked_out_time, a.created, a.hits,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS category_title,ua.name AS author_name
FROM q2mct_content AS a
LEFT JOIN `q2mct_languages` AS l
ON l.lang_code = a.language
LEFT JOIN q2mct_users AS uc
ON uc.id=a.checked_out
LEFT JOIN q2mct_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN q2mct_categories AS c
ON c.id = a.catid
LEFT JOIN q2mct_users AS ua
ON ua.id = a.created_by
2.2 × SELECT a.id, a.title, a.checked_out, a.checked_out_time, a.access, a.created, a.created_by, a.created_by_alias, a.featured, a.state,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS category_title,ua.name AS author_name
FROM q2mct_content AS a
LEFT JOIN `q2mct_languages` AS l
ON l.lang_code = a.language
LEFT JOIN q2mct_users AS uc
ON uc.id=a.checked_out
LEFT JOIN q2mct_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN q2mct_categories AS c
ON c.id = a.catid
LEFT JOIN q2mct_users AS ua
ON ua.id = a.created_by
3.2 × SELECT COUNT(session_id)
FROM q2mct_session
4.2 × SELECT extension_id AS id, element AS "option", params, enabled
FROM q2mct_extensions
5.1 × SELECT a.*, SUM(b.home) AS home,b.language,l.image,l.sef,l.title_native
FROM q2mct_menu_types AS a
LEFT JOIN q2mct_menu AS b
ON b.menutype = a.menutype
AND b.home != 0
LEFT JOIN q2mct_languages AS l
ON l.lang_code = language
6.1 × SELECT COUNT(*)
FROM q2mct_messages
7.1 × SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element
FROM q2mct_menu AS m
LEFT JOIN q2mct_extensions AS e
ON m.component_id = e.extension_id
8.1 × SELECT s.time, s.client_id, u.id, u.name, u.username
FROM q2mct_session AS s
LEFT JOIN q2mct_users AS u
ON s.userid = u.id
9.1 × SELECT folder AS type, element AS name, params
FROM q2mct_extensions
10.1 × SELECT template, s.params
FROM q2mct_template_styles as s
LEFT JOIN q2mct_extensions as e
ON e.type='template'
AND e.element=s.template
AND e.client_id=s.client_id
11.1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM q2mct_modules AS m
LEFT JOIN q2mct_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN q2mct_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
12.1 × SELECT `data`
FROM `q2mct_session`
JINÉ tabulky:
1.1 × UPDATE `q2mct_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:24;s:19:\"session.timer.start\";i:1382017100;s:18:\"session.timer.last\";i:1382017498;s:17:\"session.timer.now\";i:1382017499;s:22:\"session.client.browser\";s:71:\"Mozilla/5.0 (compatible; MSIE 10.0; Windows NT 6.1; WOW64; Trident/6.0)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":6:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}s:13:\"com_installer\";O:8:\"stdClass\":2:{s:7:\"message\";s:0:\"\";s:17:\"extension_message\";s:0:\"\";}s:11:\"com_checkin\";O:8:\"stdClass\":1:{s:7:\"checkin\";O:8:\"stdClass\":1:{s:8:\"ordercol\";s:5:\"table\";}}s:9:\"com_cache\";O:8:\"stdClass\":1:{s:5:\"cache\";O:8:\"stdClass\":1:{s:8:\"ordercol\";s:5:\"
group\";}}s:11:\"com_modules\";O:8:\"stdClass\":1:{s:7:\"modules\";O:8:\"stdClass\":4:{s:6:\"filter\";O:8:\"stdClass\":8:{s:18:\"client_id_previous\";i:0;s:6:\"search\";s:0:\"\";s:6:\"access\";i:0;s:5:\"state\";s:0:\"\";s:8:\"position\";s:0:\"\";s:6:\"module\";s:0:\"\";s:9:\"client_id\";i:0;s:8:\"language\";s:0:\"\";}s:10:\"limitstart\";s:2:\"40\";s:8:\"ordercol\";s:8:\"position\";s:9:\"orderdirn\";s:3:\"asc\";}}s:6:\"global\";O:8:\"stdClass\":1:{s:4:\"list\";O:8:\"stdClass\":1:{s:5:\"
limit\";i:20;}}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:3:\"690\";s:4:\"name\";s:10:\"Super User\";s:8:\"username\";s:5:\"admin\";s:5:\"email\";s:24:\"vrbovakarolina@gmail.com\";s:8:\"password\";s:65:\"282ab7c793bb06fe2a6fb9dd7ac98eac:w8YfOumlyOXnsIS9vDYdTXsFbPcp0xo1\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:10:\"deprecated\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2013-03-03 15:57:18\";s:13:\"lastvisitDate\";s:19:\"2013-10-17 13:07:14\";s:10:\"activation\";s:1:\"0\";s:6:\"params\";s:0:\"\";s:6:\"groups\";a:1:{i:8;s:1:\"8\";}s:5:\"guest\";i:0;s:13:\"lastResetTime\";s:19:\"0000-00-00 00:00:00\";s:10:\"resetCount\";s:1:\"0\";s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\0*\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"e3c672e0e9e5797aba6555b377d2bf1e\";}' , `time` = '1382017499'
2.1 × DELETE
FROM `q2mct_session`
17. říj 2013 16:31 #111870
Odpověď od Houbák
Zkušený uživatel
Zapněte v globálním nastavení spíš zobrazování chyb (na maximum).
17. říj 2013 21:12 #111875
Odpověď od Cony
Moderátor
Zapl jste "Ladění chyb systému". Zapněte si "Hlášení chyb" na "Maximum".
17. říj 2013 21:26 #111877
Odpověď od Alias75
Nováček
Vše bylo zapnuto už při vkládání textu.
Eventuelně povolím přistup do administrátorského prostředí, jestliže není chyba patrná.
Eventuelně povolím přistup do administrátorského prostředí, jestliže není chyba patrná.
17. říj 2013 21:49 #111878
Odpověď od Cony
Moderátor
Vypsal jste tady záznam z konzole z administrace. To je naprosto k ničemu. Tedy ještě jednou Zapněte si hlášení chyb na maximum, a zobrazte si úvodní stránku webu (ne administrace). Bude tam nějaká chyba.