I activated the debug plugin. Then I visited the webpage of one of my partners. I clicked my banner. Was redirected to my website. Guess what....no debug infromation at the botom of the page. I get debug information on all my pages except when I cilck an affiliate banner. Strange he?
In the backend I went to the affiliateclicks page of hkashop. At least there I could get some debug info. I don't know if that is what you need.
Code:
19 Queries Logged
SELECT `data`
FROM `jos_session`
WHERE `session_id` = 'dpkuk0idb02b9fg062r19smij6'
SELECT extension_id AS id, element AS "option", params, enabled
FROM jos_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'
SELECT folder AS type, element AS name, params
FROM jos_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1,2,3,4)
ORDER BY ordering
SELECT template, s.params
FROM jos_template_styles as s
LEFT JOIN jos_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
SELECT extension_id AS id, element AS "option", params, enabled
FROM jos_extensions
WHERE `type` = 'component'
AND `element` = 'com_akeebasubs'
SELECT config_value
FROM jos_hikashop_config
WHERE config_namekey = 'version'
SELECT extension_id AS id, element AS "option", params, enabled
FROM jos_extensions
WHERE `type` = 'component'
AND `element` = 'com_coalawebtraffic'
SELECT extension_id AS id, element AS "option", params, enabled
FROM jos_extensions
WHERE `type` = 'component'
AND `element` = 'com_hikashop'
SELECT *
FROM jos_hikashop_config
SELECT a.*, b.user_email, b.user_currency_id
FROM jos_hikashop_click AS a JOIN jos_hikashop_user AS b
ON a.click_partner_id = b.user_id
WHERE a.click_partner_paid=0
ORDER BY a.click_id desc
LIMIT 0, 30
SELECT COUNT(*)
FROM jos_hikashop_click AS a JOIN jos_hikashop_user AS b
ON a.click_partner_id = b.user_id
WHERE a.click_partner_paid=0
SELECT *
FROM jos_hikamarket_config
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jos_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 <= '2014-07-04 09:04:00')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2014-07-04 09:04:00')
AND m.access IN (1,1,2,3,4)
AND m.client_id = 1
AND (mm.menuid = 0 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
SELECT COUNT(*)
FROM jos_messages
WHERE state = 0
AND user_id_to = 62
SELECT COUNT(session_id)
FROM jos_session
WHERE guest = 0
AND client_id = 1
SELECT COUNT(session_id)
FROM jos_session
WHERE guest = 0
AND client_id = 0
SELECT a.*, SUM(b.home) AS home,b.language,l.image,l.sef,l.title_native
FROM jos_menu_types AS a
LEFT JOIN jos_menu AS b
ON b.menutype = a.menutype
AND b.home != 0
LEFT JOIN jos_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
SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element
FROM jos_menu AS m
LEFT JOIN jos_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
UPDATE `jos_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:29;s:19:\"session.timer.start\";i:1404464212;s:18:\"session.timer.last\";i:1404464636;s:17:\"session.timer.now\";i:1404464640;s:22:\"session.client.browser\";s:109:\"Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.153 Safari/537.36\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":5:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}s:11:\"com_plugins\";O:8:\"stdClass\":2:{s:7:\"plugins\";O:8:\"stdClass\":4:{s:6:\"filter\";O:8:\"stdClass\":4:{s:6:\"search\";s:5:\"debug\";s:6:\"access\";i:0;s:5:\"state\";s:0:\"\";s:6:\"folder\";s:0:\"\";}s:10:\"limitstart\";i:0;s:8:\"ordercol\";s:6:\"folder\";s:9:\"orderdirn\";s:3:\"asc\";}s:4:\"edit\";O:8:\"stdClass\":1:{s:6:\"plugin\";O:8:\"stdClass\":2:{s:2:\"id\";a:0:{}s:4:\"data\";N;}}}s:6:\"global\";O:8:\"stdClass\":1:{s:4:\"list\";O:8:\"stdClass\":1:{s:5:\"
limit\";i:30;}}s:13:\"com_templates\";O:8:\"stdClass\":2:{s:6:\"styles\";O:8:\"stdClass\":1:{s:10:\"limitstart\";i:0;}s:4:\"edit\";O:8:\"stdClass\":1:{s:5:\"style\";O:8:\"stdClass\":2:{s:2:\"id\";a:0:{}s:4:\"data\";N;}}}s:12:\"com_hikashop\";O:8:\"stdClass\":1:{s:4:\"user\";O:8:\"stdClass\":1:{s:14:\"filter_partner\";i:1;}}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:2:\"62\";s:4:\"name\";s:5:\"Sjaak\";s:8:\"username\";s:5:\"admin\";s:5:\"email\";s:26:\"contact@artlantismedia.com\";s:8:\"password\";s:65:\"28693969dedde7b677d699205c154ce1:tTA7evEnX1GNodIJH7Ge4ADrnkgUthpq\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:19:\"Super Administrator\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2009-07-28 22:04:58\";s:13:\"lastvisitDate\";s:19:\"2014-07-04 08:26:18\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:92:\"{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"timezone\":\"\"}\";s:6:\"groups\";a:3:{i:1;s:1:\"1\";i:2;s:1:\"2\";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\":6:{s:11:\"admin_style\";s:0:\"\";s:14:\"admin_language\";s:0:\"\";s:8:\"language\";s:0:\"\";s:6:\"editor\";s:0:\"\";s:8:\"helpsite\";s:0:\"\";s:8:\"timezone\";s:0:\"\";}}s:14:\"\0*\0_authGroups\";a:3:{i:0;i:1;i:2;i:2;i:4;i:8;}s:14:\"\0*\0_authLevels\";a:5:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:4;}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:\"3d6861d2077a4818ca6b14b18338a13b\";}__wf|a:1:{s:13:\"session.token\";s:32:\"9f11a15723a2c33f9e0c539c1cd07a12\";}' , `time` = '1404464640'
WHERE `session_id` = 'dpkuk0idb02b9fg062r19smij6'
15 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
4 × SELECT extension_id AS id, element AS "option", params, enabled
FROM jos_extensions
2 × SELECT COUNT(session_id)
FROM jos_session
1 × SELECT COUNT(*)
FROM jos_messages
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jos_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT a.*, SUM(b.home) AS home,b.language,l.image,l.sef,l.title_native
FROM jos_menu_types AS a
LEFT JOIN jos_menu AS b
ON b.menutype = a.menutype
AND b.home != 0
LEFT JOIN jos_languages AS l
ON l.lang_code = language
1 × SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element
FROM jos_menu AS m
LEFT JOIN jos_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT *
FROM jos_hikamarket_confi
1 × SELECT a.*, b.user_email, b.user_currency_id
FROM jos_hikashop_click AS a JOIN jos_hikashop_user AS b
ON a.click_partner_id = b.user_id
1 × SELECT template, s.params
FROM jos_template_styles as s
LEFT JOIN jos_extensions as e
ON e.type='template'
AND e.element=s.template
AND e.client_id=s.client_id
1 × SELECT folder AS type, element AS name, params
FROM jos_extensions
1 × SELECT config_value
FROM jos_hikashop_config
1 × SELECT *
FROM jos_hikashop_confi
1 × SELECT `data`
FROM `jos_session`
1 × SELECT COUNT(*)
FROM jos_hikashop_click AS a JOIN jos_hikashop_user AS b
ON a.click_partner_id = b.user_id
OTHER Tables:
1 × UPDATE `jos_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:29;s:19:\"session.timer.start\";i:1404464212;s:18:\"session.timer.last\";i:1404464636;s:17:\"session.timer.now\";i:1404464640;s:22:\"session.client.browser\";s:109:\"Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.153 Safari/537.36\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":5:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}s:11:\"com_plugins\";O:8:\"stdClass\":2:{s:7:\"plugins\";O:8:\"stdClass\":4:{s:6:\"filter\";O:8:\"stdClass\":4:{s:6:\"search\";s:5:\"debug\";s:6:\"access\";i:0;s:5:\"state\";s:0:\"\";s:6:\"folder\";s:0:\"\";}s:10:\"limitstart\";i:0;s:8:\"ordercol\";s:6:\"folder\";s:9:\"orderdirn\";s:3:\"asc\";}s:4:\"edit\";O:8:\"stdClass\":1:{s:6:\"plugin\";O:8:\"stdClass\":2:{s:2:\"id\";a:0:{}s:4:\"data\";N;}}}s:6:\"global\";O:8:\"stdClass\":1:{s:4:\"list\";O:8:\"stdClass\":1:{s:5:\"
limit\";i:30;}}s:13:\"com_templates\";O:8:\"stdClass\":2:{s:6:\"styles\";O:8:\"stdClass\":1:{s:10:\"limitstart\";i:0;}s:4:\"edit\";O:8:\"stdClass\":1:{s:5:\"style\";O:8:\"stdClass\":2:{s:2:\"id\";a:0:{}s:4:\"data\";N;}}}s:12:\"com_hikashop\";O:8:\"stdClass\":1:{s:4:\"user\";O:8:\"stdClass\":1:{s:14:\"filter_partner\";i:1;}}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:2:\"62\";s:4:\"name\";s:5:\"Sjaak\";s:8:\"username\";s:5:\"admin\";s:5:\"email\";s:26:\"contact@artlantismedia.com\";s:8:\"password\";s:65:\"28693969dedde7b677d699205c154ce1:tTA7evEnX1GNodIJH7Ge4ADrnkgUthpq\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:19:\"Super Administrator\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2009-07-28 22:04:58\";s:13:\"lastvisitDate\";s:19:\"2014-07-04 08:26:18\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:92:\"{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"timezone\":\"\"}\";s:6:\"groups\";a:3:{i:1;s:1:\"1\";i:2;s:1:\"2\";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\":6:{s:11:\"admin_style\";s:0:\"\";s:14:\"admin_language\";s:0:\"\";s:8:\"language\";s:0:\"\";s:6:\"editor\";s:0:\"\";s:8:\"helpsite\";s:0:\"\";s:8:\"timezone\";s:0:\"\";}}s:14:\"\0*\0_authGroups\";a:3:{i:0;i:1;i:2;i:2;i:4;i:8;}s:14:\"\0*\0_authLevels\";a:5:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:4;}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:\"3d6861d2077a4818ca6b14b18338a13b\";}__wf|a:1:{s:13:\"session.token\";s:32:\"9f11a15723a2c33f9e0c539c1cd07a12\";}' , `time` = '1404464640'
