Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.

now I install a new mango in new computer. I want to use mysql .and install mysql .but display below message .how to solve it ?

2014-08-22 14:47:33,288 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sqlConsole', v1.4.4 by Infinite Automation Software
INFO 2014-08-22 14:47:33,293 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'asciiFile', v1.1.3 by Infinite Automation
INFO 2014-08-22 14:47:33,300 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'reports', v2.0.12 by Infinite Automation Software
INFO 2014-08-22 14:47:33,307 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dnp3', v1.4.5 by Infinite Automation Software
INFO 2014-08-22 14:47:33,310 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sqlds', v1.5.5 by Infinite Automation Software
INFO 2014-08-22 14:47:33,313 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'openv4j', v1.0.4 by aploese
INFO 2014-08-22 14:47:33,315 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'http', v1.4.6 by Infinite Automation Software
INFO 2014-08-22 14:47:34,605 (com.serotonin.m2m2.web.M2M2ContextListener.contextInitialized:31) - Mango Automation context starting
INFO 2014-08-22 14:47:34,607 (com.serotonin.m2m2.web.M2M2ContextListener.contextInitialized:39) - Mango Automation context started
INFO 2014-08-22 14:47:35,365 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/users.shtm] onto handler 'usersController'
INFO 2014-08-22 14:47:35,432 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source.shtm] onto handler 'dataSourceController'
INFO 2014-08-22 14:47:35,483 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/publisher_edit.shtm] onto handler 'publisherEditController'
INFO 2014-08-22 14:47:35,542 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/login.htm] onto handler 'loginController'
INFO 2014-08-22 14:47:35,544 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/shutdown.htm] onto handler 'shutdownController'
INFO 2014-08-22 14:47:35,596 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_properties.shtm] onto handler 'dataSourcePropertiesController'
INFO 2014-08-22 14:47:35,598 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/startup.htm] onto handler 'startupController'
INFO 2014-08-22 14:47:35,633 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/webcam_live_feed.htm] onto handler 'webcamLiveFeedController'
INFO 2014-08-22 14:47:35,635 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/unauthorized.htm] onto handler 'unauthorizedController'
INFO 2014-08-22 14:47:35,636 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_point_edit.shtm] onto handler 'dataPointEditController'
INFO 2014-08-22 14:47:35,659 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_properties_error.shtm] onto handler 'dataSourceErrorController'
INFO 2014-08-22 14:47:35,661 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_edit.shtm] onto handler 'dataSourceEditController'
INFO 2014-08-22 14:47:35,663 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/mobile/users.shtm] onto handler 'usersController'
INFO 2014-08-22 14:47:35,679 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/mobile.shtm] onto handler 'mobileController'
INFO 2014-08-22 14:47:35,681 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/help.shtm] onto handler 'helpController'
INFO 2014-08-22 14:47:35,682 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/logout.htm] onto handler 'logoutController'
INFO 2014-08-22 14:47:36,363 (com.serotonin.m2m2.Lifecycle.lic:404) - Checking license...
INFO 2014-08-22 14:47:36,365 (com.serotonin.m2m2.Lifecycle.loadLic:519) - License file not found
INFO 2014-08-22 14:47:36,547 (com.serotonin.m2m2.db.BasePooledProxy.initializeImpl:36) - Initializing pooled connection manager
WARN 2014-08-22 14:47:39,917 (com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade:96) - Upgrading 'core' from 1 to 2
INFO 2014-08-22 14:47:39,951 (com.serotonin.m2m2.db.upgrade.DBUpgrade.createUpdateLogOutputStream:152) - Writing upgrade log to /opt/aa1/logs/com.serotonin.m2m2.db.upgrade.Upgrade1.log
INFO 2014-08-22 14:47:40,048 (com.serotonin.m2m2.db.BasePooledProxy.terminateImpl:110) - Stopping database
ERROR 2014-08-22 14:47:40,054 (com.serotonin.m2m2.Main.main:111) - Error during initialization
com.serotonin.ShouldNeverHappenException: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [alter table publishers add column rtdata longblob; ]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'rtdata'
at com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:102)
at com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:34)
at com.serotonin.m2m2.db.DatabaseProxy.initialize(DatabaseProxy.java:163)
at com.serotonin.m2m2.Lifecycle.databaseInitialize(Lifecycle.java:574)
at com.serotonin.m2m2.Lifecycle.initialize(Lifecycle.java:241)
at com.serotonin.m2m2.Main.main(Main.java:106)
Caused by: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [alter table publishers add column rtdata longblob; ]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'rtdata'
at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:94)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:406)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:427)
at com.serotonin.m2m2.db.BasePooledProxy.runScript(BasePooledProxy.java:73)
at com.serotonin.m2m2.db.upgrade.DBUpgrade.runScript(DBUpgrade.java:129)
at com.serotonin.m2m2.db.upgrade.DBUpgrade.runScript(DBUpgrade.java:143)
at com.serotonin.m2m2.db.upgrade.DBUpgrade.runScript(DBUpgrade.java:134)
at com.serotonin.m2m2.db.upgrade.Upgrade1.upgrade(Upgrade1.java:17)
at com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:98)
... 5 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'rtdata'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2477)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:741)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:587)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:266)
at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:420)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:395)
... 12 more
INFO 2014-08-22 14:52:06,653 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'galil', v1.4.4 by Infinite Automation Software
INFO 2014-08-22 14:52:06,668 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'scheduledEvents', v1.4.6 by (unknown vendor)
INFO 2014-08-22 14:52:06,688 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'maintenanceEvents', v1.4.7 by Infinite Automation Software
INFO 2014-08-22 14:52:06,700 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'templateConfig', v1.0.4 by Infinite Automation Software
INFO 2014-08-22 14:52:06,713 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'jmxds', v1.4.4 by Infinite Automation Software
INFO 2014-08-22 14:52:06,716 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sstTheme', v1.0.5 by Infinite Automation Software
INFO 2014-08-22 14:52:06,720 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'internal', v1.4.4 by Infinite Automation Software
INFO 2014-08-22 14:52:06,723 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'watchlists', v1.5.7 by Infinite Automation Software
INFO 2014-08-22 14:52:06,750 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'abeip', v1.0.6 by Deltamation Software
INFO 2014-08-22 14:52:06,754 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'mbus', v1.0.4 by Infinite Automation Software
INFO 2014-08-22 14:52:06,756 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pointLinks', v1.4.5 by Infinite Automation Software
INFO 2014-08-22 14:52:06,759 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'modbus', v1.4.8 by Infinite Automation Software
INFO 2014-08-22 14:52:06,765 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'snmp', v1.4.5 by Infinite Automation Software
INFO 2014-08-22 14:52:06,771 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'virtualDS', v1.4.4 by Infinite Automation Software
INFO 2014-08-22 14:52:06,774 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pop3', v1.4.4 by Infinite Automation Software
INFO 2014-08-22 14:52:06,777 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'vmstat', v1.4.6 by Infinite Automation Software
INFO 2014-08-22 14:52:06,782 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pachube', v1.4.7 by Infinite Automation Software
INFO 2014-08-22 14:52:06,785 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'abpccc', v1.0.4 by Deltamation Software
INFO 2014-08-22 14:52:06,790 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sstGraphics', v1.0.5 by Infinite Automation Software
INFO 2014-08-22 14:52:06,796 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'graphicalViews', v1.4.9 by Infinite Automation Software
INFO 2014-08-22 14:52:06,801 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'BACnet', v2.1.1 by Infinite Automation Software
INFO 2014-08-22 14:52:06,811 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'meta', v2.0.7 by Infinite Automation Software
INFO 2014-08-22 14:52:06,815 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dataImport', v1.3.4 by Infinite Automation Software
INFO 2014-08-22 14:52:06,820 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'opcda', v1.5.5 by Infinite Automation Software
INFO 2014-08-22 14:52:06,823 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sstGlobalScripts', v1.4.5 by Infinite Automation Software
INFO 2014-08-22 14:52:06,826 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'persistent', v1.4.7 by Infinite Automation Software
INFO 2014-08-22 14:52:06,829 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'onewire', v1.4.5 by Infinite Automation Software
INFO 2014-08-22 14:52:06,832 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dglux', v1.0.11 by Infinite Automation Software
INFO 2014-08-22 14:52:06,833 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'serial', v1.1.2 by Infinite Automation
INFO 2014-08-22 14:52:06,836 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dataFile', v1.0.4 by Infinite Automation
INFO 2014-08-22 14:52:06,842 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'twilio', v1.0.3 by (unknown vendor)
INFO 2014-08-22 14:52:06,845 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'scripting', v1.0.7 by Infinite Automation Software
INFO 2014-08-22 14:52:06,848 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'log4JReset', v1.0.5 by Infinite Automation Software
INFO 2014-08-22 14:52:06,850 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'loggingConsole', v1.0.1 by Infinite Automation
INFO 2014-08-22 14:52:06,851 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'jspViews', v2.0.3 by Infinite Automation Software
INFO 2014-08-22 14:52:06,855 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sqlConsole', v1.4.4 by Infinite Automation Software
INFO 2014-08-22 14:52:06,865 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'asciiFile', v1.1.3 by Infinite Automation
INFO 2014-08-22 14:52:06,867 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'reports', v2.0.12 by Infinite Automation Software
INFO 2014-08-22 14:52:06,872 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dnp3', v1.4.5 by Infinite Automation Software
INFO 2014-08-22 14:52:06,875 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sqlds', v1.5.5 by Infinite Automation Software
INFO 2014-08-22 14:52:06,879 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'openv4j', v1.0.4 by aploese
INFO 2014-08-22 14:52:06,881 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'http', v1.4.6 by Infinite Automation Software
INFO 2014-08-22 14:52:08,105 (com.serotonin.m2m2.web.M2M2ContextListener.contextInitialized:31) - Mango Automation context starting
INFO 2014-08-22 14:52:08,106 (com.serotonin.m2m2.web.M2M2ContextListener.contextInitialized:39) - Mango Automation context started
INFO 2014-08-22 14:52:08,469 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/users.shtm] onto handler 'usersController'
INFO 2014-08-22 14:52:08,527 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source.shtm] onto handler 'dataSourceController'
INFO 2014-08-22 14:52:08,569 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/publisher_edit.shtm] onto handler 'publisherEditController'
INFO 2014-08-22 14:52:08,629 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/login.htm] onto handler 'loginController'
INFO 2014-08-22 14:52:08,630 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/shutdown.htm] onto handler 'shutdownController'
INFO 2014-08-22 14:52:08,668 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_properties.shtm] onto handler 'dataSourcePropertiesController'
INFO 2014-08-22 14:52:08,676 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/startup.htm] onto handler 'startupController'
INFO 2014-08-22 14:52:08,706 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/webcam_live_feed.htm] onto handler 'webcamLiveFeedController'
INFO 2014-08-22 14:52:08,712 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/unauthorized.htm] onto handler 'unauthorizedController'
INFO 2014-08-22 14:52:08,713 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_point_edit.shtm] onto handler 'dataPointEditController'
INFO 2014-08-22 14:52:08,753 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_properties_error.shtm] onto handler 'dataSourceErrorController'
INFO 2014-08-22 14:52:08,754 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_edit.shtm] onto handler 'dataSourceEditController'
INFO 2014-08-22 14:52:08,755 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/mobile/users.shtm] onto handler 'usersController'
INFO 2014-08-22 14:52:08,801 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/mobile.shtm] onto handler 'mobileController'
INFO 2014-08-22 14:52:08,803 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/help.shtm] onto handler 'helpController'
INFO 2014-08-22 14:52:08,804 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/logout.htm] onto handler 'logoutController'
INFO 2014-08-22 14:52:09,365 (com.serotonin.m2m2.Lifecycle.lic:404) - Checking license...
INFO 2014-08-22 14:52:09,367 (com.serotonin.m2m2.Lifecycle.loadLic:519) - License file not found
INFO 2014-08-22 14:52:09,477 (com.serotonin.m2m2.db.BasePooledProxy.initializeImpl:36) - Initializing pooled connection manager
WARN 2014-08-22 14:52:09,875 (com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade:96) - Upgrading 'core' from 1 to 2
INFO 2014-08-22 14:52:09,879 (com.serotonin.m2m2.db.upgrade.DBUpgrade.createUpdateLogOutputStream:152) - Writing upgrade log to /opt/aa1/logs/com.serotonin.m2m2.db.upgrade.Upgrade1.log
INFO 2014-08-22 14:52:10,010 (com.serotonin.m2m2.db.BasePooledProxy.terminateImpl:110) - Stopping database
ERROR 2014-08-22 14:52:10,015 (com.serotonin.m2m2.Main.main:111) - Error during initialization
com.serotonin.ShouldNeverHappenException: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [alter table publishers add column rtdata longblob; ]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'rtdata'
at com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:102)
at com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:34)
at com.serotonin.m2m2.db.DatabaseProxy.initialize(DatabaseProxy.java:163)
at com.serotonin.m2m2.Lifecycle.databaseInitialize(Lifecycle.java:574)
at com.serotonin.m2m2.Lifecycle.initialize(Lifecycle.java:241)
at com.serotonin.m2m2.Main.main(Main.java:106)
Caused by: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [alter table publishers add column rtdata longblob; ]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'rtdata'
at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:94)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:406)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:427)
at com.serotonin.m2m2.db.BasePooledProxy.runScript(BasePooledProxy.java:73)
at com.serotonin.m2m2.db.upgrade.DBUpgrade.runScript(DBUpgrade.java:129)
at com.serotonin.m2m2.db.upgrade.DBUpgrade.runScript(DBUpgrade.java:143)
at com.serotonin.m2m2.db.upgrade.DBUpgrade.runScript(DBUpgrade.java:134)
at com.serotonin.m2m2.db.upgrade.Upgrade1.upgrade(Upgrade1.java:17)
at com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:98)
... 5 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'rtdata'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2477)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:741)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:587)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:266)
at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:420)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:395)
... 12 more
INFO 2014-08-22 14:56:35,980 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'galil', v1.4.4 by Infinite Automation Software
INFO 2014-08-22 14:56:35,996 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'scheduledEvents', v1.4.6 by (unknown vendor)
INFO 2014-08-22 14:56:36,009 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'maintenanceEvents', v1.4.7 by Infinite Automation Software
INFO 2014-08-22 14:56:36,021 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'templateConfig', v1.0.4 by Infinite Automation Software
INFO 2014-08-22 14:56:36,041 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'jmxds', v1.4.4 by Infinite Automation Software
INFO 2014-08-22 14:56:36,044 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sstTheme', v1.0.5 by Infinite Automation Software
INFO 2014-08-22 14:56:36,050 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'internal', v1.4.4 by Infinite Automation Software
INFO 2014-08-22 14:56:36,053 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'watchlists', v1.5.7 by Infinite Automation Software
INFO 2014-08-22 14:56:36,085 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'abeip', v1.0.6 by Deltamation Software
INFO 2014-08-22 14:56:36,088 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'mbus', v1.0.4 by Infinite Automation Software
INFO 2014-08-22 14:56:36,090 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pointLinks', v1.4.5 by Infinite Automation Software
INFO 2014-08-22 14:56:36,092 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'modbus', v1.4.8 by Infinite Automation Software
INFO 2014-08-22 14:56:36,098 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'snmp', v1.4.5 by Infinite Automation Software
INFO 2014-08-22 14:56:36,105 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'virtualDS', v1.4.4 by Infinite Automation Software
INFO 2014-08-22 14:56:36,108 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pop3', v1.4.4 by Infinite Automation Software
INFO 2014-08-22 14:56:36,111 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'vmstat', v1.4.6 by Infinite Automation Software
INFO 2014-08-22 14:56:36,116 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pachube', v1.4.7 by Infinite Automation Software
INFO 2014-08-22 14:56:36,119 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'abpccc', v1.0.4 by Deltamation Software
INFO 2014-08-22 14:56:36,123 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sstGraphics', v1.0.5 by Infinite Automation Software
INFO 2014-08-22 14:56:36,127 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'graphicalViews', v1.4.9 by Infinite Automation Software
INFO 2014-08-22 14:56:36,133 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'BACnet', v2.1.1 by Infinite Automation Software
INFO 2014-08-22 14:56:36,144 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'meta', v2.0.7 by Infinite Automation Software
INFO 2014-08-22 14:56:36,147 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dataImport', v1.3.4 by Infinite Automation Software
INFO 2014-08-22 14:56:36,153 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'opcda', v1.5.5 by Infinite Automation Software
INFO 2014-08-22 14:56:36,156 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sstGlobalScripts', v1.4.5 by Infinite Automation Software
INFO 2014-08-22 14:56:36,159 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'persistent', v1.4.7 by Infinite Automation Software
INFO 2014-08-22 14:56:36,162 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'onewire', v1.4.5 by Infinite Automation Software
INFO 2014-08-22 14:56:36,166 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dglux', v1.0.11 by Infinite Automation Software
INFO 2014-08-22 14:56:36,167 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'serial', v1.1.2 by Infinite Automation
INFO 2014-08-22 14:56:36,169 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dataFile', v1.0.4 by Infinite Automation
INFO 2014-08-22 14:56:36,175 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'twilio', v1.0.3 by (unknown vendor)
INFO 2014-08-22 14:56:36,178 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'scripting', v1.0.7 by Infinite Automation Software
INFO 2014-08-22 14:56:36,181 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'log4JReset', v1.0.5 by Infinite Automation Software
INFO 2014-08-22 14:56:36,182 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'loggingConsole', v1.0.1 by Infinite Automation
INFO 2014-08-22 14:56:36,184 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'jspViews', v2.0.3 by Infinite Automation Software
INFO 2014-08-22 14:56:36,189 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sqlConsole', v1.4.4 by Infinite Automation Software
INFO 2014-08-22 14:56:36,197 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'asciiFile', v1.1.3 by Infinite Automation
INFO 2014-08-22 14:56:36,200 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'reports', v2.0.12 by Infinite Automation Software
INFO 2014-08-22 14:56:36,206 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dnp3', v1.4.5 by Infinite Automation Software
INFO 2014-08-22 14:56:36,208 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sqlds', v1.5.5 by Infinite Automation Software
INFO 2014-08-22 14:56:36,211 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'openv4j', v1.0.4 by aploese
INFO 2014-08-22 14:56:36,213 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'http', v1.4.6 by Infinite Automation Software
INFO 2014-08-22 14:56:37,456 (com.serotonin.m2m2.web.M2M2ContextListener.contextInitialized:31) - Mango Automation context starting
INFO 2014-08-22 14:56:37,458 (com.serotonin.m2m2.web.M2M2ContextListener.contextInitialized:39) - Mango Automation context started
INFO 2014-08-22 14:56:37,820 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/users.shtm] onto handler 'usersController'
INFO 2014-08-22 14:56:37,887 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source.shtm] onto handler 'dataSourceController'
INFO 2014-08-22 14:56:37,933 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/publisher_edit.shtm] onto handler 'publisherEditController'
INFO 2014-08-22 14:56:37,994 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/login.htm] onto handler 'loginController'
INFO 2014-08-22 14:56:37,995 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/shutdown.htm] onto handler 'shutdownController'
INFO 2014-08-22 14:56:38,032 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_properties.shtm] onto handler 'dataSourcePropertiesController'
INFO 2014-08-22 14:56:38,041 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/startup.htm] onto handler 'startupController'
INFO 2014-08-22 14:56:38,065 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/webcam_live_feed.htm] onto handler 'webcamLiveFeedController'
INFO 2014-08-22 14:56:38,076 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/unauthorized.htm] onto handler 'unauthorizedController'
INFO 2014-08-22 14:56:38,078 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_point_edit.shtm] onto handler 'dataPointEditController'
INFO 2014-08-22 14:56:38,113 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_properties_error.shtm] onto handler 'dataSourceErrorController'
INFO 2014-08-22 14:56:38,120 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_edit.shtm] onto handler 'dataSourceEditController'
INFO 2014-08-22 14:56:38,121 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/mobile/users.shtm] onto handler 'usersController'
INFO 2014-08-22 14:56:38,157 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/mobile.shtm] onto handler 'mobileController'
INFO 2014-08-22 14:56:38,159 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/help.shtm] onto handler 'helpController'
INFO 2014-08-22 14:56:38,160 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/logout.htm] onto handler 'logoutController'
INFO 2014-08-22 14:56:38,707 (com.serotonin.m2m2.Lifecycle.lic:404) - Checking license...
INFO 2014-08-22 14:56:38,709 (com.serotonin.m2m2.Lifecycle.loadLic:519) - License file not found
INFO 2014-08-22 14:56:38,819 (com.serotonin.m2m2.db.BasePooledProxy.initializeImpl:36) - Initializing pooled connection manager
WARN 2014-08-22 14:56:39,215 (com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade:96) - Upgrading 'core' from 1 to 2
INFO 2014-08-22 14:56:39,218 (com.serotonin.m2m2.db.upgrade.DBUpgrade.createUpdateLogOutputStream:152) - Writing upgrade log to /opt/aa1/logs/com.serotonin.m2m2.db.upgrade.Upgrade1.log
INFO 2014-08-22 14:56:39,354 (com.serotonin.m2m2.db.BasePooledProxy.terminateImpl:110) - Stopping database
ERROR 2014-08-22 14:56:39,359 (com.serotonin.m2m2.Main.main:111) - Error during initialization
com.serotonin.ShouldNeverHappenException: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [alter table publishers add column rtdata longblob; ]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'rtdata'
at com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:102)
at com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:34)
at com.serotonin.m2m2.db.DatabaseProxy.initialize(DatabaseProxy.java:163)
at com.serotonin.m2m2.Lifecycle.databaseInitialize(Lifecycle.java:574)
at com.serotonin.m2m2.Lifecycle.initialize(Lifecycle.java:241)
at com.serotonin.m2m2.Main.main(Main.java:106)
Caused by: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [alter table publishers add column rtdata longblob; ]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'rtdata'
at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:94)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:406)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:427)
at com.serotonin.m2m2.db.BasePooledProxy.runScript(BasePooledProxy.java:73)
at com.serotonin.m2m2.db.upgrade.DBUpgrade.runScript(DBUpgrade.java:129)
at com.serotonin.m2m2.db.upgrade.DBUpgrade.runScript(DBUpgrade.java:143)
at com.serotonin.m2m2.db.upgrade.DBUpgrade.runScript(DBUpgrade.java:134)
at com.serotonin.m2m2.db.upgrade.Upgrade1.upgrade(Upgrade1.java:17)
at com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:98)
... 5 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'rtdata'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2477)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:741)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:587)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:266)
at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:420)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:395)
... 12 more
INFO 2014-08-22 15:03:58,695 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'galil', v1.4.4 by Infinite Automation Software
INFO 2014-08-22 15:03:58,722 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'scheduledEvents', v1.4.6 by (unknown vendor)
INFO 2014-08-22 15:03:58,725 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'maintenanceEvents', v1.4.7 by Infinite Automation Software
INFO 2014-08-22 15:03:58,737 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'templateConfig', v1.0.4 by Infinite Automation Software
INFO 2014-08-22 15:03:58,749 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'jmxds', v1.4.4 by Infinite Automation Software
INFO 2014-08-22 15:03:58,761 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sstTheme', v1.0.5 by Infinite Automation Software
INFO 2014-08-22 15:03:58,768 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'internal', v1.4.4 by Infinite Automation Software
INFO 2014-08-22 15:03:58,772 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'watchlists', v1.5.7 by Infinite Automation Software
INFO 2014-08-22 15:03:58,799 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'abeip', v1.0.6 by Deltamation Software
INFO 2014-08-22 15:03:58,802 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'mbus', v1.0.4 by Infinite Automation Software
INFO 2014-08-22 15:03:58,804 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pointLinks', v1.4.5 by Infinite Automation Software
INFO 2014-08-22 15:03:58,806 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'modbus', v1.4.8 by Infinite Automation Software
INFO 2014-08-22 15:03:58,813 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'snmp', v1.4.5 by Infinite Automation Software
INFO 2014-08-22 15:03:58,821 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'virtualDS', v1.4.4 by Infinite Automation Software
INFO 2014-08-22 15:03:58,824 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pop3', v1.4.4 by Infinite Automation Software
INFO 2014-08-22 15:03:58,826 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'vmstat', v1.4.6 by Infinite Automation Software
INFO 2014-08-22 15:03:58,831 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pachube', v1.4.7 by Infinite Automation Software
INFO 2014-08-22 15:03:58,834 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'abpccc', v1.0.4 by Deltamation Software
INFO 2014-08-22 15:03:58,838 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sstGraphics', v1.0.5 by Infinite Automation Software
INFO 2014-08-22 15:03:58,843 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'graphicalViews', v1.4.9 by Infinite Automation Software
INFO 2014-08-22 15:03:58,849 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'BACnet', v2.1.1 by Infinite Automation Software
INFO 2014-08-22 15:03:58,859 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'meta', v2.0.7 by Infinite Automation Software
INFO 2014-08-22 15:03:58,865 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dataImport', v1.3.4 by Infinite Automation Software
INFO 2014-08-22 15:03:58,871 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'opcda', v1.5.5 by Infinite Automation Software
INFO 2014-08-22 15:03:58,874 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sstGlobalScripts', v1.4.5 by Infinite Automation Software
INFO 2014-08-22 15:03:58,877 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'persistent', v1.4.7 by Infinite Automation Software
INFO 2014-08-22 15:03:58,879 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'onewire', v1.4.5 by Infinite Automation Software
INFO 2014-08-22 15:03:58,883 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dglux', v1.0.11 by Infinite Automation Software
INFO 2014-08-22 15:03:58,885 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'serial', v1.1.2 by Infinite Automation
INFO 2014-08-22 15:03:58,889 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dataFile', v1.0.4 by Infinite Automation
INFO 2014-08-22 15:03:58,895 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'twilio', v1.0.3 by (unknown vendor)
INFO 2014-08-22 15:03:58,898 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'scripting', v1.0.7 by Infinite Automation Software
INFO 2014-08-22 15:03:58,901 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'log4JReset', v1.0.5 by Infinite Automation Software
INFO 2014-08-22 15:03:58,902 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'loggingConsole', v1.0.1 by Infinite Automation
INFO 2014-08-22 15:03:58,904 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'jspViews', v2.0.3 by Infinite Automation Software
INFO 2014-08-22 15:03:58,908 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sqlConsole', v1.4.4 by Infinite Automation Software
INFO 2014-08-22 15:03:58,917 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'asciiFile', v1.1.3 by Infinite Automation
INFO 2014-08-22 15:03:58,923 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'reports', v2.0.12 by Infinite Automation Software
INFO 2014-08-22 15:03:58,929 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dnp3', v1.4.5 by Infinite Automation Software
INFO 2014-08-22 15:03:58,931 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sqlds', v1.5.5 by Infinite Automation Software
INFO 2014-08-22 15:03:58,934 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'openv4j', v1.0.4 by aploese
INFO 2014-08-22 15:03:58,936 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'http', v1.4.6 by Infinite Automation Software
INFO 2014-08-22 15:04:00,176 (com.serotonin.m2m2.web.M2M2ContextListener.contextInitialized:31) - Mango Automation context starting
INFO 2014-08-22 15:04:00,178 (com.serotonin.m2m2.web.M2M2ContextListener.contextInitialized:39) - Mango Automation context started
INFO 2014-08-22 15:04:00,548 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/users.shtm] onto handler 'usersController'
INFO 2014-08-22 15:04:00,610 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source.shtm] onto handler 'dataSourceController'
INFO 2014-08-22 15:04:00,646 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/publisher_edit.shtm] onto handler 'publisherEditController'
INFO 2014-08-22 15:04:00,714 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/login.htm] onto handler 'loginController'
INFO 2014-08-22 15:04:00,720 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/shutdown.htm] onto handler 'shutdownController'
INFO 2014-08-22 15:04:00,753 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_properties.shtm] onto handler 'dataSourcePropertiesController'
INFO 2014-08-22 15:04:00,761 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/startup.htm] onto handler 'startupController'
INFO 2014-08-22 15:04:00,800 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/webcam_live_feed.htm] onto handler 'webcamLiveFeedController'
INFO 2014-08-22 15:04:00,809 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/unauthorized.htm] onto handler 'unauthorizedController'
INFO 2014-08-22 15:04:00,811 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_point_edit.shtm] onto handler 'dataPointEditController'
INFO 2014-08-22 15:04:00,851 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_properties_error.shtm] onto handler 'dataSourceErrorController'
INFO 2014-08-22 15:04:00,856 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_edit.shtm] onto handler 'dataSourceEditController'
INFO 2014-08-22 15:04:00,857 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/mobile/users.shtm] onto handler 'usersController'
INFO 2014-08-22 15:04:00,898 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/mobile.shtm] onto handler 'mobileController'
INFO 2014-08-22 15:04:00,900 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/help.shtm] onto handler 'helpController'
INFO 2014-08-22 15:04:00,901 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/logout.htm] onto handler 'logoutController'
INFO 2014-08-22 15:04:01,453 (com.serotonin.m2m2.Lifecycle.lic:404) - Checking license...
INFO 2014-08-22 15:04:01,455 (com.serotonin.m2m2.Lifecycle.loadLic:519) - License file not found
INFO 2014-08-22 15:04:01,566 (com.serotonin.m2m2.db.BasePooledProxy.initializeImpl:36) - Initializing pooled connection manager
WARN 2014-08-22 15:04:01,983 (com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade:96) - Upgrading 'core' from 1 to 2
INFO 2014-08-22 15:04:01,986 (com.serotonin.m2m2.db.upgrade.DBUpgrade.createUpdateLogOutputStream:152) - Writing upgrade log to /opt/aa1/logs/com.serotonin.m2m2.db.upgrade.Upgrade1.log
INFO 2014-08-22 15:04:02,121 (com.serotonin.m2m2.db.BasePooledProxy.terminateImpl:110) - Stopping database
ERROR 2014-08-22 15:04:02,134 (com.serotonin.m2m2.Main.main:111) - Error during initialization
com.serotonin.ShouldNeverHappenException: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [alter table publishers add column rtdata longblob; ]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'rtdata'
at com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:102)
at com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:34)
at com.serotonin.m2m2.db.DatabaseProxy.initialize(DatabaseProxy.java:163)
at com.serotonin.m2m2.Lifecycle.databaseInitialize(Lifecycle.java:574)
at com.serotonin.m2m2.Lifecycle.initialize(Lifecycle.java:241)
at com.serotonin.m2m2.Main.main(Main.java:106)
Caused by: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [alter table publishers add column rtdata longblob; ]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'rtdata'
at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:94)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:406)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:427)
at com.serotonin.m2m2.db.BasePooledProxy.runScript(BasePooledProxy.java:73)
at com.serotonin.m2m2.db.upgrade.DBUpgrade.runScript(DBUpgrade.java:129)
at com.serotonin.m2m2.db.upgrade.DBUpgrade.runScript(DBUpgrade.java:143)
at com.serotonin.m2m2.db.upgrade.DBUpgrade.runScript(DBUpgrade.java:134)
at com.serotonin.m2m2.db.upgrade.Upgrade1.upgrade(Upgrade1.java:17)
at com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:98)
... 5 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'rtdata'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2477)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:741)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:587)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:266)
at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:420)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:395)
... 12 more
INFO 2014-08-22 15:04:49,049 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'galil', v1.4.4 by Infinite Automation Software
INFO 2014-08-22 15:04:49,064 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'scheduledEvents', v1.4.6 by (unknown vendor)
INFO 2014-08-22 15:04:49,076 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'maintenanceEvents', v1.4.7 by Infinite Automation Software
INFO 2014-08-22 15:04:49,093 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'templateConfig', v1.0.4 by Infinite Automation Software
INFO 2014-08-22 15:04:49,106 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'jmxds', v1.4.4 by Infinite Automation Software
INFO 2014-08-22 15:04:49,113 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sstTheme', v1.0.5 by Infinite Automation Software
INFO 2014-08-22 15:04:49,120 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'internal', v1.4.4 by Infinite Automation Software
INFO 2014-08-22 15:04:49,123 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'watchlists', v1.5.7 by Infinite Automation Software
INFO 2014-08-22 15:04:49,151 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'abeip', v1.0.6 by Deltamation Software
INFO 2014-08-22 15:04:49,154 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'mbus', v1.0.4 by Infinite Automation Software
INFO 2014-08-22 15:04:49,155 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pointLinks', v1.4.5 by Infinite Automation Software
INFO 2014-08-22 15:04:49,157 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'modbus', v1.4.8 by Infinite Automation Software
INFO 2014-08-22 15:04:49,165 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'snmp', v1.4.5 by Infinite Automation Software
INFO 2014-08-22 15:04:49,172 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'virtualDS', v1.4.4 by Infinite Automation Software
INFO 2014-08-22 15:04:49,174 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pop3', v1.4.4 by Infinite Automation Software
INFO 2014-08-22 15:04:49,179 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'vmstat', v1.4.6 by Infinite Automation Software
INFO 2014-08-22 15:04:49,184 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pachube', v1.4.7 by Infinite Automation Software
INFO 2014-08-22 15:04:49,187 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'abpccc', v1.0.4 by Deltamation Software
INFO 2014-08-22 15:04:49,191 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sstGraphics', v1.0.5 by Infinite Automation Software
INFO 2014-08-22 15:04:49,197 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'graphicalViews', v1.4.9 by Infinite Automation Software
INFO 2014-08-22 15:04:49,203 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'BACnet', v2.1.1 by Infinite Automation Software
INFO 2014-08-22 15:04:49,212 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'meta', v2.0.7 by Infinite Automation Software
INFO 2014-08-22 15:04:49,218 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dataImport', v1.3.4 by Infinite Automation Software
INFO 2014-08-22 15:04:49,224 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'opcda', v1.5.5 by Infinite Automation Software
INFO 2014-08-22 15:04:49,227 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sstGlobalScripts', v1.4.5 by Infinite Automation Software
INFO 2014-08-22 15:04:49,229 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'persistent', v1.4.7 by Infinite Automation Software
INFO 2014-08-22 15:04:49,232 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'onewire', v1.4.5 by Infinite Automation Software
INFO 2014-08-22 15:04:49,235 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dglux', v1.0.11 by Infinite Automation Software
INFO 2014-08-22 15:04:49,236 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'serial', v1.1.2 by Infinite Automation
INFO 2014-08-22 15:04:49,240 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dataFile', v1.0.4 by Infinite Automation
INFO 2014-08-22 15:04:49,248 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'twilio', v1.0.3 by (unknown vendor)
INFO 2014-08-22 15:04:49,251 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'scripting', v1.0.7 by Infinite Automation Software
INFO 2014-08-22 15:04:49,253 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'log4JReset', v1.0.5 by Infinite Automation Software
INFO 2014-08-22 15:04:49,255 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'loggingConsole', v1.0.1 by Infinite Automation
INFO 2014-08-22 15:04:49,256 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'jspViews', v2.0.3 by Infinite Automation Software
INFO 2014-08-22 15:04:49,260 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sqlConsole', v1.4.4 by Infinite Automation Software
INFO 2014-08-22 15:04:49,270 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'asciiFile', v1.1.3 by Infinite Automation
INFO 2014-08-22 15:04:49,275 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'reports', v2.0.12 by Infinite Automation Software
INFO 2014-08-22 15:04:49,278 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dnp3', v1.4.5 by Infinite Automation Software
INFO 2014-08-22 15:04:49,282 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sqlds', v1.5.5 by Infinite Automation Software
INFO 2014-08-22 15:04:49,284 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'openv4j', v1.0.4 by aploese
INFO 2014-08-22 15:04:49,286 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'http', v1.4.6 by Infinite Automation Software
INFO 2014-08-22 15:04:50,530 (com.serotonin.m2m2.web.M2M2ContextListener.contextInitialized:31) - Mango Automation context starting
INFO 2014-08-22 15:04:50,532 (com.serotonin.m2m2.web.M2M2ContextListener.contextInitialized:39) - Mango Automation context started
INFO 2014-08-22 15:04:50,914 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/users.shtm] onto handler 'usersController'
INFO 2014-08-22 15:04:50,979 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source.shtm] onto handler 'dataSourceController'
INFO 2014-08-22 15:04:51,019 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/publisher_edit.shtm] onto handler 'publisherEditController'
INFO 2014-08-22 15:04:51,090 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/login.htm] onto handler 'loginController'
INFO 2014-08-22 15:04:51,096 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/shutdown.htm] onto handler 'shutdownController'
INFO 2014-08-22 15:04:51,137 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_properties.shtm] onto handler 'dataSourcePropertiesController'
INFO 2014-08-22 15:04:51,145 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/startup.htm] onto handler 'startupController'
INFO 2014-08-22 15:04:51,178 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/webcam_live_feed.htm] onto handler 'webcamLiveFeedController'
INFO 2014-08-22 15:04:51,185 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/unauthorized.htm] onto handler 'unauthorizedController'
INFO 2014-08-22 15:04:51,191 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_point_edit.shtm] onto handler 'dataPointEditController'
INFO 2014-08-22 15:04:51,232 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_properties_error.shtm] onto handler 'dataSourceErrorController'
INFO 2014-08-22 15:04:51,234 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_edit.shtm] onto handler 'dataSourceEditController'
INFO 2014-08-22 15:04:51,235 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/mobile/users.shtm] onto handler 'usersController'
INFO 2014-08-22 15:04:51,281 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/mobile.shtm] onto handler 'mobileController'
INFO 2014-08-22 15:04:51,284 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/help.shtm] onto handler 'helpController'
INFO 2014-08-22 15:04:51,287 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/logout.htm] onto handler 'logoutController'
INFO 2014-08-22 15:04:51,868 (com.serotonin.m2m2.Lifecycle.lic:404) - Checking license...
INFO 2014-08-22 15:04:51,869 (com.serotonin.m2m2.Lifecycle.loadLic:519) - License file not found
INFO 2014-08-22 15:04:51,973 (com.serotonin.m2m2.db.BasePooledProxy.initializeImpl:36) - Initializing pooled connection manager
WARN 2014-08-22 15:04:52,368 (com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade:96) - Upgrading 'core' from 1 to 2
INFO 2014-08-22 15:04:52,371 (com.serotonin.m2m2.db.upgrade.DBUpgrade.createUpdateLogOutputStream:152) - Writing upgrade log to /opt/aa1/logs/com.serotonin.m2m2.db.upgrade.Upgrade1.log
INFO 2014-08-22 15:04:52,504 (com.serotonin.m2m2.db.BasePooledProxy.terminateImpl:110) - Stopping database
ERROR 2014-08-22 15:04:52,510 (com.serotonin.m2m2.Main.main:111) - Error during initialization
com.serotonin.ShouldNeverHappenException: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [alter table publishers add column rtdata longblob; ]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'rtdata'
at com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:102)
at com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:34)
at com.serotonin.m2m2.db.DatabaseProxy.initialize(DatabaseProxy.java:163)
at com.serotonin.m2m2.Lifecycle.databaseInitialize(Lifecycle.java:574)
at com.serotonin.m2m2.Lifecycle.initialize(Lifecycle.java:241)
at com.serotonin.m2m2.Main.main(Main.java:106)
Caused by: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [alter table publishers add column rtdata longblob; ]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'rtdata'
at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:94)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:406)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:427)
at com.serotonin.m2m2.db.BasePooledProxy.runScript(BasePooledProxy.java:73)
at com.serotonin.m2m2.db.upgrade.DBUpgrade.runScript(DBUpgrade.java:129)
at com.serotonin.m2m2.db.upgrade.DBUpgrade.runScript(DBUpgrade.java:143)
at com.serotonin.m2m2.db.upgrade.DBUpgrade.runScript(DBUpgrade.java:134)
at com.serotonin.m2m2.db.upgrade.Upgrade1.upgrade(Upgrade1.java:17)
at com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:98)
... 5 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'rtdata'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2477)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:741)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:587)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:266)
at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:420)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:395)
... 12 more

