content_info_id not found

  • Resolved alanpae

    (@alanpae)


    12 years, 1 month ago

    Trying to truncate content_info and keep getting:

    #1451 – Cannot delete or update a parent row: a foreign key constraint fails (.../kisstory_slim_stats, CONSTRAINT fk_content_info_id FOREIGN KEY (content_info_id) REFERENCES kisstory_slim_content_info (content_info_id))

    I’ve deleted the pluging and re-installed but no joy. Using 3.6.

    Thanks,
    alan

    https://ww.wp.xz.cn/plugins/wp-slimstat/

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Contributor Jason Crouse

    (@coolmann)

    12 years, 1 month ago

    We introduced foreign key constraints in version 3.5.7, which are incompatible with TRUNCATE (see mysql manual). You will need to do a DELETE.

    Thread Starter alanpae

    (@alanpae)

    12 years, 1 month ago

    Delete gives pretty much the same error message. A quick browse just shows basically who the author was. Since it’s just me does this table even do anything? 🙂

    thanks,
    alan

    Plugin Contributor Jason Crouse

    (@coolmann)

    12 years, 1 month ago

    Delete gives pretty much the same error message.

    You need to delete the corresponding rows in wp_slim_stats first.

    Since it’s just me does this table even do anything?

    That is the lookup table that stores all the information about the browsers that visited your site.

    Thread Starter alanpae

    (@alanpae)

    12 years, 1 month ago

    Just found it.

    Adding a * to filter, show user agents, then empty the other one and then I can finally delete everything.

    Thanks much,
    alan

    Plugin Contributor Jason Crouse

    (@coolmann)

    12 years, 1 month ago

    Great, a vote/review for SlimStat would be a nice way to say thank you!

    Thread Starter alanpae

    (@alanpae)

    12 years, 1 month ago

    Done. 🙂

    Plugin Contributor Jason Crouse

    (@coolmann)

    12 years, 1 month ago

    Much appreciated.

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

The topic ‘content_info_id not found’ is closed to new replies.