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@sbcglobal.net> wrote:
Date: Thu, 16 Feb 2006 21:20:17 -0800 (PST)
From: Yi Zheng <yizheng@sbcglobal.net>
To: ser sip <serusers@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@lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers