Aug 15 2007, 05:19 PM, updated 19y ago
I searched for some topics under 'Kopitiam' with these options :
1) Search Where - Search titles only
2) Result Type - Show results as posts
and the returned error was :
QUOTE
There appears to be an error with the database.
You can try to refresh the page by clicking here.
Error Returned
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: Wednesday 15th of August 2007 05:15:41 PM
We apologise for any inconvenience
You can try to refresh the page by clicking here.
Error Returned
CODE
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: Wednesday 15th of August 2007 05:15:41 PM
We apologise for any inconvenience
Cheers!
Quote
0.0137sec
1.06
5 queries
GZIP Disabled