[Skip to main content](#vessel-content) # Error on cron activation ## - **[mojweb](/forum/user/5128-mojweb "View mojweb's Profile")** - [![mojweb's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/5128-mojweb "View mojweb's Profile") Topic Author - [ Offline](/forum/user/5128-mojweb) Less More - Posts: 431 - Thank you received: 22 - 1 year 6 months ago [\#366670](#366670) by [mojweb](/forum/user/5128-mojweb "View mojweb's Profile") *[Error on cron activation](/forum/44-mass-actions/909337-error-on-cron-activation#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.")* was created by *[mojweb](/forum/user/5128-mojweb "View mojweb's Profile")* -- 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. - [ ![Posnetekzaslona2025-04-15145735.jpg](/forum/attachment/60442) ](/forum/attachment/60442 "...4-15145735.jpg") [ ](/forum/attachment/60442?download=1 "...4-15145735.jpg") - [ ![Posnetekzaslona2025-04-15145838.jpg](/forum/attachment/60443) ](/forum/attachment/60443 "...4-15145838.jpg") [ ](/forum/attachment/60443?download=1 "...4-15145838.jpg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy85MDkzMzctZXJyb3Itb24tY3Jvbi1hY3RpdmF0aW9uP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86324 - Thank you received: 14286 - - 1 year 6 months ago [\#366672](#366672) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Error on cron activation](/forum/44-mass-actions/909337-error-on-cron-activation#366672 "-- 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.")* 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](https://www.hikashop.com/support/documentation/55-hikashop-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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy85MDkzMzctZXJyb3Itb24tY3Jvbi1hY3RpdmF0aW9uP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[mojweb](/forum/user/5128-mojweb "View mojweb's Profile")** - [![mojweb's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/5128-mojweb "View mojweb's Profile") Topic Author - [ Offline](/forum/user/5128-mojweb) Less More - Posts: 431 - Thank you received: 22 - 1 year 6 months ago [\#366686](#366686) by [mojweb](/forum/user/5128-mojweb "View mojweb's Profile") Replied by *[mojweb](/forum/user/5128-mojweb "View mojweb's Profile")* on topic *[Error on cron activation](/forum/44-mass-actions/909337-error-on-cron-activation#366686 "-- 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.")* 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy85MDkzMzctZXJyb3Itb24tY3Jvbi1hY3RpdmF0aW9uP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86324 - Thank you received: 14286 - - 1 year 6 months ago [\#366691](#366691) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Error on cron activation](/forum/44-mass-actions/909337-error-on-cron-activation#366691 "-- 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.")* 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy85MDkzMzctZXJyb3Itb24tY3Jvbi1hY3RpdmF0aW9uP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[mojweb](/forum/user/5128-mojweb "View mojweb's Profile")** - [![mojweb's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/5128-mojweb "View mojweb's Profile") Topic Author - [ Offline](/forum/user/5128-mojweb) Less More - Posts: 431 - Thank you received: 22 - 1 year 6 months ago [\#366698](#366698) by [mojweb](/forum/user/5128-mojweb "View mojweb's Profile") Replied by *[mojweb](/forum/user/5128-mojweb "View mojweb's Profile")* on topic *[Error on cron activation](/forum/44-mass-actions/909337-error-on-cron-activation#366698 "-- 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.")* 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy85MDkzMzctZXJyb3Itb24tY3Jvbi1hY3RpdmF0aW9uP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86324 - Thank you received: 14286 - - 1 year 6 months ago [\#366702](#366702) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Error on cron activation](/forum/44-mass-actions/909337-error-on-cron-activation#366702 "-- 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.")* 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy85MDkzMzctZXJyb3Itb24tY3Jvbi1hY3RpdmF0aW9uP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[mojweb](/forum/user/5128-mojweb "View mojweb's Profile")** - [![mojweb's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/5128-mojweb "View mojweb's Profile") Topic Author - [ Offline](/forum/user/5128-mojweb) Less More - Posts: 431 - Thank you received: 22 - 1 year 6 months ago [\#366718](#366718) by [mojweb](/forum/user/5128-mojweb "View mojweb's Profile") Replied by *[mojweb](/forum/user/5128-mojweb "View mojweb's Profile")* on topic *[Error on cron activation](/forum/44-mass-actions/909337-error-on-cron-activation#366718 "-- 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.")* 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy85MDkzMzctZXJyb3Itb24tY3Jvbi1hY3RpdmF0aW9uP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86324 - Thank you received: 14286 - - 1 year 6 months ago [\#366722](#366722) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Error on cron activation](/forum/44-mass-actions/909337-error-on-cron-activation#366722 "-- 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.")* 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy85MDkzMzctZXJyb3Itb24tY3Jvbi1hY3RpdmF0aW9uP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[mojweb](/forum/user/5128-mojweb "View mojweb's Profile")** - [![mojweb's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/5128-mojweb "View mojweb's Profile") Topic Author - [ Offline](/forum/user/5128-mojweb) Less More - Posts: 431 - Thank you received: 22 - 1 year 6 months ago [\#366743](#366743) by [mojweb](/forum/user/5128-mojweb "View mojweb's Profile") Replied by *[mojweb](/forum/user/5128-mojweb "View mojweb's Profile")* on topic *[Error on cron activation](/forum/44-mass-actions/909337-error-on-cron-activation#366743 "-- 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.")* I did that already several times. It doesnt work. Please help me resolve this. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy85MDkzMzctZXJyb3Itb24tY3Jvbi1hY3RpdmF0aW9uP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86324 - Thank you received: 14286 - - 1 year 6 months ago [\#366754](#366754) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Error on cron activation](/forum/44-mass-actions/909337-error-on-cron-activation#366754 "-- 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.")* Please provide a backend access via our contact form: [ www.hikashop.com/support/contact-us.html](https://www.hikashop.com/support/contact-us.html) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy85MDkzMzctZXJyb3Itb24tY3Jvbi1hY3RpdmF0aW9uP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[mojweb](/forum/user/5128-mojweb "View mojweb's Profile")** - [![mojweb's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/5128-mojweb "View mojweb's Profile") Topic Author - [ Offline](/forum/user/5128-mojweb) Less More - Posts: 431 - Thank you received: 22 - 1 year 6 months ago [\#366759](#366759) by [mojweb](/forum/user/5128-mojweb "View mojweb's Profile") Replied by *[mojweb](/forum/user/5128-mojweb "View mojweb's Profile")* on topic *[Error on cron activation](/forum/44-mass-actions/909337-error-on-cron-activation#366759 "-- 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.")* 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](/forum/user/63-nicolas "View nicolas's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy85MDkzMzctZXJyb3Itb24tY3Jvbi1hY3RpdmF0aW9uP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.113 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)