Fwd: [Serusers] error querying table version

[Yi Zheng]

  I deleted all rows in the version table and manually created the table based on the ser_mysql.sh. But now I am seeing a different set of error messages. I searched ser code but can't find where it comes from.  What could be wrong?
   
  Feb 17 12:07:46 localhost ./ser[24061]: submit_query: Unknown column 'uid' in 'field list' 
Feb 17 12:07:46 localhost ./ser[24061]: db_query: Error while submitting query 
Feb 17 12:07:46 localhost ./ser[24061]: preload_udomain(): Error while doing db_query 
Feb 17 12:07:46 localhost ./ser[24061]: register_udomain(): Error while preloading domain 'location' 
Feb 17 12:07:46 localhost ./ser[24061]: domain_fixup(): Error while registering domain 
- ming
  

Yi Zheng <yizheng at sbcglobal.net> wrote:
    Date: Thu, 16 Feb 2006 21:20:17 -0800 (PST)
From: Yi Zheng <yizheng at sbcglobal.net>
To: ser sip <serusers at lists.iptel.org>
Subject: [Serusers] error querying table version

  Hi,
   
  While trying to setup auth_db() with mysql, I got the following error messages in /var/log/messages.
   
  table_version(): Invalid number of rows received: 2, location 
Feb 16 17:55:17 localhost ./ser[13709]: register_udomain(): Error while querying table version 
Feb 16 17:55:17 localhost ./ser[13709]: domain_fixup(): Error while registering domain 
I used ser_mysql.sh create to generate the ser database. It looks like that ser has two location entries in its version table. I tried to use ser_mysql.sh to reinstall the ser database but it ended up the same.  What should I do to correct this?
   
  - ming
_______________________________________________
Serusers mailing list
serusers at lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20060217/acecb601/attachment.htm>
-------------- next part --------------
_______________________________________________
Serusers mailing list
serusers at lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers