<DIV id=RTEContent> </DIV> <DIV>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?</DIV> <DIV> </DIV> <DIV>Feb 17 12:07:46 localhost ./ser[24061]: submit_query: Unknown column 'uid' in 'field list' <BR>Feb 17 12:07:46 localhost ./ser[24061]: db_query: Error while submitting query <BR>Feb 17 12:07:46 localhost ./ser[24061]: preload_udomain(): Error while doing db_query <BR>Feb 17 12:07:46 localhost ./ser[24061]: register_udomain(): Error while preloading domain 'location' <BR>Feb 17 12:07:46 localhost ./ser[24061]: domain_fixup(): Error while registering domain <BR>- ming</DIV> <DIV><BR><BR><B><I>Yi Zheng <yizheng@sbcglobal.net></I></B> wrote:</DIV> <DIV> <BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">Date: Thu, 16 Feb 2006
21:20:17 -0800 (PST)<BR>From: Yi Zheng <yizheng@sbcglobal.net><BR>To: ser sip <serusers@lists.iptel.org><BR>Subject: [Serusers] error querying table version<BR><BR> <DIV id=RTEContent>Hi,</DIV> <DIV> </DIV> <DIV>While trying to setup auth_db() with mysql, I got the following error messages in /var/log/messages.</DIV> <DIV> </DIV> <DIV>table_version(): Invalid number of rows received: 2, location <BR>Feb 16 17:55:17 localhost ./ser[13709]: register_udomain(): Error while querying table version <BR>Feb 16 17:55:17 localhost ./ser[13709]: domain_fixup(): Error while registering domain <BR>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?</DIV> <DIV> </DIV> <DIV>- ming</DIV>_______________________________________________<BR>Serusers mailing
list<BR>serusers@lists.iptel.org<BR>http://lists.iptel.org/mailman/listinfo/serusers<BR></BLOCKQUOTE><BR></DIV>