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@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@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers

---

Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers