WordPress database error: Table

  • Resolved mejapan

    (@mejapan)


    7 years, 2 months ago

    Error will be issued after updating to 4.0.0

    WordPress version 4.8.2
    Stop all plugins.
    WPP Activated only.
    PHP Ver 7.1
    Theme: Twenty Seventeen default

    1.Error immediately after installation and when opening (/wp-admin/options-general.php?Page=wordpress-popular-posts)
    [20-Sep-2017 16:38:29 UTC] WordPress database error: Table 'test.wp_comments' doesn't exist for query SELECT DATE(c.comment_date_gmt) AS 'date', COUNT(c.comment_post_ID) AS 'comment_count' FROMwp_commentsc INNER JOINwp_postsp ON c.comment_post_ID = p.ID WHERE 1 = 1 AND p.post_type IN('post', 'page') AND c.comment_date_gmt > DATE_SUB('2017-09-21 01:38:29', INTERVAL 6 DAY) AND c.comment_approved = 1 AND p.post_password = '' AND p.post_status = 'publish' GROUP BY date ORDER BY date ASC ; made by require_once('wp-admin/admin.php'), do_action('settings_page_wordpress-popular-posts'), WP_Hook->do_action, WP_Hook->apply_filters, WPP_Admin->display_plugin_admin_page, include_once('/plugins/wordpress-popular-posts/admin/partials/admin.php'), WPP_Admin->get_chart_data, WPP_Query->__construct, WPP_Query->run_query

    2.Error with all visitor access. (side Widget)
    [20-Sep-2017 16:38:30 UTC] PHP Warning: Invalid argument supplied for foreach() in /public_html/wp-content/plugins/wordpress-popular-posts/includes/class-wordpress-popular-posts-output.php on line 336

    Please help me.

Viewing 10 replies - 1 through 10 (of 10 total)
  • Plugin Author Hector Cabrera

    (@hcabrera)

    Hi there!

    WordPress database error: Table ‘test.wp_comments’ doesn’t exist (…)

    This is odd. The wp_comments table comes with every WordPress installation. Can you please check via phpmyadmin (or any other way you prefer) that it exists?

    PHP Warning: Invalid argument supplied for foreach() (…)

    I already found what the problem was and fixed it. I’m awaiting for confirmation from other users to push a new update with the fix ?? (so thanks for reporting it!)

    In the meanwhile, you might want to disable WPP’s thumbnails until 4.0.1 arrives.

    Thread Starter mejapan

    (@mejapan)

    wp_comment not exist.
    test_comment exists.
    I am changing the prefix.

    Please check.
    Thank you

    Plugin Author Hector Cabrera

    (@hcabrera)

    Did you also change the prefix in wp-config.php? WordPress is telling WPP that the prefix that it should use is wp_, which is why the query fails.

    Thread Starter mejapan

    (@mejapan)

    https://i.imgur.com/R3fbQZG.jpg

    If it was my mistake I am sorry.
    Please check.
    Thank you

    Thread Starter mejapan

    (@mejapan)

    — Delete —

    Thread Starter mejapan

    (@mejapan)

    — deleat —

    Plugin Author Hector Cabrera

    (@hcabrera)

    Thanks for the screenshot!

    It’s weird because it still is prepending the stock wp_ prefix instead of yours in the entire query. I’ll take a look and get back to you as soon as possible.

    Plugin Author Hector Cabrera

    (@hcabrera)

    Found what the problem is. I’ll push an update soon, so please make sure to upgrade once version 4.0.1 is out.

    Thank you for your help!

    Thread Starter mejapan

    (@mejapan)

    Thank you for always perfect plugin!

    Plugin Author Hector Cabrera

    (@hcabrera)

    Update pushed!

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘WordPress database error: Table’ is closed to new replies.