Zend_Db_Statement_Mysqli_Exception using CSV plugin

I have installed the CSVImport plugin for a customer, and am unable to actually import items. After labeling the columns I receive this error...

Zend_Db_Statement_Mysqli_Exception
Mysqli statement execute error : Column 'featured' cannot be null

This is the backtrace

exception 'Zend_Db_Statement_Mysqli_Exception' with message 'Mysqli statement execute error : Column 'featured' cannot be null' in /var/www/idhmcomeka.tamu.edu/html/application/libraries/Zend/Db/Statement/Mysqli.php:214
Stack trace:
#0 /var/www/idhmcomeka.tamu.edu/html/application/libraries/Zend/Db/Statement.php(300): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /var/www/idhmcomeka.tamu.edu/html/application/libraries/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 [internal function]: Zend_Db_Adapter_Abstract->query('?        INSERT...', Array)
#3 /var/www/idhmcomeka.tamu.edu/html/application/libraries/Omeka/Db.php(84): call_user_func_array(Array, Array)
#4 /var/www/idhmcomeka.tamu.edu/html/application/libraries/Omeka/Db.php(298): Omeka_Db->__call('query', Array)
#5 /var/www/idhmcomeka.tamu.edu/html/application/libraries/Omeka/Db.php(298): Omeka_Db->query('?        INSERT...', Array)
#6 /var/www/idhmcomeka.tamu.edu/html/application/libraries/Omeka/Db.php(268): Omeka_Db->exec('?        INSERT...', Array)
#7 /var/www/idhmcomeka.tamu.edu/html/application/libraries/Omeka/Record.php(553): Omeka_Db->insert('Item', Array)
#8 /var/www/idhmcomeka.tamu.edu/html/application/libraries/Omeka/Record.php(583): Omeka_Record->save()
#9 /var/www/idhmcomeka.tamu.edu/html/application/libraries/Omeka/Record/Builder.php(71): Omeka_Record->forceSave()
#10 /var/www/idhmcomeka.tamu.edu/html/application/libraries/globals.php(473): Omeka_Record_Builder->build()
#11 /var/www/idhmcomeka.tamu.edu/html/plugins/CsvImport/models/CsvImport/Import.php(345): insert_item(Array, Array)
#12 /var/www/idhmcomeka.tamu.edu/html/plugins/CsvImport/models/CsvImport/Import.php(255): CsvImport_Import->_addItemFromRow(Array, Array, Object(CsvImport_ColumnMap_Set))
#13 /var/www/idhmcomeka.tamu.edu/html/plugins/CsvImport/models/CsvImport/Import.php(197): CsvImport_Import->_importLoop(0)
#14 [internal function]: CsvImport_Import->start()
#15 /var/www/idhmcomeka.tamu.edu/html/plugins/CsvImport/models/CsvImport/ImportTask.php(22): call_user_func(Array)
#16 /var/www/idhmcomeka.tamu.edu/html/application/libraries/Omeka/Job/Dispatcher/Adapter/Synchronous.php(26): CsvImport_ImportTask->perform()
#17 /var/www/idhmcomeka.tamu.edu/html/application/libraries/Omeka/Job/Dispatcher/Default.php(91): Omeka_Job_Dispatcher_Adapter_Synchronous->send('{"className":"C...', Array)
#18 /var/www/idhmcomeka.tamu.edu/html/plugins/CsvImport/controllers/IndexController.php(131): Omeka_Job_Dispatcher_Default->send('CsvImport_Impor...', Array)
#19 /var/www/idhmcomeka.tamu.edu/html/application/libraries/Zend/Controller/Action.php(513): CsvImport_IndexController->mapColumnsAction()
#20 /var/www/idhmcomeka.tamu.edu/html/application/libraries/Zend/Controller/Dispatcher/Standard.php(295): Zend_Controller_Action->dispatch('mapColumnsActio...')
#21 /var/www/idhmcomeka.tamu.edu/html/application/libraries/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#22 /var/www/idhmcomeka.tamu.edu/html/application/libraries/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch()
#23 /var/www/idhmcomeka.tamu.edu/html/application/libraries/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#24 /var/www/idhmcomeka.tamu.edu/html/application/libraries/Omeka/Core.php(166): Zend_Application->run()
#25 /var/www/idhmcomeka.tamu.edu/html/admin/index.php(45): Omeka_Core->run()
#26 {main}

