[SR-Users] acc db_extra problem

[Daniel-Constantin Mierla]

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 at gmail.com
> <mailto:ushacked at 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 at 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20150219/646c950c/attachment.html>