Welcome to Geeklog, Anonymous Tuesday, December 24 2024 @ 10:21 pm EST

Geeklog Forums

SQL error in search


Mikael

Anonymous
When I tries to search I get:
An SQL error has occurred. Please see error.log for details.

When I check the log I get:
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 '' at line 1. SQL in question: SELECT COUNT(*) FROM

I can not find the problem. Anyone?

Mikael
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
It looks like our HTML filter ate part of that error message. Please post it again, using the forum's CODE buttons or post in text mode.

bye, Dirk
 Quote

Mikael

Anonymous
Again:

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 '' at line 1. SQL in question: SELECT COUNT(*) FROM

 


Mikael
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Hmm, "SELECT COUNT(*) FROM" - that's all? That makes it hard to track down ...

Has this only started just now? What did you do before it started? Installed any plugins, for example?

bye, Dirk
 Quote

Mikael

Anonymous
Yes, that's all in the error log. I have installed the following plugins:

menu
faqman
external
multifaq
contact
mediagallery

I haven't tested the search until now. Do you know if the error can be related file such as config, lib-custom or lib-common?

Mikael
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Try disabling the plugins one by one until the error goes away.

bye, Dirk
 Quote

Mikael

Anonymous
happy
Thanks, it was the Geeklog Contact Plugin 1.0 that caused some kind of error.

Mikael
 Quote

Status: offline

ItsCurly

Forum User
Junior
Registered: 12/05/05
Posts: 24
I had the same error, thought I would check and can also confirm, that contact plugin caused the same issue with me.
 Quote

All times are EST. The time is now 10:21 pm.

  • 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