Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Error Code 1301

forums › forums › SQLyog › Using SQLyog › Error Code 1301

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • April 17, 2013 at 8:16 pm #12978
      Sweens
      Participant

      Hi

      I've started to get the following error message when synchronising the database, and (not being an expert!) don't know what to do to correct it.

      Checksum calculation failed!

      Warning ::

      Code : 1301

      Message : Result of concat_ws() was larger than max_allowed_packet (1048576) – truncated

      Any help much appreciated.

      Thanks

      Chris

    • April 18, 2013 at 4:52 am #34299
      sathish
      Member

      Hello,

      SQLyog uses MySQL's concat_ws() function to generate checksums. You need to increase the max_allowed_packet of your source and target servers to an amount slightly more than the size of the biggest row in it.

      To change max_allowed_packet, open my.ini. Under [mysqld] section for both servers, change max_allowed_packet to whichever value you require, and restart the server.

      Regards,

      Sathish

    • April 18, 2013 at 1:05 pm #34300
      Sweens
      Participant

      Thanks Sathish – works perfectly now.

  • Author
    Posts
Viewing 2 reply threads
  • You must be logged in to reply to this topic.