|
|
Joined: Mar 2008
Posts: 15
stranger
|
stranger
Joined: Mar 2008
Posts: 15 |
Hi! After the Upgrade to 6.5.5. the search doesn´t work. This is the Error message: Script: /www/htdocs/w0093949/gefahrgutforen/ubbthreads/dosearch.php Line#: 572 SQL 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 '' at line 13 SQL Error #: 1064 Query: SELECT B_Number FROM w3t_Posts WHERE B_Approved = 'yes' AND B_Status <> 'M' AND B_Board IN ('imdgdeutsch','adrrid','praxis','austria','kontroll','Werbung','Luft','test','technik','familie','events','abfall') AND B_Posted > '1210757920' AND ( (B_Subject LIKE '%adr%' OR B_Body LIKE '%adr%')) ORDER BY B_Posted DESC LIMIT It´s an issue with the database but I do not really understand what is exactly wrong....
|
|
|
|
Joined: Dec 2003
Posts: 1,796
Pooh-Bah
|
Pooh-Bah
Joined: Dec 2003
Posts: 1,796 |
It sounds like either a corrupted file (you might try and re-upload search-related /scripts and /templates) or your version of MySQL - is your MySQL at at least version 4?
|
|
|
|
Joined: Mar 2008
Posts: 15
stranger
|
stranger
Joined: Mar 2008
Posts: 15 |
Yes, the Version of the Server is 4.0.25 - so it should be work. You mean the script "dosearch.php" is corrupt and also the "dosearch.tmpl" ???? Or should be some more related files??
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
It looks like the limit is missing, the query ends with:
ORDER BY B_Posted DESC LIMIT
You should check the Search settings in the control panel and make sure there is a maximum results per search setting.
|
|
|
|
Joined: Mar 2008
Posts: 15
stranger
|
stranger
Joined: Mar 2008
Posts: 15 |
Great!!!! Now it works!!!! A small setting with a big effect. Thanks!
|
|
|
0 members (),
502
guests, and
159
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|
|