Affiliate PHP PHPMyAdmin Bug

  • Posts: 20
  • Thank you received: 0
11 years 10 months 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: 11 years 10 months ago by sharq.

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

  • Posts: 20
  • Thank you received: 0
11 years 10 months ago #86364

sorry wrong post. :)

Last edit: 11 years 10 months ago by sharq.

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

  • Posts: 82868
  • Thank you received: 13378
  • MODERATOR
11 years 10 months 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.041 seconds
Powered by Kunena Forum