Description:
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\Mc\AppData\Roaming\MySQL\Workbench\log\wb.log]
11:03:24 [ERR][ Workbench]: Console redirection failed.
11:03:24 [INF][ WBContext]: Parsing application arguments.
11:03:24 [INF][ WBContext]: C:\Program Files\MySQL\MySQL Workbench 6.3 CE\MySQLWorkbench.exe
11:03:24 [INF][ Workbench]: Starting up Workbench
11:03:24 [INF][ Workbench]: Current environment:
Command line: "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\MySQLWorkbench.exe"
CurrentDirectory: C:\Program Files\MySQL\MySQL Workbench 6.3 CE
HasShutdownStarted: False
OSVersion: Microsoft Windows NT 6.1.7601 Service Pack 1
SystemDirectory: C:\Windows\system32
TickCount: 2658484
UserInteractive: True
Version: 4.0.30319.34209
WorkingSet: 37015552
11:03:24 [INF][ Workbench]: Environment variables:
Path = C:\Program Files\iis express\PHP\v5.3;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\Microsoft\Web Platform Installer\;C:\Program Files\Microsoft SQL Server\110\Tools\Binn\;C:\Program Files\Microsoft SQL Server\120\Tools\Binn\;C:\Program Files\Microsoft SDKs\TypeScript\1.0\;
SESSIONNAME = RDP-Tcp#0
PATHEXT = .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
USERDOMAIN = ITBIZ
PROCESSOR_ARCHITECTURE = x86
SystemDrive = C:
PUBLIC = C:\Users\Public
APPDATA = C:\Users\Mc\AppData\Roaming
windir = C:\Windows
LOCALAPPDATA = C:\Users\Mc\AppData\Local
TMP = C:\Users\Mc\AppData\Local\Temp
USERPROFILE = C:\Users\Mc
ProgramFiles = C:\Program Files
PROCESSOR_LEVEL = 6
FP_NO_HOST_CHECK = NO
HOMEPATH = \Users\Mc
COMPUTERNAME = ITBIZ
USERNAME = Mc
NUMBER_OF_PROCESSORS = 2
PROCESSOR_IDENTIFIER = x86 Family 6 Model 15 Stepping 2, GenuineIntel
SystemRoot = C:\Windows
ComSpec = C:\Windows\system32\cmd.exe
LOGONSERVER = \\ITBIZ
TEMP = C:\Users\Mc\AppData\Local\Temp
CommonProgramFiles = C:\Program Files\Common Files
VS120COMNTOOLS = C:\Program Files\Microsoft Visual Studio 12.0\Common7\Tools\
PROCESSOR_REVISION = 0f02
CLIENTNAME = TEKNIKA
PSModulePath = C:\Windows\system32\WindowsPowerShell\v1.0\Modules\
ALLUSERSPROFILE = C:\ProgramData
OS = Windows_NT
ProgramData = C:\ProgramData
HOMEDRIVE = C:
11:03:24 [INF][ Workbench]: Current version given by meta info is: 6.3.6
11:03:24 [INF][ Workbench]: Setting PATH to: C:\Windows\system32;C:\Program Files\iis express\PHP\v5.3;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\Microsoft\Web Platform Installer\;C:\Program Files\Microsoft SQL Server\110\Tools\Binn\;C:\Program Files\Microsoft SQL Server\120\Tools\Binn\;C:\Program Files\Microsoft SDKs\TypeScript\1.0\;
11:03:24 [INF][ mforms managed]: Initializing mforms wrapper
11:03:24 [INF][ WBContext UI]: Initializing workbench context UI with these values:
base dir: C:\Program Files\MySQL\MySQL Workbench 6.3 CE
plugin path: C:\Program Files\MySQL\MySQL Workbench 6.3 CE
struct path:
module path: C:\Program Files\MySQL\MySQL Workbench 6.3 CE/modules
library path: C:\Program Files\MySQL\MySQL Workbench 6.3 CE
user data dir: C:\Users\Mc\AppData\Roaming\MySQL\Workbench
open at start:
open type:
run at startup:
run type:
Force SW rendering: No
Force OpenGL: No
quit when done: No
11:03:25 [INF][ WBContext]: WbContext::init
11:03:25 [INF][ grt]: Scanning module directory C:\Users\Mc\AppData\Roaming\MySQL\Workbench\modules.
11:03:25 [INF][ grt]: Scanning module directory ..
11:03:25 [INF][ grt]: Scanning module directory C:\Program Files\MySQL\MySQL Workbench 6.3 CE/modules.
11:03:30 [INF][ WBA]: Looking for extension modules for WBA...
11:03:30 [INF][ WBA]: 0 extension modules found
11:03:30 [WRN][ grt]: C:\Program Files\MySQL\MySQL Workbench 6.3 CE\data/table_templates.xml:21: link 'com.mysql.rdbms.mysql.datatype.timestamp' <object db.SimpleDatatype> key=simpleType could not be resolved
11:03:30 [WRN][ grt]: C:\Program Files\MySQL\MySQL Workbench 6.3 CE\data/table_templates.xml:106: link 'com.mysql.rdbms.mysql.datatype.varchar' <object db.SimpleDatatype> key=simpleType could not be resolved
11:03:30 [WRN][ grt]: C:\Program Files\MySQL\MySQL Workbench 6.3 CE\data/table_templates.xml:229: link 'com.mysql.rdbms.mysql.datatype.int' <object db.SimpleDatatype> key=simpleType could not be resolved
11:03:30 [INF][ grt]: Scanning module directory C:\Program Files\MySQL\MySQL Workbench 6.3 CE.
11:03:30 [WRN][ grt]: C:\Users\Mc\AppData\Roaming\MySQL\Workbench\connections.xml:17: link '{845624A4-4069-4CD2-8546-BF095ECB21F6}' <object GrtObject> key=owner could not be resolved
11:03:31 [INF][ WBContext]: System info:
MySQL Workbench Community (GPL) for Windows version 6.3.6 CE build 511 (32 bit)
Configuration Directory: C:\Users\Mc\AppData\Roaming\MySQL\Workbench
Data Directory: C:\Program Files\MySQL\MySQL Workbench 6.3 CE
Cairo Version: 1.10.2
OS: Microsoft Windows 7 Ultimate Service Pack 1
CPU: 2x Intel(R) Core(TM)2 CPU 6300 @ 1.86GHz, 2.0 GiB RAM
Active video adapter Intel(R) G41 Express Chipset
Installed video RAM: 782 MB
Current video mode: 1024 x 768 x 4294967296 colors
Used bit depth: 32
Driver version: 8.15.10.2302
Installed display drivers: igdumdx32.dll,igd10umd32.dll
Current user language: English (United States)
11:03:31 [INF][ Workbench]: UI is up
11:03:31 [INF][ Workbench]: Running the application
11:03:35 [INF][ SqlEditor]: Opened connection 'Local instance MySQL55' to MySQL Community Server (GPL) version 5.5.48-log
11:03:37 [INF][ AutoCCache]: Initializing autocompletion cache for Local_instance_MySQL55
11:03:39 [INF][ WQE.net]: Launching SQL IDE
11:03:46 [INF][ WQE.net]: SQL IDE UI is ready
12:41:10 [INF][wb_admin_control.py:server_polling_thread:540]: Monitoring thread running...
12:41:11 [INF][wb_admin_control.py:query_server_installation_info:828]: Currently connected to MySQL server version '5.5.48-log', conn status = True, active plugins = ['partition', 'INNODB_CMPMEM_RESET', 'INNODB_BUFFER_POOL_STATS', 'CSV', 'mysql_native_password', 'INNODB_BUFFER_PAGE', 'InnoDB', 'ARCHIVE', 'INNODB_CMP', 'INNODB_TRX', 'binlog', 'INNODB_LOCKS', 'INNODB_CMPMEM', 'INNODB_LOCK_WAITS', 'MEMORY', 'MRG_MYISAM', 'PERFORMANCE_SCHEMA', 'mysql_old_password', 'BLACKHOLE', 'MyISAM', 'INNODB_CMP_RESET', 'INNODB_BUFFER_PAGE_LRU']
12:41:11 [INF][wb_admin_control.py:acquire_admin_access:284]: Target OS detection returned: os_type=windows, os_name=Windows 7 Ultimate, os_variant=Windows, os_version=Microsoft Windows [Version 6.1.7601]
12:41:12 [ERR][wb_admin_server_status.py:create_info_sections:419]: mysql_firewall_trace: None
12:41:12 [ERR][wb_admin_server_status.py:create_info_sections:420]: Firewall_access_denied: None
12:41:12 [ERR][wb_admin_server_status.py:create_info_sections:421]: Firewall_access_granted: None
12:41:12 [ERR][wb_admin_server_status.py:create_info_sections:422]: Firewall_cached_entries: None
12:48:30 [ERR][wb_admin_main.py:shutdown:217]: shutting down admn
12:48:31 [INF][wb_admin_control.py:server_polling_thread:556]: Monitoring thread done.
14:43:04 [ERR][ GRTDispatcher]: exception in grt execute_task, continuing: Exception: There was an error while applying the SQL script to the database.
14:43:04 [ERR][ GRTDispatcher]: worker: task 'wizard task' has failed with error:.There was an error while applying the SQL script to the database.
How to repeat:
create table with a boolean datatype b(1)
enter some data..
change the boolean value in workbench
an error will show
Suggested fix:
remove the single quote for the boolean value
example in my case:
UPDATE `mytable`.`user_profilelikes` SET `deleted`='1' WHERE `id`='2';
This works:
UPDATE `mytable`.`user_profilelikes` SET `deleted`=1 WHERE `id`='2';
Description: ----[For better reports, please attach the log file after submitting. You can find it in C:\Users\Mc\AppData\Roaming\MySQL\Workbench\log\wb.log] 11:03:24 [ERR][ Workbench]: Console redirection failed. 11:03:24 [INF][ WBContext]: Parsing application arguments. 11:03:24 [INF][ WBContext]: C:\Program Files\MySQL\MySQL Workbench 6.3 CE\MySQLWorkbench.exe 11:03:24 [INF][ Workbench]: Starting up Workbench 11:03:24 [INF][ Workbench]: Current environment: Command line: "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\MySQLWorkbench.exe" CurrentDirectory: C:\Program Files\MySQL\MySQL Workbench 6.3 CE HasShutdownStarted: False OSVersion: Microsoft Windows NT 6.1.7601 Service Pack 1 SystemDirectory: C:\Windows\system32 TickCount: 2658484 UserInteractive: True Version: 4.0.30319.34209 WorkingSet: 37015552 11:03:24 [INF][ Workbench]: Environment variables: Path = C:\Program Files\iis express\PHP\v5.3;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\Microsoft\Web Platform Installer\;C:\Program Files\Microsoft SQL Server\110\Tools\Binn\;C:\Program Files\Microsoft SQL Server\120\Tools\Binn\;C:\Program Files\Microsoft SDKs\TypeScript\1.0\; SESSIONNAME = RDP-Tcp#0 PATHEXT = .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC USERDOMAIN = ITBIZ PROCESSOR_ARCHITECTURE = x86 SystemDrive = C: PUBLIC = C:\Users\Public APPDATA = C:\Users\Mc\AppData\Roaming windir = C:\Windows LOCALAPPDATA = C:\Users\Mc\AppData\Local TMP = C:\Users\Mc\AppData\Local\Temp USERPROFILE = C:\Users\Mc ProgramFiles = C:\Program Files PROCESSOR_LEVEL = 6 FP_NO_HOST_CHECK = NO HOMEPATH = \Users\Mc COMPUTERNAME = ITBIZ USERNAME = Mc NUMBER_OF_PROCESSORS = 2 PROCESSOR_IDENTIFIER = x86 Family 6 Model 15 Stepping 2, GenuineIntel SystemRoot = C:\Windows ComSpec = C:\Windows\system32\cmd.exe LOGONSERVER = \\ITBIZ TEMP = C:\Users\Mc\AppData\Local\Temp CommonProgramFiles = C:\Program Files\Common Files VS120COMNTOOLS = C:\Program Files\Microsoft Visual Studio 12.0\Common7\Tools\ PROCESSOR_REVISION = 0f02 CLIENTNAME = TEKNIKA PSModulePath = C:\Windows\system32\WindowsPowerShell\v1.0\Modules\ ALLUSERSPROFILE = C:\ProgramData OS = Windows_NT ProgramData = C:\ProgramData HOMEDRIVE = C: 11:03:24 [INF][ Workbench]: Current version given by meta info is: 6.3.6 11:03:24 [INF][ Workbench]: Setting PATH to: C:\Windows\system32;C:\Program Files\iis express\PHP\v5.3;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\Microsoft\Web Platform Installer\;C:\Program Files\Microsoft SQL Server\110\Tools\Binn\;C:\Program Files\Microsoft SQL Server\120\Tools\Binn\;C:\Program Files\Microsoft SDKs\TypeScript\1.0\; 11:03:24 [INF][ mforms managed]: Initializing mforms wrapper 11:03:24 [INF][ WBContext UI]: Initializing workbench context UI with these values: base dir: C:\Program Files\MySQL\MySQL Workbench 6.3 CE plugin path: C:\Program Files\MySQL\MySQL Workbench 6.3 CE struct path: module path: C:\Program Files\MySQL\MySQL Workbench 6.3 CE/modules library path: C:\Program Files\MySQL\MySQL Workbench 6.3 CE user data dir: C:\Users\Mc\AppData\Roaming\MySQL\Workbench open at start: open type: run at startup: run type: Force SW rendering: No Force OpenGL: No quit when done: No 11:03:25 [INF][ WBContext]: WbContext::init 11:03:25 [INF][ grt]: Scanning module directory C:\Users\Mc\AppData\Roaming\MySQL\Workbench\modules. 11:03:25 [INF][ grt]: Scanning module directory .. 11:03:25 [INF][ grt]: Scanning module directory C:\Program Files\MySQL\MySQL Workbench 6.3 CE/modules. 11:03:30 [INF][ WBA]: Looking for extension modules for WBA... 11:03:30 [INF][ WBA]: 0 extension modules found 11:03:30 [WRN][ grt]: C:\Program Files\MySQL\MySQL Workbench 6.3 CE\data/table_templates.xml:21: link 'com.mysql.rdbms.mysql.datatype.timestamp' <object db.SimpleDatatype> key=simpleType could not be resolved 11:03:30 [WRN][ grt]: C:\Program Files\MySQL\MySQL Workbench 6.3 CE\data/table_templates.xml:106: link 'com.mysql.rdbms.mysql.datatype.varchar' <object db.SimpleDatatype> key=simpleType could not be resolved 11:03:30 [WRN][ grt]: C:\Program Files\MySQL\MySQL Workbench 6.3 CE\data/table_templates.xml:229: link 'com.mysql.rdbms.mysql.datatype.int' <object db.SimpleDatatype> key=simpleType could not be resolved 11:03:30 [INF][ grt]: Scanning module directory C:\Program Files\MySQL\MySQL Workbench 6.3 CE. 11:03:30 [WRN][ grt]: C:\Users\Mc\AppData\Roaming\MySQL\Workbench\connections.xml:17: link '{845624A4-4069-4CD2-8546-BF095ECB21F6}' <object GrtObject> key=owner could not be resolved 11:03:31 [INF][ WBContext]: System info: MySQL Workbench Community (GPL) for Windows version 6.3.6 CE build 511 (32 bit) Configuration Directory: C:\Users\Mc\AppData\Roaming\MySQL\Workbench Data Directory: C:\Program Files\MySQL\MySQL Workbench 6.3 CE Cairo Version: 1.10.2 OS: Microsoft Windows 7 Ultimate Service Pack 1 CPU: 2x Intel(R) Core(TM)2 CPU 6300 @ 1.86GHz, 2.0 GiB RAM Active video adapter Intel(R) G41 Express Chipset Installed video RAM: 782 MB Current video mode: 1024 x 768 x 4294967296 colors Used bit depth: 32 Driver version: 8.15.10.2302 Installed display drivers: igdumdx32.dll,igd10umd32.dll Current user language: English (United States) 11:03:31 [INF][ Workbench]: UI is up 11:03:31 [INF][ Workbench]: Running the application 11:03:35 [INF][ SqlEditor]: Opened connection 'Local instance MySQL55' to MySQL Community Server (GPL) version 5.5.48-log 11:03:37 [INF][ AutoCCache]: Initializing autocompletion cache for Local_instance_MySQL55 11:03:39 [INF][ WQE.net]: Launching SQL IDE 11:03:46 [INF][ WQE.net]: SQL IDE UI is ready 12:41:10 [INF][wb_admin_control.py:server_polling_thread:540]: Monitoring thread running... 12:41:11 [INF][wb_admin_control.py:query_server_installation_info:828]: Currently connected to MySQL server version '5.5.48-log', conn status = True, active plugins = ['partition', 'INNODB_CMPMEM_RESET', 'INNODB_BUFFER_POOL_STATS', 'CSV', 'mysql_native_password', 'INNODB_BUFFER_PAGE', 'InnoDB', 'ARCHIVE', 'INNODB_CMP', 'INNODB_TRX', 'binlog', 'INNODB_LOCKS', 'INNODB_CMPMEM', 'INNODB_LOCK_WAITS', 'MEMORY', 'MRG_MYISAM', 'PERFORMANCE_SCHEMA', 'mysql_old_password', 'BLACKHOLE', 'MyISAM', 'INNODB_CMP_RESET', 'INNODB_BUFFER_PAGE_LRU'] 12:41:11 [INF][wb_admin_control.py:acquire_admin_access:284]: Target OS detection returned: os_type=windows, os_name=Windows 7 Ultimate, os_variant=Windows, os_version=Microsoft Windows [Version 6.1.7601] 12:41:12 [ERR][wb_admin_server_status.py:create_info_sections:419]: mysql_firewall_trace: None 12:41:12 [ERR][wb_admin_server_status.py:create_info_sections:420]: Firewall_access_denied: None 12:41:12 [ERR][wb_admin_server_status.py:create_info_sections:421]: Firewall_access_granted: None 12:41:12 [ERR][wb_admin_server_status.py:create_info_sections:422]: Firewall_cached_entries: None 12:48:30 [ERR][wb_admin_main.py:shutdown:217]: shutting down admn 12:48:31 [INF][wb_admin_control.py:server_polling_thread:556]: Monitoring thread done. 14:43:04 [ERR][ GRTDispatcher]: exception in grt execute_task, continuing: Exception: There was an error while applying the SQL script to the database. 14:43:04 [ERR][ GRTDispatcher]: worker: task 'wizard task' has failed with error:.There was an error while applying the SQL script to the database. How to repeat: create table with a boolean datatype b(1) enter some data.. change the boolean value in workbench an error will show Suggested fix: remove the single quote for the boolean value example in my case: UPDATE `mytable`.`user_profilelikes` SET `deleted`='1' WHERE `id`='2'; This works: UPDATE `mytable`.`user_profilelikes` SET `deleted`=1 WHERE `id`='2';