http://forum.lowyat.net/index.php?act=Sear...lite=ridiculous
Was searching and came across this error.
This post has been edited by wodenus: Apr 18 2009, 04:52 PM
Attached thumbnail(s)
There appears to be an error in your database
There appears to be an error in your database
|
Apr 18 2009, 04:09 PM, updated 15y ago
Show posts by this member only | Post
#1
|
All Stars
14,990 posts Joined: Jan 2003 |
http://forum.lowyat.net/index.php?act=Sear...lite=ridiculous
Was searching and came across this error. This post has been edited by wodenus: Apr 18 2009, 04:52 PM Attached thumbnail(s) |
|
|
|
Apr 18 2009, 04:29 PM
Show posts by this member only | Post
#2
|
VIP
6,008 posts Joined: Jan 2003 |
Can you tell me all the search parameters?
This can happen because our search index is updated offline, so it isn't in perfect sync with the database. |
|
Apr 18 2009, 04:44 PM
Show posts by this member only | Post
#3
|
All Stars
14,990 posts Joined: Jan 2003 |
Okay screenshot attached.
|
|
Apr 18 2009, 05:12 PM
Show posts by this member only | Post
#4
|
Senior Member
7,194 posts Joined: Jun 2005 From: Sanctuary of Paradise |
mySQL query error: SELECT SQL_NO_CACHE t.*, t.posts as topic_posts, t.title as topic_title, p.pid, p.author_id, p.author_name, p.post_date, p.post, m.*, me.*
FROM ibf_topics t LEFT JOIN ibf_posts p ON (t.tid=p.topic_id AND p.new_topic=1) LEFT JOIN ibf_members m ON (m.id=p.author_id) LEFT JOIN ibf_member_extra me ON (me.id=p.author_id) WHERE t.tid IN() ORDER BY p.pid DESC LIMIT 0,25 mySQL 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 ') ORDER BY p.pid DESC LIMIT 0,25' at line 6 mySQL error code: Date: Saturday 18th 2009f April 2009 05:12:10 PM |
|
Apr 18 2009, 05:32 PM
Show posts by this member only | Post
#5
|
VIP
6,008 posts Joined: Jan 2003 |
Checked and found some code that didn't check for the case where there aren't results with that particular combo of options. Fixed, thanks.
|
|
Apr 19 2009, 02:15 PM
Show posts by this member only | Post
#6
|
VIP
6,008 posts Joined: Jan 2003 |
Oh hummm.. it's not actually fixed yet Right now if you use "search in titles" and "view results by posts", it actually searches within posts. I'll fix that.. one day. Lemme put this in the accepted feature requests.
|
|
Apr 19 2009, 03:35 PM
Show posts by this member only | Post
#7
|
VIP
2,450 posts Joined: Sep 2005 |
wK, it appears as well that new topic would not be "searchable"
|
|
Apr 16 2013, 12:01 PM
Show posts by this member only | Post
#8
|
Newbie
1 posts Joined: Apr 2013 |
hi,
i got this error since yesterday when i tried to upload picture on my thread. any information regarding this? "Server error The website encountered an error while retrieving http://forum.lowyat.net/index.php?. It may be down for maintenance or configured incorrectly. Here are some suggestions: Reload this webpage later. HTTP Error 500 (Internal Server Error): An unexpected condition was encountered while the server was attempting to fulfill the request." |
Change to: | 0.0145sec
0.19
6 queries
GZIP Disabled
Time is now: 29th March 2024 - 11:39 PM |