12 Mar
2005
12 Mar
'05
11:08 p.m.
send a copy of your DB schema...show tables.
and then the tables looked up below
desc <tablename>;
Iqbal
On 3/12/2005, "Psyber" <psyber1(a)gmail.com> wrote:
I'm not an SQL guru, but it looks to me as if
your database fields
aren't built correctly for ser. Did you run the 'ser_mysql.sh' script
that comes with the ser distribution? I wouldn't advise running the
script if your database is already built.
If all else fails and you don't mind losing whatever data is in
ser's SQL database you can drop the ser database using mysqladmin and
re-create it using 'ser_mysql.sh'.
Let me know how you make out.
--Psyber
On Thu, 10 Mar 2005 19:59:51 -0800, Bruce Ferrell <bferrell(a)baywinds.org> wrote:
I have a similar problem:
Following errors:
Maxfwd module- initializing
0(28433) mod_init(): Database connection opened successfuly
acc - initializing
voicemail - initializing
0(0) submit_query(): Unknown column 'user_agent' in 'field list'
0(0) submit_query(): Error while submitting query
0(0) preload_udomain(): Error while doing db_query
0(0) register_udomain(): Error while preloading domain 'aliases'
0(0) domain_fixup(): Error while registering domain
ERROR: error ffffffff while trying to fix configuration
I don't see where the columns for the query are defined in the config.
The change I made (and changed back) was to point SER at different DB
machine.
_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers