Update Notes for 3.1.0

Database Updates

Due to some problems with database support (sapdb) we had to change certain column names. If you use mysql you can easily use these statements below to upgrade the database column names:

alter table coriniscmsfilemanager change top cmstop bigint(20);
alter table coriniscmsqmfilemanager change top cmstop bigint(20);
alter table coriniscmslifefilemanager change top cmstop bigint(20);
alter table coriniscmsfilemanager change state filestate int(11);
alter table coriniscmsqmfilemanager change state filestate int(11);
alter table coriniscmslifefilemanager change state filestate int(11);

alter table coriniscmslifeedit change top cmstop bigint(20);
alter table coriniscmsedit change top cmstop bigint(20);
alter table coriniscmsqmedit change top cmstop bigint(20);
alter table coriniscmsedit change type fieldtype int(11);
alter table coriniscmsqmedit change type fieldtype int(11);
alter table coriniscmslifeedit change type fieldtype int(11);

alter table coriniscmsedithistory change top cmstop bigint(20);
alter table coriniscmsedithistory change type fieldtype int(11);

alter table corinisvoting change value votevalue int(11);

Possible Errors

Cms document listing is incomplete/missing

• Check the catalina.out and the application logfile for possible sql errors (ie. unable to find field <name>) and fix the column names (see above)
• Remove all files from WEB-INF/cache and make sure the directory is writeable by tomcat
• Restart tomcat
• after a restart and page refresh make sure that there are a few files in the WEB-INF/cache directory - if not please check the mailing list or the forum