Welcome Guest ( Log In | Register )

Forum Announcement

New user registrations disabled until further notice.

Bump TopicReply to this topicRSS feed Start new topic Start Poll

Outline · [ Standard ] · Linear+

> There appears to be an error in your database

wodenus
post Apr 18 2009, 04:09 PM, updated 10y ago

Tree Octopus
********
Group: Senior Member
Posts: 14,989

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
Group: VIP
Posts: 5,885

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.
wodenus
post Apr 18 2009, 04:44 PM

Tree Octopus
********
Group: Senior Member
Posts: 14,989

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

(✿◠‿◠) Queen of Love ⎝⏠⏝⏠⎠
*******
Group: Senior Member
Posts: 7,175

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
Group: VIP
Posts: 5,885

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
Group: VIP
Posts: 5,885

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
Former Staff
Group: VIP
Posts: 2,450

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
*
Group: Newbie
Posts: 1

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

Bump TopicReply to this topicTopic OptionsStart new topic
 

Switch to:
| Lo-Fi Version
0.0634sec    4.36    6 queries    GZIP Disabled
Time is now: 21st May 2018 - 11:01 PM