Welcome Guest ( Log In | Register )

Outline · [ Standard ] · Linear+

 There appears to be an error in your database

views
     
TSwodenus
post Apr 18 2009, 04:09 PM, updated 15y ago

Tree Octopus
********
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)
Attached Image
wKkaY
post Apr 18 2009, 04:29 PM

misutā supākoru
Group Icon
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.
TSwodenus
post Apr 18 2009, 04:44 PM

Tree Octopus
********
All Stars
14,990 posts

Joined: Jan 2003
Okay screenshot attached.
happy4ever
post Apr 18 2009, 05:12 PM

(✿◠‿◠) Queen of Love ⎝⏠⏝⏠⎠
*******
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
wKkaY
post Apr 18 2009, 05:32 PM

misutā supākoru
Group Icon
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.
wKkaY
post Apr 19 2009, 02:15 PM

misutā supākoru
Group Icon
VIP
6,008 posts

Joined: Jan 2003
Oh hummm.. it's not actually fixed yet smile.gif 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.
stevanistelrooy
post Apr 19 2009, 03:35 PM

Ten seconds you won't believe what's gonna happen.
Group Icon
VIP
2,450 posts

Joined: Sep 2005
wK, it appears as well that new topic would not be "searchable"
hexplacer
post Apr 16 2013, 12:01 PM

New Member
*
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."

rclxub.gif

 

Change to:
| Lo-Fi Version
0.0137sec    0.24    6 queries    GZIP Disabled
Time is now: 29th March 2024 - 02:15 PM