Hi,
It seems at the moment I have managed to get rid of most forum errors, however there is one that I don't know how important it is but I wish to get rid of it too.
Can you explain and maybe advice how to fix it. Is it the forum or the MYSQL that needs adjustments?
/Thanks
Search word seems to be "Air" in this case
Script: /xxxxxx/xxxxx/xxxxx/forums/scripts/dosearch.inc.php - Line: 577
SELECT p.POST_ID
FROM ubbt_bbfPOSTS p LEFT JOIN ubbt_bbfPOSTS pp on p.POST_ID=pp.POST_ID,
ubbt_bbfTOPICS t
WHERE p.POST_IS_APPROVED = '1'
AND t.TOPIC_STATUS <> 'M'
AND t.FORUM_ID IN ('1','2','4','31')
AND p.TOPIC_ID = t.TOPIC_ID
AND ( p.POST_DEFAULT_BODY LIKE '%Air%'))
AND p.POST_POSTED_TIME > '1375285983'
AND p.POST_POSTED_TIME < '1375285983'
ORDER BY p.POST_POSTED_TIME DESC
LIMIT 200 - 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 ')
AND p.POST_POSTED_TIME > '1375285983'
AND p.POST_POSTED_TIME < '1375285' at line 8
