| Error |
There seems to have been a slight problem with the database.
Please try again by pressing the refresh button in your browser. mysql error number: 1064
Date: Friday 09th 2009f January 2009 05:48:12 AM
Script: /carib/caribbean.php/Terms::Caribbean+Vacations/Range::All/howmuch::ALL/
Referer:
Database error:
Invalid SQL:
SELECT SQL_CALC_FOUND_ROWS iweb_hyperseek_links.*,
iweb_hyperseek_keys.keyword as bidded_term,
iweb_hyperseek_keys.bid_price,
( iweb_hyperseek_keys.bid_price + 300 ) as score,
last_modified
FROM iweb_hyperseek_links, iweb_hyperseek_keys
WHERE
( iweb_hyperseek_keys.keyword = 'Caribbean Vacations' OR iweb_hyperseek_keys.metaphone = 'KRBNFKXNS' )
AND iweb_hyperseek_keys.bid_price > 0.00
AND iweb_hyperseek_keys.zone =''
AND iweb_hyperseek_links.category IN(ALL)
AND iweb_hyperseek_keys.id = iweb_hyperseek_links.id
UNION
SELECT iweb_hyperseek_links.*,
'' as bidded_term,
'0.00' as bid_price,
( MATCH(title,description,keywords,field1) AGAINST ( 'Caribbean Vacations or ("Caribbean Vacations")' ) + 50 ) AS score,
'' as last_modified
FROM iweb_hyperseek_links
WHERE MATCH(title,description,keywords,field1) AGAINST ( 'Caribbean Vacations or ("Caribbean Vacations")' IN BOOLEAN MODE )
AND iweb_hyperseek_links.category IN(ALL)
ORDER BY score DESC, last_modified ASC LIMIT 0,20
mysql error: 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 'ALL)
A' at line 11
|