Can’y Import Database Due To Error In code

  • Resolved Evakos

    (@chrissyb)


    8 years, 8 months ago

    Hi,

    I have an MYSQL database dump which i can’t import. I understand from researching that this may have been due to the plugin running a scan whilst I downloaded the database. My question is there anyway to delete the Wordfence entries from a database dump or any workaround. It is the only database I have as there is currently an issue with accessing dback ups at the host. It’s basically a triple whammy of problems. So this is the error:

    INSERT INTOwp_zfhl_wfConfig(name,val,autoload`) VALUES
    (‘wfsd_engine’, 0x1f8b0800000000000003ecfd7b7fdcc876188afaa370389aa134529378a35b1a6e8ae25be24b24

    #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 ” at line 2 `

    I thought it might because the ‘wfsd_engine’ needed back ticks but the whole database has these entries that aren’t back ticks.

    Does anyone know how I can fix this?

    Thanks so much.

    Chris

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter Evakos

    (@chrissyb)

    8 years, 8 months ago

    Hi I manged to resolve this by editing and deleting the entries for the plugin manually. But if anyone knows why it happened I’d be interested. The most I know is it has outputted the strings during a scan, but I don’t know why they would produce an error.

    wfalaa

    (@wfalaa)

    8 years, 8 months ago

    Hi Chris,
    The error message you shared has already a syntax error near “autoload”, I’m not sure if this was done by mistake while pasting the message here in the forum or this is how it was reported in first place.
    Anyway, you can click on “Click to kill the current scan” link before exporting the database from your website, this should be enough to make sure there is no value for “wfsd_engine” set in the “wp_wfConfig” table.

    Thanks.

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

The topic ‘Can’y Import Database Due To Error In code’ is closed to new replies.