Affiliate PHP PHPMyAdmin Bug

  • Posts: 20
  • Thank you received: 0
12 years 1 week ago #86360

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

Last edit: 12 years 1 week ago by sharq.

Please Log in or Create an account to join the conversation.

  • Posts: 20
  • Thank you received: 0
12 years 1 week ago #86364

sorry wrong post. :)

Last edit: 12 years 1 week ago by sharq.

Please Log in or Create an account to join the conversation.

  • Posts: 83159
  • Thank you received: 13433
  • MODERATOR
12 years 1 week ago #86444

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.

Please Log in or Create an account to join the conversation.

Time to create page: 0.059 seconds
Powered by Kunena Forum