| Author |
 Topic  |
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
|
Etymon
Advanced Member
United States
2385 Posts |
 Posted - 21 May 2003 : 16:00:11
|
Thank you OneWayMule! A delightful MOD which will make life easier for many!
Etymon
|
 |
|
|
Heynow
Junior Member
374 Posts |
|
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 21 May 2003 : 16:31:49
|
Small typo in the readme.html file.
Line 208
<button type="button" onClick="javascript:this.form.t13.focus();this.form.13.select();">Select All</button><br />
should be:
<button type="button" onClick="javascript:this.form.t13.focus();this.form.t13.select();">Select All</button><br />
|
|
|
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 21 May 2003 : 16:36:52
|
Request:
Might there be a way that on search.asp that there could be a drop down called My Recent Searches and in the drop down would be the list of recent searches by that member? That might be a separate MOD however.
Just a thought. Definitley still appreciate the MOD!
Etymon
|
Edited by - Etymon on 21 May 2003 16:38:21 |
|
|
|
DavidRhodes
Senior Member
United Kingdom
1222 Posts |
Posted - 21 May 2003 : 16:40:31
|
error using SQL Server
Microsoft OLE DB Provider for SQL Server (0x80040E14)
The text, ntext, and image data types cannot be used in an ORDER BY clause.
/forum/searchlog.asp, line 557 |
The UK MkIVs Forum |
|
|
|
DavidRhodes
Senior Member
United Kingdom
1222 Posts |
Posted - 21 May 2003 : 16:45:19
|
| inc_searchlog.asp is missing from the zip |
The UK MkIVs Forum |
|
|
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 21 May 2003 : 18:24:06
|
Yes,
if CInt(strSLDoLog) = 1 then
Call AddSearchToDB()
Call AddKeywordsToDB()
Call AddQueriesToDB()
end if
is ineffective in search.asp ... needing inc_searchlog.asp
Looking good though!
|
|
|
|
scorpswolle
Starting Member
39 Posts |
Posted - 21 May 2003 : 18:40:47
|
| missing inc_searchlog.asp too!!! |
|
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
|
DavidRhodes
Senior Member
United Kingdom
1222 Posts |
Posted - 22 May 2003 : 10:36:26
|
got this error using the dbs upgrade on sql server
quote:
MOD: Search Log Upgrade v1.0 -> v1.0.1
Adding Column SLS_QUERY...
ALTER TABLE FORUM_SEARCHLOG_SEARCHES ALTER COLUMN SLS_QUERY nvarchar (255) NULL
ALTER TABLE FORUM_SEARCHLOG_SEARCHES ALTER COLUMN SLS_QUERY nvarchar (255) NULL
-2147217900 | Cannot alter column 'SLS_QUERY' because it is 'ntext'.
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_SEARCHLOG_QUERIES( ALTER#SLQ_QUERY#VARCHAR (255)#NULL# int IDENTITY (1, 1) PRIMARY KEY NOT NULL )
Creating table(s)...
CREATE TABLE FORUM_SEARCHLOG_KEYWORDS( SLK_KEYWORD#VARCHAR (255)#NULL# int IDENTITY (1, 1) PRIMARY KEY NOT NULL )
If there were errors please post a question in the MOD Implementation Forum at
Snitz Forums
|
The UK MkIVs Forum |
|
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
|
DavidRhodes
Senior Member
United Kingdom
1222 Posts |
Posted - 22 May 2003 : 10:52:01
|
| Cheers, functionality all ok now, just missing "button_search.gif" from the zip. |
The UK MkIVs Forum |
|
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 22 May 2003 : 22:55:54
|
Hi OneWayMule,
Could you please start a topic in the Help: MOD Implementation for this MOD? I have a couple of questions to ask.
Thanks,
Etymon
|
|
|
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 23 May 2003 : 05:26:26
|
Finally found the problem.
In the dbs_searchlog.asp and the dbs_searchlog2.asp files, I found an error in the Data Type field.
SEARCHLOG_SEARCHES
SLS_ID
SLS_QUERY#varchar (255)#NULL#
SLS_DATE#varchar (14)#NULL#
SLS_MEMBER#int#NULL#
SLS_METHOD#int#NULL#
SLS_FORUM#int#NULL#
SLS_IN#int#NULL#
SLS_ARCHIVE#int#NULL#
SLS_SEARCHDATE#int#NULL
SLS_BYMEMBER#int#NULL#
[END]
Should be:
SEARCHLOG_SEARCHES
SLS_ID
SLS_QUERY#varchar (255)#NULL#
SLS_DATE#varchar (14)#NULL#
SLS_MEMBER#int#NULL#
SLS_METHOD#varchar (10)#NULL#
SLS_FORUM#int#NULL#
SLS_IN#int#NULL#
SLS_ARCHIVE#int#NULL#
SLS_SEARCHDATE#int#NULL
SLS_BYMEMBER#int#NULL#
[END]
I think the three options for the ( ) value in varchar could be:
and = (3)
or = (2)
phrase = (6)
but I placed (10) just to be safe. 
NOTE: I am using Snitz 3.3.05, so perhaps for Snitz 3.4.03 the SLS_METHOD could work fine with the Data Type as int. I'm not sure how the search.asp is setup for 3.4.03.
I had to make several code modifications for this to work on 3.3.05, but this Data Type error may be of significance to 3.4.03 users.
Thanks again for the MOD OneWayMule! It's been a lot of fun installing and will help my users greatly.
Cheers,
Etymon
|
|
|
|
Topic |
|
Topic Locked
)
- too bad I can't test on SQL Server 