It is currently Mon Sep 16, 2019 4:34 am




 Page 1 of 1 [ 1 post ] 
Author Message
 Post subject: Error retrieving users using MS SQL Server 2000
PostPosted: Wed Jul 16, 2008 1:27 am 
Support Staff

Joined: Fri Nov 01, 2002 4:06 am
Posts: 43
If your ChatBlazer server is using MS SQL Server 2000 as the database system, you may have a problem loading your users in the Admin client. The error in the database logs (cbdb.log) looks like this.

ERROR 20:14:57 - Load profiles failed
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Column index 2 is out of range.
   at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
   at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
   at com.microsoft.jdbc.base.BaseResultSet.validateColumnIndex(Unknown Source)
   at com.microsoft.jdbc.base.BaseResultSet.getString(Unknown Source)
   at com.microsoft.jdbc.base.BaseResultSet.getString(Unknown Source)
   at com.mchange.v2.c3p0.impl.NewProxyResultSet.getString(NewProxyResultSet.java:3342)
   at u.b(Unknown Source)
   at aq.a(Unknown Source)
   at com.chatblazer.server.y.a(Unknown Source)
   at com.chatblazer.server.y.handleMessage(Unknown Source)
   at com.chatblazer.protocol.AbstractMessageBuilder.fireMessage(Unknown Source)
   at com.chatblazer.protocol.AbstractMessageBuilder.transform(Unknown Source)
   at com.chatblazer.server.q.a(Unknown Source)
   at com.chatblazer.server.w.a(Unknown Source)
   at com.chatblazer.server.br.a(Unknown Source)
   at fn.run(Unknown Source)


Strangely, this doesn't happen in our development environment when we tested on the same database.

To solve this, look for the statement "s11" in confdb.xml.

<statement sid="s11">
  <dep-table name="user" default="1" />
  <dep-table name="site_user" />
    <sql type="query">SELECT ${user}.* FROM ${user}...


Change SELECT ${user}.* FROM to SELECT * FROM.



_________________
Samuel
ChatBlazer Support
Offline
 Profile  
 
Display posts from previous:  Sort by  
 Page 1 of 1 [ 1 post ] 


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  

cron