Holiday Notice – Support Unavailable on April 18 and April 21
We just wanted to let you know that our support team will be offline on Friday, April 18th (Good Friday) and Monday, April 21st (Easter Monday) due to the holidays.
We'll be back on Tuesday, ready to assist you!
In the meantime, if you need any help, feel free to:
-
Use the support widget in the bottom right corner on our websites (Amelia and wpDataTables) — our latest AI-powered assistant is there 24/7 to help with basic and intermediate questions,
-
Browse our detailed documentation (Amelia, wpDataTables)
-
Explore helpful articles,
-
Or check out our YouTube channels for video guides!
Amelia YouTube Channel
wpDataTables YouTube Channel
Thank you for your understanding, and we wish you a wonderful holiday weekend!
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