WordPress.org

1. dparmet
   Member
   Posted 4 years ago #

   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 http://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

2. xensen
   Member
   Posted 4 years ago #

   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?

3. moshu
   Member
   Posted 4 years ago #

   See the "sticky post" on the main page of the forum!

4. xensen
   Member
   Posted 4 years ago #

   Thanks.

5. drew3000
   Member
   Posted 4 years ago #

   You can find a mostly fix at http://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?

Topic Closed

This topic has been closed to new replies.