| Author |
 Topic  |
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
 Posted - 11 July 2002 : 07:56:17
|
1) Ok, will stick some monitors on it, could you make a note of the exact error next time you get one
2) NO, that would havee meant reconfiging the Snitz db which was not something I wanted to do, so it uses the standard Snitz search code, I have just redone the queeries so they are more optimised for SQL.
|
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 11 July 2002 : 08:04:43
|
quote:
1) Ok, will stick some monitors on it, could you make a note of the exact error next time you get one
2) NO, that would havee meant reconfiging the Snitz db which was not something I wanted to do, so it uses the standard Snitz search code, I have just redone the queeries so they are more optimised for SQL.
Ok on both counts. However the error is not very descriptive. Just the OLEDB Error: and and 80xxx code. Nothing more than that.
Wait..., I've managed to recreate it. Here you have the query and the error message:
No need for image to be here any longer...
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs
Edited by - ruirib on 13 July 2002 14:08:44 |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 11 July 2002 : 08:06:27
|
There is nothing in your search box ?
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 11 July 2002 : 08:12:48
|
Nope, just trying to get all the user's posts. Maybe choosing the Any Words options in this situation is the problem?
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 11 July 2002 : 08:30:25
|
err, NO, not giving it anything to search for is the problem.
You have then selected Any words, whitries to split your non existent search string into
individual words, which it can't. 'Exact phrase' would have been ok, why did you choose 'Any words' when you hadn't actually entered any ?
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 11 July 2002 : 10:59:35
|
quote:
err, NO, not giving it anything to search for is the problem.
You have then selected Any words, whitries to split your non existent search string into
individual words, which it can't. 'Exact phrase' would have been ok, why did you choose 'Any words' when you hadn't actually entered any ?
Well I really don't know. I agree it doesn't make any sense to choose the Any Words option.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 11 July 2002 : 11:03:26
|
quote:
Well I really don't know. I agree it doesn't make any sense to choose the Any Words option.
Next time I update it, I will make it default to 'Exact Phrase' if nothing is entered into the search box, then it won't try to split it into individual words.
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 11 July 2002 : 11:09:00
|
Ok . I'll let you know if that error comes up in a normal situation  .
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 11 July 2002 : 11:15:09
|
I have added a check now, will try and replace it later today.
By the way, you can also sort the grid by clicking on the column titles.
|
|
|
|
Hamlin
Advanced Member
United Kingdom
2386 Posts |
Posted - 13 July 2002 : 08:13:24
|
Just got another OLE 80040E10 error This time tho I think I know why, I had some ' in there, when i tried with out the ', it was fine.
Normally i just leave them in (with the old search) but i suppose i cant any more
He moved in a way that suggested he was attempting the world speed record for the nonchalant walk.
-- Terry Pratchett |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 13 July 2002 : 13:42:14
|
in where, it should accept ' without any probs, will investigate
|
|
|
|
Hamlin
Advanced Member
United Kingdom
2386 Posts |
Posted - 13 July 2002 : 13:57:54
|
A little more explanation
Sometimes if a user post an error message and I think I can remember a post about it I search on the error, just copy and paste it in the box, normally these errors are like contain those little ' thingys like Microsoft JET Database Engine error '80004005' (only example I can find in active topics page ), I noticed that if I leave the two ' in there I get the error, so now I just remove them…
Or am I the only one who leaves them in any way 
He moved in a way that suggested he was attempting the world speed record for the nonchalant walk.
-- Terry Pratchett
Edited by - Hamlin on 13 July 2002 14:01:00 |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 13 July 2002 : 14:07:32
|
No, you aren't the only one, I normally do aswell, I will try and post a fix later today so that it works, it was working fine initially, must have broke it in the last update.
|
|
|
|
SalmanKhana
Average Member
USA
961 Posts |
Posted - 20 July 2002 : 05:27:18
|
I got this error while using the search function above
error '80004005'
Unspecified error
/forum/search.asp, line 193
search term => Save failed
_______________________
Tribute to the best hosting company I've known so far http://www.reddi-web.com  |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 20 July 2002 : 06:06:51
|
quote:
I got this error while using the search function above
error '80004005'
Unspecified error
/forum/search.asp, line 193
search term => Save failed
_______________________
Tribute to the best hosting company I've known so far http://www.reddi-web.com
I suggest you re-read the first post in the thread, then use the correct search link.
|
|
|
|
Topic |
|
Topic Locked
