| Author |
 Topic  |
|
frankie
Junior Member
Vatican City
304 Posts |
 Posted - 24 December 2000 : 01:03:31
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
frankie,
If you followed the instructions for the fileAttachments, all should be ok it creates the ncessary mod tables for you.
If you go to admin_home, do you get the modcommander table at the bottom ?
I will dig out the link for the message sorting.
digging...
Found the treasure !
http://forum.snitz.com/forum/link.asp?TOPIC_ID=1857
Merry Christmas <img src=icon_smile.gif border=0 align=middle><img src=icon_smile_wink.gif border=0 align=middle>
<font color=blue>'Resistance is futile'</font id=blue>
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
HuwR, I really appreciate this and thank you for replying. I do have that table at the bottom of my admin_home. Though do I need to create any .mod or readme.txt files by my self and if so what goes in them?. Plus what do you mean by a virtual uploaded directory ( as far I know if it's in the main directory it is virtual), also do I have to create the mod or mods directory or it's included when you unzip?..lots of questions(less of experience!!) I learn from the master though!!<img src=icon_smile.gif border=0 align=middle>
Thanks once again and merry christmas
P.S. Do you have the code for the bookmarked topics or it requires some digging here?
ô¿~ |
 |
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 24 December 2000 : 04:44:11
|
All the relevant files are in the zip file.
You will need to create a mods, an include directory, and the uploaded directory.
The Zip file contains the subdirectories so you can see which files go where.
It just requires a directory called uploaded, a virtual directory is a pointer to a directory any where on the server, not just in your web directory.
ie you could create a virtula uploaded www.mydomain.com/uploaded which pointed to c:\myuploads rather than c:\.....wwwroot/uploaded
Anyway, just create a normal subdirectory in your webspace, it must have full read/write permissions.
I noticed from your other post that you found the Bookmark topics
<font color=blue>'Resistance is futile'</font id=blue> |
|
|
|
frankie
Junior Member
Vatican City
304 Posts |
Posted - 24 December 2000 : 12:16:38
|
HuwR,
Thanks alot, I can put the pieces together now the picture is clearer.
Yes I did find the bookmark link..after I digged.lol <img src=icon_smile.gif border=0 align=middle>
ô¿~ |
|
|
|
concep86
Junior Member
USA
140 Posts |
Posted - 25 December 2000 : 12:46:07
|
Where is this icon...
icon_paperclip.gif
I did not find it in the zip.
Thanks
|
|
|
|
concep86
Junior Member
USA
140 Posts |
Posted - 29 December 2000 : 13:37:43
|
I have installed the mod ad it works great if I am logged into the forum. However I get this error if I am not logged into the site...
___________________________________________
ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted; the operation requested by the application requires a current record.
/SNITZ/inc_functions.asp, line 648
______________________________________
If I log in to the forum... no error. mod works great.
Line 648 is part of this function
-------------------------------------
function getMemberID(fUser_Name)
'## Forum_SQL
strSql = "SELECT " & strMemberTablePrefix & "MEMBERS.MEMBER_ID "
strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS "
strSql = strSql & " WHERE M_NAME = '" & fUser_Name & "'"
rsGetMemberID = my_Conn.Execute(strSql)
***** getMemberID = rsGetMemberID("MEMBER_ID")
end function
--------------------
the exact line is the one with *******
it is looking for a member id... well there is no member identified yet...
Did I miss something....
Thanks...
|
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 29 December 2000 : 15:04:02
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
I have installed the mod ad it works great if I am logged into the forum. However I get this error if I am not logged into the site...
___________________________________________
ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted; the operation requested by the application requires a current record.
/SNITZ/inc_functions.asp, line 648
______________________________________
If I log in to the forum... no error. mod works great.
Line 648 is part of this function
-------------------------------------
function getMemberID(fUser_Name)
'## Forum_SQL
strSql = "SELECT " & strMemberTablePrefix & "MEMBERS.MEMBER_ID "
strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS "
strSql = strSql & " WHERE M_NAME = '" & fUser_Name & "'"
rsGetMemberID = my_Conn.Execute(strSql)
***** getMemberID = rsGetMemberID("MEMBER_ID")
end function
--------------------
the exact line is the one with *******
it is looking for a member id... well there is no member identified yet...
Did I miss something....
Thanks...
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Where does it give you this error, default.asp, or a different page?
<font color=blue>'Resistance is futile'</font id=blue> |
|
|
|
pinozz
New Member
53 Posts |
Posted - 29 December 2000 : 21:31:25
|
I get two errors: <img src=icon_smile_sad.gif border=0 align=middle>
Microsoft VBScript compilation error '800a0401'
Expected end of statement
/post_info.asp, line 631
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)
--------------------------------------------------------------------------^
Microsoft JET Database Engine error '80040e57'
The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.
/inc_top.asp, line 208
line 208 is
my_Conn.Execute (strSql)
inside the "who's on line" inserted code
could you help me please? I'm losing all my users ! <img src=icon_smile_sad.gif border=0 align=middle>
|
|
|
|
concep86
Junior Member
USA
140 Posts |
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 30 December 2000 : 04:28:17
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
HuwR,
I get the error on the post.asp page... when I go to reply to the topic...
Take a look .... http://www.coneciones.com/snitz/default.asp
Thanks...
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
That is odd, the only code in the fileattachment mod that call getmemberid in post.asp, is to display the button, however it is wrapped in an if then statement, and is not called if the membername is blank.
Could you mail me your post.asp, I will take a look.
<font color=blue>'Resistance is futile'</font id=blue> |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 30 December 2000 : 04:32:31
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
I get two errors: <img src=icon_smile_sad.gif border=0 align=middle>
Microsoft VBScript compilation error '800a0401'
Expected end of statement
/post_info.asp, line 631
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)
--------------------------------------------------------------------------^
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
my_conn.execute should be on a separate line.
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Microsoft JET Database Engine error '80040e57'
The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.
/inc_top.asp, line 208
line 208 is
my_Conn.Execute (strSql)
inside the "who's on line" inserted code
could you help me please? I'm losing all my users ! <img src=icon_smile_sad.gif border=0 align=middle>
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
If you post this in the "whos online or active user thread" someone should be able to fix it.
In general it is NOT a good idea to be installing Mods on a live site, you should test them first before going live, everyones code is slightly different, and the Mods can not be guarenteed to work first time you install them.
<font color=blue>'Resistance is futile'</font id=blue> |
|
|
|
pinozz
New Member
53 Posts |
Posted - 30 December 2000 : 08:10:35
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote> my_conn.execute should be on a separate line. <hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
I tried, but no succes <img src=icon_smile_sad.gif border=0 align=middle>
I completely removed that line (the one in the post before), and everything seems to work fine, what is it used for?
PS: I installed the scripts in a testing forum and everything was good, then I upgraded the official one, still good, but 5 days after I got the errors I posted, this is the strange part! |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 30 December 2000 : 08:15:26
|
You should not delete the line, it is the SQL execute, without it you are not updating the DB.
What exactly are you doing when you get this error?
<font color=blue>'Resistance is futile'</font id=blue> |
|
|
|
pinozz
New Member
53 Posts |
Posted - 30 December 2000 : 08:45:39
|
I get this error when I push submit button to post a reply
|
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 30 December 2000 : 09:10:08
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
I get this error when I push submit button to post a reply
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
could you email me your post and post_info.asp files I will check them.
Also the who's online error, what is the exact name of the Topic you are trying to post to ?, it may be a punctuation problem ?
<font color=blue>'Resistance is futile'</font id=blue> |
|
|
|
shahid
Starting Member
31 Posts |
Posted - 03 January 2001 : 11:39:54
|
hi
I am completely new to ASP, so please help me installing the attachment mod.
I have downloaded both the zip files (fileattach.zip and modcmd.zip). now where should i start from?
I am using a windows 2000 server with IIS 5.0.
please help
|
|
|
|
Topic |
|
Topic Locked
