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

  • Resolved Brendon Brown

    (@bigb159)


    7 years, 4 months ago

    Woo version 3.1.0

    This error happens hourly:
    [22-Jun-2017 09:12:41 PST] WordPress database error Unknown column ‘p.feed_title’ in ‘field list’ for query SELECT p.product_feed_id, p.source_id AS source, p.title, p.feed_title, p.feed_description, p.main_category, p.url, p.include_variations, p.is_aggregator, p.status_id, p.updated, p.schedule, c.name_short AS country, m.channel_id AS channel, p.status_id FROM wp_d6zbrwv6g8_feedmanager_product_feed AS p INNER JOIN wp_d6zbrwv6g8_feedmanager_country AS c ON p.country_id = c.country_id INNER JOIN wp_d6zbrwv6g8_feedmanager_channel AS m ON p.channel_id = m.channel_id WHERE p.product_feed_id = 1 made by do_action_ref_array, WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, WP_Product_Feed_Manager->activate_feed_update_schedules, wppfm_update_feeds, WPPFM_Schedules->update_active_feeds, WPPFM_Data_Class->get_feed_data, WPPFM_Queries->read_feed
    [22-Jun-2017 09:12:41 PST] WordPress database error 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 ” at line 1 for query SELECT short FROM wp_d6zbrwv6g8_feedmanager_channel WHERE channel_id = made by do_action_ref_array, WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, WP_Product_Feed_Manager->activate_feed_update_schedules, wppfm_update_feeds, WPPFM_Schedules->update_active_feeds, WPPFM_Data_Class->get_feed_data, WPPFM_Queries->get_channel_short_name_from_db

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Contributor Michel Jongbloed

    (@michel-jongbloed)

    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.

    Thread Starter Brendon Brown

    (@bigb159)

    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?

    Plugin Contributor Michel Jongbloed

    (@michel-jongbloed)

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

    What action are you performing when you get the error?

    Plugin Contributor Michel Jongbloed

    (@michel-jongbloed)

    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.

    Thread Starter Brendon Brown

    (@bigb159)

    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).

    Plugin Contributor Michel Jongbloed

    (@michel-jongbloed)

    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?

    Plugin Contributor Michel Jongbloed

    (@michel-jongbloed)

    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)?

    Plugin Contributor Michel Jongbloed

    (@michel-jongbloed)

    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.

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘WordPress database error Unknown column ‘p.feed_title’ in ‘field list’ for query’ is closed to new replies.

Tags