Affiliate PHP PHPMyAdmin Bug

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

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

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

sorry wrong post. :)

Last edit: 11 years 3 months ago by sharq.

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

  • Posts: 81598
  • Thank you received: 13082
  • MODERATOR
11 years 3 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.059 seconds
Powered by Kunena Forum