mysql_send_long_data() when scanning

  • Resolved smreka

    (@smreka)


    3 years, 4 months ago

    So whenever I do a scan I get this error after about 15 seconds.

    Any idea what this is about?

    [JAN 19 04:08:28] Error finishing writing value for wfsd_engine (MySQLi error: [1105] Parameter of prepared statement which is set through mysql_send_long_data() is longer than ‘max_long_data_size’ bytes)

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support wfpeter

    (@wfpeter)

    3 years, 4 months ago

    Hi @smreka,

    I’ve not seen this before with Wordfence or its scans, but it could be an idea to try setting max_long_data_size to the same value as max_allowed_packet.

    max_long_data_size was removed in MySQL 5.6 and just incorporated into max_allowed_packet, so it could be that the default value is too small. Alternatively, upgrading MySQL to a newer version could be an option, but if you’re having problems setting the value then speaking with your administrator or hosting provider could help.

    Thanks,
    Peter.

    Thread Starter smreka

    (@smreka)

    3 years, 4 months ago

    I tried setting it to the max setting, didn’t help. But I think there must have been some issue with the Duplicator database restore procedure (I had to restore my site) because when I dropped the database and re imported manually it the issue went away.

    • This reply was modified 3 years, 4 months ago by smreka.
    • This reply was modified 3 years, 4 months ago by smreka.
    Plugin Support wfpeter

    (@wfpeter)

    3 years, 4 months ago

    That’s great news, I will keep restores or migrations in mind if this crops up again and I appreciate you for keeping us updated @smreka .

    neoxphuse

    (@neoxphuse)

    2 years, 10 months ago

    Hi I am having this issue when scanning. I’m not an expert by any means. Can you please tell me how to fix this step by step.

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

The topic ‘mysql_send_long_data() when scanning’ is closed to new replies.