| Summary: | Kexi crashes while importing certain CSV file into MySQL DB | ||
|---|---|---|---|
| Product: | [Applications] KEXI | Reporter: | mark75to <m.iannozzi> |
| Component: | Migration/Import/Export | Assignee: | Jarosław Staniek <staniek> |
| Status: | CLOSED WAITINGFORINFO | ||
| Severity: | crash | ||
| Priority: | NOR | ||
| Version: | 2.2.2 (KOffice 2.2.2) | ||
| Target Milestone: | --- | ||
| Platform: | Ubuntu | ||
| OS: | Linux | ||
| Latest Commit: | Version Fixed In: | 2.4 (Calligra 2.4) | |
| Sentry Crash Report: | |||
| Bug Depends on: | 279980 | ||
| Bug Blocks: | |||
| Attachments: | CSV file that is not imported properly | ||
|
Description
mark75to
2010-10-13 15:49:38 UTC
Hi, thanks for reporting. Could you please try to: 1. import the CSV file into SQLite (file-based) database using Kexi? 2. add test CSV file that crashed as attachment here or send to me (staniek at kde .org) Hello, I have tried to import same csv file in Kexi file-based and it works good. Sorry but I can't send data file because it contain information about my organization unit. So let me know how can I help you. Best Regards. (In reply to comment #1) > Hi, thanks for reporting. Could you please try to: > 1. import the CSV file into SQLite (file-based) database using Kexi? > 2. add test CSV file that crashed as attachment here or send to me (staniek at > kde .org) I understand that you have sensitive data. In such cases it will be enough if you create CSV file with one or two lines or random data that causes problems in Kexi (you can also replace texts with XXXXXX, etc.). Also please consider testing if the file can be imported if you use SQLite database (.kexi file) instead of MySQL. This will help me to identify source of the issues. Related to #279980 Created attachment 69352 [details]
CSV file that is not imported properly
While importing this file, the mysql server responds:
Message from server: Column count doesn't match value count at row 1
SQL statement: INSERT INTO votersbook_small2(id,column_1,column_2,column_3,column_4) VALUES (NULL,NULL,NULL,'c')
Server result: 1136
Git commit 7661374b40c0a626de0d0493bf5914aec727a843 by Jaroslaw Staniek. Committed on 07/03/2012 at 21:45. Pushed by staniek into branch 'master'. KexiDB MySQL Driver: fixed crash when inserting incomplete rows KexiDB *MySQL Driver **fixed crash in prepared statement execution for inserting data when number of items to insert is smaller than expected; this case could be found when importing CSV data in Kexi with fewer columns specified than expected Related: bug 279980 FIXED-IN: 2.4 (Calligra 2.4) M +10 -3 kexi/doc/dev/CHANGELOG-Kexi-js M +8 -1 kexi/kexidb/drivers/mySQL/mysqlpreparedstatement.cpp M +1 -1 kexi/kexidb/drivers/mySQL/mysqlpreparedstatement.h http://commits.kde.org/calligra/7661374b40c0a626de0d0493bf5914aec727a843 Git commit 4ca56dd13fe4b97ddcd940eaa6e5ef0d9b509ad6 by Jaroslaw Staniek. Committed on 07/03/2012 at 21:45. Pushed by staniek into branch 'calligra/2.4'. KexiDB MySQL Driver: fixed crash when inserting incomplete rows KexiDB *MySQL Driver **fixed crash in prepared statement execution for inserting data when number of items to insert is smaller than expected; this case could be found when importing CSV data in Kexi with fewer columns specified than expected Related: bug 279980 FIXED-IN: 2.4 (Calligra 2.4) REVIEW: 104188 M +1 -1 kexi/doc/dev/CHANGELOG-Kexi-js M +8 -1 kexi/kexidb/drivers/mySQL/mysqlpreparedstatement.cpp M +1 -1 kexi/kexidb/drivers/mySQL/mysqlpreparedstatement.h http://commits.kde.org/calligra/4ca56dd13fe4b97ddcd940eaa6e5ef0d9b509ad6 Git commit 0c2d1ba6250e8346c5f67b3c963bc1ce1d80bead by Jaroslaw Staniek. Committed on 07/03/2012 at 23:40. Pushed by staniek into branch 'calligra/2.4'. KexiDB PostgreSQL Driver: fixed crash when inserting incomplete rows KexiDB *PostgreSQL Driver **fixed crash in prepared statement execution for inserting data when number of items to insert is smaller than expected; this case could be found when importing CSV data in Kexi with fewer columns specified than expected Related: bug 279980 FIXED-IN: 2.4 (Calligra 2.4) REVIEW: 104189 M +8 -0 kexi/kexidb/drivers/pqxx/pqxxpreparedstatement.cpp http://commits.kde.org/calligra/0c2d1ba6250e8346c5f67b3c963bc1ce1d80bead Git commit 38da0b59e0864e69c880fbbab27e88e113eea7e5 by Jaroslaw Staniek. Committed on 07/03/2012 at 23:40. Pushed by staniek into branch 'master'. KexiDB PostgreSQL Driver: fixed crash when inserting incomplete rows KexiDB *PostgreSQL Driver **fixed crash in prepared statement execution for inserting data when number of items to insert is smaller than expected; this case could be found when importing CSV data in Kexi with fewer columns specified than expected Related: bug 279980 FIXED-IN: 2.4 (Calligra 2.4) REVIEW: 104189 M +8 -0 kexi/kexidb/drivers/pqxx/pqxxpreparedstatement.cpp http://commits.kde.org/calligra/38da0b59e0864e69c880fbbab27e88e113eea7e5 Fixed related issues, also for PostgreSQL. If you confirm the fix this bug will be closed. Git commit 58f546cfbc490938c4049b99c81e543397b2ca6d by Jaroslaw Staniek. Committed on 27/06/2012 at 09:49. Pushed by staniek into branch 'master'. MySQL & PostgreSQL Driver: Fixed crash when inserting incomplete rows *Fixed crash in prepared statement execution for inserting data when number of items to insert is smaller than expected; this case could be found when importing CSV data in Kexi with fewer columns specified than expected **(2012-03-07 calligra master commit 7661374b40c) **(2012-03-07 calligra master commit 38da0b59e08) Related: bug 279980 M +14 -7 Drivers/mysql/MysqlPreparedStatement.cpp M +2 -1 Drivers/mysql/MysqlPreparedStatement.h M +16 -8 Drivers/postgresql/PostgresqlPreparedStatement.cpp M +2 -1 Drivers/postgresql/PostgresqlPreparedStatement.h M +4 -3 Drivers/sqlite/SqlitePreparedStatement.cpp M +2 -1 Drivers/sqlite/SqlitePreparedStatement.h M +2 -1 Predicate/Interfaces/PreparedStatementInterface.h M +1 -1 Predicate/PreparedStatement.cpp http://commits.kde.org/predicate/58f546cfbc490938c4049b99c81e543397b2ca6d |