HIKASHOP ESSENTIAL 60€The basic version. With the main features for a little shop.
HIKAMARKETAdd-on Create a multivendor platform. Enable many vendors on your website.
HIKASERIALAdd-on Sale e-tickets, vouchers, gift certificates, serial numbers and more!
MARKETPLACEPlugins, modules and other kinds of integrations for HikaShop
-- url of the page with the problem -- :
artlantismedia.com
-- HikaShop version -- : 2.3.0
-- Joomla version -- : 2.5
Hi,
I set up an affiliate program and have a few afiliate partners showing my banners on their website.
I also use an app that monitors traffic on my website (Extrawatch Pro). Using this app I see visitors coming from the partner websites. The app even mentions the affiliate Partner ID. So the banners work OK. They send visitors to my website.
BUT....
When I look in Hikashop/affiliates/Clicks I do not see clicks recorded.
So now I am puzzled: Is something going wrong here? Did I set set it up wrong? Are affiliate clicks recorded by Hikashop?
Can somebody explain?
Thanks
Sjaak
Please Log in or Create an account to join the conversation.
Hi,
You should see the clicks there. We do see them on our end (on our website for example).
Maybe there is a bug ?
If you turn on the "error reporting" and "debug mode" options of the Joomla configuration and that you click on an affiliate link, to you get an error ?
Please Log in or Create an account to join the conversation.
Hello Nicolas,
I followed your advise. Debug mode 'ON'. Error reporting 'ON'. On the website of one affiliate partner I clicked a banner.
No error shown. My website opened OK. No Click was recorded by Hikashop. Extrawatch mentions a visitor (with my IPaddress) coming from the partners website mentioning their affiliate ID.
Do I need to look somewhere else for the error?
Sjaak
Please Log in or Create an account to join the conversation.
Hi,
Ok. I see only two possibilities in that case. Either the MySQL is failing or the partner_id in the URL is not for a valid partner (not activated, account deleted for that id)
Could you provide the MySQL queries traces at the bottom of that page that you see with the debug turned on ?
Please Log in or Create an account to join the conversation.
Hi Nicolas,
I do not get an SQLquery at the bottom of the page with debug on.
The Affiliate partner indeed appears to have more than one user accounts. So I checked: The affiliate ID is the same as the Hikashop customer ID. That is correct right?
The affiliate account is set to active.
I have set the most recent joomla user account 'enabled' and active in joomla. It's the one that fits the data as shown in the affiliate account.
Should the joomla user ID be the same as the hikashop customer ID?
Thanks
Sjaak
Please Log in or Create an account to join the conversation.
Hi,
You should definitely get the queries at the bottom of the pages with the debug mode of the Joomla configuration on.
www.inmotionhosting.com/support/edu/joom...ettings/debug-system
If you don't, then this would indicate that your joomla template is coded to not display the debug data.
The fact that the joomla user id and the hikashop user id are different is normal, but the partner id and the hikashop user id should be the same.
How about to look at the clicks listing of the backend with the debug mode turned on ? Maybe the error is during the display of the listing and not during the saving of the click.
Please Log in or Create an account to join the conversation.
Hi Nicolas,
I tried your last suggestion but that did not give me any new information. With debug mode on I neither get error messages.
Sjaak
Please Log in or Create an account to join the conversation.
Hi,
Ok. Then what if you temporarily change your frontend template to the default one of Joomla, make sure that the debug plugin of Joomla is activated and try again the procedure ? That way, you should get the queries debug at the bottom.
Please Log in or Create an account to join the conversation.
pfff, first I thought you meant the debug system in the joomla global configuration. Only after your last post I looked in my plugins and enabled the plugin.
Well it's on now and at the bottom of the page I see ' Joomla! debug console'. It has 4 sections. Session, Profile information, Memory usage and Database Queries.
I assume you need the last?
Sjaak
Please Log in or Create an account to join the conversation.
Yes, I need the last one.
Please Log in or Create an account to join the conversation.
Hi Nicolas,
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.
Thanks for helping me.
Sjaak
Copy/paste of debug info:
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'Please Log in or Create an account to join the conversation.
Hi,
I have some plans to expand the affiliate program. But first I need to have it working properly.
Any new insights on this one?
Sjaak
Please Log in or Create an account to join the conversation.
My problem still exists. Can someone please surprise me with an update on this one?
Please Log in or Create an account to join the conversation.
Hi,
The clicks are recorded by the system plugin "hikashopaffiliate".
In the trigger "onAfterRoute", the plugin read the parameter "partner_id" (or another parameter depending of the configuration of the hikashopaffiliate plugin, you can rename it if you want).
If the partner id value point to an existing partner, the plugin will continue his process and at the end of the function you can see that a "click" object is stored in the database.
If the click is not stored, it could be because the user is not found or the "user_partner_activated" is not set.
The best at this moment will be to add some debug data in the plugin in order to understand the process.
You might use the "$app->enqueueMessage('....');" in order to display information in the plugin and get some information about the process.
Hope it will help.
Regards,
Please Log in or Create an account to join the conversation.
Sorry to say so but it doesn't help much.
Please tell me where to find the "onAfterRoute" trigger. Screenshot attached.
And I do not know how to use "$app->enqueueMessage('....');"
user is activated IserID is correct.
Best regards,
Sjaak
Please Log in or Create an account to join the conversation.
Hi,
It is in the source code of the plugin.
It requires some full debug in the plugin in order to understand why the plugin is not called and the click is not stored in the database.
Because, it is possible that something else in your website block the hikashop affiliate plugin to work correctly.
Regards,
Please Log in or Create an account to join the conversation.
Well, apparantly the plugin does not work correctly. Since I do not know how to code I buy software so I don't have to code.
Some time passed since I posted my question and now it seems something has to be done in the sourcecode.... 
.....mmmh
How can this be solved?
Best regards
Sjaak
Please Log in or Create an account to join the conversation.
Hi,
Well, some credentials will be required if you want us to make some debug in your website.
A backend access to check your configuration, see the affiliates, their clicks and see the other system plugins in place in your website.
A ftp access to edit the hikashop affiliate plugin directly and add some debug data into.
You can send such private information using private message.
Regards,
Please Log in or Create an account to join the conversation.
Hi Jerome,
I sent you a PM.
Thanks in advance
Sjaak
Please Log in or Create an account to join the conversation.
Hi,
Thanks for the access but you send me only the backend one, not the FTP.
Regards,
Please Log in or Create an account to join the conversation.
