AllaClone Search Exception
Posted: Tue Nov 03, 2009 2:36 am
If you add an apostrophe in your search for AllaClone ex: Champion's Badge
This error message occurs:
fullsearch.php
MYSQL_QUERY
SELECT faction_list.id,faction_list.name FROM faction_list WHERE name like '%Champion's%Badge%' ORDER BY faction_list.name,faction_list.id LIMIT 2147483648
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 's%Badge%' ORDER BY faction_list.name,faction_list.id LIMIT 214' at line 3
Have you sourced the eqbrowser tables in your database ?
This error message occurs:
fullsearch.php
MYSQL_QUERY
SELECT faction_list.id,faction_list.name FROM faction_list WHERE name like '%Champion's%Badge%' ORDER BY faction_list.name,faction_list.id LIMIT 2147483648
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 's%Badge%' ORDER BY faction_list.name,faction_list.id LIMIT 214' at line 3
Have you sourced the eqbrowser tables in your database ?