X-Cart: shopping cart software

X-Cart forums (https://forum.x-cart.com/index.php)
-   Third Party Add-Ons for X-Cart 5 (https://forum.x-cart.com/forumdisplay.php?f=64)
-   -   UPS module keeps switching itself off (https://forum.x-cart.com/showthread.php?t=75988)

kontrabass_forum 02-14-2018 07:54 AM

UPS module keeps switching itself off
 
Hi!

I have our UPS module set up, it gets rates and works fine testing in checkout. But every day or so it switches itself to "inactive" and I have to activate it again. Any ideas on where to start troubleshooting?

Thanks!

cflsystems 02-14-2018 08:04 AM

Re: UPS module keeps switching itself off
 
Database problem. I have a client where UPS and FedEx will turn off on its own around early morning hours every day.

The only thing we got from XC support when they fixed the issue was
Quote:

There were some discrepancies in the store database (in the "xc_shipping_methods" table).

Shipping was setup from admin to begin with and redone few times in a hope redoing it will remove the problem but it doesn't. I suspect it is an XC issue to begin with but it doesn't happen often or it may be due to environment or some momentum glitch.

Anyway - you probably have incorrect database entries in this table or related ones which will cause the shipping to go off.

kontrabass_forum 02-14-2018 08:12 AM

Re: UPS module keeps switching itself off
 
Quote:

Originally Posted by cflsystems
Database problem. I have a client where UPS and FedEx will turn off on its own around early morning hours every day.

The only thing we got from XC support when they fixed the issue was


Shipping was setup from admin to begin with and redone few times in a hope redoing it will remove the problem but it doesn't. I suspect it is an XC issue to begin with but it doesn't happen often or it may be due to environment or some momentum glitch.

Anyway - you probably have incorrect database entries in this table or related ones which will cause the shipping to go off.


Thank you I think that may have been it. I had over 200 records in the xc_shipping_methods table and it looked like a mess. I deleted all the rows from that table (except my 3 offline methods), uninstalled UPS and then installed it again. I now have 38 records in that table and it looks very clean. I bet that fixed it but won't know for sure until tomorrow :)

Thanks!

cflsystems 02-14-2018 08:23 AM

Re: UPS module keeps switching itself off
 
I hope it works for you


All times are GMT -8. The time now is 08:31 AM.

Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.