Unknown column ‘ip’ in ‘field list’

  • Resolved bkaufenberg

    (@bkaufenberg)


    6 years, 5 months ago

    Hi there,

    We are getting repeated errors showing up in our php error log like this:

    [30-May-2018 22:04:15 UTC] WordPress database error Unknown column ‘ip’ in ‘field list’ for query INSERT INTO wp_redirection_404 (url, created, ip, agent) VALUES (‘/events/sociable-cider-werks-dinner-at-nightingale/’, ‘2018-05-30 17:04:15’, ‘157.55.39.221’, ‘Mozilla/5.0 (compatible; bingbot/2.0; +https://www.bing.com/bingbot.htm)’) made by require(‘wp-blog-header.php’), wp, WP->main, WP->handle_404, status_header, apply_filters(‘status_header’), WP_Hook->apply_filters, call_user_func_array, WordPress_Module->status_header_404, RE_404::create

    I saw another resolved thread (https://www.ads-software.com/support/topic/unknown-column-ip-in-field-list-for-query/) saying that it’s possible our wp_redirection_404 table is missing a column, but I’m not an experienced coder and I’m not sure if I’m experiencing the same problem as that person. If so, I don’t understand how to implement the fixes proposed in that thread. Can you help?

Viewing 1 replies (of 1 total)
  • Thread Starter bkaufenberg

    (@bkaufenberg)

    Okay, I’ve figured out how to delete the table and that made the magic fixer button appear on the website. I pressed it and recreated the table.

    • This reply was modified 6 years, 5 months ago by bkaufenberg.
Viewing 1 replies (of 1 total)
  • The topic ‘Unknown column ‘ip’ in ‘field list’’ is closed to new replies.