Comments 2compasssites started the conversationFebruary 17, 2017 at 4:22pmHi, Not able to enter decimals even after changing the column type to FLOAT. Not able to do it even in the PHPmyadmin database. It gets rounded off automatically.Am i missing something? 1,689Miloš repliedFebruary 17, 2017 at 5:28pmHi compasssites,Thank you for your purchase.Did you checked on wpDataTables Settings page is there any number in Decimal places field.Kind Regards, Miloš Jovanović[email protected] Rate my support wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community You can try wpDataTables add-ons before purchasing on these sandbox sites: Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables 2compasssites repliedFebruary 17, 2017 at 5:54pmyes I did that. Played around with it but no success. Intact directly editing the MySQL table with phpmyadmin is also not showing decimals. It's truncating. Error 1265. Not able to workaround. Thanks. 1,689Miloš repliedFebruary 20, 2017 at 7:41pmHi compasssites,Can you please check in database does the the type for that column is set to float(16,4).Thank you.Kind Regards, Miloš Jovanović[email protected] Rate my support wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community You can try wpDataTables add-ons before purchasing on these sandbox sites: Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables 2compasssites repliedFebruary 22, 2017 at 7:21amSolved the decimals issue by editing the database in phpmyadmin and changing to FLOAT 16. It solved, you may close this ticket.Thanks1 Like Sign in to reply ...
Hi,
Not able to enter decimals even after changing the column type to FLOAT. Not able to do it even in the PHPmyadmin database. It gets rounded off automatically.
Am i missing something?
Hi compasssites,
Thank you for your purchase.
Did you checked on wpDataTables Settings page is there any number in Decimal places field.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
yes I did that. Played around with it but no success.
Intact directly editing the MySQL table with phpmyadmin is also not showing decimals. It's truncating. Error 1265.
Not able to workaround.
Thanks.
Hi compasssites,
Can you please check in database does the the type for that column is set to float(16,4).
Thank you.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Solved the decimals issue by editing the database in phpmyadmin and changing to FLOAT 16. It solved, you may close this ticket.
Thanks