| Author |
 Topic  |
|
StephenD
Senior Member
Australia
1044 Posts |
 Posted - 17 September 2002 : 22:11:53
|
| If I perform a search for a word eg 'invoice' using any of the 3 options and then select for any date option other than 'any dates' the search fails to find any topics. Also there seems to be a black filled table header field after Last Post when 'no records found'. |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
StephenD
Senior Member
Australia
1044 Posts |
Posted - 17 September 2002 : 22:22:27
|
| Yes, I've tried most of the date selections and different words. |
 |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 17 September 2002 : 22:28:26
|
on this site search for argo
try it with all 3 options
try it with Any Date and then also try it with Since Yesterday or Since 2 Days Ago or Since 5 Days Ago
works fine for me. |
|
|
|
StephenD
Senior Member
Australia
1044 Posts |
Posted - 17 September 2002 : 22:36:57
|
| OK, it still doesn't work on mine except when I select 14 days ago... when I know there have been posts yesterday and before containing the key words. The search results then brings up the list with the topics from yesterday with the required info. If I send you the login would you care to try please? |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
StephenD
Senior Member
Australia
1044 Posts |
Posted - 17 September 2002 : 22:51:46
|
| Well, my forum is showing the right date. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 17 September 2002 : 23:25:18
|
Stephen, try adding the lines in red after the line shown, around line# 299, search.asp:
strSql3 = strSql3 & " AND (T.T_DATE > '" & DateToStr(dateadd("d", -dt, strForumTimeAdjust)) & "')"
Response.Write DateToStr(dateadd("d", -dt, strForumTimeAdjust)) & "')"
Response.End
Then try the search with one the the date intervals that's giving your problems (I've been to your site and saw that indeed something is wrong) and post whatever will be shown there.
It's late here and I'm going to bed. Surely someone will help you with this, but in the remote chance that you're still stuck, I'll help in the morning. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
StephenD
Senior Member
Australia
1044 Posts |
Posted - 17 September 2002 : 23:31:01
|
Thanks Ruirib. This is the result of the search request:
20020917132013') |
|
|
|
StephenD
Senior Member
Australia
1044 Posts |
Posted - 18 September 2002 : 00:22:05
|
I also get the following error when I hit the link for UserName Filter Configuration.
Microsoft JET Database Engine error '80040e37'
The Microsoft Jet database engine cannot find the input table or query 'NAMEFILTER'. Make sure it exists and that its name is spelled correctly.
/forum/admin_config_namefilter.asp, line 272
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 18 September 2002 : 00:39:16
|
| Is this a new install? Or an upgrade from a previous version? |
|
|
|
StephenD
Senior Member
Australia
1044 Posts |
Posted - 18 September 2002 : 00:44:27
|
| Upgrade from 3.4.01 |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 18 September 2002 : 01:03:32
|
| Did you replace all of your files with the new ones in v3.4.03 ? There were some changes that would affect the NAMEFILTER and BADWORDS tables. |
|
|
|
StephenD
Senior Member
Australia
1044 Posts |
Posted - 18 September 2002 : 01:17:35
|
| Yes, I'm sure I replaced all non graphic files. I'll try it again and see how I go. |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 18 September 2002 : 01:21:55
|
| the main one is config.asp. Just copy the strConnString from your old file and paste it into the config.asp file from v3.4.03 and then overwrite your old copy. (make sure to uncomment the strDBType in the new config.asp file as well) |
|
|
|
Topic |
|
Topic Locked
