take so much proccess indatabase

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Ajay

    (@ajay)

    8 years, 3 months ago

    Can you check that the Primary Key’s are set up for the wp_top_ten and wp_top_ten_daily tables?

    If not, you will need to run this in phpMyAdmin or Adminer:

    
alter table wp_top_ten drop primary key(postnumber, blog_id);
alter table wp_top_ten_daily drop primary key(postnumber, dp_date, blog_id);

    Also turn on the caching within the plugin

    • This reply was modified 8 years, 3 months ago by Ajay.
    Plugin Author Ajay

    (@ajay)

    8 years, 3 months ago

    v2.5.6 has a new button under Tools that lets you add/recreate the primary key

    Thread Starter jazuly

    (@animekosia)

    8 years, 3 months ago

    i try ths tool but still no Primary Key n that table.
    i try manual code but give me error messages
    “#1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘(postnumber, blog_id)’ at line 1”

    Thread Starter jazuly

    (@animekosia)

    8 years, 3 months ago

    is that posible to create primary when the values is same?

    View post on imgur.com

    View post on imgur.com

    Plugin Author Ajay

    (@ajay)

    8 years, 3 months ago

    Those screenshots do not show that you have a PRIMARY KEY or not. If you’ve clicked the recreate Primary Key this should get created into the table.

    How are you confirming this?

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

The topic ‘take so much proccess indatabase’ is closed to new replies.