[Serusers] Cant restart SER after I edit the 'ser.cfg'

Iqbal iqbal at gigo.co.uk
Sat Mar 12 23:08:20 CET 2005


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




More information about the sr-users mailing list