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

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


    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/
Stack trace:
#0 /mnt/docroot/html/ Zend_Db_Statement_Mysqli->_prepare()
#1 /mnt/docroot/html/ Zend_Db_Statement->__construct()
#2 /mnt/docroot/html/ Zend_Db_Adapter_Mysqli->prepare()
#3 /mnt/docroot/html/ Zend_Db_Adapter_Abstract->query()
#4 /mnt/docroot/html/ Omeka_Db->__call()
#5 /mnt/docroot/html/ Omeka_Db->insert()
#6 /mnt/docroot/html/ Omeka_Record_AbstractRecord->save()
#7 /mnt/docroot/html/ UsersController->forgotPasswordAction()
#8 /mnt/docroot/html/ Zend_Controller_Action->dispatch()
#9 /mnt/docroot/html/ Zend_Controller_Dispatcher_Standard->dispatch()
#10 /mnt/docroot/html/ Zend_Controller_Front->dispatch()
#11 /mnt/docroot/html/ Zend_Application_Bootstrap_Bootstrap->run()
#12 /mnt/docroot/html/ Zend_Application->run()
#13 /mnt/docroot/html/ 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?

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.