Support » Plugin: WordPress Popular Posts » DB Table doesn’t Exsit?

  • Resolved Tommy White

    (@twdesigns)


    Can someone point me in the right direction. I keep getting a LOT of php error files that start with this:

    popularpostsdata' doesn't exist for query

    I’m trying to track down if the plugin is still using this DB table or if my Theme has an older version hard coded. I checked my DB and there is no popularpost table of any kind. Which brings me to the next question of where the data is stored if not in popularpostsdata.

    Also the plugin is enabled, I have disabled / enabled and reinstalled.

    Any help would be great,

    Thanks

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author Héctor Cabrera

    (@hcabrera)

    Hey @twdesigns,

    What theme are you using?

    Thread Starter Tommy White

    (@twdesigns)

    It’s an OLD one that I’ve basically rewrote over the years to keep up with depreciated wordpress calls. I’ve heavily modified it to fit my needs. They had a call to a themes plugin folder for your plugin. I tried updating it and also disabled the call and enabled the plugin through the plugin section but I still get the same issue. I think the developer was solostream or Gavick, I’ll have to check.

    I think there was a widget that displayed posts hits which is where my breaking point is. I just wasn’t sure if you still use that table or if it’s obsolete.

    Plugin Author Héctor Cabrera

    (@hcabrera)

    The plugin still uses it (that and another one, too) so there’s definitely something wrong there.

    Could you please share the entire error message?

    Thread Starter Tommy White

    (@twdesigns)

    02-May-2018 02:16:03 UTC] WordPress database error Table 'my_database.cc_popularpostssummary' doesn't exist for query INSERT INTO cc_popularpostssummary
                (postid, pageviews, view_date, view_datetime) VALUES (1828, 1, '2018-05-02', '2018-05-02 02:16:03')
                ON DUPLICATE KEY UPDATE pageviews = pageviews + 1, view_datetime = '2018-05-02 02:16:03'; made by do_action('wp_ajax_update_views_ajax'), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, WPP_Public->update_views, WPP_Public->update_views_count

    This is what I get every time someone views a post. The table names appear to be popularpostssummary and popularpostsdata. I get an error for both. I deleted the plugin and reactivated it. I also disabled the calls in the theme. Still confused on this one.

    • This reply was modified 3 years, 7 months ago by Tommy White.
    • This reply was modified 3 years, 7 months ago by Tommy White.
    Thread Starter Tommy White

    (@twdesigns)

    I just installed the plugin at another site and the database fields were made correctly. So obviously it’s on my side. Just confused what could block it from creating the tables on install.

    Thread Starter Tommy White

    (@twdesigns)

    OK I have been going through a lot of the plugins I have installed and took out a couple I no longer use. After removing them it not works. I’m not sure which plugin was blocking the install but for me I think wordfence was it as I noticed the install was successful after disabling it.

    Thanks for getting back with me!

    Plugin Author Héctor Cabrera

    (@hcabrera)

    Hey @twdesigns,

    Looks like you were having fun while I was asleep 😛

    I’m glad you were able to work it out. However, Wordfence preventing WPP from installing its DB tables sounds a bit odd (although it’s not like I’m completely familiar with Wordfence, maybe it has an option for this that I haven’t seen yet?)

    Thanks for reporting back 🙂 I’m marking this as resolved for the time being.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘DB Table doesn’t Exsit?’ is closed to new replies.