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

[SMS]

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

[andymorton]

Hi Shannon,

Checked this out - and can confirm that the user does have access to the db.

I went through the install process, supplying the XML backup from the initial server.

My guess is that the schema has changed and that column was added somewhere between 7.5 and 7.12..

Regards,

Andrew

[SMS]

Andrew,

Can you help us to understand exactly how your upgrade process went?

Ideally you would need to perform the upgrade using the installer, but by your message it sounds like you may have installed a fresh copy of 7.12 on a new server, and then exported your backup from 7.5 to that.

I would recommend doing the following:

1. Completely remove the new installation you have created.
2. Install 7.5 on the new server.
3. Import your XML from 7.5 into this installation.
4. Shut down Jira
5. Upgrade to 7.12 using the installer.

Regards,

Shannon

[andymorton]

Shannon - that may be best.

Where can one get the 7.5 install?

A.

[SMS]

Hi Andrew,

You can get it from the Jira download page. You just need to click View all versions and then in the drop-down in the pop-up window select 7 and select 7.5 from there.

Shannon