WordPress database error Unknown column ‘p.feed_title’ in ‘field list’ for query

Hello Brendon,

This is a known issue where, after an update the database tables are not updated automatically.

Are you able to add two columns to the “feedmanager_product_feed” table? If so please add the following columns:
– First Column: name ‘feed_title’, varchar(100), empty allowed and no standard value
– ??Second Column: name ‘feed_description’, varchar(500), also empty allowed and no standard value

Let me know if you can do this or not.

Thanks for getting back to me. These columns already exist in my table:

8 feed_title VARCHAR 500 NULL NULL
9 feed_description VARCHAR 100 NULL NULL

I have moved them to positions 1 and 2 and changed varchar values to those you stipulate above.

What will this change?

No, moving the columns to the first positions should not effect the issue.

What action are you performing when you get the error?

Sorry, I missed your remark that this happens every hour. So disregard my last question.

Could you please perform the following actions:

Open you Control tab and update a feed manually. To open the Browser Console Tab press, depending on your preferred browser: CNTRL+SHFT+J (for Chrome) CNTR+SHFT+K (for Firefox) or F12 (for Explorer). If you work on a Mac: (CMD+OPT+J for Chrome or CMD+OPT+K for Firefox). This should open a Console Tab on your browser. After it is open, perform the manual update, wait about a minute and see of you get any message on the console tab that looks like an error message.

If you see an error message, please copy it and place it here.

No issues that I can see.
I click on the Save&Generate Feed button and the console returns:

load-scripts.php?c=1&load[]=jquery-core,jquery-migrate,utils,plupload&ver=4.8:9 JQMIGRATE: Migrate is installed, version 1.4.1
wppfm_ajaxdatahandling.min.js?ver=fr-1.6.1:7 Feed update started at 10:44:29
wppfm_ajaxdatahandling.min.js?ver=fr-1.6.1:7 Feed update ended at 10:44:41 (runtime 12.158 seconds).

OK, indeed no error messages in the manual update, which is somewhat strange as the manual update uses the same code as the automatic update (except that the auto update is started from a cron job).

Where or how are you getting the error message? In an error log, in the feed or somewhere else?

And if in the error log, are you still getting the message?

Brendon, are you still getting this error message?

Can you deactivate and then reactivate the plugin once and then see if the error disappears? And also could you tell me where or how you are getting the error message (in the wp_error.log or somewhere else)?

Brendon, if you don’t mind I will close this topic. If you’re still having issues with this don’t hesitate to reopen it and if you have any other questions or issue please let us know by opening a new topic.