[OpenSIPS-Users] use DB_STRING as default

Vlad Paiu vladpaiu at opensips.org
Fri Dec 30 17:59:45 CET 2011


Hi,

This is really strange, can't really see why your server is returning a 
varchar column as a blob.
Please apply the attached patch ( run 'patch -p0 < db_mysql.patch' from 
the root of OpenSIPS sources ), recompile everything and see if it fixes 
your issue.

Regards,
Vlad

Pe 12/28/2011 3:36 AM, Nick a scris:
> Hello
>
> err_code column type is varchar(100), not BLOB.
> How can i do fix this problem??
>
> Thanks
>
> Nick
>
>
>
> On 2011年12月28日 05:21, Vlad Paiu wrote:
>> Hello,
>>
>> Is err_code column of type long blob ?
>> I see that in the mysql lib, 251 is MYSQL_TYPE_LONG_BLOB, which 
>> should be mapped in OpenSIPS to DB_BLOB, but it's currently missing.
>>
>> Should be an easy fix, but first please confirm the err_code column 
>> type in the DB.
>>
>> Regards,
>> Vlad
>>
>> Nick<nick_chang at ezmobo.com>  wrote:
>>
>>> Hello
>>>
>>> My Opensips Server versions is 1.7.1.
>>> MySQL Version is 5.1.
>>>
>>> I have create some table for my project. But I get this error.
>>> WARNING:db_mysql:db_mysql_get_columns: unhandled data type column
>>> (err_code) type id (251), use DB_STRING as default
>>>
>>> If I downgrade mysql version to 5.0.
>>> I can't get this error.
>>>
>>> Can everyone give me a suggestion??
>>>
>>> Thanks
>>>
>>>
>>>
>>> _______________________________________________
>>> Users mailing list
>>> Users at lists.opensips.org
>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>> _______________________________________________
>> Users mailing list
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users

-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: db_mysql.patch
URL: <http://lists.opensips.org/pipermail/users/attachments/20111230/eef3ed19/attachment.asc>


More information about the Users mailing list