MythonPonty Posted October 18, 2022 Posted October 18, 2022 Hi. after upgrading my community to 4.7.3 the views doesn't count up. Take a look at the screen. https://poeten.de
opentype Posted October 18, 2022 Posted October 18, 2022 Check that your Cron job is running. Maybe it stopped working after you updated PHP or something like that.
MythonPonty Posted October 18, 2022 Author Posted October 18, 2022 My task is still running and did not finish. I've started manually this task but nóthing change And i don't have an error log
Marc Posted October 18, 2022 Posted October 18, 2022 It will run only so many at a time, so it wouldnt update all of them instantly. Are you seeing any errors being returned from your cron?
MythonPonty Posted October 18, 2022 Author Posted October 18, 2022 7 hours ago, Marc Stridgen said: Are you seeing any errors being returned from your cron? No, unfortunately I don't see any error message.
Jim M Posted October 18, 2022 Posted October 18, 2022 We would need to look further into this for you, however the access details on file appear to be incorrect or missing. Could you please update these details by visiting your client area, selecting the relevant purchase, then clicking "Review/Update Access Information" under the "Stored Access Information" section. We look forward to further assisting you. MythonPonty 1
MythonPonty Posted October 18, 2022 Author Posted October 18, 2022 10 minutes ago, Jim M said: We look forward to further assisting you. Thank you... I've updated my information
Jim M Posted October 18, 2022 Posted October 18, 2022 I unlocked the background task and was able to run it a few times manually without errors. That should be resolved now as I see views updating now. Please also keep in mind, as you are not using CRON, the background tasks are ran via traffic so if you do not have a lot of traffic, these will be slow to process.
MythonPonty Posted October 22, 2022 Author Posted October 22, 2022 On 10/18/2022 at 8:05 PM, Jim M said: Please also keep in mind, as you are not using CRON, the background tasks are ran via traffic so if you do not have a lot of traffic, these will be slow to process. Thanks @Jim M I've changed the task method by open the url via a cronjob at my server, every minute. Nothing changed.
Marc Posted October 24, 2022 Posted October 24, 2022 It will take quite some time to catch up, as it will have quite a few to go through with it having not been running
MythonPonty Posted November 19, 2022 Author Posted November 19, 2022 @Marc Stridgen @Jim M Can i try it again with a query ? It doesn't work and maybe the task can't update this ! It's very annoying 😕 Do you have an idea what i can do ? Run a sql query or something else ?? Thank you very much !
Miss_B Posted November 19, 2022 Posted November 19, 2022 Have you considered upgrading to the latest version, 4.7.4? Maybe that will fix the issue.
Jim M Posted November 19, 2022 Posted November 19, 2022 Seems that the view counts are working, they are just slow to update. As there are counts on November 12th which have updated. I see you're using a web cron service, have you configured this to run every minute?
MythonPonty Posted November 19, 2022 Author Posted November 19, 2022 1 hour ago, Miss_B said: Have you considered upgrading to the latest version, 4.7.4? Maybe that will fix the issue. Yes, i have upgraded to the latest version. 🙂 1 hour ago, Jim M said: I see you're using a web cron service, have you configured this to run every minute? Yes @Jim M, my cronjob runs every minute. Can i do something manually to push this ? That worked very well before i've updated to 4.7.3... Something happend there !?
Jim M Posted November 19, 2022 Posted November 19, 2022 1 hour ago, MythonPonty said: Yes, i have upgraded to the latest version. 🙂 Yes @Jim M, my cronjob runs every minute. Can i do something manually to push this ? That worked very well before i've updated to 4.7.3... Something happend there !? Are you receiving any errors in the cron service?
MythonPonty Posted November 19, 2022 Author Posted November 19, 2022 how is the workflow running ? First the task collect the data and then the cron processed the collected data ?!
Randy Calvert Posted November 19, 2022 Posted November 19, 2022 In the ACP, there is a list of tasks. Those tasks run on different schedules at different intervals. When the cron is processed, it runs through the list of various tasks. It looks at when it's next scheduled to run and if that time is in the past, it runs it and updates the next run time to be at the next time defined by the frequency. If the time has not occurred yet, (meaning the next scheduled run time is still in the future), it skips over it. I would first confirm your web cron is actually working. I would also confirm if it's making remote calls instead of being done locally that your server's firewall is not rate limiting it or blocking it in any way. (If you're making the request EVERY MINUTE, some firewalls might see that as an attack and try to limit what it can do.) I would also suggest looking into if your hosting service provides the ability to run cron jobs locally. It's generally MUCH more reliable than externally triggered crons. MythonPonty 1
MythonPonty Posted November 20, 2022 Author Posted November 20, 2022 (edited) Yes my cronjob is running well, as a URL call. At my develop environment (same server), it works well. Just my live community have this problem. Are there any temporary data which i can delete, so it starts the next task with no data ?! 23 hours ago, Jim M said: Are you receiving any errors in the cron service? No, i get no error messages just this message Quote The task "https://xxx.de/applications/core/interface/task/web.php?key=ab1a3....2abd4070aa" completed successfully in 0 seconds Url 'https://xxx.de/applications/core/interface/task/web.php?key=ab1a3...2abd4070aa' fetched Status: 200 Output: Task Ran Edited November 20, 2022 by MythonPonty
Solution MythonPonty Posted November 20, 2022 Author Solution Posted November 20, 2022 I did this update manually by myself. 1. First i took a look into the table core_view_update... Result --> nearly 195.000 unprocessed entries. 2. Then i export the table entries into a csv file. 3. truncate the table core_view_update 4. group the entries in my csv file 5. import the grouped entries into my forums_topics table Result Now i'll check the next days my tasks / cron jobs. At this moment it looked normally
Marc Posted November 21, 2022 Posted November 21, 2022 It does need to be noted, we would not advise on the action you have taken there. We can only really advise on the cron job being corrected if you are having issues
Recommended Posts