| Summary: | Kexi crashed after importing a .csv file as a new table | ||
|---|---|---|---|
| Product: | [Applications] KEXI | Reporter: | toolman638 |
| Component: | Migration/Import/Export | Assignee: | Jarosław Staniek <staniek> |
| Status: | CLOSED FIXED | ||
| Severity: | crash | CC: | darksparc, kde, mh |
| Priority: | NOR | ||
| Version: | 2.3.3 (KOffice 2.3.3) | ||
| Target Milestone: | --- | ||
| Platform: | Ubuntu | ||
| OS: | Linux | ||
| Latest Commit: | Version Fixed In: | 2.4 rc1 (Calligra 2.4 rc1) | |
| Sentry Crash Report: | |||
| Bug Depends on: | |||
| Bug Blocks: | 254068 | ||
| Attachments: | New crash information added by DrKonqi | ||
|
Description
toolman638
2011-08-12 16:10:33 UTC
Thanks for the report! Could you please provide a small sample CSV file that causes a crash? *** Bug 283104 has been marked as a duplicate of this bug. *** *** Bug 287931 has been marked as a duplicate of this bug. *** Created attachment 69013 [details]
New crash information added by DrKonqi
kexi (2.3.3 (KOffice 2.3.3)) on KDE Platform 4.7.4 (4.7.4) using Qt 4.7.4
- What I was doing when the application crashed:
I was trying to import a UTF-8 CSV database into a new project
-- Backtrace (Reduced):
#7 isNull (d=0x1c) at kernel/qguivariant.cpp:292
#8 0x00298261 in QVariant::isNull (this=0x1c) at kernel/qvariant.cpp:2909
#9 0x02385347 in KexiDB::SQLitePreparedStatement::execute (this=0xa157bb8) at ../../../../../kexi/kexidb/drivers/sqlite/sqlitepreparedstatement.cpp:86
#10 0x02a53344 in saveRow (this=0xa0ad598, inGUI=<optimized out>) at ../../../../../kexi/plugins/importexport/csv/kexicsvimportdialog.cpp:1264
#11 KexiCSVImportDialog::saveRow (this=0xa0ad598, inGUI=false) at ../../../../../kexi/plugins/importexport/csv/kexicsvimportdialog.cpp:1257
Thanks for the backtrace but a small sample CSV file that causes a crash is needed to fix this bug (or to confirm that it's fixed already). You can attach it here or send to me: <staniek at kde.org> Reproduced using provided file, thanks. Git commit a99283dd1e3079a5c01f7d5cc270e678ce7f3eba by Jaroslaw Staniek. Committed on 27/02/2012 at 00:15. Pushed by staniek into branch 'master'. Fix crash while importing CSV rows that start with empty cells CSV Import *Fixed bug: crash while importing CSV rows that start with empty cells (only delimiters) **Example row: ,,,"a" FIXED-IN: 2.4 rc1 (Calligra 2.4 rc1) M +17 -3 kexi/plugins/importexport/csv/kexicsvimportdialog.cpp M +5 -2 kexi/plugins/importexport/csv/kexicsvimportdialog.h http://commits.kde.org/calligra/a99283dd1e3079a5c01f7d5cc270e678ce7f3eba Git commit 1e9be96a9e438186d5771d0e5797e68cb197311d by Jaroslaw Staniek. Committed on 27/02/2012 at 00:09. Pushed by staniek into branch 'master'. KexiDB SQLite Driver: fixed crash when inserting incomplete rows KexiDB *SQLite 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 M +4 -2 kexi/kexidb/drivers/sqlite/sqlitepreparedstatement.cpp M +1 -1 kexi/kexidb/drivers/sqlite/sqlitepreparedstatement.h http://commits.kde.org/calligra/1e9be96a9e438186d5771d0e5797e68cb197311d 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 254068 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 254068 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 254068 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 254068 FIXED-IN: 2.4 (Calligra 2.4) REVIEW: 104189 M +8 -0 kexi/kexidb/drivers/pqxx/pqxxpreparedstatement.cpp http://commits.kde.org/calligra/38da0b59e0864e69c880fbbab27e88e113eea7e5 Git commit 9d938f3e3d382885996bda5027b61f0240b2ec19 by Jaroslaw Staniek. Committed on 20/06/2012 at 22:29. Pushed by staniek into branch 'master'. SQLite 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-02-27 calligra master commit 1e9be96a9e) M +4 -2 Drivers/sqlite/SqlitePreparedStatement.cpp M +1 -1 Drivers/sqlite/SqlitePreparedStatement.h http://commits.kde.org/predicate/9d938f3e3d382885996bda5027b61f0240b2ec19 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 254068 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 |