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<[email protected]> 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
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
--- modules/db_mysql/res.c 2011-12-26 19:12:01.272504013 +0200
+++ modules/db_mysql/res.c 2011-12-29 18:31:00.328503677 +0200
@@ -100,6 +100,9 @@
break;
case MYSQL_TYPE_BLOB:
+ case MYSQL_TYPE_TINY_BLOB:
+ case MYSQL_TYPE_MEDIUM_BLOB:
+ case MYSQL_TYPE_LONG_BLOB:
LM_DBG("use DB_BLOB result type\n");
RES_TYPES(_r)[col] = DB_BLOB;
break;
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
