We've hit a roadblock in upgrading from an old 1.5 install to a new server with 2.3 (just before the version released Aug 27th).
We've tried the process twice, with a clean install on the new server and both times we get to the "upgrading" process fails with this message:
Omeka encountered an error when upgrading your installation.
SQL error in migration: Mysqli statement execute error : Unknown column 'record_name' in 'omeka_search_texts'
{see end of this post for the 16 line error message that follows}
We think we've followed the directions correctly:
- The new server has a fresh, empty copy of the new version, with one superuser and no data records added.
- On the old machine we deactivated plugins
- From the old machine we exported the database using mysqldump
- We also copied the Archive folder to the new installation
- We then imported the mysql database to the new installation
Once we've done all this, Omeka then tries to upgrade the installation, at which point it fails.
On the new install we can see from phpmyadmin that the data has been transferred over, along with the users from the old install. We're not sure where to go next on this and are looking for help.
Thanks!
Here's the detailed error message:
Omeka encountered an error when upgrading your installation.
SQL error in migration: Mysqli statement execute error : Unknown column 'record_name' in 'omeka_search_texts'
exception 'Zend_Db_Statement_Mysqli_Exception' with message 'Mysqli statement execute error : Unknown column 'record_name' in 'omeka_search_texts'' in /Library/Server/Web/Data/Sites/Default/dm/application/libraries/Zend/Db/Statement/Mysqli.php:214
Stack trace:
#0 /Library/Server/Web/Data/Sites/Default/dm/application/libraries/Zend/Db/Statement.php(303): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /Library/Server/Web/Data/Sites/Default/dm/application/libraries/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#2 [internal function]: Zend_Db_Adapter_Abstract->query('ALTER TABLE `o...')
#3 /Library/Server/Web/Data/Sites/Default/dm/application/libraries/Omeka/Db.php(79): call_user_func_array(Array, Array)
#4 /Library/Server/Web/Data/Sites/Default/dm/application/migrations/20120813000000_changeToRecordType.php(22): Omeka_Db->__call('query', Array)
#5 /Library/Server/Web/Data/Sites/Default/dm/application/migrations/20120813000000_changeToRecordType.php(22): Omeka_Db->query('ALTER TABLE `o...')
#6 /Library/Server/Web/Data/Sites/Default/dm/application/libraries/Omeka/Db/Migration/Manager.php(231): changeToRecordType->up()
#7 /Library/Server/Web/Data/Sites/Default/dm/application/libraries/Omeka/Db/Migration/Manager.php(111): Omeka_Db_Migration_Manager->_migrateUp(Object(DateTime))
#8 /Library/Server/Web/Data/Sites/Default/dm/application/controllers/UpgradeController.php(41): Omeka_Db_Migration_Manager->migrate()
#9 /Library/Server/Web/Data/Sites/Default/dm/application/libraries/Zend/Controller/Action.php(516): UpgradeController->migrateAction()
#10 /Library/Server/Web/Data/Sites/Default/dm/application/libraries/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch('migrateAction')
#11 /Library/Server/Web/Data/Sites/Default/dm/application/libraries/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#12 /Library/Server/Web/Data/Sites/Default/dm/application/libraries/Zend/Application/Bootstrap/Bootstrap.php(105): Zend_Controller_Front->dispatch()
#13 /Library/Server/Web/Data/Sites/Default/dm/application/libraries/Zend/Application.php(382): Zend_Application_Bootstrap_Bootstrap->run()
#14 /Library/Server/Web/Data/Sites/Default/dm/application/libraries/Omeka/Application.php(79): Zend_Application->run()
#15 /Library/Server/Web/Data/Sites/Default/dm/admin/index.php(28): Omeka_Application->run()
#16 {main}