[Serusers] error to start ser-0.9.0

[Daniel-Constantin Mierla]

The database structure has changed from 0.8.14 to 0.9.0. You can use 
ser_mysql.sh to recreate the database to fit to 0.9.0 (!!! make backup 
of your data prior to use ser_mysql.sh, to be in the safe side).

Particularly in this case, the table "version" has now different names 
for columns: (table_name, version) in 0.8.14 => (table_name, 
table_version) in 0.9.0

Daniel


On 02/24/05 08:41, Charles Wang wrote:

>Mohammad:
>Please post your config first.
>1. And does the setting about db_url is correct?
>    Ex: modparam("acc", "db_url", "mysql://ser:heslo@localhost/ser")
>    Not modparam("acc", "db_url", "sql://ser:heslo@localhost/ser")
>
>2. Do you recompile the acc function to support MySQL or Postgresql?
>
>Best Regard
>Charles
>
>On Tue, 22 Feb 2005 18:34:51 -0500, Mohammad Khan <info at beeplove.com> wrote:
>  
>
>>Hello list:
>>
>>I was away for little while from playing with ser.
>>I just switched  from 0.8.14 to 0.9.0
>>
>>I am getting these, when I tried to start ser.
>>My main concern is "submit_query(): Unknown column 'table_version' in
>>'field list'"
>>Anybody out there can help, please.
>>
>>Feb 22 18:29:46 perch /usr/sbin/ser[21332]: Maxfwd module- initializing
>>Feb 22 18:29:47 perch /usr/sbin/ser[21332]: submit_query(): Unknown
>>column 'table_version' in 'field list'
>>Feb 22 18:29:47 perch /usr/sbin/ser[21332]: submit_query(): Error while
>>submitting query
>>Feb 22 18:29:47 perch /usr/sbin/ser[21332]: table_version(): Error in
>>db_query
>>Feb 22 18:29:47 perch /usr/sbin/ser[21332]: register_udomain(): Error
>>while querying table version
>>Feb 22 18:29:47 perch /usr/sbin/ser[21332]: domain_fixup(): Error while
>>registering domain
>>
>>Thanks
>>MOhammad
>>
>>_______________________________________________
>>Serusers mailing list
>>serusers at lists.iptel.org
>>http://lists.iptel.org/mailman/listinfo/serusers
>>
>>    
>>
>
>_______________________________________________
>Serusers mailing list
>serusers at lists.iptel.org
>http://lists.iptel.org/mailman/listinfo/serusers
>
>  
>