Ok, on the forms that work I get LIMIT 0,10000 and on those that dont work I get LIMIT -1,10000
If I paste the query in phpmyadmin and change the limit from -1 to 0 the query executes corectly.
Why there is a different parameter in the LIMIT depending on the form?
Many thanks.
@advertisingtech the -1 is a bug but it come from when there are zero count of entries detected. But the larger bug is that the drop-down lists the form name, indicating it sees some kind of entry. But the subsequent fetch of the items returns nothing. I haven’t been able to recreate that situation myself.
What might be helpful for me is if can share with me data in the DB associated with such a form. Run this query (using your form name) then send me the results [email protected]
SELECT * FROM wp_cf7dbplugin_submits WHERE form_name = 'YOUR-FORM-NAME'
@tom1975 I think getting some example data is more useful at this point then looking at your site.
Thanks.
So which example data you want?
And how can I gave it to you?
@tom1975 contact me at [email protected] and maybe I can take a look at the site.