Bug #111077 I click on the + under database connections and nothing happens
Submitted: 18 May 2023 16:00 Modified: 13 Jun 12:50
Reporter: Sean O'Connor Email Updates:
Status: Need Feedback Impact on me:
Category:Shell VSCode Extension Severity:S1 (Critical)
Version: OS:Any
Assigned to: MySQL Verification Team CPU Architecture:Any

[18 May 2023 16:00] Sean O'Connor
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
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?

PLEASE SEE PREVIOUS BUG.  #110670  The developer seemed to just close it and not look at it again.

I don't think the developer even tried to reproduce my setup.  My last name has an apostrophe in it and somewhere you have SQL that is failing.  Can you please setup a username with apostrophe or go look at the part of code where the apostrophe is getting injected?  See the error above.


How to repeat:
Click on the + and have a username with an apostrophe.  See error around dynamic SQL being messed up.
[13 Jun 12:50] MySQL Verification Team
Hello Sean O'Connor,

Thank you for the bug report.
Please upgrade to latest version and report us back if issue persist even in latest version. Thank you.

Ashwini Patil