Weird error message after posting

  • I upgraded to 2.3 last week. All is fine, except after I post anything, I get the error messages below. Even though the post goes through fine, and everything works, I’m getting this error message.

    My blog is at https://www.parmet.net/pr

    Here’s the error message:

    WordPress database error: [Table ‘pr.wp_post2cat’ doesn’t exist]
    SELECT YEAR(post_date) AS year, MONTH(post_date) AS month, category_id FROM wp_posts INNER JOIN wp_post2cat ON (wp_posts.ID = wp_post2cat.post_id) WHERE post_date > 0 AND ID = 1213 ORDER By post_date DESC

    WordPress database error: [Table ‘pr.wp_post2cat’ doesn’t exist]
    SELECT DISTINCT YEAR(p.post_date) AS year FROM wp_posts p INNER JOIN wp_post2cat p2c ON (p.ID = p2c.post_id) WHERE p.post_date > 0 ORDER By p.post_date DESC

    WordPress database error: [Table ‘pr.wp_post2cat’ doesn’t exist]
    SELECT DISTINCT MONTH(p.post_date) AS month FROM wp_posts p INNER JOIN wp_post2cat p2c ON (p.ID = p2c.post_id ) WHERE YEAR(p.post_date) = 2007 AND p.post_date_gmt < ‘2007-10-17 20:48:28’ ORDER By p.post_date DESC

    WordPress database error: [Table ‘pr.wp_post2cat’ doesn’t exist]
    SELECT DISTINCT MONTH(p.post_date) AS month FROM wp_posts p INNER JOIN wp_post2cat p2c ON (p.ID = p2c.post_id ) WHERE YEAR(p.post_date) = 2006 AND p.post_date_gmt < ‘2007-10-17 20:48:28’ ORDER By p.post_date DESC

    WordPress database error: [Table ‘pr.wp_post2cat’ doesn’t exist]
    SELECT DISTINCT MONTH(p.post_date) AS month FROM wp_posts p INNER JOIN wp_post2cat p2c ON (p.ID = p2c.post_id ) WHERE YEAR(p.post_date) = 2005 AND p.post_date_gmt < ‘2007-10-17 20:48:28’ ORDER By p.post_date DESC

    WordPress database error: [Table ‘pr.wp_post2cat’ doesn’t exist]
    SELECT DISTINCT MONTH(p.post_date) AS month FROM wp_posts p INNER JOIN wp_post2cat p2c ON (p.ID = p2c.post_id ) WHERE YEAR(p.post_date) = 1969 AND p.post_date_gmt < ‘2007-10-17 20:48:28’ ORDER By p.post_date DESC

    Warning: Invalid argument supplied for foreach() in /home/.garfy/parmet/parmet.net/pr/wp-content/plugins/af-extended-live-archive/af-extended-live-archive-include.php on line 292

    Warning: Invalid argument supplied for foreach() in /home/.garfy/parmet/parmet.net/pr/wp-content/plugins/af-extended-live-archive/af-extended-live-archive-include.php on line 292

    Warning: Invalid argument supplied for foreach() in /home/.garfy/parmet/parmet.net/pr/wp-content/plugins/af-extended-live-archive/af-extended-live-archive-include.php on line 292

    Warning: Invalid argument supplied for foreach() in /home/.garfy/parmet/parmet.net/pr/wp-content/plugins/af-extended-live-archive/af-extended-live-archive-include.php on line 292

    WordPress database error: [Table ‘pr.wp_categories’ doesn’t exist]
    SELECT cat_ID, cat_name, category_nicename, category_parent FROM wp_categories c WHERE c.cat_ID > 0 ORDER BY c.cat_ID asc

    WordPress database error: [Table ‘pr.wp_categories’ doesn’t exist]
    SELECT c.cat_ID, COUNT(distinct p2c.post_id) AS cat_count FROM wp_categories c INNER JOIN wp_post2cat p2c ON (c.cat_ID = p2c.category_id) INNER JOIN wp_posts p ON (p.ID = p2c.post_id) WHERE p.post_status = ‘publish’ AND p.post_date_gmt < ‘2007-10-17 20:48:28’ GROUP BY p2c.category_id

    Warning: Invalid argument supplied for foreach() in /home/.garfy/parmet/parmet.net/pr/wp-content/plugins/af-extended-live-archive/af-extended-live-archive-include.php on line 459

    Warning: Cannot modify header information – headers already sent by (output started at /home/.garfy/parmet/parmet.net/pr/wp-includes/wp-db.php:160) in /home/.garfy/parmet/parmet.net/pr/wp-includes/pluggable.php on line 390

Viewing 4 replies - 1 through 4 (of 4 total)
  • xensen

    (@xensen)

    I get the same messages. I assume it’s some kind of deprecated code, but I’m not sure just what yet. Did you find a fix?

    moshu

    (@moshu)

    See the “sticky post” on the main page of the forum!

    xensen

    (@xensen)

    Thanks.

    drew3000

    (@drew3000)

    You can find a mostly fix at https://blog.tinyau.net/archives/2007/07/07/extended-live-archives-for-wordpress-23/

    He has some fixed files for Live Archive that remedy most all the problems. The one thing that remains is when you delete a post. The post does delete but you get the following error message:

    —————

    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 ‘AND p.post_date_gmt < ‘2007-11-14 20:31:58′ ORDER By p.post_date DESC’ at line 6]
    SELECT DISTINCT MONTH(p.post_date) AS month FROM wp_posts p INNER JOIN wp_term_relationships tr ON (p.ID = tr.object_id ) WHERE YEAR(p.post_date) = AND p.post_date_gmt < ‘2007-11-14 20:31:58’ ORDER By p.post_date DESC

    Warning: Invalid argument supplied for foreach() in /home/drewthrz/public_html/wp-content/plugins/af-extended-live-archive/af-extended-live-archive-include.php on line 292

    Warning: Invalid argument supplied for foreach() in /home/drewthrz/public_html/wp-content/plugins/af-extended-live-archive/af-extended-live-archive-include.php on line 465
    1

    ——-

    A bit more useful than the sticky post. Anyone know how to fix the delete problem, though?

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Weird error message after posting’ is closed to new replies.

Tags