Title: wp_popularpoststransients database error
Last modified: July 11, 2022

---

# wp_popularpoststransients database error

 *  Resolved [Wendihihihi](https://wordpress.org/support/users/wendihihihi/)
 * (@wendihihihi)
 * [3 years, 11 months ago](https://wordpress.org/support/topic/wp_popularpoststransients-database-error/)
 * Hi Héctor,
 * These error messages are filling my log file at the moment. The log goes back
   until June 19. I don’t know if they were there before as well. Any ideas how 
   to fix this?
 * Cheers
 *     ```
       [19-Jun-2022 09:53:03 UTC] Database error WordPress Table 'hellowthere.wp_popularpoststransients' doesn't exist for query SHOW FULL COLUMNS FROM *wp_popularpoststransients* called via require_once('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/theme/single.php'), get_sidebar, locate_template, load_template, require_once('/themes/theme/sidebar.php'), dynamic_sidebar, WP_Widget->display_callback, WordPressPopularPosts\Widget\Widget->widget, WordPressPopularPosts\Widget\Widget->get_popular, WordPressPopularPosts\Cache::set
   
       [11-Jul-2022 12:36:08 UTC] Database error WordPress Table 'hellowthere.wp_popularpoststransients' doesn't exist for query SHOW FULL COLUMNS FROM *wp_popularpoststransients* called via require_once('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/theme/404.php'), get_sidebar, locate_template, load_template, require_once('/themes/theme/sidebar.php'), dynamic_sidebar, WP_Widget->display_callback, WordPressPopularPosts\Widget\Widget->widget, WordPressPopularPosts\Widget\Widget->get_popular, WordPressPopularPosts\Widget\Widget->maybe_query, WordPressPopularPosts\Cache::set
       ```
   
 * * = grave accent (otherwise it messes up the code formatting on WP forum)
 * btw WP and plugin are all latest versions
    -  This topic was modified 3 years, 11 months ago by [Wendihihihi](https://wordpress.org/support/users/wendihihihi/).
    -  This topic was modified 3 years, 11 months ago by [Wendihihihi](https://wordpress.org/support/users/wendihihihi/).
    -  This topic was modified 3 years, 11 months ago by [Wendihihihi](https://wordpress.org/support/users/wendihihihi/).

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Plugin Author [Hector Cabrera](https://wordpress.org/support/users/hcabrera/)
 * (@hcabrera)
 * [3 years, 11 months ago](https://wordpress.org/support/topic/wp_popularpoststransients-database-error/#post-15815454)
 * Hi [@wendihihihi](https://wordpress.org/support/users/wendihihihi/),
 * Looks like you’re missing a database table for some reason, hence the error message.
 * To force the plugin to recreate its database tables please add the following 
   code to the wp-config.php file:
 * `define( 'WPP_DO_DB_TABLES', true );`
 * When you’re done, go to the Plugins screens, deactivate WordPress Popular Posts,
   then enable it again. The plugin should automatically create the missing table
   for you.
 * Once you have confirmed that the table was created successfully (you can check
   via phpMyAdmin for example), remove the WPP_DO_DB_TABLES constant from your wp-
   config.php file.
 * You can also create the table manually. To do so, log in into phpMyAdmin (or 
   whatever your hosting provider uses to manage databases), select your site’s 
   database, and run this query:
 *     ```
       CREATE TABLE wp_popularpoststransients (
         ID bigint(20) NOT NULL AUTO_INCREMENT,
         tkey varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
         tkey_date datetime NOT NULL,
         PRIMARY KEY (ID)
       ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
       ```
   
 * (To anyone else reading this now or in the future you may need to change the 
   _wp\__ prefix to whatever your site uses, see _wp-config.php_ in the root of 
   your public folder for more details).
 * You may need to change the charset / collate information according to your own
   setup (but shouldn’t be necessary in most cases).
    -  This reply was modified 3 years, 11 months ago by [Hector Cabrera](https://wordpress.org/support/users/hcabrera/).
      Reason: Added info about the WPP_DO_DB_TABLES to recreate tables automatically
 *  Thread Starter [Wendihihihi](https://wordpress.org/support/users/wendihihihi/)
 * (@wendihihihi)
 * [3 years, 11 months ago](https://wordpress.org/support/topic/wp_popularpoststransients-database-error/#post-15815560)
 * You’re right, Héctor; it wasn’t there. I’ve added it and will see if that did
   the trick.
 * Thank you for the fast reply.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘wp_popularpoststransients database error’ is closed to new replies.

 * ![](https://ps.w.org/wordpress-popular-posts/assets/icon-256x256.png?rev=1232659)
 * [WP Popular Posts](https://wordpress.org/plugins/wordpress-popular-posts/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wordpress-popular-posts/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wordpress-popular-posts/)
 * [Active Topics](https://wordpress.org/support/plugin/wordpress-popular-posts/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wordpress-popular-posts/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wordpress-popular-posts/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [Wendihihihi](https://wordpress.org/support/users/wendihihihi/)
 * Last activity: [3 years, 11 months ago](https://wordpress.org/support/topic/wp_popularpoststransients-database-error/#post-15815560)
 * Status: resolved