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