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
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.
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.
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?
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.
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
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
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
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
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
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