file change detection scan error

  • Resolved bigfish512

    (@bigfish512)


    6 years, 5 months ago

    hi,
    everytime i try to do a file change detection scan, i get the error – Warning: mysqli_query(): MySQL server has gone away. please refer to the image below to see what i’m talking about.

    error

    error

    [url=https://postimg.cc/8sFKjcHj][img]https://i.postimg.cc/nV26SQ9Y/file_change_detection_error.jpg[/img][/url]

    [url=https://postimg.cc/8sFKjcHj][img]https://i.postimg.cc/8sFKjcHj/file_change_detection_error.jpg[/img][/url]

    sorry about the multiple links. the screenshot is being hosted by postimg.cc and i was given multiple links. i’m not sure which one to use and this forum doesn’t have a post preview function.

    please let me know how i can fix this. thanks.

    The page I need help with: [log in to see the link]

Viewing 10 replies - 1 through 10 (of 10 total)
  • Thread Starter bigfish512

    (@bigfish512)

    sorry, i had to change the link. here’s the working link:

    error

    Plugin Contributor mbrsolution

    (@mbrsolution)

    Hi, do you know what your server specs are?

    For example, what type of server is your site hosted in? What is the MySQL and PHP version running in your server.

    Kind regards

    Plugin Contributor wpsolutions

    (@wpsolutions)

    Hi @bigfish512,
    Can you check your php.ini file and see what values you have for the following?
    mysql.connect_timeout
    default_socket_timeout

    Thread Starter bigfish512

    (@bigfish512)

    hi,
    this is a local installation of WordPress on WampServer with the following components:
    apache 2.4.27
    php 5.6.31
    mysql 5.7.19

    php.ini:
    mysql.connect_timeout = 60
    default_socket_timeout = 60

    Plugin Contributor mbrsolution

    (@mbrsolution)

    Hi, have you tested this feature in a live server? I run this plugin locally using Xampp in windows 10 without any issues. I have never experienced this warning message myself in my laptop.

    Could this issue be related to the WampServer version you have running locally? Unfortunately I have never used WampServer, so my knowledge is none ??

    Regards

    Plugin Contributor wpsolutions

    (@wpsolutions)

    Hi @bigfish512,
    Try increasing those values and see if your issue goes away.

    Plugin Contributor wpsolutions

    (@wpsolutions)

    ……forgot to mention that you should also try increasing the following configuration item which can be found in the my.ini file:

    max_allowed_packet

    I’ve seen this issue on a local installation before a while ago and if I remember correctly increasing the above value from 1M to something larger fixed it.

    Thread Starter bigfish512

    (@bigfish512)

    hi wpsolutions

    increasing the value of max_allowed_packet actually fixed the issue!

    does this mean that there’s a really large mysql statement in the code and that i might encounter this error again with other plugins?

    Plugin Contributor mbrsolution

    (@mbrsolution)

    Hi, that is good news. I will make a note of this in one of my tutorials ??

    does this mean that there’s a really large mysql statement in the code and that i might encounter this error again with other plugins?

    My guess is yes. One of your plugins requires to process a large MySQL statement. If this occurs in your local install then you should check to make sure your live server also has a large increase value for max_allowed_packet as @wpsolutions pointed out above.

    If your issue is resolved and you don’t need any more help, you can mark this support thread as resolved.

    Thank you

    • This reply was modified 6 years, 5 months ago by mbrsolution.
    Thread Starter bigfish512

    (@bigfish512)

    great plugin and great support. thanks!

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘file change detection scan error’ is closed to new replies.