Ruben
Forum Replies Created
-
Forum: Plugins
In reply to: [dbview] [Plugin: dbview] Table Doesn't ExistTHAT WORKED!!!
Thank you John. Will be contributing soon!
Regards,
RubenForum: Plugins
In reply to: [dbview] [Plugin: dbview] Table Doesn't ExistFYI: I have get_magic_quotes_gpc function disabled on my PHP installation. I noticed you call this function in your code.
Forum: Plugins
In reply to: [dbview] [Plugin: dbview] Table Doesn't ExistFollow up: I’ve been able to pull data back with simple queries. It seems that only queries that include WHERE, LIKE or similar clauses seem to error out.
Forum: Plugins
In reply to: [dbview] [Plugin: dbview] Table Doesn't ExistNot sure if it helps, but I’m using MySQL Server Version 5.0.95
Forum: Plugins
In reply to: [dbview] [Plugin: dbview] Table Doesn't ExistNo problem. Thanks!
Here’s the ‘List views’ load, with ONLY the table reference updated to reflect my actual options table name:
select option_name as name, option_value as v1, option_value as v2, option_value as v3 from wp_shoplocaloptions where option_name like \”dbview%\”
Forum: Plugins
In reply to: [dbview] [Plugin: dbview] Table Doesn't ExistHello John,
Thanks for the quick follow up. I have tried both of your suggestions and still experiencing the same errors. Here are the details:
I deactivated plugin and reactivated. Same issue as in my original post.
I loaded ‘List views’, made the table reference correction, saved it, then executed query. Here’s the error result I got:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘\”dbview%\”‘ at line 1