[Plugin: Robots Meta] robotsmeta adds weird errors in apache

  • micronox

    (@micronox)


    14 years, 8 months ago

    Hey Joost,

    Looking at my apache error logs, im seeing this

    [Thu Aug 20 12:42:12 2009] [error] [client 72.91.211.209] WordPress database error Unknown column 'robotsmeta' in 'field list' for query UPDATE wp_posts SET robotsmeta = '' WHERE ID = 816 made by wp_create_post_autosave, _wp_put_post_revision, wp_insert_post, do_action, call_user_func_array, RobotsMeta_Admin->robotsmeta_insert_post, referer: http://www.911-foreclosure.com/wp-admin/post.php?action=edit&post=813&message=1
[Thu Aug 20 12:42:21 2009] [error] [client 72.91.211.209] WordPress database error Unknown column 'robotsmeta' in 'field list' for query UPDATE wp_posts SET robotsmeta = 'index,follow' WHERE ID = 817 made by edit_post, wp_update_post, wp_insert_post, do_action, call_user_func_array, wp_save_post_revision, _wp_put_post_revision, wp_insert_post, do_action, call_user_func_array, RobotsMeta_Admin->robotsmeta_insert_post, referer: http://www.911-foreclosure.com/wp-admin/post.php?action=edit&post=813&message=1
[Thu Aug 20 12:42:21 2009] [error] [client 72.91.211.209] WordPress database error Unknown column 'robotsmeta' in 'field list' for query UPDATE wp_posts SET robotsmeta = 'index,follow' WHERE ID = 813 made by edit_post, wp_update_post, wp_insert_post, do_action, call_user_func_array, RobotsMeta_Admin->robotsmeta_insert_post, referer: http://www.911-foreclosure.com/wp-admin/post.php?action=edit&post=813&message=1
[Thu Aug 20 12:43:25 2009] [error] [client 72.91.211.209] WordPress database error Unknown column 'robotsmeta' in 'field list' for query UPDATE wp_posts SET robotsmeta = '' WHERE ID = 816 made by wp_create_post_autosave, wp_update_post, wp_insert_post, do_action, call_user_func_array, RobotsMeta_Admin->robotsmeta_insert_post, referer: http://www.911-foreclosure.com/wp-admin/post.php?action=edit&post=813&message=1

    any ideas?

Viewing 5 replies - 1 through 5 (of 5 total)
  • slurm23

    (@slurm23)

    14 years, 8 months ago

    Hi! Thx for the nice plugin, but I too do have a similar issue with the latest version (on WP 2.8.4). When the plugin is running it “hides” the permalink-renaming function in the “create post” admin menu. The error it gives me is a similar one:

    WordPress database error: [Unknown column ‘robotsmeta’ in ‘field list’]
    UPDATE wp_posts SET robotsmeta = ” WHERE ID = 266

    Please help!

    samueldiener

    (@samueldiener)

    14 years, 8 months ago

    me too!

    slurm23

    (@slurm23)

    14 years, 8 months ago

    This seems to be resulting from a conflict with Bad Behavior. See: http://wordpress.org/support/topic/305104

    felthos

    (@felthos)

    14 years, 4 months ago

    I had the same problem. It wasn’t a conflict with the Bad Behavior plugin b/c I don’t have (and never had) that installed.

    It was because the ‘robotsmeta’ column was missing from the wp_posts table in the WordPress database.

    Fix:

    1. Go into PHPMyAdmin where your WordPress database is set up
    2. Click on the wp_posts table, then Structure (at the top)
    3. Right after where it lists all the fields, you’ll see a “Add [1] fields” line. Click Go at the end of that.
    4. Enter “robotsmeta” for the field, I guessed and picked a data type of “VARCHAR” and length of “100”. I set my Collation to “latin1_general_ci” but yours may be different.
    5. Save
    6. Test by doing a ‘tail -f’ on your Web server’s error log and then updating one of your WordPress posts (or creating a new one).
    7. Also a good idea to try changing the Robots Meta value in your post and then browsing the database (wp_posts table) to check that the new value is in there.

    Good luck!

    PS> I tried deactivating and re-activating the plugin first per Joost’s advice (http://yoast.com/wordpress-noindex-specific-posts-and-pages/) but that didn’t work. Joost – perhaps you may want to see why the plugin does not create that additional column on activation.
    Cheers!

    avatarworf

    (@avatarworf)

    14 years, 3 months ago

    Below Plugin Version 2.3 it should create the table alteration – definded as a VARCHAR(64) just in case anybody’s watching their space allocation.

    Maybe the Plugin Developer was hoping to do something new in this version but the syntax doesn’t support it. So I guess we go ahead and create the column

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘[Plugin: Robots Meta] robotsmeta adds weird errors in apache’ is closed to new replies.