News:

SMF 2.1.4 has been released! Take it for a spin! Read more.

Main Menu

Error with Search function in 2.0

Started by shorepower, June 19, 2011, 03:10:24 PM

Previous topic - Next topic

shorepower

After moving to 2.0 (see thread http://www.simplemachines.org/community/index.php?topic=438311.0) search are no longer working.

Any help appreciated. The following error is displayed.

http://www.xxx.yy/index.php?action=search2
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 '' at line 5
File: /www/webvol1/le/6vbqwak4dlpmvqx/xxx.yy/public_html/Sources/Search.php
Line: 1687


Installation:

Version Information:
Forum version: SMF 2.0 (more detailed)
Current SMF version: SMF 2.0
GD version: bundled (2.0.34 compatible)
MySQL version: 5.1.55
PHP: 5.3.3
Server version: Apache/2.2.17 (FreeBSD) PHP/5.3.3 with Suhosin-Patch mod_ssl/2.2.17 OpenSSL/0.9.8n


Also, System is set up with UTF-8
Ἐν οἴνῳ ἀλήθεια -- www.finewines.se

Kermit

Your Search.php file seems ok,me is not so sure but it can be something with search indexes
My Mods
Please don't PM/mail me for support,unless i invite you
Formerly known as Duncan85
Quote
"Two things are infinite: the universe and human stupidity; and I'm not sure about the the universe."

A. Einstein

Advertisement: