Help with report builder

4 posts by 2 authors in: Forums > CMS Builder: Plugins & Add-ons
Last Post: August 29, 2019   (RSS)

By JeffC - August 29, 2019

Hi, I am probably missing something really basic. I have created a report, but the screen is blank.

I have a table called registration_forms, with a checkbox field called facebookmarketing. I would like my report to display all records where facebookmarketing is checked.

SELECT
    title
FROM `<?php echo $TABLE_PREFIX ?>registration_forms`
WHERE facebookmarketing='1'
LIMIT 1000
Jeff

By daniel - August 29, 2019

Hi Jeffncou,

You've got the right idea in your example, so there may be something less obvious going on. When you say the screen is blank, does that mean that the page does not load, or that it just returns no rows? If the page does not load, could you check the Developer Log to see if any errors show up when you try to load the report? Also, do you have any other reports that are working?

Thanks,

Daniel
Technical Lead
interactivetools.com

By JeffC - August 29, 2019

Thanks for pointing me in the right direction. I didn't think to look in the developer log.

The developer log says: _ERROR: Call to undefined function mysqli()

This site is running version 3.07 and using php 5.6.4, so my first action should probably be to get everything up to date.

To be honest I've been avoiding it because you've done quite a bit of custom code to it and I am worried that something mysqli related is going to break – but I have to take the plunge at some point!

Jeff