Upgrade database migration fails

2 posts / 0 new
Last post
gwcoffey
Upgrade database migration fails

I'm upgrading a client's CWIS (which I know very little about) from 2.1.2 to 2.4.0. I get this error while it converts the database:

 

 

Beginning Upgrade Process...

Checking subdirectories...

Testing database permissions...

Upgrading database to version 2.2.0...

Errors Encountered:

Database command failed:

ALTER TABLE RSSConfiguration DROP ImageTitle, DROP ImageLink;

(SQL error: Can't DROP 'ImageTitle'; check that column/key exists)

The RSSConfiguration table does not have ImageTitle in any of their 4 CWIS 2.1.2 installations. 

 

Anybody have any idea what's wrong?

ealmasy
Re: Upgrade database migration fails

I'm not sure why the error is coming up for you, but if you unpack the attached zip file and copy the enclosed SQL file into install/DBUpgrades, it should resolve it.