popularpostsdata DB doesn’t exist

  • Resolved hing02

    (@hing02)


    4 years, 2 months ago

    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

    (@hcabrera)

    Hi @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.