Affiliate "total unpaid amount" blank

In the joomla backend - the affiliate "total unpaid amount" is blank - but if you click change on an affiliates name it show unpaid amounts....

this should appear on the "total unpaid amount"

please advise

We never had such problem reported so far. Could you provide a back end access and FTP access to your website so that we can see the problem and maybe fix it if there's a bug ? If so, you can use our contact form for that: www.hikashop.com/en/support/contact-us.html

i pm'd you - please take a look, also if you can see why the paypal option not coming up if you paying in ZAR.
many tx

I didn't see the total unpaid amount blank on your back end. Here is an example I saw for the username rachel :
Unpaid amount for clicks 1.4
Unpaid amount for Leads 0
Unpaid amount for sales 20.25
Total unpaid amount 21.65

Hi Nicolas

please see the "total unpaid amount" in the screenshot attached. I am not sure why you mentioned the info is there??? sure if you drill down into the person you can see it - but it should be showing on the landing screen...

please advise

Hi,

I tried to access you back end again in order to look at the problem but I got an error:
500 - An error has occurred.

JDatabaseMySQL::query: 1146 - Table 'bodytuamkv_db1.jos_jcacl_block_list' doesn't exist SQL=SELECT * FROM jos_jcacl_block_list WHERE `option` = '' AND (user_id = 70)

It seems that JCACL database is missing but that you still have some part of it on your website. You should first disable the debug mode in the configuration.php of your website via FTP so that you will be able to restore the access to the back end and then make sure that the JCACL component is either properly installed or properly uninstalled.


Anyway, I see what you mean now. I was indeed talking about the information on the user edition screen, not the information on the listing. We'll have to look at that and fix it for next release.

Hi,
I encountered the same problem (the affiliate "total unpaid amount" is blank in listing).
Have you found an option to fix this?

Hi,

Yes, that has been fixed on our end already and will be available in next release of HikaShop.
In the mean time, if you want to fix it, you need to replace the several instances of:
a.user_currency_id=b.click_partner_currency_id
in the file administrator/components/com_hikashop/view/user/view.html.php
by:
(CASE WHEN a.user_currency_id=0 THEN '.hikashop_getCurrency().' ELSE a.user_currency_id END)=b.click_partner_currency_id

thanks a lot

I replaced the three combinations
a.user_currency_id=b.click_partner_currency_id
by
a.user_currency_id=0 THEN '.hikashop_getCurrency().' ELSE a.user_currency_id END)=b.click_partner_currency_id

a.user_currency_id=b.user_partner_currency_id
by
a.user_currency_id=0 THEN '.hikashop_getCurrency().' ELSE a.user_currency_id END)=b.order_partner_currency_id

a.user_currency_id=b.user_partner_currency_id
by
a.user_currency_id=0 THEN '.hikashop_getCurrency().' ELSE a.user_currency_id END)=b.user_partner_currency_id


Now only shows the amount unpaid for clicks
does not add to the amount unpaid for sales (in my case leads = 0)
(in your demo - shows sum of clicks and sales, but does not consider the leads)
_________________

sorry, now it's vorking
maybe problem with caching

You're missing the "(CASE WHEN" at the beginning of your modification.