<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Hello <br>
<br>
Thanks for your support. It fixes my issue.<br>
<br>
Nick<br>
<br>
On 2011年12月31日 00:59, Vlad Paiu wrote:
<blockquote cite="mid:4EFDEE01.7030103@opensips.org" type="cite">Hi,
<br>
<br>
This is really strange, can't really see why your server is
returning a varchar column as a blob.
<br>
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.
<br>
<br>
Regards,
<br>
Vlad
<br>
<br>
Pe 12/28/2011 3:36 AM, Nick a scris:
<br>
<blockquote type="cite">Hello
<br>
<br>
err_code column type is varchar(100), not BLOB.
<br>
How can i do fix this problem??
<br>
<br>
Thanks
<br>
<br>
Nick
<br>
<br>
<br>
<br>
On 2011年12月28日 05:21, Vlad Paiu wrote:
<br>
<blockquote type="cite">Hello,
<br>
<br>
Is err_code column of type long blob ?
<br>
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.
<br>
<br>
Should be an easy fix, but first please confirm the err_code
column type in the DB.
<br>
<br>
Regards,
<br>
Vlad
<br>
<br>
Nick<a class="moz-txt-link-rfc2396E" href="mailto:nick_chang@ezmobo.com"><nick_chang@ezmobo.com></a> wrote:
<br>
<br>
<blockquote type="cite">Hello
<br>
<br>
My Opensips Server versions is 1.7.1.
<br>
MySQL Version is 5.1.
<br>
<br>
I have create some table for my project. But I get this
error.
<br>
WARNING:db_mysql:db_mysql_get_columns: unhandled data type
column
<br>
(err_code) type id (251), use DB_STRING as default
<br>
<br>
If I downgrade mysql version to 5.0.
<br>
I can't get this error.
<br>
<br>
Can everyone give me a suggestion??
<br>
<br>
Thanks
<br>
<br>
<br>
<br>
_______________________________________________
<br>
Users mailing list
<br>
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<br>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
<br>
</blockquote>
_______________________________________________
<br>
Users mailing list
<br>
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<br>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
<br>
<br>
</blockquote>
<br>
<br>
_______________________________________________
<br>
Users mailing list
<br>
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<br>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
<br>
</blockquote>
<br>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
</body>
</html>