[SR-Users] db_mysql errors

[Daniel-Constantin Mierla]

It seems that the value in a datetime column cannot be converted -- can
you show the result of the same query in mysql client?

Cheers,
Daniel

On 26/02/15 00:45, jaflong jaflong wrote:
> I am getting errors when I run the following code
>
>
>  if (sql_xquery("mydb", "select * from account where account = 'demo'", "res") == 1) {
>                 xlog("L_INFO", "my number: $xavp(res=>number)\n");
>         } else {
>                 xlog("L_WARN", "Connection forbidden from $si\n");
>                 sl_send_reply("403", "Forbidden");
>                 exit;
>         }
>         sql_result_free("res");
>  }
>  
>  
>  
> 10(4033) ERROR: <core> [db_ut.c:225]: db_str2time(): Error during time conversion
> 10(4033) ERROR: <core> [db_val.c:159]: db_str2val(): error while converting datetime value from string
> 10(4033) ERROR: db_mysql [km_row.c:68]: db_mysql_convert_row(): failed to convert value
> 10(4033) ERROR: db_mysql [km_res.c:190]: db_mysql_convert_rows(): error while converting row #0
> 10(4033) ERROR: db_mysql [km_res.c:219]: db_mysql_convert_result(): error while converting rows
> 10(4033) ERROR: db_mysql [km_dbase.c:252]: db_mysql_store_result(): error while converting result
> 10(4033) ERROR: <core> [db_query.c:188]: db_do_raw_query(): error while storing result10(4033) ERROR: sqlops [sql_api.c:454]: sql_exec_xquery(): cannot do the query
>  
>  
> Any help please
>
>
> _______________________________________________
> 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