Unknown column error in publisher

Hello Peter,

Yes it does look like I used double quotes or back ticks on the meta key value. However I did use single quotes the same as I did for the query that did work. Here is the where clause I used in the publication:

meta_key = ‘wdm_incremental_val’

Thank you for the quick reply,
Jeff

Hello Peter,
I turned on the debug mode, but only see a different message. Viz

DataTables warning: table id=wp5k_postmeta9 – You have an error in your SQL syntax; check the manual
that corresponds to your MariaDB server version for the right syntax to use near
‘'wdm_incremental_val&#039’ at line 1

Although it does not show in the string, there is an ending semicolon at the end of the submitted line.

Hello Peter,

Am not sure if this will help. I made a staging site, repointed the publication to the new database and correct table name and confirmed I am still getting the error. Here is a link to the page:

https://staging.malahatlegion.ca/wp-admin/admin.php?page=wpda_publisher&table_name=wp5k_wpda_publisher

I can give you admin access to the staging site if there is some way I can give you a user name in private email.

Please advise.

Cheers,
Jeff

Hi Peter,

I’ve just been using the test mode to see the publication worked. I’ve since put the shortcode on a page but see no difference with debug enabled. Debug is turned on in the data access plugin. On checking the wp-config.php file, debug is turned on, but WP_DEBUG_DISPLAY is turned off.

Here is a link to the page. I can’t see where to enter a url that can only be viewed by logged in viewers so have put it in below.

https://staging.malahatlegion.ca/auction-meta/

Hope this helps,
Jeff