[OpenSIPS-Users] use DB_STRING as default

[Nick]

Hello

Thanks for your support.  It fixes my issue.

Nick

On 2011年12月31日 00:59, Vlad Paiu wrote:
> 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
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20111230/c6da8306/attachment.htm>