Bug 307575

Summary:	Table import fails with error "Unable to create table"
Product:	[Applications] KEXI	Reporter:	Guido Schmidt <guido>
Component:	Migration/Import/Export	Assignee:	Kexi Bugs <kexi-bugs>
Status:	CONFIRMED ---
Severity:	normal
Priority:	NOR
Version First Reported In:	2.5.2
Target Milestone:	---
Platform:	openSUSE
OS:	Linux
Latest Commit:		Version Fixed In:
Sentry Crash Report:

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.