What’s the status of this topic?
Thanks,
Peter
I get this message within your plugin, not from Apache:
“ERROR: Invalid table name or not authorized”
Sorry I didn’t respond earlier-I answered email instead of posting to this support forum.
Rick
Thank you for your reply Rick!
Sounds like a conflict with another plugin or another resource. Argument schema_name might be used by another plugin which is loaded before WP Data Access and expects. Since this is a localhost, can you try switching off some plugins to see what happens?
Thanks,
Peter
Peter-
All plugins deactivated with the same results. I also tried deactivating yours and reactivating, but no luck. Is there a log I can send for you to evaluate? I have modsecurity2 on my apache installation, but have set “SecRuleEngine DetectionOnly”.
Rick
Peter:
A little progress. I deactivated modsecurity2 and now the link:
http://localhost/wordpress/wp-admin/admin.php?page=wpda&schema_name=olli
works but the last two give the same results. I can see the results of the “participation” table if I click “Explore” in your plugin and the “Manage” button seems to work as well.
Rick
Hi Rick,
Thank you for your reply! You can ignore the errors on those last two URLs. They were just meant for testing. When the URLs containing the schema_name work, you’re fine.
I know some other plugin users were having similar issues but we never found out why. Thank you for being so persistent! Now we at least know what the cause of the problem is.
I need to investigate if there is a way around this issue with modsecurity2. If not, you won’t be able to use it. Would that be a problem for you?
Best regards,
Peter
Peter-
And thank you for being so responsive. I can do without modsecurity2, but would prefer to have it activated. If you like, I can send you one of the appropriate lines from the log.
Of note is that modsecurity2 also interferes with phpmyadmin in some cases.
Rick