Bug 307575 - Table import fails with error "Unable to create table"
Summary: Table import fails with error "Unable to create table"
Status: CONFIRMED
Alias: None
Product: KEXI
Classification: Applications
Component: Migration/Import/Export (show other bugs)
Version: 2.5.2
Platform: openSUSE Linux
: NOR normal
Target Milestone: ---
Assignee: Kexi Bugs
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-09-29 13:35 UTC by Guido Schmidt
Modified: 2021-03-09 23:43 UTC (History)
0 users

See Also:
Latest Commit:
Version Fixed In:

Attachments
Add an attachment

Note You need to log in before you can comment on or make changes to this bug.
Description Guido Schmidt 2012-09-29 13:35:26 UTC 
I'm trying to import the tables from a MySQL-db with foreign key constraints into an empty Kexi-db (stored on the same MySQL-server). It only works with some of them. You can find an SQL-file with it's structure attached to bug #307571.

Reproducible: Always

Steps to Reproduce:
1. Open the table-import-assistant
2. Select source-location and database.
3. Select one of the tables. ("Auftragsstatus" for instance triggers the error while "Bearbeiter" doesn't)
4. Don't change anything in the "Alter the Detected Design"-Dialog
5. Start the import.

Actual Results:  
A Dialog with the error "Unable to create table" appears. After pressing OK the import-assistant claims "Success". The table has not been created.

Expected Results:  
Have the selected table imported.
If that's not possible give more information about what did't work.
Comment 1 Jarosław Staniek 2012-10-01 22:17:39 UTC 
Thanks for the valuable report, I'll investigate it as soon as possible.
Comment 2 Justin Zobel 2021-03-09 23:43:34 UTC 
Thank you for the bug report.

As this report hasn't seen any changes in 5 years or more, we ask if you can please confirm that the issue still persists.

If this bug is no longer persisting or relevant please change the status to resolved.