| Author |
 Topic  |
|
wob
Starting Member
39 Posts |
 Posted - 16 January 2001 : 14:00:51
|
I'm so upset... I called myself checking that and trying it both ways. Apparently, I didn't check it good enough. Now I get links to mods installed with this error at the top:
quote:
Microsoft VBScript runtime error '800a003e'
Input past end of file
/snitz/mods/modCMD.asp, line 51
The area in the file is:
for each objFileItem in objFolderContents
modFile = instr(objFileItem.Name, ".mod")
if modFile <> 0 then
modFile = left(objFileItem.Name, modfile - 1)
whichfile=server.mappath(modFolder & modFile & ".mod")
Set fs = CreateObject("Scripting.FileSystemObject")
Set thisfile = fs.OpenTextFile(whichfile, 1, False)
modName = " " & thisfile.readline
modLink = thisfile.readline
if modLink = "" then
modLink = "-"
else
modLink = "<a href=""" & modLink & """>go</a>"
end if
if thisfile.readline = "false" then
modReadme = "-"
else
modReadme = "<a href=""" & modFolder & "readme.asp?readme="
modReadme = modReadme & server.urlencode(modFile) & """>view</a>"
end if
modVersion = thisfile.readline
if thisfile.AtEndOfStream then
modSetup = "-"
modAuthor = "-"
else
modSetup = thisfile.readline
if modSetup = "" then
modSetup = "-"
else
modSetup = "<a href=""" & modSetup & """>go</a>"
end if
modAuthor = thisfile.readline
end if
thisfile.Close
set fs=nothing
???
|
 |
|
|
wob
Starting Member
39 Posts |
Posted - 16 January 2001 : 14:20:08
|
HuwR,
Since the links were showing at the bottom for the mods, I ran the setup for the file attachment mod. I got this message:
0 |
0 |
-2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'int'.
-2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'int'.
-2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]The identifier that starts with 'DF_FORUM_MEMBERS_M_ALLOWUPLOAD' is too long. Maximum length is 30.
-2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]The identifier that starts with 'DF_FORUM_MEMBERS_M_DOWNLOADFIL' is too long. Maximum length is 30.
-2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]The identifier that starts with 'DF_FORUM_MEMBERS_M_DOWNLOADFIL' is too long. Maximum length is 30.
-2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]The identifier that starts with 'DF_FORUM_MEMBERS_M_DOWNLOADFIL' is too long. Maximum length is 30.
-2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]The identifier that starts with 'DF_FORUM_MEMBERS_M_DOWNLOADFIL' is too long. Maximum length is 30.
Database set-up finished..
I've checked and the attachment function seems to be working, should I be worried about this message?
|
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 16 January 2001 : 15:07:48
|
quote:
I'm so upset... I called myself checking that and trying it both ways. Apparently, I didn't check it good enough. Now I get links to mods installed with this error at the top:
quote:
Microsoft VBScript runtime error '800a003e'
Input past end of file
/snitz/mods/modCMD.asp, line 51
The area in the file is:
for each objFileItem in objFolderContents
modFile = instr(objFileItem.Name, ".mod")
if modFile <> 0 then
modFile = left(objFileItem.Name, modfile - 1)
whichfile=server.mappath(modFolder & modFile & ".mod")
Set fs = CreateObject("Scripting.FileSystemObject")
Set thisfile = fs.OpenTextFile(whichfile, 1, False)
modName = " " & thisfile.readline
modLink = thisfile.readline
if modLink = "" then
modLink = "-"
else
modLink = "<a href=""" & modLink & """>go</a>"
end if
if thisfile.readline = "false" then
modReadme = "-"
else
modReadme = "<a href=""" & modFolder & "readme.asp?readme="
modReadme = modReadme & server.urlencode(modFile) & """>view</a>"
end if
modVersion = thisfile.readline
if thisfile.AtEndOfStream then
modSetup = "-"
modAuthor = "-"
else
modSetup = thisfile.readline
if modSetup = "" then
modSetup = "-"
else
modSetup = "<a href=""" & modSetup & """>go</a>"
end if
modAuthor = thisfile.readline
end if
thisfile.Close
set fs=nothing
???
This sounds like you have a duff mod file somewhere.
'Resistance is futile' |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 16 January 2001 : 15:12:08
|
quote:
HuwR,
Since the links were showing at the bottom for the mods, I ran the setup for the file attachment mod. I got this message:
0 |
0 |
-2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'int'.
-2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'int'.
-2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]The identifier that starts with 'DF_FORUM_MEMBERS_M_ALLOWUPLOAD' is too long. Maximum length is 30.
-2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]The identifier that starts with 'DF_FORUM_MEMBERS_M_DOWNLOADFIL' is too long. Maximum length is 30.
-2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]The identifier that starts with 'DF_FORUM_MEMBERS_M_DOWNLOADFIL' is too long. Maximum length is 30.
-2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]The identifier that starts with 'DF_FORUM_MEMBERS_M_DOWNLOADFIL' is too long. Maximum length is 30.
-2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]The identifier that starts with 'DF_FORUM_MEMBERS_M_DOWNLOADFIL' is too long. Maximum length is 30.
Database set-up finished..
I've checked and the attachment function seems to be working, should I be worried about this message?
I would be a bit concerned about this, if you can, check your db, check the for the existance of M_ALLOWDOWNLOADS, also could you mail me the file that ran to do the setup, the error message is very odd.
'Resistance is futile' |
|
|
|
wob
Starting Member
39 Posts |
Posted - 16 January 2001 : 15:49:44
|
HuwR,
I sent you an email, also, I find no instances of M_ALLOWDOWNLOADS in any of my db tables. After trying to upload a file, the file gets transferred to the server correctly, but when I hit 'post new reply' it shows this message:
Microsoft VBScript runtime error '800a01b6'
Object doesn't support this property or method: 'rs2.closestrSQL'
/snitz/post_info.asp, line 620
Could these things be related ?
The code is as follows :
'#################################### file attach stuff ############
strSQL = "SELECT MAX(REPLY_ID) AS MAXID FROM " & strTablePrefix & "REPLY "
strSQL = strSQL + "WHERE TOPIC_ID = " & Request.Form("TOPIC_ID")
strSQL = strSQL + " AND R_AUTHOR = " & rs("MEMBER_ID")
set rs2 = my_Conn.Execute (strSql)
intReplyID = rs2("MAXID")
rs2.closestrSQL = "UPDATE " & strTablePrefix & "USERFILES "
strSQL = strSQL & "SET F_REPLY_ID = " & intReplyID
strSQL = strSQL & " WHERE MEMBER_ID = " & rs("MEMBER_ID")
strSQL = strSQL & " AND F_REPLY_ID = -1 AND F_TOPIC_ID =" & Request.Form("TOPIC_ID")
my_Conn.execute (strSQL)
'####################################################################
If I go to the admin section of the mod I get:
Microsoft VBScript runtime error '800a01c9'
This key is already associated with an element of this collection
/snitz/Mods/admin_fileattachment.asp, line 10
The code for the admin_fileattachment is:
<!--#INCLUDE FILE="../config.asp" -->
<!--#INCLUDE file="../inc_top_short.asp" -->
<%
Dim objDict
Set objDict = Server.CreateObject("Scripting.Dictionary")
set objRec = my_Conn.execute("SELECT * FROM " & strTablePrefix & "MODS WHERE M_NAME = 'Attachment'")
while not objRec.EOF
objDict.Add objRec.Fields.Item("m_code").Value, objRec.Fields.Item("m_value").Value
objRec.moveNext
wend
if Request.Form("Method_Type") = "Write_Configuration" then
Err_Msg = ""
if Err_Msg = "" then
I added the fields for M_ALLOWDOWNLOADS and M_ALLOWUPLOADS to my MEMBERS table, but it didn't seem to help.
Edited by - wob on 16 January 2001 18:08:10 |
|
|
|
Astro
Starting Member
11 Posts |
Posted - 16 January 2001 : 17:24:55
|
Hi,
I tryed to install that mod on the latest version of Snitz and it'is full of bugs. So my question is: Do you have a updated working version of it? If yes where can i download it?
I was on ubb before and i installed maybe 40 mods on it with no problems and at my first attempt with snitz, it look impossible to install. It is full of compilation error in the scripts in the Mods directory and when i fix a problem, and other one appear.
It is very important for me to install that on my very busy snitz board because i had a mod like that on my ubb and the members used it all the time.
Thank you!!!!
http://www.astro23.com
|
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 16 January 2001 : 20:11:25
|
quote:
Hi,
I tryed to install that mod on the latest version of Snitz and it'is full of bugs. So my question is: Do you have a updated working version of it? If yes where can i download it?
I was on ubb before and i installed maybe 40 mods on it with no problems and at my first attempt with snitz, it look impossible to install. It is full of compilation error in the scripts in the Mods directory and when i fix a problem, and other one appear.
It is very important for me to install that on my very busy snitz board because i had a mod like that on my ubb and the members used it all the time.
Thank you!!!!
http://www.astro23.com
I have it running on four forums all using sr4 without a problem.
All your errors are related to your db not having been setup. I have mailed you a new db setup file.
'Resistance is futile' |
|
|
|
mot
New Member
United Kingdom
70 Posts |
Posted - 16 January 2001 : 20:15:30
|
Is the latest DB setup file in the zip file?
|
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 16 January 2001 : 20:27:29
|
it will be in five mins.
'Resistance is futile'
Done now
Edited by - huwr on 16 January 2001 20:36:14 |
|
|
|
Astro
Starting Member
11 Posts |
Posted - 16 January 2001 : 20:37:19
|
Thank you very much...by the way i realy like your Snitz forum, he is a lot more faster than the ubb and take less place on the server. The only thing is the availability of mod is much better for ubb but i understand you are a young community and i am sure with the talent you have it will be much better in not too long time. Thank you for that great forum! quote:
quote:
Hi,
I tryed to install that mod on the latest version of Snitz and it'is full of bugs. So my question is: Do you have a updated working version of it? If yes where can i download it?
I was on ubb before and i installed maybe 40 mods on it with no problems and at my first attempt with snitz, it look impossible to install. It is full of compilation error in the scripts in the Mods directory and when i fix a problem, and other one appear.
It is very important for me to install that on my very busy snitz board because i had a mod like that on my ubb and the members used it all the time.
Thank you!!!!
http://www.astro23.com
I have it running on four forums all using sr4 without a problem.
All your errors are related to your db not having been setup. I have mailed you a new db setup file.
'Resistance is futile'
|
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 16 January 2001 : 20:55:01
|
If there are any ubb mods that you must have, post a request in the DEV Design Request W/O Code, someone may be interrested in writing it.
'Resistance is futile' |
|
|
|
rick7165
Senior Member
USA
1094 Posts |
Posted - 16 January 2001 : 20:57:59
|
Can someone post this Mod for download?
Thanks
Rick
My Demo Site
www.eastpasco.com
Edited by - rick7165 on 17 January 2001 15:53:26 |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 16 January 2001 : 21:03:34
|
the link is in the first post.
'Resistance is futile' |
|
|
|
Astro
Starting Member
11 Posts |
Posted - 16 January 2001 : 21:15:30
|
It's me again...
Did you send the file at astro@astro.com? if yes this address do not work because we transferd the site on an other server lest night and my domain will be transfer only tomorrow. Can you please resend it at highway@videotron.ca
Thank you again
quote:
If there are any ubb mods that you must have, post a request in the DEV Design Request W/O Code, someone may be interrested in writing it.
'Resistance is futile'
|
|
|
|
wob
Starting Member
39 Posts |
Posted - 17 January 2001 : 09:56:07
|
HuwR,
I have installed that updated file you sent me, thanks. When I run it, I get this error:
Microsoft VBScript compilation error '800a03f6'
Expected 'End'
/snitz/Mods/file_attach_setup.asp, line 73
UPDATE !!!
Works fine now. I went in and added a couple of 'end if' statements and everything got better. The only error I still get is when I upload a file and hit 'post new reply', the post_info screen displays an error :
Microsoft VBScript runtime error '800a01b6'
Object doesn't support this property or method: 'rs2.closestrSQL'
/snitz/post_info.asp, line 620
Can't seem to get this one. The reply shows up and the file is on the server but the link to it in the post is inactive???
Edited by - wob on 17 January 2001 15:37:36 |
|
|
|
Topic |
|
Topic Locked
