11-21-2005, 05:40 PM
Advanced Search is disabled if you enter a text query. For example, when I searched "eye", it produced the following SQL error:
Thank you for your time.
Quote:Database error in IDB:
Invalid SQL - Query: SELECT id, weap_name, comment_count, cache from battlepedia as bd LEFT JOIN bd_cache as c ON bd.id = c.weaponid WHERE ((length(replace(att, "earth", "!!!!!!")) - length(att))) >=0 AND ((length(replace(att, "water", "!!!!!!")) - length(att))) >=0 AND ((length(replace(att, "dark", "!!!!!")) - length(att))) >=0 AND ((length(replace(att, "light", "!!!!!!")) - length(att))) >=0 AND ((length(replace(att, "air", "!!!!")) - length(att))) >=0 AND ((length(replace(att, "fire", "!!!!!")) - length(att))) >=0 AND ((length(replace(att, "physical", "!!!!!!!!!")) - length(att))) >=0 AND ((length(replace(def, "earth", "!!!!!!")) - length(def))) >=0 AND ((length(replace(def, "water", "!!!!!!")) - length(def))) >=0 AND ((length(replace(def, "dark", "!!!!!")) - length(def))) >=0 AND ((length(replace(def, "light", "!!!!!!")) - length(def))) >=0 AND ((length(replace(def, "air", "!!!!")) - length(def))) >=0 AND ((length(replace(def, "fire", "!!!!!")) - length(def))) >=0 AND ((length(replace(def, "physical", "!!!!!!!!!")) - length(def))) >=0 AND (swa <= eye AND swa > '0') AND reli = '6' ORDER BY weap_name,id LIMIT 25
mySQL error: Unknown column 'eye' in 'where clause'
Time of error: Nov 21, 2005 7:37:59
Script: /index.php?searchtype=page&page=advsearch
Debug messages:
Thank you for your time.