Support » Plugin: WordPress Popular Posts » The table in the wp_popularpostssummary database has disappeared.

  • Resolved alisa2009

    (@alisa2009)


    Hello. When you reset the statistics, the table in the wp_popularpostssummary database has disappeared. After reinstalling the plugin, the table did not appear. Because of this, views are not considered and popular entries are not displayed. Tell me how to fix it?

Viewing 14 replies - 16 through 29 (of 29 total)
  • Plugin Author Héctor Cabrera

    (@hcabrera)

    There’s a typo there. It’s default_storage_engine, not defolt_storage_engine.

    Там есть опечатка там. Это _storage_engine по умолчанию , а не defolt _storage_engine.

    What else needs to be done?

    Plugin Author Héctor Cabrera

    (@hcabrera)

    Alright, try running this query and please make sure to type it exactly the same way:

    CREATE TABLE IF NOT EXISTS wp_popularpostssummary (ID bigint(20) NOT NULL AUTO_INCREMENT, postid bigint(20) NOT NULL, pageviews bigint(20) NOT NULL DEFAULT 1, view_date date NOT NULL, view_datetime datetime NOT NULL)

    Plugin Author Héctor Cabrera

    (@hcabrera)

    Ok, one more time:

    CREATE TABLE IF NOT EXISTS wp_popularpostssummary (ID bigint(20) NOT NULL AUTO_INCREMENT, postid bigint(20) NOT NULL, pageviews bigint(20) NOT NULL DEFAULT 1, view_date date NOT NULL, view_datetime datetime NOT NULL, PRIMARY KEY (ID));

    You think ?

    Plugin Author Héctor Cabrera

    (@hcabrera)

    Yep, seems like a permission issue. Check with your hosting provider, send them this last screenshot you posted so they can help you sort it out.

    Well. If the problem is solved, I will unsubscribe. Thank you for your time.

    Everything was decided. The table is in place.

    Calculations go.

    There was the following problem. There was a broken wp_popularpostssummary.ibd table. The hoster deleted it, I reinstalled the plugin and it all worked. I will give the correspondence below, can someone come in handy.
    ————————————————————
    Good evening. I again had a question on the plugin. Which I could not install. I contacted the developer on the forum and, after a long correspondence, he sent to you. Something is not created. The developer said that there is some limitation in the database and send you the last screenshot. Can you see it with an experienced look ?, I made a lot of screenshots and requests to the database.
    ———————————————————-
    Hello. In the database logs, we see the following errors.

    190212 0:05:41 InnoDB: Error creating file ‘./blog/wp_popularpostssummary.ibd’.
    InnoDB: Resolve the file ‘./blog/wp_popularpostssummary.ibd’
    190212 0:16:26 InnoDB: Error creating file ‘./blog/wp_popularpostssummary.ibd’.
    InnoDB: Resolve the file ‘./blog/wp_popularpostssummary.ibd’
    190212 0:30:29 InnoDB: Error creating file ‘./blog/wp_popularpostssummary.ibd’.
    InnoDB: Resolve the file ‘./blog/wp_popularpostssummary.ibd’

    Where stated, delete the ./blog/wp_popularpostssummary.ibd file
    —————————————-
    And how can I remove it. Do you need to disable the plugin, delete it. Then delete this ./blog/wp_popularpostssummary.ibd?
    ——————–
    We can delete this file.
    Yes, probably a plugin that uses this table is better off or removed.
    It turns out that the file is only one, and this is a “broken” table.
    While a valid table has at least two files.

    # ls -la | grep ‘wp_popularpostssummary’
    -rw-rw —- 1 mysql mysql 131072 Feb 11 05:14 wp_popularpostssummary.ibd
    # ls -la | grep ‘wp_top_ten_daily’
    -rw-rw —- 1 mysql mysql 8684 Feb 12 02:29 wp_top_ten_daily.frm
    -rw-rw —- 1 mysql mysql 98304 Feb 12 02:37 wp_top_ten_daily.ibd

    —————————————————————-
    Well, I’ll delete the plugin and clean the cache and let you know a second).
    —————————————–
    Delete the wp_popularpostssummary.ibd file, try to create a table, or install a plugin.
    —————————————————-

    Resolved

    Plugin Author Héctor Cabrera

    (@hcabrera)

    Fantastic, I’m sure this information can help others in the future so thanks for reporting back!

Viewing 14 replies - 16 through 29 (of 29 total)
  • The topic ‘The table in the wp_popularpostssummary database has disappeared.’ is closed to new replies.