Automatic Status - cron to update automatic status

Post Reply
pepe
Sponsor
Sponsor
Posts: 556
Joined: 25 Aug 2015, 21:35
Name: Pepe
Location: Graz, Austria
Contact:

Automatic Status - cron to update automatic status

Post by pepe »

Hi Sergey,
I have to raise this issue again! Last time we thought it has been solved and, as a matter of fact, Ruko's autostatus.php did work correctly to update all records after you implemented the fix. Today I have tested the Automtic status fields for updating text in filters when using the OR conditions. Please see different posting.
For getting the testing done, I have added a new item in autostatus list with sort position 1 (to move it on top of list) and did add filter with the OR condition. As a result, I can confirm that the OR conditon works with text (like 'red'|'blue'|'green' when editing and saving a given record.
In the next steep, to get back to working conditions, I deleted that entry in list including all filters. Ever since, the autostaus.php cron does not update any records. This issue happened before and has been solved. However, we have the same problem again. After this happened, I updated to 2.3.1 ... same results.
Please look at this problem, I have been so closed to get the system to something that could be released ...
Thank you. Best Pepe
User avatar
support
Site Admin
Posts: 6215
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: Automatic Status - cron to update automatic status

Post by support »

Please provide database and video and I will look.
pepe
Sponsor
Sponsor
Posts: 556
Joined: 25 Aug 2015, 21:35
Name: Pepe
Location: Graz, Austria
Contact:

Re: Automatic Status - cron to update automatic status

Post by pepe »

Hi Sergey,
there are 2 videos to demonstrate the AUTOMATIC STATUS not updating using cron job. The cron on server runs every 5 minutes. Large files are not accepted for upload here, hince, I did send zipped files with private message.
Thank you for looking at the problem.
Best, Pepe
pepe
Sponsor
Sponsor
Posts: 556
Joined: 25 Aug 2015, 21:35
Name: Pepe
Location: Graz, Austria
Contact:

Re: Automatic Status - cron to update automatic status

Post by pepe »

Hi Sergey, any news on this issue? I should give a presentation a.s.a.p. and automatic status is a key feature.
Regards, Pepe
User avatar
support
Site Admin
Posts: 6215
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: Automatic Status - cron to update automatic status

Post by support »

I did not check yet.
User avatar
support
Site Admin
Posts: 6215
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: Automatic Status - cron to update automatic status

Post by support »

I have check your database and there is no issue in code.
Please note that autostatus cron works with fields that have dynamic fields only like formula etc.
Since you don't have filters like this the autostatus cron skip this field. It's because this field will be updated by usual insert/edit action.
But since you have added new field and want to prepare status for already exists records then you can do just multiple update and update some number +0, means it's not updated but in this action we will check autostatus field and update it.
Or second solution you can add second filter by formula for autostatus field and then this field will be checking in cron.
pepe
Sponsor
Sponsor
Posts: 556
Joined: 25 Aug 2015, 21:35
Name: Pepe
Location: Graz, Austria
Contact:

Re: Automatic Status - cron to update automatic status

Post by pepe »

Hi Sergey,
thank you for your help ... I should have known better!
Regards, Pepe
Post Reply