MySQL CRUD search not working.

[drosen001]

Created a simple database of 3 fields and am trying access it using MySQL CRUD control Adding a record works, but searching doesn't, always returns no records found.

Geting this error (hostname removed).

AH01215: PHP Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /var/www//wb.mysql.crud.php on line 133: /var/www/cgi-bin/cgi_wrapper/cgi_wrapper, referer: http:..../unsubscribe.html

Also, one of the fields is a date. Is there any way to have it default to today's date?

[Pablo]

It is difficult to say anything meaningful about this without knowing the context of the error.
To be able to help you, I need to know all settings, the URL of the page, the PHP code and the database structure.

It works for me, as you can see here:
https://www.wysiwygwebbuilder.com/support/mysqlcrud.php

[drosen001]

1. What PHP code are you referring to?

2. I don't see any items listed when I go to my page?

3. I would prefer the URL not be posted in a public forum as this is live data with user's email addresses. Is there a way to send it to you privately?

[alan_sh]

1. What PHP code are you referring to?

2. I don't see any items listed when I go to my page?

3. I would prefer the URL not be posted in a public forum as this is live data with user's email addresses. Is there a way to send it to you privately?

I would suggest that, while you are testing, you create a dummy page with dummy data. It's never good to work on live data for the very reason you suggest - it could go public if you are not careful - which would fall foul of GDPR and could end up with a large fine.

[Pablo]

1. What PHP code are you referring to?

In the workspace go to Page -> Page HTML

I don't see any items listed when I go to my page?

Are you sure all settings are correct?
Did you set a primary key, as documented in the PDF?

I would prefer the URL not be posted in a public forum as this is live data with user's email addresses. Is there a way to send it to you privately?

The best way to test new functionality is creating a DEMO project with only the extension and nothing else. Then you can also rule out potential conflicts with other scripts.

Note that I can only help you, if I know exactly what you have done.