Missing column after update from 7.5 to 7.12

andymorton

Hi.

 

Just migrated my jira server to a new server, and upgraded in the process.

Followed the instructions, and imported the data successfully. However, when I attempt to log in, I am getting the following SQL error message - suggesting a column is missing..

 

Unknown column 'LAST_POLLED' in 'field list'

All my users are there - ive checked in the DB, but alas, no one can log in!

Anyone have any suggestions to try and fix this?

 

Regards,

Andrew

Shannon S

Hi Andrew,

Can you try the workaround specified at JIRA Upgrade Fails with Invalid Column Name Error? I realize it mentions a different error and version, but it still has some useful tests listed:

Workaround

1. Stop JIRA.
2. Backup JIRA using the native DB tools.
3. Check that the $JIRA_HOME/dbconfig.xml has the correct schema, as in Connecting JIRA to a Database. If it does not, enter it as detailed in the documentation for the database that JIRA instance is using.
4. Check if the database user has the necessary permission on the JIRA database, specifically the alter permissions as in the Connecting JIRA to a Database documentation.
5. Disable auto-export as in our Disabling Auto-Export documentation.
6. Start JIRA and verify the instance is able to complete the upgrade tasks successfully.

OR

• Follow the resolution in our JIRA User Does Not Have Permission to Access the Database KB.

OR

• Follow the resolution as per our JIRA throws table already exist error due to incorrect MySQL Schema KB.

 

Let us know how that goes!

Regards,

Shannon