wp_icwp_wpsf db Error

  • Resolved jhcmarket

    (@jhcmarket)


    8 years, 4 months ago

    When restoring a wordpress database that includes the shield plugin I get a mysql error ‘wp_icwp_wpsf_audit_trail’ already exists however all tables have been dropped prior to importing the database. I’ve never seen this kind of error when restoring to an empty database. When I delete the shield plugin and try again the import of the database works. Could there be something inherit in the shield plugin that is causing such an error?

    Thanks

    https://www.ads-software.com/plugins/wp-simple-firewall/

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Paul

    (@paultgoodchild)

    What you’re referring to is a mysql error… there’s no reason the plugin would be affecting mysql like that to generate such errors.

    I’m having the same problem. Trying to do a site migration to a clean directory and brand new database. Gets halfway down the import, then fails. Also, the Audit Trail feature seems to be increasing the size of the database by almost 300mb! I moved it from two weeks to 7 days now to see if it helps.

    Loading SQL from file E:\staging\stinkmoody/wp-content/uploads/backupbuddy_temp/yhv76gckso/wp_icwp_wpsf_audit_trail.sql.

    Error(s)
    Error #9010: Unable to import SQL query. Error: Duplicate entry '28179732' for key 'PRIMARY' Errno: 1062. Click to view error details in the Knowledge Base
    Error #9010: Unable to import SQL query. Error: Duplicate entry '28179731' for key 'PRIMARY' Errno: 1062. Click to view error details in the Knowledge Base

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘wp_icwp_wpsf db Error’ is closed to new replies.

Tags