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

Omeka Classic Troubleshooting
1

Hello, I just upgraded to Omeka v2.8 from v.2.x I’m not sure which exactly it was, as I have inherited the website.

When I enter my email address in the ‘forgot password’ (I don’t know the password) I get the follwoing error:


Omeka has encountered an error

Zend_Db_Statement_Mysqli_Exception

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

Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'id' in 'field list' in /mnt/docroot/html/pickardspapers.gla.ac.uk/www/application/libraries/Zend/Db/Statement/Mysqli.php:77
Stack trace:
#0 /mnt/docroot/html/pickardspapers.gla.ac.uk/www/application/libraries/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare()
#1 /mnt/docroot/html/pickardspapers.gla.ac.uk/www/application/libraries/Zend/Db/Adapter/Mysqli.php(388): Zend_Db_Statement->__construct()
#2 /mnt/docroot/html/pickardspapers.gla.ac.uk/www/application/libraries/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Adapter_Mysqli->prepare()
#3 /mnt/docroot/html/pickardspapers.gla.ac.uk/www/application/libraries/Omeka/Db.php(80): Zend_Db_Adapter_Abstract->query()
#4 /mnt/docroot/html/pickardspapers.gla.ac.uk/www/application/libraries/Omeka/Db.php(257): Omeka_Db->__call()
#5 /mnt/docroot/html/pickardspapers.gla.ac.uk/www/application/libraries/Omeka/Record/AbstractRecord.php(541): Omeka_Db->insert()
#6 /mnt/docroot/html/pickardspapers.gla.ac.uk/www/application/controllers/UsersController.php(91): Omeka_Record_AbstractRecord->save()
#7 /mnt/docroot/html/pickardspapers.gla.ac.uk/www/application/libraries/Zend/Controller/Action.php(516): UsersController->forgotPasswordAction()
#8 /mnt/docroot/html/pickardspapers.gla.ac.uk/www/application/libraries/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch()
#9 /mnt/docroot/html/pickardspapers.gla.ac.uk/www/application/libraries/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch()
#10 /mnt/docroot/html/pickardspapers.gla.ac.uk/www/application/libraries/Zend/Application/Bootstrap/Bootstrap.php(105): Zend_Controller_Front->dispatch()
#11 /mnt/docroot/html/pickardspapers.gla.ac.uk/www/application/libraries/Zend/Application.php(384): Zend_Application_Bootstrap_Bootstrap->run()
#12 /mnt/docroot/html/pickardspapers.gla.ac.uk/www/application/libraries/Omeka/Application.php(73): Zend_Application->run()
#13 /mnt/docroot/html/pickardspapers.gla.ac.uk/www/admin/index.php(28): Omeka_Application->run()
#14 {main}

The email exists (if I input an email that doesn’t exist I get a different error). I did do the admin/upgrade/, so the database is upgraded. What can the issue be?

2

This error is indicating an issue with your database: it’s saying that the users_activations table is missing the “id” column.

The users_activations table has had an id column essentially forever, so if it’s missing that might have been a manual change to your database at some point? I don’t really have any other explanations.