Здравствуйте. При добавлении рассылки на договор, выдает вот такую ошибку:
Код:
ru.bitel.bgbilling.common.BGException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'active' in 'field list'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.sun.xml.ws.fault.SOAPFaultBuilder.createUserDefinedException(SOAPFaultBuilder.java:318)
at com.sun.xml.ws.fault.SOAPFaultBuilder.createException(SOAPFaultBuilder.java:139)
at com.sun.xml.ws.client.sei.SyncMethodHandler.invoke(SyncMethodHandler.java:123)
at com.sun.xml.ws.client.sei.SyncMethodHandler.invoke(SyncMethodHandler.java:93)
at com.sun.xml.ws.client.sei.SEIStub.invoke(SEIStub.java:144)
at com.sun.proxy.$Proxy44.updateSubscriptions(Unknown Source)
at ru.bitel.bgbilling.plugins.dispatch.client.contract.ContractDispatchPanel$DispatchForm$7.actionPerformedImpl(ContractDispatchPanel.java:321)
at ru.bitel.common.client.AbstractBGUPanel.actionPerformed(AbstractBGUPanel.java:237)
at ru.bitel.common.client.AbstractBGUPanel$DefaultAction.actionPerformed(AbstractBGUPanel.java:91)
at ru.bitel.bgbilling.client.common.BGEditor$DelegateAction.actionPerformed(BGEditor.java:354)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$500(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Код:
Информация о версии:
Клиент: вер. 7.0.884 / 04.04.2017 18:10:46
os: Windows 7; java: Java HotSpot(TM) Client VM, v.1.8.0_45
Сервер: вер. 7.0.1219 / 05.04.2017 17:27:33
os: Linux; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_111
bill: вер. 7.0.119 / 22.03.2017 01:01:35
card: вер. 7.0.43 / 21.03.2017 15:12:24
dba: вер. 7.0.167 / 08.04.2016 17:40:39
dialup: вер. 7.0.319 / 29.08.2016 16:38:40
inet: вер. 7.0.744 / 28.03.2017 21:55:20
ipn: вер. 7.0.267 / 13.03.2017 11:35:50
mps: вер. 7.0.212 / 28.03.2017 21:55:49
npay: вер. 7.0.206 / 15.03.2017 18:44:23
reports: вер. 7.0.231 / 15.03.2017 18:48:01
robokassa: вер. 7.0.29 / 21.11.2016 18:40:52
ru.bitel.bgbilling.plugins.dispatch: вер. 7.0.92 / 25.01.2017 17:01:23
ru.bitel.bgbilling.plugins.documents: вер. 7.0.176 / 21.11.2016 19:01:57
trayinfo: вер. 7.0.175 / 10.06.2016 17:00:23
Окружение:
Клиент:
os: Windows 7 x86, 6.1
java: Java HotSpot(TM) Client VM, v.1.8.0_45
jre home: C:\Program Files\Java\jre1.8.0_45
memory (use/total/max): 24M/33M/494M
default tz: 13.04.2017 09:21 YAKT +0900 (Asia/Yakutsk)
user tz: 13.04.2017 09:21 GMT+09:00 +0900 (GMT+09:00)
locale: ru_RU
Сервер:
os: Linux amd64, 3.16.0-4-amd64
java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_111
jre home: /opt/java/jdk1.8.0_111/jre
default tz: 13.04.2017 09:10 YAKT +0900 (Asia/Yakutsk)
memory (use/total/max): 125M/166M/455M
db time: master: 13.04.2017 09:10 YAKT
db charset: connection: utf8(utf8_unicode_ci), database: utf8(utf8_general_ci)
locale: ru_RU
uptime: Started: 12.04.2017 15:00:21 Uptime: 0 d 18:09:52
Почитал форум и понял, что нет столбца 'active' в MySQL базе!
Подскажите пожалуйста какую команду нужно выполнить в MySQL, чтобы добавился этот столбец?
В личном кабинете тоже при добавлении рассылки выдает "произошла непредвиденная ошибка".
Заранее благодарен!