forum.bitel.ru http://forum.bitel.ru/ |
|
ErrorException: Unknown column 'hash' in 'field list' http://forum.bitel.ru/viewtopic.php?f=54&t=12879 |
Страница 1 из 1 |
Автор: | georgdts [ 25 апр 2018, 18:33 ] |
Заголовок сообщения: | ErrorException: Unknown column 'hash' in 'field list' |
Поставил плагин, добавляю договору рассылку, получаю ошибку: Код: ru.bitel.bgbilling.common.BGException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'hash' in 'field list'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) 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.$Proxy38.updateSubscriptions(Unknown Source) at ru.bitel.bgbilling.plugins.dispatch.client.contract.ContractDispatchPanel$DispatchForm$7.actionPerformedImpl(ContractDispatchPanel.java:308) at ru.bitel.common.client.AbstractBGUPanel.actionPerformed(AbstractBGUPanel.java:235) at ru.bitel.common.client.AbstractBGUPanel$DefaultAction.actionPerformed(AbstractBGUPanel.java:96) at ru.bitel.bgbilling.client.common.BGEditor$DelegateAction.actionPerformed(BGEditor.java:367) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022) at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2348) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252) at java.awt.Component.processMouseEvent(Component.java:6539) at javax.swing.JComponent.processMouseEvent(JComponent.java:3324) at java.awt.Component.processEvent(Component.java:6304) at java.awt.Container.processEvent(Container.java:2239) at java.awt.Component.dispatchEventImpl(Component.java:4889) at java.awt.Container.dispatchEventImpl(Container.java:2297) at java.awt.Component.dispatchEvent(Component.java:4711) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4904) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4535) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4476) at java.awt.Container.dispatchEventImpl(Container.java:2283) at java.awt.Window.dispatchEventImpl(Window.java:2746) at java.awt.Component.dispatchEvent(Component.java:4711) at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:760) at java.awt.EventQueue.access$500(EventQueue.java:97) at java.awt.EventQueue$3.run(EventQueue.java:709) at java.awt.EventQueue$3.run(EventQueue.java:703) at java.security.AccessController.doPrivileged(Native Method) at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:74) at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:84) at java.awt.EventQueue$4.run(EventQueue.java:733) at java.awt.EventQueue$4.run(EventQueue.java:731) at java.security.AccessController.doPrivileged(Native Method) at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:74) at java.awt.EventQueue.dispatchEvent(EventQueue.java:730) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:205) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93) at java.awt.EventDispatchThread.run(EventDispatchThread.java:82) |
Автор: | skn [ 25 апр 2018, 19:26 ] |
Заголовок сообщения: | Re: ErrorException: Unknown column 'hash' in 'field list' |
Код: ALTER TABLE `dispatch_subscription_contact` ADD COLUMN `hash` VARCHAR(32) DEFAULT NULL;
|
Автор: | georgdts [ 25 апр 2018, 21:40 ] |
Заголовок сообщения: | Re: ErrorException: Unknown column 'hash' in 'field list' |
Подскажите почему ошибка вылазит? Письмо доставляется. Код: 04-25/18:33:01 INFO [Thread-3] TaskExecuter - Starting periodic task #7: ru.bitel.bgbilling.plugins.dispatch.server.task.DispatchWorker
04-25/18:33:01 INFO [pool-2-thread-2] DispatchWorker - Task finished time=7 ms. 04-25/18:34:01 INFO [Thread-3] TaskExecuter - Starting periodic task #7: ru.bitel.bgbilling.plugins.dispatch.server.task.DispatchWorker 04-25/18:34:01 INFO [pool-2-thread-3] DispatchWorker - Task finished time=8 ms. 04-25/18:35:01 INFO [Thread-3] TaskExecuter - Starting periodic task #7: ru.bitel.bgbilling.plugins.dispatch.server.task.DispatchWorker 04-25/18:35:05 ERROR [pool-2-thread-4] LoggingPrintStream - javax.mail.SendFailedException: No recipient addresses 04-25/18:35:05 ERROR [pool-2-thread-4] LoggingPrintStream - at javax.mail.Transport.send0(Transport.java:210) 04-25/18:35:05 ERROR [pool-2-thread-4] LoggingPrintStream - at javax.mail.Transport.send(Transport.java:124) 04-25/18:35:05 ERROR [pool-2-thread-4] LoggingPrintStream - at bitel.billing.server.util.MailMsg.sendMessage(MailMsg.java:138) 04-25/18:35:05 ERROR [pool-2-thread-4] LoggingPrintStream - at ru.bitel.bgbilling.plugins.dispatch.server.sender.EmailSender.send(EmailSender.java:69) 04-25/18:35:05 ERROR [pool-2-thread-4] LoggingPrintStream - at ru.bitel.bgbilling.plugins.dispatch.server.bean.MessageProcessor.send(MessageProcessor.java:252) 04-25/18:35:05 ERROR [pool-2-thread-4] LoggingPrintStream - at ru.bitel.bgbilling.plugins.dispatch.server.task.DispatchWorker.executeTask(DispatchWorker.java:136) 04-25/18:35:05 ERROR [pool-2-thread-4] LoggingPrintStream - at ru.bitel.bgbilling.kernel.task.server.TaskBase.run(TaskBase.java:83) 04-25/18:35:05 ERROR [pool-2-thread-4] LoggingPrintStream - at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) 04-25/18:35:05 ERROR [pool-2-thread-4] LoggingPrintStream - at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) 04-25/18:35:05 ERROR [pool-2-thread-4] LoggingPrintStream - at java.lang.Thread.run(Thread.java:748) 04-25/18:35:05 INFO [pool-2-thread-4] DispatchWorker - Task finished time=3266 ms. 04-25/18:36:01 INFO [Thread-3] TaskExecuter - Starting periodic task #7: ru.bitel.bgbilling.plugins.dispatch.server.task.DispatchWorker 04-25/18:36:01 INFO [pool-2-thread-5] DispatchWorker - Task finished time=7 ms. 04-25/18:37:01 INFO [Thread-3] TaskExecuter - Starting periodic task #7: ru.bitel.bgbilling.plugins.dispatch.server.task.DispatchWorker 04-25/18:37:01 INFO [pool-2-thread-1] DispatchWorker - Task finished time=8 ms. 04-25/18:38:01 INFO [Thread-3] TaskExecuter - Starting periodic task #7: ru.bitel.bgbilling.plugins.dispatch.server.task.DispatchWorker 04-25/18:38:01 INFO [pool-2-thread-2] DispatchWorker - Task finished time=7 ms. |
Автор: | skn [ 26 апр 2018, 18:52 ] |
Заголовок сообщения: | Re: ErrorException: Unknown column 'hash' in 'field list' |
ошибка в адресе скорее всего (лишнии символы, пробелы или что то еще, программа пытается выделить из строки адрес, один находит и по нему отправляет, а остальное не может распарсить как адрес и ругается) можете попробовать добавить в конфиг сервера параметр Код: mail.debug=true в логах может быть что то дополнительно появится |
Страница 1 из 1 | Часовой пояс: UTC + 5 часов [ Летнее время ] |
Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |