I was populating many date as this format "Ymd" in order to easily sort it by programming, and when I use SQL WpDatatables with the format Date , he was able to compute it with the format d/m/Y as we're in france .
Now since few months I had some issues and he puts me 22/08/1970 as date for every date he found in display .
Do you have any idea, is it a regression , it was working during 6 months.
Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.
Also point me to the table ID where this issue happens so I can take a look.
Unfortunately, I can not deliver you access to may production area . is appear.in are supported with me ?
My room is appear.in/bgo
My Version is the V2.2 .
The format of my data are string in the MYSQL database like 20180521 to ensure Ascending and descending sort even in string as in numeric . By the past the Format Date was finding that we can put 21/08/2018 on this STRING attribute. But since few times I have seen this behavior happening ;
I don't succeed to FIX the problem .
What is strange is that some tables are well working , however. and one is not .
Doo you have any idea of how to fix it ?
NB : issue is on the last field with 22/08/1970 and all the date are displaying 22/08/1970.
Can you please update the plugin to 2.2.1 version.
The list of all available formats are in the wpdatatables settings page ( attachment). Probably there is an issue with the format that is in database so can you please try to make a table which will have the same date format as the format from the database.
Also if your query is complex ( have a lot of functions) try to create VIEW in phpmyadmin or any other database management system and see if it will return desired results. If the result is good you can use that query as an input ( SELECT * FROM VIEW_name) when creating tables with add from data source option.
Hi ,
I was populating many date as this format "Ymd" in order to easily sort it by programming, and when I use SQL WpDatatables with the format Date , he was able to compute it with the format d/m/Y as we're in france .
Now since few months I had some issues and he puts me 22/08/1970 as date for every date he found in display .
Do you have any idea, is it a regression , it was working during 6 months.
HI Beber31,
Thank you for your purchase.
Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.
Also point me to the table ID where this issue happens so I can take a look.
Best regards.
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 Bogdan, could we do a WEBEX or a gotomeeting now ?
Thanks
HI Beber31,
Unfortunately we do not support WEBEX, Skype, TeamViewer etc calls.
Can you please tell me which version of our plugin do you use.
Best regards.
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 Bogdan,
Unfortunately, I can not deliver you access to may production area . is appear.in are supported with me ?
My room is appear.in/bgo
My Version is the V2.2 .
The format of my data are string in the MYSQL database like 20180521 to ensure Ascending and descending sort even in string as in numeric . By the past the Format Date was finding that we can put 21/08/2018 on this STRING attribute. But since few times I have seen this behavior happening ;
I don't succeed to FIX the problem .
What is strange is that some tables are well working , however. and one is not .
Doo you have any idea of how to fix it ?
NB : issue is on the last field with 22/08/1970 and all the date are displaying 22/08/1970.
HI Beber31,
Can you please update the plugin to 2.2.1 version.
The list of all available formats are in the wpdatatables settings page ( attachment).
Probably there is an issue with the format that is in database so can you please try to make a table which will have the same date format as the format from the database.
Also if your query is complex ( have a lot of functions) try to create VIEW in phpmyadmin or any other database management system and see if it will return desired results. If the result is good you can use that query as an input ( SELECT * FROM VIEW_name) when creating tables with add from data source option.
Best regards.
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