Category Archives: Bugs & Troubleshooting

Mysql Workbench error #1064

This is an incompatibility (assuming the database model is correct) between MySQL workbench and MySQL Server. For example, this could occur occasionally by installing XAMPP 3.2.2 and latest MySQL Workbench 8.

For example: XAMPP 3.2.2 installs Maria DB 10.1.37 which is compatible with MySQL 5.7 but MySql workbench 8 is compatible with MySQL 8.0.

The solution would be to either upgrade MySQL to 8.0 so that it is compatible with MySQL workbench or downgrade the MySQL workbench model:

  • Open MySQL workbench and desired model
  • Go to Edit, Preferences, then Modeling section, MySQL
  • set MySQL version to 5.7.
  • forward engineer

Audio staggering in Windows 10

Update:

There are now two better solutions:

1. Disable dynamic tick

  1. Open Command prompt (Admin) to bring up elevated command prompt.
  2. Type BCDEDIT /SET DISABLEDYNAMICTICK YES command and press Enter to fix the high DPC latency
  3. restart the computer

2. Install and use TCP optimizer:

  1. Download TCP optimizer
  2. Set settings to optimal
  3. restart the computer

If the above does not work, you can try the older solutions mentioned below.

Continue reading Audio staggering in Windows 10

Unable to use ctrl+shift+? shortcuts with keyboard layout switcher

You have a Linux distribution with Xorg and you have configured the keyboard layout switcher to use alt+shift to switch between languages. But once you do that, keyboard shortcuts that use alt+shift+<key> combinations cannot be used. The same could happen if you have selected ctrl+shift as a shortcut to change language which disables all ctrl+shift+<key> combinations.

Continue reading Unable to use ctrl+shift+? shortcuts with keyboard layout switcher

Clock messed up when dual booting

The problem:

  • Linux store the time on the hardware clock as UTC by default
  • Windows store the time on the hardware clock as the local time by default

Since both operating systems access the hardware clock you may encounter problems when you dual boot between them.

A comment for the geeks:

The advantage of having the hardware clock as UTC is that you don’t need to change the hardware clock when moving between timezones or when Daylight Savings Time (DST) begins or ends as UTC does not have DST or timezone offsets. Continue reading Clock messed up when dual booting