[Devel] Re: [Users] The lcr module has incorrect syntax for the current mysql release

[Klaus Darilion]

Maybe the ' is part of the substituted string? Brandon, just log the URI 
and watch in syslog if the URI is plain or enclosed with ''.

regards
klaus

Juha Heinanen wrote:
> Brandon Price writes:
> 
>  > q_len = snprintf(query, MAX_QUERY_SIZE, "SELECT %.*s.%.*s, %.*s.%.*s,  
>  > %.*s.%.*s, %.*s.%.*s, %.*s.%.*s, %.*s.%.*s FROM %.*s, %.*s WHERE %.*s  
>  > LIKE %.*s.%.*s AND '%.*s' LIKE CONCAT(%.*s.%.*s, '%%') AND %.*s.%.*s  
>  > = %.*s.%.*s ORDER BY CHAR_LENGTH(%.*s.%.*s), %.*s.%.*s DESC, RAND()",
>  > 
>  > and it works. Notice I removed the ''s after WHERE.
> 
> if there is a problem, it must be in mysql client library, not lcr
> module.  on the other hand, i don't understand why you didn't need to
> remove the quotes also from arround AND '%.*s' LIKE.
> 
> -- juha
> 
> _______________________________________________
> Users mailing list
> Users at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users