Title: popularpostsdata DB doesn’t exist
Last modified: September 28, 2020

---

# popularpostsdata DB doesn’t exist

 *  Resolved [hing02](https://wordpress.org/support/users/hing02/)
 * (@hing02)
 * [5 years, 8 months ago](https://wordpress.org/support/topic/popularpostsdata-db-doesnt-exist/)
 * After uninstall the plugin and reinstall it again in mysite. It shows the following
   error msg.
 * WordPress database error Table ‘myweb_wordpress.wp2_popularpostsdata’ doesn’t
   exist for query INSERT INTO wp2_popularpostsdata
 * It seems the db cannot recreate. Can I do it manually?

Viewing 1 replies (of 1 total)

 *  Plugin Author [Hector Cabrera](https://wordpress.org/support/users/hcabrera/)
 * (@hcabrera)
 * [5 years, 8 months ago](https://wordpress.org/support/topic/popularpostsdata-db-doesnt-exist/#post-13461037)
 * Hi [@hing02](https://wordpress.org/support/users/hing02/),
 * You can try creating the table manually on your database via PHPMyAdmin or some
   other way. This is the query you need to run:
 *     ```
       CREATE TABLE IF NOT EXISTS wp2_popularpostsdata (
           postid bigint(20) NOT NULL,
           day datetime NOT NULL,
           last_viewed datetime NOT NULL,
           pageviews bigint(20) DEFAULT 1,
           PRIMARY KEY (postid)
       ) ENGINE=InnoDB;
       ```
   

Viewing 1 replies (of 1 total)

The topic ‘popularpostsdata DB doesn’t exist’ 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/)

 * 1 reply
 * 2 participants
 * Last reply from: [Hector Cabrera](https://wordpress.org/support/users/hcabrera/)
 * Last activity: [5 years, 8 months ago](https://wordpress.org/support/topic/popularpostsdata-db-doesnt-exist/#post-13461037)
 * Status: resolved