[mv] sql search error

[Andreas Kotowicz <koto@mynetix.de>]

******    message to minivend-users from Andreas Kotowicz <koto@mynetix.de>     ******

hi,

I just try to upgrade all my shops from minivend 3.12 to minivend 4.04.  in one
of my shops I use following search routine:

<INPUT TYPE="hidden" NAME="mv_searchtype" VALUE="sql">
<INPUT TYPE="hidden" NAME="mv_sql_query" VALUE="select * from products where concat(lcase(description),lcase(category)) rlike '%s'">
<INPUT TYPE="hidden" NAME="mv_matchlimit" VALUE="7">
<INPUT MAXLENGTH="30" NAME="mv_searchspec" SIZE="13" VALUE=""><BR>

with minivend 3.12 I get all results but with minivend 4.04 I get following
error message:

"there are no items of this decritpion ARRAY(0x82ddca8)."

error.log says:
/shop/search Bad SQL statement: Parse error near (lcase(description),lcase(category)) rlike '%s' at /home/mvend/lib/Vend/Scan.pm line 573.

when I look in Scan.pm I have this line.

"$stmt = SQL::Statement->new($text, $parser);"

I really don't know what the problem is.  Racke thinks, that the SQL::Statement
doesn't like lcase and rlike, but this can't be the problem. (in my opinion)

andreas

-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list