Zend_Db_Statement_Mysqli_Exception

Hello,

I have a upgrade from Omeka 1.5.3 to Omeka 2.0.2. When I try to modify a item, I have a message (below). Someone would like help me.

Thank you,
Hubert Dubois,
University of Namur

Zend_Db_Statement_Mysqli_Exception

Mysqli prepare error: Unknown column 'metadata' in 'field list'

#0 /var/www/webapps/html/bib/test_omeka2/application/libraries/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('INSERT INTO `ne...')
#1 /var/www/webapps/html/bib/test_omeka2/application/libraries/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'INSERT INTO `ne...')
#2 /var/www/webapps/html/bib/test_omeka2/application/libraries/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('INSERT INTO `ne...')
#3 [internal function]: Zend_Db_Adapter_Abstract->query('INSERT INTO `ne...', Array)
#4 /var/www/webapps/html/bib/test_omeka2/application/libraries/Omeka/Db.php(79): call_user_func_array(Array, Array)
#5 /var/www/webapps/html/bib/test_omeka2/application/libraries/Omeka/Db.php(252): Omeka_Db->__call('query', Array)
#6 /var/www/webapps/html/bib/test_omeka2/application/libraries/Omeka/Db.php(252): Omeka_Db->query('INSERT INTO `ne...', Array)
#7 /var/www/webapps/html/bib/test_omeka2/application/libraries/Omeka/Record/AbstractRecord.php(543): Omeka_Db->insert('File', Array)
#8 /var/www/webapps/html/bib/test_omeka2/application/models/Item.php(251): Omeka_Record_AbstractRecord->save()
#9 [internal function]: Item->afterSave(Array)
#10 /var/www/webapps/html/bib/test_omeka2/application/libraries/Omeka/Record/AbstractRecord.php(277): call_user_func(Array, Array)
#11 /var/www/webapps/html/bib/test_omeka2/application/libraries/Omeka/Record/AbstractRecord.php(550): Omeka_Record_AbstractRecord->runCallbacks('afterSave', Array)
#12 /var/www/webapps/html/bib/test_omeka2/application/libraries/Omeka/Controller/AbstractActionController.php(175): Omeka_Record_AbstractRecord->save(false)
#13 /var/www/webapps/html/bib/test_omeka2/application/controllers/ItemsController.php(88): Omeka_Controller_AbstractActionController->editAction()
#14 /var/www/webapps/html/bib/test_omeka2/application/libraries/Zend/Controller/Action.php(516): ItemsController->editAction()
#15 /var/www/webapps/html/bib/test_omeka2/application/libraries/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch('editAction')
#16 /var/www/webapps/html/bib/test_omeka2/application/libraries/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#17 /var/www/webapps/html/bib/test_omeka2/application/libraries/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch()
#18 /var/www/webapps/html/bib/test_omeka2/application/libraries/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#19 /var/www/webapps/html/bib/test_omeka2/application/libraries/Omeka/Application.php(79): Zend_Application->run()
#20 /var/www/webapps/html/bib/test_omeka2/admin/index.php(28): Omeka_Application->run()
#21 {main}

Did you have to go through the database upgrade/migration screen when you updated Omeka?

This looks like a un-upgraded Files table, but if the database upgrade as a whole didn't work, I'd expect you'd be seeing many more errors than just this one.

Did you have any errors occur during the upgrade process, or did you possibly restore an old copy of a table after running the upgrade?

Thank you for your answer.

Actually, I have an other problem with Image Magick :

The path to Image Magick has not been set. No derivative images will be created. If you would like Omeka to create derivative images, please add the path to your settings form.

Do you know the path of Image Magick ?

I never have this problem before.

Thank you,
Hubert Dubois,
Université of Namur

That message is just telling you that there's nothing set in the Settings panel for the ImageMagick path.

Omeka looks at your system and "guesses" where ImageMagick is during the installation process. If you had something filled in for that setting, it should have carried over to your upgraded install without any changes. If it's disappeared, that would again indicate some problem with the database during the upgrade, like changing where db.ini points to, or an incomplete MySQL dump and restore.

If you've just never had that setting filled in (which would mean Omeka would have never created any thumbnail images), it depends from server to server what the correct setting is. If you have shell access, running the command dirname `which convert` should tell you what the setting should be.