Error on cron activation

  • Posts: 349
  • Thank you received: 19
  • Hikashop Business
3 days 23 hours ago #366670

-- HikaShop version -- : 5.1.5
-- Joomla version -- : 4
-- PHP version -- : 8.2

I have several problems with cron and mass actions. I gues it is conected.
1. When I manualy trigger cron job in hika, I get
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE user_id > 0 LIMIT 5' at line 1

2. Trying to set mass action, no file is exported.

Attachments:

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

  • Posts: 83603
  • Thank you received: 13533
  • MODERATOR
3 days 19 hours ago #366672

Hi,

Before you try to use the cron for a mass action, it's best to use the "process" button to launch the mass action manually.
That way, if you have an error with it, you should be able to see it on the screen.
What do you see when you run the mass action manually ?

Once you know the mass action is filtering properly, and generating the XLSX file when you manually process it, you can check that your cron task itself is working:
www.hikashop.com/support/documentation/5...ashop-cron-task.html
If you get an error with the cron, turn on the "debug" setting of the Joomla configuration and try again. You should get an error message with more information. That will be important to better understand the problem.

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

  • Posts: 349
  • Thank you received: 19
  • Hikashop Business
3 days 5 hours ago #366686

I created new action. Set it without trigger, saved and manually click process. I get Successfully Saved. No file is created.
Then I tried with Display the results. Again I get Successfully Saved but nothing happens.
My old mass actions are all working.

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

  • Posts: 83603
  • Thank you received: 13533
  • MODERATOR
3 days 1 hour ago #366691

Hi,

If you don't see anything with a "display the results" action, it means that there is a problem with your filters which leads HikaShop to find 0 results. That would also explain why no file is generated.
Try adding / removing the filters one by one to understand what is wrong.

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

  • Posts: 349
  • Thank you received: 19
  • Hikashop Business
2 days 23 hours ago #366698

If you look at my first post and filter setup, it should show all orders in last 30 days with affiliate. In my affiliate statistic there are at least 5 sales.
If I remove filter order_partner_id it shows latest orders.
So how to set filter to show affiliate sales from one specific partner and from all partners?

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

  • Posts: 83603
  • Thank you received: 13533
  • MODERATOR
2 days 20 hours ago #366702

Hi,

it should show all orders in last 30 days with affiliate

That's not what I see. You configured your filters to get only the orders from the last 30 days with a partner different than the partner with the id "1".
If you want to also take into account the partner with the id "1", then you need to change that filter to be either "> 0", or ">= 1".

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

  • Posts: 349
  • Thank you received: 19
  • Hikashop Business
2 days 18 hours ago #366718

Partner id is all greater then 1 (22270, ...). So it should show.
So how to set filter to show affiliate sales from one specific partner and from all partners?

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

  • Posts: 83603
  • Thank you received: 13533
  • MODERATOR
2 days 5 hours ago #366722

Well, I don't see another reason.
If you want to target a specific partner, you can have a filter on order_partner_id = xx where xx is the id of the user in HikaShop which is the partner.
And for all the partners, order_partner_id >=1 should do the trick. At least, it works on my end with my tests.

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

  • Posts: 349
  • Thank you received: 19
  • Hikashop Business
2 days 33 minutes ago #366743

I did that already several times. It doesnt work. Please help me resolve this.

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

  • Posts: 83603
  • Thank you received: 13533
  • MODERATOR
1 day 19 hours ago #366754

Please provide a backend access via our contact form:
www.hikashop.com/support/contact-us.html

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

  • Posts: 349
  • Thank you received: 19
  • Hikashop Business
1 day 5 hours ago #366759

By some miracle it's working again now. Maybe some cache? The sql error is gone too.

The following user(s) said Thank You: nicolas

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

Time to create page: 0.079 seconds
Powered by Kunena Forum