Bug #109480 Beautifyer doesn't work
Submitted: 24 Dec 2022 21:49 Modified: 29 Dec 2022 9:53
Reporter: Kiss Attila Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:8.0.31 OS:Windows (Microsoft Windows 10 Home)
Assigned to: CPU Architecture:Other
Tags: WBBugReporter

[24 Dec 2022 21:49] Kiss Attila
Description:
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\Felhasználó\AppData\Roaming\MySQL\Workbench\log\wb.log]
22:31:31 [ERR][      Workbench]: Console redirection failed.
22:31:31 [INF][      Workbench]: Starting up Workbench
22:31:31 [INF][      Workbench]: Current environment:
	Command line: "C:\Program Files\MySQL\MySQL Workbench 8.0\MySQLWorkbench.exe" 
	CurrentDirectory: C:\Program Files\MySQL\MySQL Workbench 8.0
	HasShutdownStarted: False
	OSVersion: Microsoft Windows NT 6.2.9200.0
	SystemDirectory: C:\Windows\system32
	TickCount: 201165828
	UserInteractive: True
	Version: 4.0.30319.42000
	WorkingSet: 42635264
22:31:31 [INF][      Workbench]: Environment variables:
	COMPUTERNAME = DESKTOP-AHKV7GV
	USERPROFILE = C:\Users\Felhasználó
	HOMEPATH = \Users\Felhasználó
	LOCALAPPDATA = C:\Users\Felhasználó\AppData\Local
	PSModulePath = C:\Program Files\WindowsPowerShell\Modules;C:\Windows\system32\WindowsPowerShell\v1.0\Modules
	PROCESSOR_ARCHITECTURE = AMD64
	Path = C:\Program Files\Common Files\Oracle\Java\javapath;C:\Program Files\Amazon Corretto\jdk11.0.17_8\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\OpenSSH\;C:\Program Files\Meld\;C:\Users\Felhasználó\AppData\Local\Microsoft\WindowsApps;
	CommonProgramFiles(x86) = C:\Program Files (x86)\Common Files
	ProgramFiles(x86) = C:\Program Files (x86)
	PROCESSOR_LEVEL = 6
	LOGONSERVER = \\DESKTOP-AHKV7GV
	PATHEXT = .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
	HOMEDRIVE = C:
	SystemRoot = C:\Windows
	SESSIONNAME = Console
	ALLUSERSPROFILE = C:\ProgramData
	DriverData = C:\Windows\System32\Drivers\DriverData
	FPS_BROWSER_APP_PROFILE_STRING = Internet Explorer
	APPDATA = C:\Users\Felhasználó\AppData\Roaming
	PROCESSOR_REVISION = 9705
	USERNAME = attilakixx
	CommonProgramW6432 = C:\Program Files\Common Files
	TEMP = C:\Users\FELHAS~1\AppData\Local\Temp
	OneDrive = C:\Users\Felhasználó\OneDrive
	CommonProgramFiles = C:\Program Files\Common Files
	OS = Windows_NT
	USERDOMAIN_ROAMINGPROFILE = DESKTOP-AHKV7GV
	PROCESSOR_IDENTIFIER = Intel64 Family 6 Model 151 Stepping 5, GenuineIntel
	ComSpec = C:\Windows\system32\cmd.exe
	USERDOMAIN = DESKTOP-AHKV7GV
	SystemDrive = C:
	FPS_BROWSER_USER_PROFILE_STRING = Default
	ProgramFiles = C:\Program Files
	NUMBER_OF_PROCESSORS = 12
	TMP = C:\Users\FELHAS~1\AppData\Local\Temp
	ProgramData = C:\ProgramData
	ProgramW6432 = C:\Program Files
	windir = C:\Windows
	JAVA_HOME = C:\Program Files\Amazon Corretto\jdk11.0.17_8
	PUBLIC = C:\Users\Public
	ZES_ENABLE_SYSMAN = 1
