Upgrade Problem from 4.2.0.1 to 5.0.0.0

[michaelwechner]

Hi

I have installed the new Konakart 5.0.0.0 community edition using the sample data of KonaKart 4.2.0.1
and receive the following exception after starting/accessing Tomcat

The details of the malfunction are :

Exception Name = com.konakart.app.KKException
Exception Message = org.apache.torque.TorqueException: org.postgresql.util.PSQLException: ERROR: column products.products_date_expiry does not exist

After re-importing the sample data of 5.0.0.0 it seems to be fine, but this seems to me a backwards compatibility issue which is not mentioned at

http://www.konakart.com/downloads/ver-5000-whats-new

Cheers

Michael

[kate]

It seems that you didn't apply the upgrade SQL script that you need to run when moving from 4.2.0.1 to 5.0.0.0 ?

See:

http://www.konakart.com/docs/CreateDatabase.html#UpgradeDB

The database upgrade scripts that you should run when upgrading between versions are under the database directory under the KonaKart home.

[michaelwechner]

No, I did not run this script. Thanks very much for pointing this out, whereas I think it
would be good to note this on the page

http://www.konakart.com/downloads/ver-5000-whats-new

Cheers

Michael