Hi Timo 

Thanks for your prompt response.

I realized what i did wrong now, i had followed the guide you specified below but i believe i may have entered the following command more than once:

INSERT INTO version (table_name, table_version) VALUES ('dialog_vars','1');

I found 4 entries in the mysql "version" table for dialog_vars. I then removed the 3 entries and left only one and this worked. Now everything is ok.
Sorry to have troubled you and thank you for your support.

Regards
Phillip


On Mon, Feb 20, 2012 at 11:50 PM, Timo Reimann <sr@foo-lounge.de> wrote:
Hey,


Am 20.02.2012 um 15:10 schrieb Phillman25 Kyriacou:
> After upgrading from V3.1.5 to V3.2. Kamailio crashes with the below error messages:
>
> Feb 20 16:43:59 sipproxy /usr/local/sbin/kamailio[11705]: ERROR: <core> [db.c:392]: invalid number of rows received: 4, dialog_vars

This one describes the actual error: "invalid number of rows received".


> Feb 20 16:43:59 sipproxy /usr/local/sbin/kamailio[11705]: ERROR: <core> [db.c:419]: querying version for table dialog_vars
> Feb 20 16:43:59 sipproxy /usr/local/sbin/kamailio[11705]: ERROR: dialog [dlg_db_handler.c:153]: error during dialog-vars version check.
> Feb 20 16:43:59 sipproxy /usr/local/sbin/kamailio[11705]: ERROR: dialog [dialog.c:646]: failed to initialize the DB support
> Feb 20 16:43:59 sipproxy /usr/local/sbin/kamailio[11705]: ERROR: <core> [sr_module.c:932]: init_mod(): Error while initializing module dialog (/usr/local/lib/kamailio/modules_k/dialog.so)

[snip!]


> i realised that when i set the
>
> "modparam("dialog", "db_mode", 0)" kamailio starts fine, seems to be a problem connecting to the database.
>
>
> Does anyone know what is wrong?

Did you possibly miss to follow the upgrade guide

http://sip-router.org/wiki/install/3.1.x-to-3.2.x

particularly the part describing the changes required to the MySQL database (given that you use MySQL)

http://sip-router.org/wiki/install/3.1.x-to-3.2.x#sql_commands

?

Dialog variables were introduced in 3.2. As they are used by default once you enable db_mode, SIP-Router barks at you if missed generating the according tables. Catch up on this and you should be fine.


HTH,

--Timo