| Author |
 Topic  |
|
|
crash
Advanced Member
Netherlands
2064 Posts |
 Posted - 22 April 2002 : 15:14:24
|
when someone is viewing an archived topic, it shows this error on the active_users.asp page:
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'TOPIC_ID==106'.
/active_users.asp, line 477
i updated the file with the update Nathan posted about the "ARCHIVEVIEW" bit (the three-places-update) but ow i get the above...
please help!
Crash's Site | Crash is from 
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 22 April 2002 : 15:21:58
|
Crash,
looks like an extra '=' is being added to the SQL statement. Can't you detect where the SQL statement is being generated and remove the '=' character?
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
 |
|
|
crash
Advanced Member
Netherlands
2064 Posts |
Posted - 22 April 2002 : 15:27:20
|
Ruirib, i already checked for that and there isn't an extra '=' in the SQL statement...
Crash's Site | Crash is from
|
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
|
|
crash
Advanced Member
Netherlands
2064 Posts |
Posted - 22 April 2002 : 18:34:43
|
yes. everytime a member, including admin/moderators, look at a topic that has been archived, the error appears. i believe there is a minor glitch in the "ARCHIVEDVIEW" patch you suggested...
if analyzeQuery(strQuery, "ARCHIVEVIEW") = "True" then
i'm not feeling too good about the "analyzeQuery" bit...
Crash's Site | Crash is from
|
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 22 April 2002 : 19:28:13
|
Well no wonder, snitz has a little bug on line 758 of topic.asp. The part in the strin should just be ARCHIVE= not ARCHIVEVIEW=
So therefor all three of those if analyzeQuery(strQuery, "ARCHIVEVIEW") = "True" then should really be if analyzeQuery(strQuery, "ARCHIVE") = "True" then
Ok, I think I've got it worked out now.
if analyzeQuery(strQuery, "ARCHIVEVIEW") = "True" then
needs to be
strQuery = fQuery
if lcase(analyzeQuery(strQuery, "ARCHIVE")) = "true" then
 Nathan Bales
Snitz Exchange | Do's and Dont's
Edited by - Nathan on 22 April 2002 19:34:14 |
|
|
|
crash
Advanced Member
Netherlands
2064 Posts |
Posted - 22 April 2002 : 19:30:10
|
i figured that out too, but it resulted in the same error... hold on... i am not sure i had refreshed my browser... will check tomorrow
Crash's Site | Crash is from
|
|
|
|
crash
Advanced Member
Netherlands
2064 Posts |
Posted - 23 April 2002 : 00:45:45
|
yes! that did it! great one Nathan! Thanks!
Crash's Site | Crash is from
|
|
|
| |
Topic |
|
Topic Locked
