Affiliate PHP PHPMyAdmin Bug

Hi. This is (maybe?) a Bug and Fix as well

I noticed that affiliate not working as I wanted, that's why I checked a background started with PHPMyAdmin. When I tried to list the hikashop_sale_view table I get #1356 error in myAdmin.

I googling around and found this: www.ubmedia.it/blog/2012/02/21/mysql-err...-rights-to-use-them/

And this post solved the problem.

In this topic they say, that It is a PHP or PHPMyAdmin related bug,

www.insidethebook.com/ee/index.php/site/...view_access_problem/

but the code didn't changed in Hikashop 2.0 neither, that's what I decided to notice you. I hope it's help

Peter

sorry wrong post.

That's because HikaShop uses views to process the affiliate fees. And based on how your hosting company configured your MySQL, your MySQL user might not have the right to create/modify/display/delete views resulting in that error.
So it's not a bug.