Description:
11:52:37 [INF][ Workbench]: Starting up Workbench
11:52:37 [INF][ WBContext UI]: Initializing workbench context UI with these values:
base dir: /Applications/MySQLWorkbench.app/Contents/Resources
plugin path: /Applications/MySQLWorkbench.app/Contents/PlugIns
struct path: /Applications/MySQLWorkbench.app/Contents/Resources/grt
module path: /Applications/MySQLWorkbench.app/Contents/PlugIns:/Applications/MySQLWorkbench.app/Contents/Resources/plugins
library path: /Applications/MySQLWorkbench.app/Contents/Resources/libraries
user data dir: /Users/chenje02/Library/Application Support/MySQL/Workbench
open at start:
open type:
run at startup:
run type:
Force SW rendering: No
Force OpenGL: No
quit when done: No
11:52:37 [INF][ WBContext]: WbContext::init
11:52:37 [INF][ WBA]: Looking for extension modules for WBA...
11:52:37 [INF][ WBA]: 0 extension modules found
11:52:37 [WRN][ grt]: /Applications/MySQLWorkbench.app/Contents/Resources/modules/data/mysql_rdbms_info.xml:1401: link 'om.mysql.rdbms.mysql.driver.native_sshtun' <object > key=owner could not be resolved
11:52:37 [WRN][ grt]: /Users/chenje02/Library/Application Support/MySQL/Workbench/connections.xml:26: link '00881E77-2AE0-4D47-936D-4BCFB19F2347' <object GrtObject> key=owner could not be resolved
11:52:37 [INF][ WBContext]: System info:
MySQL Workbench Community (GPL) for Mac OS X version 8.0.12 CE build 13312926 (64 bit)
Configuration Directory: /Users/chenje02/Library/Application Support/MySQL/Workbench
Data Directory: /Applications/MySQLWorkbench.app/Contents/Resources
Cairo Version: 1.10.2
OS: macOS 10.13.x High Sierra x86_64
CPU: 8x Intel(R) Core(TM) i7-6820HQ CPU @ 2.70GHz - 16.00GiB RAM
No video adapter info available
11:52:40 [INF][SQL Editor Form]: Opened connection 'Live Db' to MySQL Community Server (GPL) version 5.6.35-log
11:53:12 [ERR][SQL Editor Form]: Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column
To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect.
11:53:30 [WRN][SQL Editor Form]: 0 row(s) affected, 1 warning(s):
1050 Table 'TempAvailableClients' already exists
11:53:37 [ERR][SQL Editor Form]: Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column
To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect.
11:53:49 [ERR][SQL Editor Form]: Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column
To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect.
11:55:52 [ERR][SQL Editor Form]: Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column
To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect.
11:56:03 [INF][SQL Editor Form]: Opened connection 'Live Db' to MySQL Community Server (GPL) version 5.6.35-log
11:58:38 [ERR][SQL Editor Form]: Error Code: 1146. Table 'SolarDb.AvailableClients2' doesn't exist
11:59:26 [ERR][ WBContext]: WBContext: exception in flush idle task: Exception:
11:59:36 [ERR][SQL Editor Form]: Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GetCallTypeselect a.*, IFNULL(b.LastSale, '2000-01-01') as LastSale
from TempAv' at line 1
11:59:55 [ERR][SQL Editor Form]: Error Code: 1146. Table 'SolarDb.TempAvailableClients2' doesn't exist
12:00:18 [ERR][SQL Editor Form]: Error Code: 1146. Table 'SolarDb.TempAvailableClients2' doesn't exist
12:00:45 [WRN][SQL Editor Form]: 0 row(s) affected, 1 warning(s):
1050 Table 'TempAvailableClients' already exists
12:03:00 [ERR][ utilities]: Could not open URL http://bugs.mysql.com/report.php?in[status]=Open&in[php_version]=8.0.12&in[os]=6&in[os_det... 10.13.x High Sierra x86_64&in[tags]=WBBugReporter&in[really]=0&in[ldesc]=----[For better reports, please attach the log file after submitting. You can find it in /Users/chenje02/Library/Application Support/MySQL/Workbench/log/wb.log]
How to repeat:
Everytime i run a SQL query that produces an error, if i fix the query and it runs successfully, the result grid does now show, unless i restart SQL workbench completely.
This started happening when i upgraded my Mac OS to High Sierra 10.13.2.
I tried uninstalling SQL workbench and reinstalling. Still same problems.
Suggested fix:
Please help fix!