danielrvt Posted June 8, 2018 Share Posted June 8, 2018 If I set a new currency and I try to set the exchange rate to: 2500000 (Or any number over 1000000), when I click save it get overwritten by: 99999.99999. What happened to the rate I set. I does not seem to be getting saved. How can I get around this? PD: This is the description for that DB Table: # col type null? default 6 rate decimal(10,5) No 1.00000 0 Quote Link to comment Share on other sites More sharing options...
danielrvt Posted June 10, 2018 Author Share Posted June 10, 2018 I finally worked this out. What I did was changing the "rate" column type from DECIMAL(10,5) to DECIMAL(15,5). Adding 5 more slots did the magic. I still don't know if this can cause any problems when updating. 0 Quote Link to comment Share on other sites More sharing options...
brian! Posted June 11, 2018 Share Posted June 11, 2018 Hi Daniel, 15 hours ago, danielrvt said: I still don't know if this can cause any problems when updating. it shouldn't when updating the currency - but just remember to check the table structure after you update WHMCS... I doubt minor updates will make changes to the database table, but major releases might (e.g v7.6 or v8 etc). 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.