Forums

[resolved] Help with this Database error after commenting? (5 posts)

  1. yennygirl
    Member
    Posted 1 year ago #

    Hello,

    I'm not sure if this is where I should ask this kind of problem in my site. But I'm helpless. So, I really need your help,please! I just changed my blog to a new theme and now I thought everything went well except that everytime there is someone comments in my my post and every time I will make a new post and hit submit/post this will pop in the screen.

    WordPress database error: [Table 'yennygir_wrdp1.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 = 1652 ORDER By post_date DESC

    WordPress database error: [Table 'yennygir_wrdp1.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: [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 < '2008-01-23 15:44:18' ORDER By p.post_date DESC' at line 6]
    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) = AND p.post_date_gmt < '2008-01-23 15:44:18' ORDER By p.post_date DESC

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

    WordPress database error: [Table 'yennygir_wrdp1.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 'yennygir_wrdp1.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 < '2008-01-23 15:44:18' GROUP BY p2c.category_id

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

    Warning: Cannot modify header information - headers already sent by (output started at /home/yennygir/public_html/wp-includes/wp-db.php:160) in /home/yennygir/public_html/wp-includes/pluggable.php on line 391

    Here's my blog add:

    http://yennygirl.com/

    Can you please help me? I dn't have any idea where to look the problem.

    Thanks!

  2. jeremyclark13
    Moderator
    Posted 1 year ago #

    Your new theme isn't compatible with wp 2.3 you'll need to find an updated version of the theme or find a different that works. Here's a partial list of working theme for 2.3.
    http://codex.wordpress.org/Themes/Theme_Compatibility/2.3
    Also 2.3.2 is the latest version.

  3. yennygirl
    Member
    Posted 1 year ago #

    Thank you! I just upgraded to 2.3.1 It's not compatible still? And do you know if the theme is compatible with 2.3.2?

  4. jeremyclark13
    Moderator
    Posted 1 year ago #

    Sorry after reading your post again, disabling your af extended live archives plugin should do the trick.

  5. yennygirl
    Member
    Posted 1 year ago #

    Thanks! I am okey now:) I upgraded to 3.2 and it's up and running.

Topic Closed

This topic has been closed to new replies.

About this Topic