75ZT Community

every time I do a search I get this error ...

cut n pasted ..
------------
General Error
SQL ERROR [ mysql4 ]

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 LCASE(f.forum_desc) LIKE '%mirror%' AND )) OR (( AND LCASE(f.forum_name) LIK' at line 4 [1064]

SQL

SELECT f.forum_id, f.forum_parents, f.parent_id, f.forum_name, f.forum_desc, f.forum_posts, f.forum_link, f.forum_image FROM phpbb_forums f WHERE f.forum_type = 2 AND f.parent_id > 0 AND ((( AND LCASE(f.forum_desc) LIKE '%mirror%' AND )) OR (( AND LCASE(f.forum_name) LIKE '%mirror%' AND ))) AND f.forum_id NOT IN (4, 31, 35) ORDER BY f.forum_name ASC

BACKTRACE

FILE: [ROOT]/includes/db/mysql.php
LINE: 175
CALL: dbal->sql_error()

FILE: [ROOT]/includes/template.php(230) : eval()'d code
LINE: 56
CALL: dbal_mysql->sql_query()

FILE: [ROOT]/includes/template.php
LINE: 230
CALL: eval()

FILE: [ROOT]/includes/functions.php
LINE: 5062
CALL: template->display()

FILE: [ROOT]/search.php
LINE: 1148
CALL: page_footer()
-----------end ---------------------

Chris..

Oower, I can't reproduce this or any other error. Will you please PM me with the exact search parameters you are entering. Preferably with a screen shot of the entry so I can try to reproduce it.
Anybody else getting this?

Thanks.

Working OK for me when I searched for 'search'. IE 9 on win 7.

I've picked up on this too and investigating. It seems the error occurs when selecting "Search for any terms" as opposed to "Search for all terms or use query as entered" when performing a search.

Well done Simon. Thought I tried that but must have missed. It produces the error for me now. If you look at the recent searches list you can see the word "mirror" is enclosed in brackets. Looks like the extra characters are being added before the search is performed.
I'll have a play as well.

If you search for (mirror) it produces the error when the search is set for "Search for all terms or use query as entered"

Interestingly, search is working fine for me and I am clinging on to IE7......

We have been able to duplicate this error and diagnosed the fault. Simon is working on the solution which is rather complex and make take a little time. The particular part of his bespoke search programming which causes this error will be disabled until the solution has been implemented. Therefore you should not see the error again.

If in the event this error re-occurs when doing a search you should for the moment restrict searches to using the "Search for all terms or use query as entered" option. You will still find what you are looking for, just a few more results will appear than would if the "Search for any terms" option is selected.



Thank you for your patience.

The only time I find this message is when I visit this page?

Mike

You'll be pleased to know that a solution has been implemented and some changes are afoot!

We are currently reconsolidating the How-To listings as these were causing the problems with the search function as noted above. Luckily the solution has brought with it improvements on the forum and is likely to yield better results in finding a PDF when searching for keywords.