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.

Radix IoT Website Mango 3 Documentation Website Mango 4 Documentation Website

Help!urgent! why I use mysql in mango and display below?


  • 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