ondras / wwwsqldesigner

WWW SQL Designer, your online SQL diagramming tool
https://sql.toad.cz/?keyword=online_library
BSD 3-Clause "New" or "Revised" License
2.86k stars 722 forks source link

Add Table in Chrome does not work #285

Open thomasdilts opened 5 years ago

thomasdilts commented 5 years ago

Add Table does not work in google chrome. It works in all the other browsers I have tried.

ondras commented 4 years ago

I think you will have to be more specific.

I just tried that with Chrome 75, Windows 10, https://ondras.zarovi.cz/sql/demo/ -- and it normally worked.

What exactly is your setup and what happens? Does the Console show something relevant?

thomasdilts commented 4 years ago

Wow. That is really strange. Now, when I try in chrome it works perfectly. It really is a wonderful tool. Thank you so much.

micodel commented 4 years ago

I appear to be having this issue. It was working off and on, but now just wont work. Ive tried restarting, new project, etc

Version 79.0.3945.130 (Official Build) (64-bit) MacOS 10.14.6 Mojave

UPDATE: Issue is present in Safari and Firefox as well

UPDATE: The issue went away after restarting my machine.

For more info, the issue originally started occurring after trying to add a new table, and the cursor changed into a gray click and drag box selector.

UPDATE: This issue keeps reoccurring. When it happens, it appears to get stuck on the closing of the gray click and drag box. I have a hard time trying to get that selector to go away.

I just mash clicked a bunch of times and it eventually resolved itself. In past occurrence I have been unable to get it to go away without reloading. I assume it's a JavaScript issue but I am not seeing any immediate console errors.

ondras commented 4 years ago

Hi @micodel, thanks for your detailed report. Can you please clarify (using words or screenshots) these two, please?

the cursor changed into a gray click and drag box selector.

stuck on the closing of the gray click and drag box

In particular: adding a table is a two-step process, where you first have to click the workspace in order to determine the table's position; then a popup box is opened where you fill in the table's name. When does the behavior described happens?

micodel commented 4 years ago

@ondras

Step 1: Click the "Add Table" button. This changes the cursor to a cross. Step 2: Try to click on the workspace to add the table.

Step 2 is where the failure sometimes occurs. It should normally drop the table box, but sometimes this second click fails to respond, it gets stuck and you can only just click and drag around a gray highlight window, which I seem unable to escape.

You can recreate this when the app is functioning by clicking and holding and dragging around the "Add Table" cursor.

I believe this is the same highlight box used to select multiple table boxes for rearrangement.

micodel commented 4 years ago

@ondras Also if this helps, I ran into the issue again today.

When I reloaded the browser tab, I received this alert.

Screen Shot 2020-02-05 at 5 01 10 PM

This appeared to happen instead of the app loading in the default / example tables.

UPDATE: Completely restarting Chrome resolved this issue. Google Chrome: Version 79.0.3945.130 (Official Build) (64-bit)

micodel commented 4 years ago

@ondras P.S. Thanks for maintaining this app! Have used it for several years

ondras commented 4 years ago

Step 2 is where the failure sometimes occurs. It should normally drop the table box, but sometimes this second click fails to respond, it gets stuck and you can only just click and drag around a gray highlight window, which I seem unable to escape.

If you move the mouse a bit between pressing and releasing the button, you will experience precisely the described behavior. That is because the sequence "press down and move" will initiate and create the multi-selection area; releasing the button subsequently will happen over this area and thus no "click" will be generated (mouse down/up must happen on the same element in order for "click" to be fired).

nervouna commented 4 years ago

I've encountered the same issue. However it worked fine in incognito mode.

Chrome Version 83.0.4103.61 (Official Build) (64-bit) Windows 10 18363.836

rpgd60 commented 4 years ago

(re-reading the comments below, I realize I am explaining --with different words-- what Ondras mentioned last February 12th)

I encountered the same issue, in Brave (1.7.92) and Firefox (77.0.1) running on Kubuntu 19.10 This does not look like a bug to me but simply a somewhat awkward unexpected GUI behavior

screenshot www sql designer

In short, this is still a great application but in my opinion the GUI could be a bit more friendly :-) One simple option to help clumsy people like me could be to change the Menu from "[place table]" to something like "[click to place table]"