DB Table doesn’t Exsit?

  • Resolved Tommy White

    (@twdesigns)


    8 years, 1 month ago

    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 Hector Cabrera

    (@hcabrera)

    8 years, 1 month ago

    Hey @twdesigns,

    What theme are you using?

    Thread Starter Tommy White

    (@twdesigns)

    8 years, 1 month ago

    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 Hector Cabrera

    (@hcabrera)

    8 years, 1 month ago

    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)

    8 years, 1 month ago

    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 8 years, 1 month ago by Tommy White.
    • This reply was modified 8 years, 1 month ago by Tommy White.
    Thread Starter Tommy White

    (@twdesigns)

    8 years, 1 month ago

    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)

    8 years, 1 month ago

    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 Hector Cabrera

    (@hcabrera)

    8 years, 1 month ago

    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.