Unable to upgrade

We have 1.2.1 currently installed.

The admin site has always said: "Your Omeka database is not compatible with your current version of Omeka. Please backup your existing database and then upgrade"

but if I click the upgrade link, I get the following error:

"Omeka encountered an error when upgrading your installation:
Error in Migration #1
Message: Migration file does not exist for #1!"

This shows up in both our production and development servers.

Also, if I try to update the Omeka software to any other version of Omeka, I get this error when opening a browser:

"The page isn't redirecting properly
Firefox has detected that the server is redirecting the request for this address in a way that will never complete.
*This problem can sometimes be caused by disabling or refusing to accept cookies."

I know I'm posting two problems here, but I believe the second is a result of the first. It's also worth mentioning that if I install from scratch, these problems go away. They return as soon as I re-import the .sql file back into that database server.

Not sure what do to do next. Can anyone help? Thanks.

Did you ever have Omeka 1.2.1 working? The "Migration #1" part tells me there's something wrong with the database: it's missing the option that older versions of Omeka used to store what "version" the database was at.

You know, that's what I'm wondering. The software says 1.2.1, but that doesn't necessarily mean that the database is that version, correct?

And you're right, I can't find the "migration" field in the options table. Is there a field that tells me what version the database thinks it is?

One a side note, I did try unzipping version 1.2.0 and it does the same thing (software says 1.2, but clicking the upgrade gives the "Migration #1" error.

Well that's the thing: there is a field in the database that tells you that (the migration number), but that's the same thing Omeka's looking for and failing to find. It would appear to be missing.

Since it can't find any number, it's defaulting to "1", the migration for a very old version of the database, and Omeka 1.2.1 doesn't have the database upgrade files going back that far.

I think it's highly unlikely you have database version 1. If you can be confident about what version this database dump comes from, you can just manually add the correct migration number into the options table.

John, Thanks for responding so quickly.

I definitely had version 1.1 installed at one point. A while back my users requested upgrading to 1.5.3, so in the process I upgraded (or thought I upgraded) to version 1.2.1.

Could the database still be version 1.1? Would it be worth unzipping that version to see what happens?

-Jason

Using a different version of the code won't make any difference, it's the database that's the problem here, which would be the same.

The migration number for a 1.1 install is 42. The migration number for 1.2 or 1.2.1 is 47. The number should be stored as an option named "migration" in the options table.

If the "processes" table in your database dump has "started," "stopped," and "log" columns, then you probably have a 1.2 database, and the migration number should be 47. If you don't, then it should probably be 42.