[Skip to main content](#vessel-content) # Affiliate "total unpaid amount" blank ## - **[waynedejager](/forum/user/3007-waynedejager "View waynedejager's Profile")** - [![waynedejager's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/3007-waynedejager "View waynedejager's Profile") Topic Author - [ Offline](/forum/user/3007-waynedejager) Less More - Posts: 13 - Thank you received: 0 - - 15 years 3 months ago [\#21252](#21252) by [waynedejager](/forum/user/3007-waynedejager "View waynedejager's Profile") *[Affiliate "total unpaid amount" blank](/forum/2-general-talk-about-hikashop/21252-affiliate-total-unpaid-amount-blank#21252 "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")* was created by *[waynedejager](/forum/user/3007-waynedejager "View waynedejager's Profile")* 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 Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzIxMjUyLWFmZmlsaWF0ZS10b3RhbC11bnBhaWQtYW1vdW50LWJsYW5rP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86293 - Thank you received: 14271 - - 15 years 3 months ago [\#21262](#21262) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Affiliate "total unpaid amount" blank](/forum/2-general-talk-about-hikashop/21252-affiliate-total-unpaid-amount-blank#21262 "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](http://www.hikashop.com/en/support/contact-us.html) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzIxMjUyLWFmZmlsaWF0ZS10b3RhbC11bnBhaWQtYW1vdW50LWJsYW5rP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[waynedejager](/forum/user/3007-waynedejager "View waynedejager's Profile")** - [![waynedejager's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/3007-waynedejager "View waynedejager's Profile") Topic Author - [ Offline](/forum/user/3007-waynedejager) Less More - Posts: 13 - Thank you received: 0 - - 15 years 3 months ago [\#21266](#21266) by [waynedejager](/forum/user/3007-waynedejager "View waynedejager's Profile") Replied by *[waynedejager](/forum/user/3007-waynedejager "View waynedejager's Profile")* on topic *[Re: Affiliate "total unpaid amount" blank](/forum/2-general-talk-about-hikashop/21252-affiliate-total-unpaid-amount-blank#21266 "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")* 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 Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzIxMjUyLWFmZmlsaWF0ZS10b3RhbC11bnBhaWQtYW1vdW50LWJsYW5rP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86293 - Thank you received: 14271 - - 15 years 3 months ago [\#21277](#21277) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Affiliate "total unpaid amount" blank](/forum/2-general-talk-about-hikashop/21252-affiliate-total-unpaid-amount-blank#21277 "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")* 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 Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzIxMjUyLWFmZmlsaWF0ZS10b3RhbC11bnBhaWQtYW1vdW50LWJsYW5rP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[waynedejager](/forum/user/3007-waynedejager "View waynedejager's Profile")** - [![waynedejager's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/3007-waynedejager "View waynedejager's Profile") Topic Author - [ Offline](/forum/user/3007-waynedejager) Less More - Posts: 13 - Thank you received: 0 - - 15 years 3 months ago [\#21588](#21588) by [waynedejager](/forum/user/3007-waynedejager "View waynedejager's Profile") Replied by *[waynedejager](/forum/user/3007-waynedejager "View waynedejager's Profile")* on topic *[Re: Affiliate "total unpaid amount" blank](/forum/2-general-talk-about-hikashop/21252-affiliate-total-unpaid-amount-blank#21588 "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")* 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 [ ![[img](http://www.hikashop.com/media/kunena/attachments/legacy/images/affiliate_programme_not_wor.jpg) ](http://www.hikashop.com/media/kunena/attachments/legacy/images/affiliate_programme_not_wor.jpg "[img") - [ ![affiliate_programme_not_wor.jpg](/forum/attachment/1467) ](/forum/attachment/1467 "...me_not_wor.jpg") [ ](/forum/attachment/1467?download=1 "...me_not_wor.jpg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzIxMjUyLWFmZmlsaWF0ZS10b3RhbC11bnBhaWQtYW1vdW50LWJsYW5rP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86293 - Thank you received: 14271 - - 15 years 3 months ago [\#21599](#21599) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Affiliate "total unpaid amount" blank](/forum/2-general-talk-about-hikashop/21252-affiliate-total-unpaid-amount-blank#21599 "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")* 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. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzIxMjUyLWFmZmlsaWF0ZS10b3RhbC11bnBhaWQtYW1vdW50LWJsYW5rP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[slydog](/forum/user/4407-slydog "View slydog's Profile")** - [![slydog's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4407-slydog "View slydog's Profile") - [ Offline](/forum/user/4407-slydog) Less More - Posts: 45 - Thank you received: 0 - - 14 years 11 months ago [\#30068](#30068) by [slydog](/forum/user/4407-slydog "View slydog's Profile") Replied by *[slydog](/forum/user/4407-slydog "View slydog's Profile")* on topic *[Re: Affiliate "total unpaid amount" blank](/forum/2-general-talk-about-hikashop/21252-affiliate-total-unpaid-amount-blank#30068 "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")* Hi, I encountered the same problem (the affiliate "total unpaid amount" is blank in listing). Have you found an option to fix this? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzIxMjUyLWFmZmlsaWF0ZS10b3RhbC11bnBhaWQtYW1vdW50LWJsYW5rP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86293 - Thank you received: 14271 - - 14 years 11 months ago [\#30082](#30082) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Affiliate "total unpaid amount" blank](/forum/2-general-talk-about-hikashop/21252-affiliate-total-unpaid-amount-blank#30082 "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")* 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 Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzIxMjUyLWFmZmlsaWF0ZS10b3RhbC11bnBhaWQtYW1vdW50LWJsYW5rP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[slydog](/forum/user/4407-slydog "View slydog's Profile")** - [![slydog's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4407-slydog "View slydog's Profile") - [ Offline](/forum/user/4407-slydog) Less More - Posts: 45 - Thank you received: 0 - - 14 years 11 months ago [\#30084](#30084) by [slydog](/forum/user/4407-slydog "View slydog's Profile") Replied by *[slydog](/forum/user/4407-slydog "View slydog's Profile")* on topic *[Re: Affiliate "total unpaid amount" blank](/forum/2-general-talk-about-hikashop/21252-affiliate-total-unpaid-amount-blank#30084 "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")* thanks a lot Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzIxMjUyLWFmZmlsaWF0ZS10b3RhbC11bnBhaWQtYW1vdW50LWJsYW5rP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[slydog](/forum/user/4407-slydog "View slydog's Profile")** - [![slydog's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4407-slydog "View slydog's Profile") - [ Offline](/forum/user/4407-slydog) Less More - Posts: 45 - Thank you received: 0 - - 14 years 11 months ago - 14 years 11 months ago [\#30288](#30288) by [slydog](/forum/user/4407-slydog "View slydog's Profile") Replied by *[slydog](/forum/user/4407-slydog "View slydog's Profile")* on topic *[Re: Affiliate "total unpaid amount" blank](/forum/2-general-talk-about-hikashop/21252-affiliate-total-unpaid-amount-blank#30288 "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")* 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 Last edit: 14 years 11 months ago by [slydog](/forum/user/4407-slydog "View slydog's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzIxMjUyLWFmZmlsaWF0ZS10b3RhbC11bnBhaWQtYW1vdW50LWJsYW5rP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86293 - Thank you received: 14271 - - 14 years 11 months ago [\#30339](#30339) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Affiliate "total unpaid amount" blank](/forum/2-general-talk-about-hikashop/21252-affiliate-total-unpaid-amount-blank#30339 "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")* You're missing the "(CASE WHEN" at the beginning of your modification. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzIxMjUyLWFmZmlsaWF0ZS10b3RhbC11bnBhaWQtYW1vdW50LWJsYW5rP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop- Install & Update- Product & Category Display- Content Creation- Sales and Orders- - Orders management- - Reports & Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import & Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel & Slider- - Mass Actions- - Filters & Search- - Discount & Coupon- - Feature Request- Integrations- Showcase- General Talk about HikaShop- Development- - HikaShop 3.0 Beta- Translation- Commercial Jobs HikaShop Components- HikaMarket- - Market: Feature requests- - Market: How to?- - Market: Bug Report- HikaSerial- - General talk about HikaSerial- - Serial: Bug Report- - Serial: How to?- - Support en Français de HikaSerial (French Support)- - HikaSubscription- HikaAuction- - Auction: Feature requests- - Auction: How to?- - Auction: Bug report Hikashop around the world- Support en Français (French Support)- Russian- - FAQ. Курс выживания с Hikashop. Частые вопросы и о- - Расширения Hikashop- - Наши сайты на Hikashop- 日本語版サポート(Japanese Support)- Thai- German Archives- Bug Report- How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.143 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)