Can you submit a link to the page or demo page displaying your issues?
http://flavorchemists.com/test-page
Please note that I’m actively testing this page, so your results may be different if any significant amount of time has passed.
I figured out part of the problem. The plugin is not fully PHP 7+ compatible.
Line 643 in class/members.php should be
return mysqli_real_escape_string($s);
(It is still using mysql_real_escape_string(), which is deprecated)
Searching does not work in PHP 7+ unless that change is made.
I updated that line, and stopped getting the 500 errors that I was getting, but you will observe that the search still does not work.
The zipcode search works. But the regular search and the alphabetized click list always return all results.
Thank you for tracking down the issue with PHP 7+.
I can see the searching and filtering is not working. This is normally due to the query parameters being filtered out of the REQUEST $_GET data somehow. Can you confirm the variables specified in the URL are available to the plugin?
Ok, I figured it out. It’s all related to that mysqli_real_escape_string($s);
You can’t use mysqli without a mysqli_connect(), and there isn’t one. Since it processes the search parameters, they weren’t coming back.
Note that you also use mysql_real_escape_string() in class/forms.php on line 116 and 117.
For now, I’ve solved my problem by changing
Line 643 in class/members.php to
return addslashes($s);
It’s not the exact same thing, but it seems to be working fine.
I’ve moved the test page back behind our users-only limitation.
If you need it for something, please let me know.
We can consider this topic resolved.
