MySQL Bugs: #110670: I click on the + under database connections and nothing happens

Bug #110670	I click on the + under database connections and nothing happens
Submitted:	12 Apr 2023 19:20	Modified:	11 May 2023 22:31
Reporter:	Sean O'Connor	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	Shell VSCode Extension	Severity:	S1 (Critical)
Version:	1.9.1	OS:	Windows
Assigned to:		CPU Architecture:	Any

Description:
After 7 years of a bug in MYSQL Workbench causing our team frustration I was excited to see this new plug-in.  I loaded it and when I hit the + on the database connections..  nothing happens..  It seems very self explanatory, hit the plus to create a connection..   But it does nothing.  

Version: 1.77.3 (user setup)
Commit: 704ed70d4fd1c6bd6342c436f1ede30d1cff4710
Date: 2023-04-12T09:16:02.548Z
Electron: 19.1.11
Chromium: 102.0.5005.196
Node.js: 16.14.2
V8: 10.2.154.26-electron.0
OS: Windows_NT x64 10.0.19044
Sandboxed: Yes

Error log:
12:17:51.800542 INFO: Starting MySQL Shell GUI web server...

12:17:51.801541 INFO: 	Checking web server certificate...

12:17:51.990659 INFO: 	Certificate is installed.

12:17:51.997691 ERROR: Log message could not be inserted into db. near "Connor": syntax error

Could it be because my name has an apostrophe in it and somehow that is preventing me from creating a database connection?

How to repeat:
Click on the database connection + and nothing happens.

Updating severity

Hello Sean O'Connor,

Thank you for the bug report.
I tried to reproduce your issue on windows 10 with Shell VSCode Extension 1.9.1 but I am not seeing any issues at my end. Please see Bug #106843 and check the steps suggested by dev. Thanks.

Regards,
Ashwini Patil

Shell VSCode Extension 1.9.1 test results

Attachment: 110670_test_results.PNG (image/png, text), 125.57 KiB.

Hi,
How could you reproduce it if you didn't setup the situation to be the same as mine?  My last name is O'Connor and has an apostrophe.  Did you try it with a user who's winodws name has an apostrophe in it?  It won't reproduce unless you have a user who's name in windows has an apostrophe.  How can I get past this?

Please see the last error in my submission:
12:17:51.997691 ERROR: Log message could not be inserted into db. near "Connor": syntax error.

This is right after the apostrophe in my name.  You must have some sort of sql without parameters in your code, otherwise this would not occur.

Can you please try it for a user who's windows name has an apostrophe.  I tried to remove it however It's all integrated with my enterprise and my name is too ingrained in the windows system.

Are you still monitoring this bug or do I need to submit a new one?