select * from wp_subscribers where deleted = '0' This brings back a column of type INT containing a Unix timestamp which I want to display as DateTime. Therefore, I have changed the column type to DateTime in WP DataTables. However this results in "01.01.1970 00:00" for every entry. How to fix?
Miljko is currently on vacation so I will try to help you. There are some reserved words from Wordpress and MySQL for column names and it can be very tricky to found the source of the issue. Here you can take a look which of the words are reserved - Link.
Can you please provide me temporary WP admin credentials so I can take a look at your table. You can write credentials here but please check the Private replay so nobody can see it except us.
I use the query:
select * from wp_subscribers where deleted = '0'
This brings back a column of type INT containing a Unix timestamp which I want to display as DateTime. Therefore, I have changed the column type to DateTime in WP DataTables. However this results in "01.01.1970 00:00" for every entry. How to fix?
Hi Frank,
This is little bug on our side. Please find this file
../wp-content/plugins/wpdatatables/source/class.datetime.wpdatacolumn.php
and in it around line 42
and change it to
Thank you for reporting this. We will include solution for this problem in next version of our plugin.
Worked like a charm - thanks Miljko!
Hi Frank,
Thank you for your purchase.
Miljko is currently on vacation so I will try to help you.
There are some reserved words from Wordpress and MySQL for column names and it can be very tricky to found the source of the issue.
Here you can take a look which of the words are reserved - Link.
Can you please provide me temporary WP admin credentials so I can take a look at your table.
You can write credentials here but please check the Private replay so nobody can see it except us.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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
Hi Frank,
Thank you for reporting this.
We will release the update again and it will be on codecanyon in 2-3 days.
Please find this file
../wp-content/plugins/wpdatatables/source/class.datetime.wpdatacolumn.php
and in it around line 42
and change it to
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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
Hi Frank,
Please provide me a temporary WP-admin login for your site I will need it to investigate this.
You can write credentials here just check Private Reply so nobody can see them except us.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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