Welcome to Geeklog, Anonymous Saturday, December 21 2024 @ 10:41 am EST
Geeklog Forums
An SQL error has occurred
Status: offline
::Ben
Forum User
Full Member
Registered: 01/14/05
Posts: 1569
Location:la rochelle, France
When I try to make an advanced search on or on a Geeklog site : An SQL error has occurred.
Please see your error.log for details.
May be a bug.
::Ben
I'm available to customise your themes or plugins for your Geeklog CMS
Text Formatted Code
'WHERE id=1' at line 1Text Formatted Code
'A'Please see your error.log for details.
May be a bug.
::Ben
I'm available to customise your themes or plugins for your Geeklog CMS
11
9
Quote
Status: offline
Dirk
Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
It's a bug in the forum:
Try it on a site without the forum plugin ...
bye, Dirk
Text Formatted Code
1064: 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 'A'%' OR subject LIKE '%'A'%') ORDER BY date DESC LIMIT 0,10' at. SQL in question: SELECT id,name,forum,date,subject,comment,views,uid FROM forum_topic WHERE (comment LIKE '%'A'%' OR subject LIKE '%'A'%') ORDER BY date DESC LIMIT 0,10Try it on a site without the forum plugin ...
bye, Dirk
11
12
Quote
ironmax
Anonymous
Quote by: cordisteWhen I try to make an advanced search on or on a Geeklog site : An SQL error has occurred.
Please see your error.log for details.
May be a bug.
::Ben
Text Formatted Code
'WHERE id=1' at line 1Text Formatted Code
'A'Please see your error.log for details.
May be a bug.
::Ben
I know this is not much of a work-around but this will work changing your input searches to include a backslash before the apostrophe like below.
Text Formatted Code
\'A\'
12
11
Quote
All times are EST. The time is now 10:41 am.
- Normal Topic
- Sticky Topic
- Locked Topic
- New Post
- Sticky Topic W/ New Post
- Locked Topic W/ New Post
- View Anonymous Posts
- Able to post
- Filtered HTML Allowed
- Censored Content