Skip to main content

Error In table Design.

Hi Shahjahan Jewel I'm customising my FluentCrm install and in the process of migrating from AWeber to FluentCRM.
I'm writing longitude and latitude information into the wp_fc_subscribers table and noticed that longitude values above -99.999 etc for example 150.9999 were getting written as -99.99 repeating, this is because the the latitude and longitude fields are declared as decimal(10, 8) whereas they should be declared as decimal (11,8) (unless I've missed something). I'm issuing alter table commands on my install to fix this issue, however it means a lot of my older data will have incorrect values due to this.
Maybe you need to fix this going forward?
I'm using an ip service to get these values combined with my own self designed ajax opt in forms.
Best Regards
Sean