I have a MySQL-db with foreign key constraints. When I try to import it's structure into another MySQL-db I get an MySQL-syntax-error. Reproducible: Always Steps to Reproduce: 1. Select the source-location and db 2. Select the destination-type, title, project filename and db 3. Set type of import to "Structure only" 4. Help the importer by selecting the data type for a field (in this case Serviceposition.KVA which is decimal(7,2)) Actual Results: Failure Import failed Could not import data from data source ... Not connected to the database server. Message from server: You have an error in your SQL syntax; [...] near 'UNSIGNED NOT NULL, `status` VARCHAR(255) NOT NULL' at line 1 Server result: 1064 Expected Results: Imported db. (BTW: It would be nice if it were possible to mark the message window text for copying it) This is the db I was refering to in Bug #307479. I'm going to attach it here.
Created attachment 74229 [details] Database-structure exported with phpMyAdmin
Thanks for the valuable report, I'll investigate it as soon as possible.
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.