Based on other topics, I can narrow it down as not being a database permissions issue, the omeka DB user has all privileges. Also the CSV related tables exist and I have already tried uninstall / reinstalling this plugin.

Here are the tables,

mysql> show fields from omeka_csv_import_imports;
+------------------------+---------------------+------+-----+---------------------+----------------+
| Field                  | Type                | Null | Key | Default             | Extra          |
+------------------------+---------------------+------+-----+---------------------+----------------+
| id                     | int(10) unsigned    | NO   | PRI | NULL                | auto_increment |
| item_type_id           | int(10) unsigned    | NO   |     | NULL                |                |
| collection_id          | int(10) unsigned    | NO   |     | NULL                |                |
| owner_id               | int(10) unsigned    | NO   |     | NULL                |                |
| delimiter              | varchar(1)          | NO   |     | NULL                |                |
| original_filename      | text                | NO   |     | NULL                |                |
| file_path              | text                | NO   |     | NULL                |                |
| file_position          | bigint(20) unsigned | NO   |     | NULL                |                |
| status                 | varchar(255)        | YES  |     | NULL                |                |
| skipped_row_count      | int(10) unsigned    | NO   |     | NULL                |                |
| skipped_item_count     | int(10) unsigned    | NO   |     | NULL                |                |
| is_public              | tinyint(1)          | YES  |     | 0                   |                |
| is_featured            | tinyint(1)          | YES  |     | 0                   |                |
| serialized_column_maps | text                | NO   |     | NULL                |                |
| added                  | timestamp           | NO   |     | 0000-00-00 00:00:00 |                |
+------------------------+---------------------+------+-----+---------------------+----------------+
15 rows in set (0.00 sec)

mysql> show fields from omeka_csv_import_imported_items;
+-----------+------------------+------+-----+---------+----------------+
| Field     | Type             | Null | Key | Default | Extra          |
+-----------+------------------+------+-----+---------+----------------+
| id        | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| item_id   | int(10) unsigned | NO   | UNI | NULL    |                |
| import_id | int(10) unsigned | NO   | MUL | NULL    |                |
+-----------+------------------+------+-----+---------+----------------+
3 rows in set (0.00 sec)

Also I saw one suggestion of repairing the tables, however these two tables can't be repaired (but others in the omeka DB can).

mysql> repair table omeka_csv_import_imports;
+-------------------------------------+--------+----------+---------------------------------------------------------+
| Table                               | Op     | Msg_type | Msg_text                                                |
+-------------------------------------+--------+----------+---------------------------------------------------------+
| idhmcomeka.omeka_csv_import_imports | repair | note     | The storage engine for the table doesn't support repair |
+-------------------------------------+--------+----------+---------------------------------------------------------+
1 row in set (0.00 sec)

mysql> repair table omeka_csv_import_imported_items;
+--------------------------------------------+--------+----------+---------------------------------------------------------+
| Table                                      | Op     | Msg_type | Msg_text                                                |
+--------------------------------------------+--------+----------+---------------------------------------------------------+
| idhmcomeka.omeka_csv_import_imported_items | repair | note     | The storage engine for the table doesn't support repair |
+--------------------------------------------+--------+----------+---------------------------------------------------------+
1 row in set (0.00 sec)

Please let me know what other information may be useful to troubleshoot this.

Thanks
- Trey

Thanks for reporting this.

We've had at least one other report of the same issue, and we're looking into it.

Stay tuned.

We're fairly confident that we have fixed this (and a few other) issues with the latest version. Please let us know if it works for you. Thanks!

Success! Yes the latest version did solve that problem. Thanks for the update.

- Trey