What 's wrong with it please refer to attachment.

BR

Attachment: download link

As topic.
how to undisplay "reports" icon and "help" icon and "DGLUX" icon when "user" log in ?

I unzip a new m2m2 and copy old database -----mah2.h2.db,mah2.lock.db,mah2.trace.db in mango_automation_2.4.0_full_install\databases (the old databases have store some days data.)

But when I filter in data point and display like attachment.

How to solve it ?

Attachment: download link

Haha ,Very stranger ,Test many times and status is like before .finally I restart the computer it is ok!!!

Each time the scrip runs it will do the action that matches the conditions you create. So if the first if in your scrip is true each time it runs then it will do the sets each time. If they are modbus registers then it will send out new modbus set commands each time.

You can get around this by putting additional conditions in the first if statement.

As topic

How to setting can only display "urgent alarm" button and no need "information events","critical events alarm", "lifte safety Events" on top center alarm button for user?

Thank for your help.

You could use the HTTP Retriever I think.

It's the same answer from another thread, but I would use meta points to define complex conditions.

Hi Terry,
That last Data Source seems to have fixed the crashing.
How do I remove the added debug messages from the logs?
I have removed the line from the log4j configuration file and restarted Mango but the messages keep coming.
I am getting daily logs over 650MB in size.

Cheers,
Matt.

