Category Archives: Software

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

Windows 8/2012 dark configuration

Here is how you can configure Windows 8/2012 to use a dark task bar with white letters:

  1. Install uxstyle
  2. Download Windows 8.1 Update1 RTM Dark Aero archive (memext mirror link)
  3. Decompress to C:\Windows\Resources\Themes
  4. delete the archive
  5. Right click Desktop → Personalize
    1.  Select Aero Dark MK IV Theme
    2. Click Color
      1. Click “show color mixer”
      2. Configure color as desired
  6. Optionally install classicshell