Author |
Topic ![Next Topic Next Topic](images/icon_go_right.gif) |
OneWayMule
Dev. Team Member & Support Moderator
![](images/icon_star_bronze.gif) ![](images/icon_star_bronze.gif) ![](images/icon_star_bronze.gif) ![](images/icon_star_bronze.gif) ![](images/icon_star_bronze.gif)
Austria
4969 Posts |
|
Etymon
Advanced Member
![](images/icon_star_silver.gif) ![](images/icon_star_silver.gif) ![](images/icon_star_silver.gif) ![](images/icon_star_silver.gif) ![](images/icon_star_silver.gif)
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
|
![Go to Top of Page Go to Top of Page](images/icon_go_up.gif) |
|
Heynow
Junior Member
![](images/icon_star_cyan.gif) ![](images/icon_star_cyan.gif)
374 Posts |
|
Etymon
Advanced Member
![](images/icon_star_silver.gif) ![](images/icon_star_silver.gif) ![](images/icon_star_silver.gif) ![](images/icon_star_silver.gif) ![](images/icon_star_silver.gif)
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 />
|
![Go to Top of Page Go to Top of Page](images/icon_go_up.gif) |
|
Etymon
Advanced Member
![](images/icon_star_silver.gif) ![](images/icon_star_silver.gif) ![](images/icon_star_silver.gif) ![](images/icon_star_silver.gif) ![](images/icon_star_silver.gif)
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 |
![Go to Top of Page Go to Top of Page](images/icon_go_up.gif) |
|
DavidRhodes
Senior Member
![](images/icon_star_purple.gif) ![](images/icon_star_purple.gif) ![](images/icon_star_purple.gif) ![](images/icon_star_purple.gif)
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 |
![Go to Top of Page Go to Top of Page](images/icon_go_up.gif) |
|
DavidRhodes
Senior Member
![](images/icon_star_purple.gif) ![](images/icon_star_purple.gif) ![](images/icon_star_purple.gif) ![](images/icon_star_purple.gif)
United Kingdom
1222 Posts |
Posted - 21 May 2003 : 16:45:19
|
inc_searchlog.asp is missing from the zip |
The UK MkIVs Forum |
![Go to Top of Page Go to Top of Page](images/icon_go_up.gif) |
|
Etymon
Advanced Member
![](images/icon_star_silver.gif) ![](images/icon_star_silver.gif) ![](images/icon_star_silver.gif) ![](images/icon_star_silver.gif) ![](images/icon_star_silver.gif)
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!
|
![Go to Top of Page Go to Top of Page](images/icon_go_up.gif) |
|
scorpswolle
Starting Member
39 Posts |
Posted - 21 May 2003 : 18:40:47
|
missing inc_searchlog.asp too!!! |
![Go to Top of Page Go to Top of Page](images/icon_go_up.gif) |
|
OneWayMule
Dev. Team Member & Support Moderator
![](images/icon_star_bronze.gif) ![](images/icon_star_bronze.gif) ![](images/icon_star_bronze.gif) ![](images/icon_star_bronze.gif) ![](images/icon_star_bronze.gif)
Austria
4969 Posts |
|
DavidRhodes
Senior Member
![](images/icon_star_purple.gif) ![](images/icon_star_purple.gif) ![](images/icon_star_purple.gif) ![](images/icon_star_purple.gif)
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 |
![Go to Top of Page Go to Top of Page](images/icon_go_up.gif) |
|
OneWayMule
Dev. Team Member & Support Moderator
![](images/icon_star_bronze.gif) ![](images/icon_star_bronze.gif) ![](images/icon_star_bronze.gif) ![](images/icon_star_bronze.gif) ![](images/icon_star_bronze.gif)
Austria
4969 Posts |
|
DavidRhodes
Senior Member
![](images/icon_star_purple.gif) ![](images/icon_star_purple.gif) ![](images/icon_star_purple.gif) ![](images/icon_star_purple.gif)
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 |
![Go to Top of Page Go to Top of Page](images/icon_go_up.gif) |
|
OneWayMule
Dev. Team Member & Support Moderator
![](images/icon_star_bronze.gif) ![](images/icon_star_bronze.gif) ![](images/icon_star_bronze.gif) ![](images/icon_star_bronze.gif) ![](images/icon_star_bronze.gif)
Austria
4969 Posts |
|
Etymon
Advanced Member
![](images/icon_star_silver.gif) ![](images/icon_star_silver.gif) ![](images/icon_star_silver.gif) ![](images/icon_star_silver.gif) ![](images/icon_star_silver.gif)
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
|
![Go to Top of Page Go to Top of Page](images/icon_go_up.gif) |
|
Etymon
Advanced Member
![](images/icon_star_silver.gif) ![](images/icon_star_silver.gif) ![](images/icon_star_silver.gif) ![](images/icon_star_silver.gif) ![](images/icon_star_silver.gif)
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. ![](images/icon_smile_big.gif)
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
|
![Go to Top of Page Go to Top of Page](images/icon_go_up.gif) |
|
Topic ![Next Topic Next Topic](images/icon_go_right.gif) |
|