Affiliate "total unpaid amount" blank

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 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,

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,

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

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