Joomla 3.6.5
Moodle 3.1
HikaShop 2.6.4
Joomdle 1.0.8 with the latest HikaShop plugins
Our website uses HikaShop to list the courses and for course purchase. Joomdle is showing all green checkmarks in the System Check. The shop connection is enabled and working. Everything is setup just as it should be, and has been working. Lately though, with increasing frequency, we are having issues.
Some orders placed result in the user not being enrolled in the courses they purchased. It happens with the purchase of a single course, multiple courses, and bundles. It is sporadic though as not all users have the issue. We have orders placed every day for courses and most are fine.
We find that when the issue occurs, not only is the user not enrolled in the courses purchased, but they don't get the normal order email from HikaShop, nor do we get the typical email that there was an order.
At first I thought it was our hosting, as we were having sporadic issues with the reliability of the hosting. I have moved the website to new hosting, and the availability issues are resolved, but this issue remains.
Any attempts of mine to reproduce this issue have failed. I have placed countless orders on the website without any issues at all. Users though continue to have this issue. It happens at least once every day or two.
I have been able to work with a couple orders that were having this issue and have this information to share. Within HikaShop I changed the order status from confirmed to created and then tried changing it back. The web page just "spun", and eventually errored out with a 503 error. Upon looking at the order in HikaShop the order status did indeed change to confirmed, but the user was never enrolled in the course. I could repeat that process with the same results every time.
I also found that within the hosting account while the website was "spinning" during the order status change to confirmed that the CPU and memory for the hosting account spiked incredibly. I have not been able to look into that further though to find out exactly what was causing them to spike.
I also found that for users that were having this issue with orders, name changes within Joomla were also having issues. Upon saving the user record the website would "spin" again, and eventually error out again with a 503 error. I noticed the same memory and CPU spikes during the name change as I did with the changing of the order status.
This issue though with changing name does not happen with all users. It appears to be isolated to just those users having issues getting enrolled after placing an order.
I have another website with an identical configuration for a different client that does not have any of these issues. So this confuses me even more.
I am wondering if anyone has ever had similar issues, and if so how did you fix them? Or does anyone have any thoughts or ideas on how I can approach debugging this further?
