Hello,
I’m having this error when I try to access to the dashboard of our omeka database installed on the debian 11 managed wuth webmin.
Two things: first, can you copy-paste the text of the error here? There’s information cut off the right side here that should be useful.
Second, what version of MySQL or MariaDB are you using? I’m pretty sure I know what’s happening here but it’s a little odd because we haven’t seen other reports of this nor have we seen it ourselves… it could be limited to a quite specific version.
Maria DB Version 10.5.29
I paste the text of the error :
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Illegal mix of collations (ascii_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation ‘=’ in /var/www/html/akwaba/application/libraries/Zend/Db/Statement/Mysqli.php:215
Stack trace:
#0 /var/www/html/akwaba/application/libraries/Zend/Db/Statement.php(303): Zend_Db_Statement_Mysqli->_execute()
#1 /var/www/html/akwaba/application/libraries/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute()
#2 /var/www/html/akwaba/application/libraries/Zend/Db/Adapter/Abstract.php(737): Zend_Db_Adapter_Abstract->query()
#3 /var/www/html/akwaba/application/libraries/Zend/Auth/Adapter/DbTable.php(479): Zend_Db_Adapter_Abstract->fetchAll()
#4 /var/www/html/akwaba/application/libraries/Zend/Auth/Adapter/DbTable.php(368): Zend_Auth_Adapter_DbTable->_authenticateQuerySelect()
#5 /var/www/html/akwaba/application/libraries/Zend/Auth.php(117): Zend_Auth_Adapter_DbTable->authenticate()
#6 /var/www/html/akwaba/application/controllers/UsersController.php(441): Zend_Auth->authenticate()
#7 /var/www/html/akwaba/application/libraries/Zend/Controller/Action.php(516): UsersController->loginAction()
#8 /var/www/html/akwaba/application/libraries/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch()
#9 /var/www/html/akwaba/application/libraries/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch()
#10 /var/www/html/akwaba/application/libraries/Zend/Application/Bootstrap/Bootstrap.php(106): Zend_Controller_Front->dispatch()
#11 /var/www/html/akwaba/application/libraries/Zend/Application.php(384): Zend_Application_Bootstrap_Bootstrap->run()
#12 /var/www/html/akwaba/application/libraries/Omeka/Application.php(73): Zend_Application->run()
#13 /var/www/html/akwaba/admin/index.php(28): Omeka_Application->run()
#14 {main}
Next Zend_Auth_Adapter_Exception: The supplied parameters to Zend_Auth_Adapter_DbTable failed to produce a valid sql statement, please check table and column names for validity. in /var/www/html/akwaba/application/libraries/Zend/Auth/Adapter/DbTable.php:489
Stack trace:
#0 /var/www/html/akwaba/application/libraries/Zend/Auth/Adapter/DbTable.php(368): Zend_Auth_Adapter_DbTable->_authenticateQuerySelect()
#1 /var/www/html/akwaba/application/libraries/Zend/Auth.php(117): Zend_Auth_Adapter_DbTable->authenticate()
#2 /var/www/html/akwaba/application/controllers/UsersController.php(441): Zend_Auth->authenticate()
#3 /var/www/html/akwaba/application/libraries/Zend/Controller/Action.php(516): UsersController->loginAction()
#4 /var/www/html/akwaba/application/libraries/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch()
#5 /var/www/html/akwaba/application/libraries/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch()
#6 /var/www/html/akwaba/application/libraries/Zend/Application/Bootstrap/Bootstrap.php(106): Zend_Controller_Front->dispatch()
#7 /var/www/html/akwaba/application/libraries/Zend/Application.php(384): Zend_Application_Bootstrap_Bootstrap->run()
#8 /var/www/html/akwaba/application/libraries/Omeka/Application.php(73): Zend_Application->run()
#9 /var/www/html/akwaba/admin/index.php(28): Omeka_Application->run()
#10 {main}
Hmmm, okay. Thanks.
Tell me one more thing: what version of Omeka are you using? I’d assumed the latest, version 3.2, but the details here suggest you might be on an older version. Did you try upgrading and then go back to a previous version or anything like that?
Yes the older version is 3.1.2 and the new one is 3.2. The older version is still connected to the database with the new version.
I’m pretty sure this is being caused by running the 3.1.2 code against a 3.2 database. That’s not a supported configuration: once you upgrade the database to 3.2 you need to be running 3.2. If you want go back to 3.1.2 you’d need to restore a backup or dump of the database from before the upgrade, and to run the two versions simultaneously you’d need to have them pointed to different databases.
Even ignoring this specific error, once you’ve logged in as a user on 3.2, their password data will be changed in a way that makes it incompatible with earlier versions.
Effectively, I disconnected the 3.1.2 and reached the dashboard of the 3.2. Thank You very much.