Bug 103068 - New Database Wizard gets confused between ODBC and JDBC connection if you backup twice to step 1.
Summary: New Database Wizard gets confused between ODBC and JDBC connection if you bac...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
5.2.2.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Database-Connectivity Database-Wizard
  Show dependency treegraph
 
Reported: 2016-10-09 18:55 UTC by Howard Johnson
Modified: 2018-12-07 11:27 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Howard Johnson 2016-10-09 18:55:45 UTC
Description:
While working inside the Database Wizard trying to setup ODBC, I noticed that the Database Wizard gets confused if you first select MySQL-ODBC, then backup and select ODBC, and then backup again and select MySQL-ODBC.

At that point (step 3) it should ask for the ODBC setup, but instead it asks for the JDBC setup.

This might or might not have to do with the fact that there are 4 steps from MySQL setup, and 5 steps for ODBC setup.



Steps to Reproduce:
From the menu:
  File | New | Database

---Opens the Database Wizard dialog -------
Step1:
* Connect to an existing database: MySQL
Next>>
-------------
Step2:
* Connect using ODBC
Next>>
-------------
Step3:
<<Back
-------------
Step2:
<<Back
-------------

Step1:
* Connect using ODBC
Next>>
-------------
Step2:
<<Back

-------------
Step1:
* Connect using MySQL
Next>>
-------------
Step2:
* Connect using ODBC
Next>>
-------------
Step3:
  Results: "Set up a connection to a MySQL database using JDBC" dialog.

((BUT, this should be "Set up a connection to a MySQL database using ODBC"))

Actual Results:  
Dialog opened: "Set up a connection to a MySQL database using JDBC"

Expected Results:
Dialog should open: "Set up a connection to a MySQL database using ODBC"


Reproducible: Always

User Profile Reset: No

Additional Info:
I may also have a problem w/ ODBC being broken, as I still can't get that to work without crashing, so stay tuned.  :-(


User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101 Firefox/45.0
Comment 1 Howard Johnson 2016-10-10 01:29:18 UTC
This bug appears to be more widespread than just where I reported it before.  I am also seeing similar behavior under "Use Wizard to Create Form..."

In other words, going forward is ok.  But going back gets messed up quickly.  

I have two tables:

-----------  
Categories:

Category ID
Category
-----------  

Items:

Item ID
Category ID
Item
-----------  

1. Select Table Categories.  >>Add all fields to the form.  Next>
2. Check Add Subform.  * Subform based on manual selection of fields.  Next>
3. Select Table Items.  >>Add all fields to the form.  Next>
4. <Back.
3. <Back.  (this click does nothing!)
3. <Back.
(We skipped #2)
1. Next>   (this click does nothing!)
(we skipped #2)
3. Next>   (this click does nothing!)
(we skipped #4)
5.  

Just crazy.  Probably just a little thing messing this all up.  But it clearly does not behave as I would expect.  

What I expect:  When I have the choice for "<Back" or "Next>" I would expect something to happen when I click on it.  

It might be reasonable to backup up by 2 at a time.

It does not seem reasonable to go forward skipping a step.

Thanks!
Comment 2 Robert Großkopf 2016-10-10 10:30:16 UTC
I could reproduce the behavior, If I do the following:

New Database
MySQL
MySQL-connection > ODBC
ODBC-connection

then back to
MySQL-connection, switch to JDBC
JDBC-connection

then back to
MySQL-connection, switch to ODBC

then back to
MySQL

You could see as step 3 now: JDBC-connection, but
MySQL-connection shows ODBC and step 3 would be the dialog for JDBC-connection.

Tested here with LO 5.2.2.2 on OpenSUSE 42.1 64bit rpm Linux.
Comment 3 Julien Nabet 2016-10-11 21:02:30 UTC
On pc Debian x86-64 with master sources updated today, I could reproduce this.
I suppose it's linked with svtools/source/dialogs/wizardmachine.cxx but I don't succeed in understanding where it's wrong.
Comment 4 Alex Thurgood 2016-10-12 10:14:00 UTC
@Julien : you could try asking Caolan if he has an idea, he fixed some UI stuff in the dbwizard not too long ago, perhaps this is related ?
Comment 5 Julien Nabet 2016-10-12 10:25:37 UTC
(In reply to Alex Thurgood from comment #4)
> @Julien : you could try asking Caolan if he has an idea, he fixed some UI
> stuff in the dbwizard not too long ago, perhaps this is related ?

Perhaps you thought about https://cgit.freedesktop.org/libreoffice/core/commit/?id=01889962cab8449e1d9682d22db0f6e1e28252fd but it's unrelated.
Anyway, let's ask him! :-)

Caolán: perhaps you may have some idea about root cause of this one?
Comment 6 QA Administrators 2018-10-24 02:56:32 UTC Comment hidden (obsolete)
Comment 7 Robert Großkopf 2018-10-24 06:24:25 UTC
Bug still exists for LO 6.1.2.1 on OpenSUSE 15, 64bit rpm Linux
Comment 8 himajin100000 2018-12-07 11:26:30 UTC
Steps to Reproduce:

1. Run LibreOffice Base

2. Database Wizard comes up.

3. Click 'Connect to an existing database'

4. Choose MySQL from the Combobox
4-Sub-1. See the 'Steps' Section in the roadmap on the left side. Threr you will find confusing 'Set up JDBC Connection' item. In fact this item is for JDBC, but displayed without connection information. Probably coders thought users can choose how to connect on the page later, but they did not notice the roadmap.

https://opengrok.libreoffice.org/xref/core/dbaccess/source/ui/dlg/generalpage.cxx?r=32ca8708#130

5. Next 

6. you will see a page with JDBC radio button checked as default. click 'Connect using ODBC'

7. Next

8. you will see 'Setup Connection to an ODBC Database' as the title.

9. Back

10. Back

11. Now you've reached the first page. you will see 'Set up ODBC Connection' in the roadmap. Yes, it's not JDBC, but it's ODBC!

12. VERY IMPORTANT STEP. Either click radio button or combobox for the 'Connect to exisiting database'. you will see JDBC in the roadmap.

13. Next

13. you will see ODBC radio button is checked.

14. ANOTHER VERY IMPORTANT STEP. DON'T TOUCH THE RADIOBUTTONS. ESPECIALLY DO NOT TRY CLICKING JDBC FIRST, and CLICKING ODBC AFTER THAT.

15. Next

ACTUAL RESULT:

As the repoter says, you will see "Set up a connection to a MySQL database using JDBC"

you are a nice person , who never forgets the impotant steps, and who don't like tricks in Halloween, aren't you ?
Comment 9 himajin100000 2018-12-07 11:27:45 UTC
typo:Threr -> There