Graverende fejl på website vist i IE - vi kan simplethen ikke løse problemet!
Hej alle sammen,Vi har et STORT problem vi ikke kan løse på vores site der står til at skulle lanceres asap.
Det er en nyt online bådmarked, og fejlen opstår konsekvent i IE browsere (primært testet på IE8) i forbindelse med resultatsiden og valg af filterfunktion (=Tilpas søgning)
Windows7: Random error message
Vista: Nærmest konsekvent
XP: Nærmest konsekvent
Se link til resultatsiden her: http://www.yachtmarket24.com/result_sail.php
Håber nogle kan hjælpe os på rette vej ;-)
Fejlmelding:
Database error: Invalid SQL: SELECT boats.*, login.type AS loginType FROM boats LEFT JOIN login ON boats.loginID = login.id WHERE boats.boatCategoryID = 2 and boats.boatAddStatusID = 1 and boats.loginID != 0 AND ( (boats.price >= 0 and boats.currencyID=1) OR (boats.price >= 0 and boats.currencyID=2) OR (boats.price >= 0 and boats.currencyID=3) OR (boats.price >= 0 and boats.currencyID=4) OR (boats.price >= 0 and boats.currencyID=5)) AND boatTypeID in (11) AND (1!=1 (length>0 and length <= 6) OR (length > 10 and length <= 12) OR (length > 12 and length <= 15)) AND boatRiggingID in (2) ORDER BY boatAddTypeID in(6,3) DESC, boats.priceEUR DESC LIMIT 0, 25
SQL Error: 1064 (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 '(length>0 and length <= 6) OR (length > 10 and length <= 12) OR (length > 12 and' at line 1)
Session halted.
