scratchrf

can''t save phone mappings - asterisk-im 1.0/jive messenger 2.3.0

Discussion created by scratchrf on Nov 22, 2005
Latest reply on Jan 4, 2006 by MuppetMaster

Hello,

 

My problem seems similar to this recent post from Eduardo, however I am not savvy enough to say for sure:

 

http://www.jivesoftware.org/community/thread.jspa?threadID=16635&tstart=0

 

Just upgraded from asterisk-im 1.0b2 to 1.0, jive messenger 2.2.1 to 2.3.0

Cannot save Phone Mappings, recieve the "operation completed succesfully" when creating a new mapping.

 

However, when I go into ''Phone Mappings'' there are no entries listed.

 

Some things to note:

 

- This all worked fine with my previous versions

- I''m using the embedded database

- I included my Error Log for examination

 

Seems as though there is a difference in the way the 1.0 plugin requires you to enter the details of the phone mapping, or for some reason it cannot save it to the database. This is how I entered the information, which again, worked before:

 

Username: ryan

Phone: SIP/20 (from the drop down menu)

Extension: 20

 

My Error Log:

 

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

248

249

250

251

252

253

254

at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375)

at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:271)

at org.hibernate.impl.SessionImpl.list(SessionImpl.java:840)

at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)

at org.jivesoftware.phone.database.HibernatePhoneDAO.getALL(HibernatePhoneDAO.java :132)

at org.jivesoftware.phone.BasePhoneManager.getAll(BasePhoneManager.java:34)

at org.jivesoftware.messenger.plugin.phone.phone_002dusers_jsp._jspService(phone_0 02dusers_jsp.java:287)

at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)

at org.jivesoftware.messenger.container.PluginServlet.handleJSP(PluginServlet.java :227)

at org.jivesoftware.messenger.container.PluginServlet.service(PluginServlet.java:9 1)

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(WebApplica tionHandler.java:822)

at org.jivesoftware.admin.AuthCheckFilter.doFilter(AuthCheckFilter.java:98)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:813)

at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:11 8)

at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:813)

at org.jivesoftware.util.LocaleFilter.doFilter(LocaleFilter.java:43)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:813)

at org.jivesoftware.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingF ilter.java:41)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:813)

at org.jivesoftware.admin.AuthCheckFilter.doFilter(AuthCheckFilter.java:98)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.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.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.ja va:624)

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)

Caused by: java.sql.SQLException: Column not found: DEVICES0_.ISMONITORED in statement

at org.hsqldb.jdbc.Util.throwError(Unknown Source)

at org.hsqldb.jdbc.jdbcPreparedStatement.(Unknown Source)

at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)

at org.jivesoftware.database.AbstractConnection.prepareStatement(AbstractConnectio n.java:36)

at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:38 3)

at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:32 1)

at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:8 6)

at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1129)

at org.hibernate.loader.Loader.doQuery(Loader.java:373)

at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java: 210)

at org.hibernate.loader.Loader.loadCollection(Loader.java:1401)

... 46 more

Outcomes