22:31:31 [INF][      Workbench]: Current version given by meta info is: 8.0.31
22:31:31 [INF][      Workbench]: Setting PATH to: C:\Windows\system32;C:\Program Files\Common Files\Oracle\Java\javapath;C:\Program Files\Amazon Corretto\jdk11.0.17_8\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\OpenSSH\;C:\Program Files\Meld\;C:\Users\Felhasználó\AppData\Local\Microsoft\WindowsApps;
22:31:31 [INF][ mforms managed]: Initializing mforms wrapper
22:31:31 [INF][   WBContext UI]: Initializing workbench context UI with these values:
	base dir: C:\Program Files\MySQL\MySQL Workbench 8.0
	plugin path: C:\Program Files\MySQL\MySQL Workbench 8.0
	struct path: 
	module path: C:\Program Files\MySQL\MySQL Workbench 8.0/modules
	library path: C:\Program Files\MySQL\MySQL Workbench 8.0
	user data dir: C:\Users\Felhasználó\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
22:31:31 [INF][      WBContext]: WbContext::init
22:31:31 [INF][            WBA]: Looking for extension modules for WBA...
22:31:31 [INF][            WBA]: 0 extension modules found
22:31:31 [WRN][            grt]: Duplicate plugin name wb.tools.cmdlineClient	There is more than one plugin with the name wb.tools.cmdlineClient (in PyWbUtils and PyWbUtils).
22:31:31 [WRN][            grt]: C:\Users\Felhasználó\AppData\Roaming\MySQL\Workbench\connections.xml:25: link '{71E9B2C2-D77C-4E4C-B950-A6638DAC7803}' <object GrtObject> key=owner could not be resolved
22:31:31 [WRN][            grt]: Duplicate plugin name wb.tools.cmdlineClient	There is more than one plugin with the name wb.tools.cmdlineClient (in PyWbUtils and PyWbUtils).
22:31:31 [INF][      WBContext]: System info:
 	MySQL Workbench Community (GPL) for Windows version 8.0.31 CE build 2235049 (64 bit)
	Configuration Directory: C:\Users\Felhasználó\AppData\Roaming\MySQL\Workbench
	Data Directory: C:\Program Files\MySQL\MySQL Workbench 8.0
	Cairo Version: 1.17.4
	OS: Microsoft Windows 10 Home
	CPU: 12x 12th Gen Intel(R) Core(TM) i5-12500, 15.8 GiB RAM
	Active video adapter Intel(R) UHD Graphics 770
	Installed video RAM: 1024 MB
	Current video mode: 1920x1200x4294967296 szín
	Used bit depth: 32
	Driver version: 31.0.101.3302
	Installed display drivers: <>,C:\Windows\System32\DriverStore\FileRepository\iigd_dch.inf_amd64_f7180ab14784122f\igd10iumd64.dll,C:\Windows\System32\DriverStore\FileRepository\iigd_dch.inf_amd64_f7180ab14784122f\igd10iumd64.dll,C:\Windows\System32\DriverStore\FileRepository\iigd_dch.inf_amd64_f7180ab14784122f\igd12umd64.dll
	Current user language: magyar (Magyarország)

22:31:31 [INF][      Workbench]: UI is up
22:31:31 [INF][      Workbench]: Running the application
22:31:33 [ERR][SQL Editor Form]: Can't restore default schema (coffe_store): Unknown database 'coffe_store'
22:31:33 [ERR][SQL Editor Form]: Can't restore default schema (coffe_store): Unknown database 'coffe_store'
22:31:33 [INF][SQL Editor Form]: Opened connection 'development' to MySQL Community Server - GPL version 8.0.31
22:31:34 [INF][        WQE.net]: Launching SQL IDE
22:31:34 [INF][        WQE.net]: SQL IDE UI is ready
23:04:27 [ERR][SQL Editor Form]: Error Code: 1072. Key column 'address_id' doesn't exist in table
00:01:09 [INF][        WQE.net]: Shutting down SQL editor (development)

The beautifyer does'nt work at all.
nor ctrl+b, nor preferences/query editor/use uppercase keywords.

How to repeat:
Just type in any code, and press ctrl+b or the beautify button

Suggested fix:
Make it work :D
[27 Dec 2022 13:09] MySQL Verification Team
Hello,

Thank you for the bug report.
Imho this is duplicate of Bug #100608, please see Bug #100608.

Regards,
Ashwini Patil
[29 Dec 2022 9:49] Kiss Attila
hi, it is not the same error. Mine doesn't work at all. the beautifyer button doesn't do anything.
Also not even the sem OPsystem.
[29 Dec 2022 9:53] Kiss Attila
it has started to work now, I haven't changed anything. The use keyword won't get capitalised tho.