Upgrade from 1.6.1.2 to 1.7.1.13

[carlosmp]

We finally got around to upgrading our install, and after adjusting the database issues by adding the necessary fields, etc. we're getting the following error when attempting to run any report:


Database access error.  -  <p> - Exception: it.loway.tpf.common.exceptions.TechException - Errore file/DB: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'data5' in 'field list' - at it.loway.app.queuemetrics.asterisk.logs.analyzers.AnalizzaLogMysql.createTemporaryFile(AnalizzaLogMysql.java:500) - at it.loway.app.queuemetrics.asterisk.logs.analyzers.AnalizzaLogMysql.loadLogInfo_classic(AnalizzaLogMysql.java:250) - at it.loway.app.queuemetrics.asterisk.logs.analyzers.AnalizzaLogMysql.loadLogInfo(AnalizzaLogMysql.java:200) - at it.loway.app.queuemetrics.caricamento.caricaCoda.runDataAnalysis(caricaCoda.java:281) -

TIA,

Carlos.

[carlosmp]

Anyone have any ideas?  The upgrade went through correct, I had to add a bunch of fields to the tables.  Fortunately, the call volume is minimal this time of year, but in the next two weeks we'll be back up to normal and need to have this working.

Thanks

[Anthony]

Hi,

The following SQL query which should solve the issue.

ALTER TABLE `queue_log` ADD `data5` VARCHAR( 200 ) NOT NULL DEFAULT '';

You need to run it via your usual SQL editor.