Same issue. Called the hosting company and they said that the connection with the database was stuck in a loop and they manually terminated it on their end and that I shouldn’t use the script until it is fixed. I am not an IT person so if this is correct or not I have no idea.
Stupidly enough I did yep and it was fine if doing 1 page at a time with the default 20 products.
But then I accidentally half way through clicked select all rather than select visible.. And it’s stuck processing right now as I’m writing this lol problem is yes it was stupid of me to use it again, but st the same time in terms of sales value it’s quite an important thing to be using.
Because it works seemingly with 20 products at a time fine.. I’m guessing something like the php settings timeout.. Leaving it stuck processing.
Because there’s a value in php that defines the timeout time and memory usage and things.
So possibly script runs.. Reaches a time or memory limit, php pulls the plug, leaving it stuck in that state
I’ve tried all of above, still no joy.... :( Initially tried just reinstall. Still continues to spin synchronising. Then tried complete uninstall then re-install, no joy there. Then tried increasing memory to 512M, and then uninstalling and reinstalling, still loops in exact same place....... and will eventually time out. Any other ideas how to remedy? Not sure why it occurs in 1st place, worked fine for weeks, then seemed to break when adding another store in.