#1 ERROR WHILE USING SEARCH FUNCTION

open
nobody
None
5
2006-06-07
2006-06-07
Anonymous
No

Hi!
I installed this great tool for managing personal
movies info.
But I'm getting some issues.

First, I was able to update the movies table thru
phpMyAdmin (I was getting problems with the import
function)

But I'm not able to perform SEARCHS

I get the following error when trying to filter by
Letters (in this case, movies starting with 'h')

You have an error in your SQL syntax. Check the manual
that corresponds to your MySQL server version for the
right syntax to use near '\'h%\' ORDER BY name ASC,nr
ASC,year DESC LIMIT 0,25' at line 1

Or this error, when trying to search for string thru
the input box below.

You have an error in your SQL syntax. Check the manual
that corresponds to your MySQL server version for the
right syntax to use near '\'zatoichi\' IN BOOLEAN
MODE) ORDER BY name ASC,nr ASC,year DES

If you could send me more information about what could
be wrong, I'd really appreciate it. Thanks!

Discussion

  • Pablo Linares
    Pablo Linares
    2006-06-07

    Logged In: YES
    user_id=1536010

    Sorry, I was the one that created the request. I registered
    recently. If you have an answer, contact me @
    alphete@gmail.com
    Thanks