rebarsan
Forum Replies Created
-
I should add that the plugin seems to work on my development server, but not on my host, InMotion.
Data Base Connection works well.
The problem seems to be running a function in a VIEW that is then displayed by your plugin. Other VIEW’s work well.
I have a function named “anon” (which takes 2 parameters) and when I have a VIEW with this:[SELECT…
members.last_nameASlast_name,
…]your plugin works, but when I use the function as in:
[SELECT…
anon(members.anonymous,members.last_name) ASlast_name,
…]the plugin does not work. The VIEW itself works well.
Have you tried a query containing a function? If it doesn’t work, do you have a suggested “work around”?
Many thanks, RickPeter-
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.
RickPeter:
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
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”.
Rickhttp://localhost/wordpress/wp-admin/admin.php?page=wpda
OKhttp://localhost/wordpress/wp-admin/admin.php?page=wpda&schema_name=olli
From Apache:
Forbidden
You don’t have permission to access this resource.
Apache/2.4.29 (Ubuntu) Server at localhost Port 80http://localhost/wordpress/wp-admin/admin.php?page=wpda&table_name=participation
From plugin:
ERROR: Invalid table name or not authorizedhttp://localhost/wordpress/wp-admin/admin.php?action=listtable
Interface “hangs”-No responsePlugin updated to Version 3.1.3 this morning.
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