Version History - 2022

SQLyog 13.2.0 (December 2022)

• Bug Fixes:
  
  --With Azure DB, SQLyog returned an error “unknown thread id” on stopping the query execution.
  --With Azure DB, SQLyog crashed when killing the query from another connection.
  --When the ‘CA Certificate’ field is set to empty in a SSL connection, "New Connection Using Current Settings" and “Backup” failed and returned an error after restoring the session.
  --In some rare cases, SQLyog would crash while restoring the session.
  --With an HTTP connection, SQLyog crashed when you open the ‘Info’ tab on selecting the ‘Information_schema’ tables.
  --With an HTTP connection, SQLyog closed abruptly when the option “Copy All/Selected Rows to clipboard” was selected in the RESULT tab.
  --Indexes were incorrectly displayed for MySQL v5.1.x and below.
  --Importing an excel file failed when the database collation was set to utf8mb4.
  --Fixed an issue with SSH connection where SQLyog GUI could become unresponsive after switching from Read only to Edit mode in the RESULTtab.
  --In some rare cases, the generated column’s condition was truncated in the expression field of the CREATE/ALTER TABLE UI.
  --SQLyog failed to connect to a server through SSH with an Ed25519 encrypted private key.
  --Fixed an HTTP connection failure issue with PHP v8.1. The tunneler file for HTTP-tunnel has been updated with this release and must be replaced on the server. 
  --SQLyog generated an incorrect ALTER TABLE statement in Schema synchronization with datatype TINYINT(1) for MySQL version 8.0.19 or above with any target MySQL version and vice versa.
• Miscellaneous:
  
  --Upgraded the PLINK executable bundled with SQLyog to PuTTY/PLINK v 0.77, to support private keys generated in the PPK version 3 file format.

SQLyog 13.1.9 (January 2022)

• Features:
  
  --Updated the 'User Manager' GUI to support the newly added privileges in MariaDB v10.5.

• Bug Fixes:
  
  --SQLyog returned an error when setting user server resources like maximum number of queries per hour, Maximum number of updates per hour, Maximum number of connections per hour, or Maximum number of user connections using User Manager GUI for MySQL v8+ Servers.
  --The tunneler file for HTTP-tunnel has been updated with this release and must be replaced on the server. In the old tunneler file, curly braces were used for accessing array elements and string offsets; this behavior is deprecated. Also, some functions used are deprecated in PHP 7.4x.
  --In some rare cases, the Schema Designer failed to add all the child tables of a parent table to the canvas.
  --Explain Extended menu option is disabled for MySQL v5.7.3+ as it is deprecated.
  --Database Synchronization wizard returned an error "Column definition mismatch" for "DATETIME" column on syncing the data from v5.7 to v8.
  --SQLyog stopped responding when executing a query in an SSL connection through SSH-Tunnel.
  --When an SSL connection was established through an SSH-tunnel, the 'New connection using current settings' option failed to open the same connection, as the UI stopped responding and SQLyog had to be forcefully terminated.

• Note:

  --Windows 7 Support has ended.