Home › Forums › Product Support Forums › Ajax Search Pro for WordPress Support › Cron Job zeros after product import
This topic contains 4 replies, has 2 voices, and was last updated by oMouxtis76 1 year, 11 months ago.
- AuthorPosts
- April 3, 2021 at 12:36 am #32538
Hello dear friend.
The cron job you told me to enable is working good but i am facing a new issue now. While the cron job was working well and indexing i wanted to import some products to my shop with an extesion that i use and the cron job stopped suddenly and everything went back to zero .All the indexed keywords went to zero directly and didn’t restart alone. I had to repress create new index for the cron job to start again. This is the second time it happens. I already deactivated the Index new posts upon creation but is still giving the same result.
Any ideas? why it does that?
Kind regards awaiting your replyApril 3, 2021 at 8:34 am #32543Hi,
It may only show 0 if the database query was not able to complete the counting task. Counting rows in the database is actually a very resource heavy task (MySQL flaw), so it may sometimes time out and simply report 0. The index is very likely still all right.
Best,
Ernest Marcinko
If you like my products, don't forget to rate them on codecanyon :)
April 3, 2021 at 12:23 pm #32545Ok is good to hear that. But is it normal for the stats to not show even after 24 hours that i stopped importing products?? Is there any test i can do to check it? Or something in my sql database?
April 3, 2021 at 12:32 pm #32546Yes, if it does not show up now, then it probably won’t show up anymore. You can’t really do anything to check unfortunately. This is a general issue with mysql, not your databse. Calculating rows is the issue, unfortunately there is no way of getting around it.
Best,
Ernest Marcinko
If you like my products, don't forget to rate them on codecanyon :)
April 3, 2021 at 12:36 pm #32547Well if its only that the issue of not showing then its fine as long as it’s working in the background. I will be doing some test with my search bar and some keywords after a few days when it will index things. I thought it stopped working and restart the process unfortunately. But no problem i will wait and check again.
Thank you - AuthorPosts
You must be logged in to reply to this topic.