Affiliate PHP PHPMyAdmin Bug

  • Posts: 20
  • Thank you received: 0
12 years 1 month 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 month ago by sharq.

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

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

sorry wrong post. :)

Last edit: 12 years 1 month ago by sharq.

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

  • Posts: 83396
  • Thank you received: 13489
  • MODERATOR
12 years 1 month 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.055 seconds
Powered by Kunena Forum