Hey everyone!
With the holiday season upon us, we want to share our upcoming working hours:
- New Year: Our team will be off on January 1st and 2nd. We’ll be back on Friday, January 3rd, to respond to any messages received during this time.
- Weekend: As usual, we don’t work on weekends, so January 4th and 5th will also be non-working days.
- Orthodox Christmas: Our office will be closed on Monday and Tuesday, January 6th and 7th for the holiday.
After that, we’ll return to our regular schedule and assist you as quickly as possible.
In the meantime, you can explore our documentation for Amelia and wpDataTables. You'll find tons of helpful resources, including articles and handy video tutorials on YouTube (Amelia's YouTube Channel and wpDataTables' YouTube Channel), which might just have the answers you need while we’re away.
Thanks a bunch for your understanding and support!
Warm regards and happy holidays!
TMS
Hi,
I'm using wpdatatables with an SQL query and placeholders. It works fine when the query returns rows but I get a warning on top of the page when the result is empty.
Warning: count(): Parameter must be an array or an object that implements Countable in C:\Apache24\htdocs\wordpress\wp-content\plugins\wpdatatables\source\class.wpdatatable.php on line 1870
The query is returning data for the last month so it is supposed return an empty result if there has been no entries. How can I fix this?
select
gh_dpl.dTimeStamp as 'Time Stamp',
max(if(gh_point.sName = 'SUCTION_PRESSURE', gh_dpl.fData, 0)) as 'Suct Press',
max(if(gh_point.sName = 'SUCTION_TEMP', gh_dpl.fData, 0)) as 'Suct Temp',
max(if(gh_point.sName = 'DISCHARGE_PRESSURE', gh_dpl.fData, 0)) as 'Disc Press',
max(if(gh_point.sName = 'DISCHARGE_TEMP', gh_dpl.fData, 0)) as 'Disc Temp',
max(if(gh_point.sName = 'OIL_TEMP', gh_dpl.fData, 0)) as 'Oil Temp'
from gh_dpl_all as gh_dpl, gh_point, gh_site, gh_connection, gh_device
where
gh_device.ConnectionID = gh_connection.ID and
gh_connection.SystemID = gh_site.ID and
gh_site.sName = '%VAR1%' and
gh_device.sName = '%VAR2%' and
gh_point.deviceID = gh_device.ID and
gh_point.id = PointID and
gh_dpl.dTimeStamp > DATE_SUB(NOW(), INTERVAL 30 DAY)
group by gh_dpl.dTimeStamp
Regards Peter
Hi Peter,
Thank you for your purchase.
Can you please tell me does the WP_debug or some error reporting is turned on.
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,
I don't think so. It is a fresh install of WordPress with a few plugins like yours and some login protection. If something needs to be turned of please advise.
Regards Peter
Hi Peter,
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 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,
Our site is not exposed to the internet so that is not possible. I am leaving for Holliday's and won't be back before January. Can we make a Skype session or something similar then?
I am located in Denmark CET
Regards Peter
Hi Peter,
Unfortunately Skype calls are not covered in included support of the plugin but I will give my best to help you out.
Can you please tell me which version of PHP do you use.
It looks like there is some issue on the PHP side and this is happening on the 7.2 version of it found on this link.
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 and Happy New Year,
I'm using PHP 7.2. What is your recommended solution
- Downgrade to 7.1
- Patch class.wpdatatable.php at line 1870 with a check for empty data set
- Something else
Regards Peter
Hi Peter,
Happy New Year.
Can you please first downgrade the PHP version to 7.1 so we can start from that.
Let me know the result.
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,
Using PHP 7.1 with the same settings as 7.2 solved the issue. Thank you for your assistance.
Regards Peter
Hi Peter,
Glad to hear that we managed to find the issue.
It looks like there is some problem with the 7.2 version of PHP that is causing this problems.
If you like our plugin and support we'd greatly appreciate it if you could take a minute and leave a review on CodeCanyon on this link. It means a lot to us. Thanks.
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