BiTel

При попытке импорта географических кодов в модуль телефонии в server.out появляется вот такое сообщение и ни чего не имрортируется

com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'bgbilling.phone_geographic_code_5' doesn't exist
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3124)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1149)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1262)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:205)
at bitel.billing.server.tariff.voice.bean.GeographicCodeManager.getGeographicCodeList(GeographicCodeManager.java:363)
at bitel.billing.server.tariff.voice.ActionGeographicCode.doAction(ActionGeographicCode.java:30)
at bitel.billing.server.Executer.doModule(Executer.java:509)
at bitel.billing.server.Executer.doPost(Executer.java:121)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:615)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:427)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:822)
at bitel.billing.server.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:32)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:813)
at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:494)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:569)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1482)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1434)
at org.mortbay.http.HttpServer.service(HttpServer.java:896)
at org.mortbay.http.HttpConnection.service(HttpConnection.java:814)
at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:981)
at org.mortbay.http.HttpConnection.handle(HttpConnection.java:831)
at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244)
at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:366)
at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)

Версия биллинга 4.1, модуль phone 4.1

А при установке модуля ошибок не возникло? Похоже что таблица не создалась в базе данных. Попробуйте переустановить модуль или выполнить эти запросы

# ./bg_installer.sh phone_4.1.zip!
Module: phone version 4.1 already installed.
File's copy finished...
File copy => OK
Database updated...
Install ticket inserted..
Base update => OK
Reinit module instanses
REINIT module => 5
Table 'time_range_5' already exists
Table 'bgbilling.phone_client_item_5' doesn't exist
Table 'bgbilling.phone_client_item_5' doesn't exist
Table 'bgbilling.phone_client_item_5' doesn't exist
Table 'bgbilling.phone_client_item_5' doesn't exist
Table 'bgbilling.phone_client_item_5' doesn't exist
Table 'bgbilling.phone_client_item_5' doesn't exist
Table 'bgbilling.phone_client_item_5' doesn't exist
Table 'bgbilling.phone_client_item_5' doesn't exist
Table 'bgbilling.phone_client_item_5' doesn't exist
Module Instance init => OK
Executing call ExecuteSQL; param: atc.sql
Executing database update...OK
Result => true
Executing call ExecuteSQL; param: add_bgs.sql
Executing database update...OK
Result => true
Executing call AddSchedulerTasks; param: phone.sc
Scheduled class bitel.billing.server.phone.BalanceSetter already exists!
Result => true
Execute calls => OK
Module phone version 4.1 was sucsessfull installed!
Please, restart BGBilling server..


Таблицы создал теперь когда пытаюсь импортировать список выдает

com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'bgbilling.phone_dest_5' doesn't exist

Попробуйте удалить модуль в редакторе модулей и услуг и создать заново.

Спасибо, помогло