Hi,
Thank you for explaining where this stands so far! I believe I am working the the original 1.5.2 version of the database. The previous assistant had made a second copy of the database and attempted the upgrade using that copy. I have made my own copies of the original and have made my attempts with those.
The library I work for has an account on our university's MySQL server. I can access it through SSH or phpMyAdmin. I copied down search_texts in phpMyAdmin here. X indicates a blank field:
Field, Type, Collation, Attributes, Null, Default, Extra
id, int(10),X,unsigned,No,None,auto_increment
record_type, varchar(30), utf8_unicode_ci,X, No, None, X
record_id, int(10), X, unsigned, No, None, X
public, intyint(1), X, X, No, None, X
title, tinytext, utf8_unicode_ci, X, Yes, NULL, X
text, longtext, utf8_unicode_ci, X, No, None, X
Indexes:
Keyname, Type, Unique, Packed, Field, Cardinality, Collation, Null, Comment
PRIMARY, BTREE, Yes, No, id, 0, A, X, X
record_name, BTREE, Yes, No, record_type/ record_id, 0/0, A/A, X, X
text, FULLTEXT, No, No, text, 0, X, X, X
Interestingly, I tried clicking the upgrade button once more this morning, after leaving it for 4 days. Rather than the “SQL error in migration: Mysqli statement execute error : Unknown column 'record_name' in 'lilly_collections_search_texts'” message, I got "SQL error in migration: Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INDEX owner_id
(owner_id
)' at line 5." I changed everything back to ADD and then changed to MODIFY one by one. It is now back to the “SQL error in migration: Mysqli statement execute error : Unknown column 'record_name' in 'lilly_collections_search_texts'” message.
Here is the stack trace for the new message I encountered this morning:
SQL error in migration: Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INDEX owner_id
(owner_id
)' at line 5
#0 /ip/liblilly/www/omekaCollectionsTest2/application/libraries/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('ALTER TABLE `li...')
#1 /ip/liblilly/www/omekaCollectionsTest2/application/libraries/Zend/Db/Adapter/Mysqli.php(388): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'ALTER TABLE `li...')
#2 /ip/liblilly/www/omekaCollectionsTest2/application/libraries/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Adapter_Mysqli->prepare('ALTER TABLE `li...')
#3 [internal function]: Zend_Db_Adapter_Abstract->query('ALTER TABLE `li...')
#4 /ip/liblilly/www/omekaCollectionsTest2/application/libraries/Omeka/Db.php(79): call_user_func_array(Array, Array)
#5 /ip/liblilly/www/omekaCollectionsTest2/application/libraries/Omeka/Db.php(282): Omeka_Db->__call('query', Array)
#6 /ip/liblilly/www/omekaCollectionsTest2/application/libraries/Omeka/Db.php(282): Omeka_Db->query('ALTER TABLE `li...')
#7 /ip/liblilly/www/omekaCollectionsTest2/application/migrations/20120224000000_unEntityExhibitBuilder.php(48): Omeka_Db->queryBlock('ALTER TABLE `li...')
#8 /ip/liblilly/www/omekaCollectionsTest2/application/migrations/20120224000000_unEntityExhibitBuilder.php(21): unEntityExhibitBuilder->_updateSchema()
#9 /ip/liblilly/www/omekaCollectionsTest2/application/libraries/Omeka/Db/Migration/Manager.php(231): unEntityExhibitBuilder->up()
#10 /ip/liblilly/www/omekaCollectionsTest2/application/libraries/Omeka/Db/Migration/Manager.php(111): Omeka_Db_Migration_Manager->_migrateUp(Object(DateTime))
#11 /ip/liblilly/www/omekaCollectionsTest2/application/controllers/UpgradeController.php(43): Omeka_Db_Migration_Manager->migrate()
#12 /ip/liblilly/www/omekaCollectionsTest2/application/libraries/Zend/Controller/Action.php(516): UpgradeController->migrateAction()
#13 /ip/liblilly/www/omekaCollectionsTest2/application/libraries/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch('migrateAction')
#14 /ip/liblilly/www/omekaCollectionsTest2/application/libraries/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#15 /ip/liblilly/www/omekaCollectionsTest2/application/libraries/Zend/Application/Bootstrap/Bootstrap.php(101): Zend_Controller_Front->dispatch()
#16 /ip/liblilly/www/omekaCollectionsTest2/application/libraries/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#17 /ip/liblilly/www/omekaCollectionsTest2/application/libraries/Omeka/Application.php(79): Zend_Application->run()
#18 /ip/liblilly/www/omekaCollectionsTest2/admin/index.php(28): Omeka_Application->run()
#19 {main}
Lastly, I checked with our IT support regarding a warning message in phpMyAdmin since I thought it might be related to the Omeka issues: "Your PHP MySQL library version 5.1.46 differs from your MySQL server version 5.0.83." They claim that there are no known issues cause by having them out of sync, though I thought I would bring this up just in case.
Thank you again for your help.