Maybe it's covered in the [url=http://forum.infiniteautomation.com/forum/recentTopics/showTopicsByUser/11563.page]Mango Automation FAQ

Database settings for conversion.

If the db.* settings point to a new database instance, and the convert type setting

is set, Mango Automation will attempt to convert from the convert.db.* settings to the db.* settings

This is a known issue and has been resolved for the next release coming soon. In the mean time see this thread you started: http://forum.infiniteautomation.com/forum/posts/list/1796.page

Is the ^ part of the pattern? I don't see a $ so it sort of looks like it would be...

One thing you could theoretically do is put in an event for no update X minutes, and give that event a handler that sets the point to 0. But, this would mix the zeros in with your data and possibly cause other problems if someone mistakes it for real. In DGLux you can write a script that combs the source value table and transposes it into another table, interpolating however you like. For the current built-in charts, I don't believe there is a solution like the second.

ok .I upload the image again.

Attachment: download link

@JoelHaggar said:

delete from EVENTS

The above SQL statement successfully purged a large number of events from my mango installation (mySQL), which has hopefully fixed the exceptions, and made it a lot snappier!
Thanks!

Yes .I have changed the ""From " name: AA system" ,And I can received the alarm email display "AA system" ,But in scheduled report still display email address(xx@gamil.com).
just now I try write in ""From" address " : AA system,and then I test the schedule report email will not be sent.

Thank very much! :)

Ah, that is mistaken in the documentation as well. I believe the .class is required.