qtwrk Posted October 2, 2022 Share Posted October 2, 2022 Hi, my friend has a oscommerce site with some customization I think , by reading from PHP script , the programmer who built it is no long aler in contact with him recently he wants to migrate hosting from his current provider due resources restriction on shared hosting , in which I happen to have an OVH server , so I migrated his site over my server , on the surface it works fine but from time to time , the admin area is having weird issue 1) sometimes the order will be duplicated , the amount/product/quantity are exact same but timestamp is like 1 - 2 seconds difference , not sure if it's coincidence , it seems the chance for duplication is multiple times higher with CloudFlare proxy , but seems less happens without CF 2) sometimes after the order edit , the order will disappear from the order list , it is still in the database , I checked the tables , and the column order_status = 0 currency = empty currency_value = 0.0000 once I manually update them to 1 , EUR , 1.0000 respectively , the order shows up in the order list again , but it won't allow him to do any edit , so far I have been manually edit it directly from database for him as temp workaround, but this is not exactly a good solution my current is MariaDB 10.5.17 , where his previous provider was 10.5.16 , is it even possible for a minor version difference could cause all of these ? I also carefully look through the database settings by all the variables I can see from phpMyAdmin , pretty much all the same except I have some higher cache size also attempted to create same PHP version/extension as identical as possible , but seems none of these have any positive effect , the issue still happens from time to time so I have come here to seek help, appreciate any help or hint where I can look into Best regards, Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.