Having followed the upgrade instructions to the point of upgrading the database, I get the following error:
Omeka encountered an error when upgrading your installation.
SQL error in migration: Mysqli statement execute error : Column 'text' cannot be null
exception 'Zend_Db_Statement_Mysqli_Exception' with message 'Mysqli statement execute error : Column 'text' cannot be null' in /usr/local/data/htdocs/omeka/application/libraries/Zend/Db/Statement/Mysqli.php:214
Stack trace:
#0 /usr/local/data/htdocs/omeka/application/libraries/Zend/Db/Statement.php(303): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /usr/local/data/htdocs/omeka/application/libraries/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#2 [internal function]: Zend_Db_Adapter_Abstract->query('INSERT INTO `om...', Array)
#3 /usr/local/data/htdocs/omeka/application/libraries/Omeka/Db.php(79): call_user_func_array(Array, Array)
#4 /usr/local/data/htdocs/omeka/application/migrations/20121018000001_removeCollectionNameDescriptionCollectors.php(59): Omeka_Db->__call('query', Array)
#5 /usr/local/data/htdocs/omeka/application/migrations/20121018000001_removeCollectionNameDescriptionCollectors.php(59): Omeka_Db->query('INSERT INTO `om...', Array)
#6 /usr/local/data/htdocs/omeka/application/migrations/20121018000001_removeCollectionNameDescriptionCollectors.php(93): removeCollectionNameDescriptionCollectors->_addElementText(70, 'Collection', 41, '0', NULL)
#7 /usr/local/data/htdocs/omeka/application/migrations/20121018000001_removeCollectionNameDescriptionCollectors.php(37): removeCollectionNameDescriptionCollectors->_addDescriptionElement(Array)
#8 /usr/local/data/htdocs/omeka/application/libraries/Omeka/Db/Migration/Manager.php(231): removeCollectionNameDescriptionCollectors->up()
#9 /usr/local/data/htdocs/omeka/application/libraries/Omeka/Db/Migration/Manager.php(111): Omeka_Db_Migration_Manager->_migrateUp(Object(DateTime))
#10 /usr/local/data/htdocs/omeka/application/controllers/UpgradeController.php(41): Omeka_Db_Migration_Manager->migrate()
#11 /usr/local/data/htdocs/omeka/application/libraries/Zend/Controller/Action.php(516): UpgradeController->migrateAction()
#12 /usr/local/data/htdocs/omeka/application/libraries/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch('migrateAction')
#13 /usr/local/data/htdocs/omeka/application/libraries/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#14 /usr/local/data/htdocs/omeka/application/libraries/Zend/Application/Bootstrap/Bootstrap.php(105): Zend_Controller_Front->dispatch()
#15 /usr/local/data/htdocs/omeka/application/libraries/Zend/Application.php(382): Zend_Application_Bootstrap_Bootstrap->run()
#16 /usr/local/data/htdocs/omeka/application/libraries/Omeka/Application.php(79): Zend_Application->run()
#17 /usr/local/data/htdocs/omeka/admin/index.php(28): Omeka_Application->run()
#18 {main}
What am I missing?
Jerry
Ok, I got past that error. Now I am getting:
Omeka encountered an error when upgrading your installation.
SQL error in migration: Mysqli prepare error: Unknown column 'name' in 'field list'
exception 'Zend_Db_Statement_Mysqli_Exception' with message 'Mysqli prepare error: Unknown column 'name' in 'field list'' in /usr/local/data/htdocs/omeka/application/libraries/Zend/Db/Statement/Mysqli.php:77
Stack trace:
#0 /usr/local/data/htdocs/omeka/application/libraries/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('SELECT id, `n...')
#1 /usr/local/data/htdocs/omeka/application/libraries/Zend/Db/Adapter/Mysqli.php(388): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'SELECT id, `n...')
#2 /usr/local/data/htdocs/omeka/application/libraries/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Adapter_Mysqli->prepare('SELECT id, `n...')
#3 [internal function]: Zend_Db_Adapter_Abstract->query('SELECT id, `n...')
#4 /usr/local/data/htdocs/omeka/application/libraries/Omeka/Db.php(79): call_user_func_array(Array, Array)
#5 /usr/local/data/htdocs/omeka/application/migrations/20121018000001_removeCollectionNameDescriptionCollectors.php(18): Omeka_Db->__call('query', Array)
#6 /usr/local/data/htdocs/omeka/application/migrations/20121018000001_removeCollectionNameDescriptionCollectors.php(18): Omeka_Db->query('SELECT id, `n...')
#7 /usr/local/data/htdocs/omeka/application/libraries/Omeka/Db/Migration/Manager.php(231): removeCollectionNameDescriptionCollectors->up()
#8 /usr/local/data/htdocs/omeka/application/libraries/Omeka/Db/Migration/Manager.php(111): Omeka_Db_Migration_Manager->_migrateUp(Object(DateTime))
#9 /usr/local/data/htdocs/omeka/application/controllers/UpgradeController.php(41): Omeka_Db_Migration_Manager->migrate()
#10 /usr/local/data/htdocs/omeka/application/libraries/Zend/Controller/Action.php(516): UpgradeController->migrateAction()
#11 /usr/local/data/htdocs/omeka/application/libraries/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch('migrateAction')
#12 /usr/local/data/htdocs/omeka/application/libraries/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#13 /usr/local/data/htdocs/omeka/application/libraries/Zend/Application/Bootstrap/Bootstrap.php(105): Zend_Controller_Front->dispatch()
#14 /usr/local/data/htdocs/omeka/application/libraries/Zend/Application.php(382): Zend_Application_Bootstrap_Bootstrap->run()
#15 /usr/local/data/htdocs/omeka/application/libraries/Omeka/Application.php(79): Zend_Application->run()
#16 /usr/local/data/htdocs/omeka/admin/index.php(28): Omeka_Application->run()
#17 {main}
I suspect that the issue is in the pluging. Can anyone tell me which one, and how to get arount the issue?
It looks like the update is getting stuck on the step that updates the collection information in the database. It appears to have gotten through the step that drops some data from the old structure, but because of the error it is now still trying to look for the data that was dropped.
It's hard to know exactly how far along it got in updating your collection data. You could try the following, which would just skip over trying to update any collections. It's a bit risky and might lead to side-effects later, but to get through a database migration process that's it might be the only option.
In the application/migrations folder, find the file 20121018000001_removeCollectionNameDescriptionCollectors.php and comment out what's inside the up function:
public function up()
{
/*
....content of the function ....
*/
}
That will skip trying to complete that database change. We'll just have to hope that most of the changes happened okay.
It looks like the function that you recommended was the hangup. The database upgraded successfully. Since it appears to me that what the function was attempting was to rename three of the columns name, description, and collectors in the table 'Collections' to TitleElement, DescriptionElement, and Contributors, I did so manually after the upgrade finished.