Hello,

the solution with deleting my.cnf is quite strange, I would say. Perhaps it has to do with type auto-conversion in mysql, my.cnf was probably setting a strict rule on that.

The db_extra columns should be defined as varchar - kamailio is writing the values as string.

Cheers,
Daniel

On 17/02/15 15:13, Uri Shacked wrote:

Hi again,

I remembered :-) but do not really understand why it works...

Deleting the my.cnf from /etc (or from /usr) did the job.

The acc db_extra works.

On Tue, Feb 17, 2015 at 2:09 PM, Uri Shacked <ushacked@gmail.com> wrote:

Hi,

It is my second time upgrading kamailio to 4.2.X.

Everything is working except the acc db_extra inserts.

I keep on getting that error:

ERROR: db_mysql [km_dbase.c:123]: db_mysql_submit_query(): driver error on query: Incorrect integer value: '' for column XXXXXXX

I must confess, I managed to solve the problem once. But I do not remember how :-(.

The XXXXXX column is set as an integer with NULL enabled and no default value (which works on the kamailio server where i fixed it...)

Any ideas of where it comes from?

BR,

Uri
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

-- 
Daniel-Constantin Mierla
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio World Conference, May 27-29, 2015
Berlin, Germany - http://www.kamailioworld.com