Bug Reports If you've seen a problem on the site, let us know here! (non-member posting allowed) |
|
18th April 2011, 19:32
|
#1
|
Saxperience Post Whore
Join Date: Dec 2006
Location: Maidstone
Posts: 8,210
Car(s): Golf TDI
|
Database error when searching?
Hello
Never had it before but I don't seem to be able to search as of about 7:30 tonight:
Quote:
Database Error Database error
The Saxperience - Citroen Saxo Forum database has encountered a problem.
Please try the following:
Load the page again by clicking the Refresh button in your web browser.
Open the www.saxperience.com home page, then try to open another page.
Click the Back button to try another link.
The www.saxperience.com forum technical staff have been notified of the error, though you may contact them if the problem persists.
We apologise for any inconvenience.
|
Tried a reboot
|
|
|
18th April 2011, 19:33
|
#2
|
Saxperience Post Whore
Join Date: Dec 2006
Location: Maidstone
Posts: 8,210
Car(s): Golf TDI
|
Actually it only seems to be when I search for the word VTR and have titles only selected
Maybe too broad a search?
|
|
|
18th April 2011, 19:51
|
#3
|
Saxperience Post Whore
Join Date: Mar 2008
Posts: 5,127
|
Same thing happens for me, wierd. Dont think too broad of a search would fail, the search results would just be limited (to i think 10 pages).
|
|
|
19th April 2011, 10:55
|
#4
|
Administrator
Join Date: Dec 2002
Location: Warrington
Posts: 20,551
Car(s): Blue Saxo VTS Turbo/White Megane F1 R26
|
Too broad a search takes a LONG time to search millions of posts and will eventually time out.
|
|
|
19th April 2011, 12:50
|
#5
|
Saxperience Post Whore
Join Date: Dec 2006
Location: Maidstone
Posts: 8,210
Car(s): Golf TDI
|
Ahh that makes sense, it times out after about 3-4 seconds so I suppose the database just knows that it's not capable of finding the results and just flags up the error straight away to indicate that
|
|
|
19th April 2011, 13:54
|
#6
|
Administrator
Join Date: Dec 2002
Location: Warrington
Posts: 20,551
Car(s): Blue Saxo VTS Turbo/White Megane F1 R26
|
I'll see if the DB can be edited to give sensible results, whilst not effecting performance on general searches like this... later.
There are too many threads/posts which contain the word 'vtr', which is causing the problem.
|
|
|
19th April 2011, 19:37
|
#7
|
Saxperience Post Whore
Join Date: Dec 2006
Location: Maidstone
Posts: 8,210
Car(s): Golf TDI
|
Makes sense, not the end of the world Simo as I doubt I will need to search that broad again. Thought something was wrong at first
|
|
|
Thread Tools |
|
Display Modes |
Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT. The time now is 12:20.
|