| Author |
 Topic  |
|
frankie
Junior Member
Vatican City
304 Posts |
 Posted - 22 December 2000 : 23:10:49
|
Guys! Help Help
I need this to work..Does anybody has the whole code for this mod that's compatible with v3.1 sr3 final...and tell please a little on how this mod suppose to work..bit confused here
excuse my ignorance..newbie to asp but with a promising future! <img src=icon_smile.gif border=0 align=middle>
thanks a punch
ô¿~
Edited by - frankie on 22 December 2000 23:11:45 |
 |
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 23 December 2000 : 05:26:55
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
please help me, I get this error from my admin_fileattachment.asp
_____________________________________
Microsoft VBScript runtime error '800a01c9'
This key is already associated with an element of this collection
/admin_fileattachment.asp, line 10
___________________________________________
...and this from file_attach_setup.asp
______________________________________
-2147217900 | Table 'FORUM_USERFILES' already exists.
-2147217900 | Table 'FORUM_MODS' already exists.
-2147217887 | Field 'M_ALLOWDOWNLOADS' already exists in table 'FORUM_MEMBERS'.
-2147217887 | Field 'M_ALLOWUPLOADS' already exists in table 'FORUM_MEMBERS'.
-2147217900 | Syntax error in ALTER TABLE statement.
-2147217900 | Syntax error in ALTER TABLE statement.
-2147217900 | Syntax error in ALTER TABLE statement.
-2147217900 | Syntax error in ALTER TABLE statement.
-2147217900 | Syntax error in ALTER TABLE statement.
Database set-up finished..
__________________________________
How can I fix this? Please I need fast help, 'cause my forum shows bad error messages!!!
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
The second errors mean you already had the tables etc ignore it.
The first error ?
Do you already have an objRec defined somewhere else ?
<font color=blue>'Resistance is futile'</font id=blue> |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 23 December 2000 : 05:31:55
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Guys! Help Help
I need this to work..Does anybody has the whole code for this mod that's compatible with v3.1 sr3 final...and tell please a little on how this mod suppose to work..bit confused here
excuse my ignorance..newbie to asp but with a promising future! <img src=icon_smile.gif border=0 align=middle>
thanks a punch
ô¿~
Edited by - frankie on 22 December 2000 23:11:45
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
The files are available here
The Mod allows users to attach files to their replies. If the message is later deleted, the files are also removed.
You can set a limit on filesize, and extension.
The Admin can turn of Attachments globally, and can grant or revoke upload/download privelages on a user by user basis.
<font color=blue>'Resistance is futile'</font id=blue> |
|
|
|
pinozz
New Member
53 Posts |
Posted - 23 December 2000 : 08:04:03
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
please help me, I get this error from my admin_fileattachment.asp
_____________________________________
Microsoft VBScript runtime error '800a01c9'
This key is already associated with an element of this collection
/admin_fileattachment.asp, line 10
___________________________________________
...and this from file_attach_setup.asp
______________________________________
-2147217900 | Table 'FORUM_USERFILES' already exists.
-2147217900 | Table 'FORUM_MODS' already exists.
-2147217887 | Field 'M_ALLOWDOWNLOADS' already exists in table 'FORUM_MEMBERS'.
-2147217887 | Field 'M_ALLOWUPLOADS' already exists in table 'FORUM_MEMBERS'.
-2147217900 | Syntax error in ALTER TABLE statement.
-2147217900 | Syntax error in ALTER TABLE statement.
-2147217900 | Syntax error in ALTER TABLE statement.
-2147217900 | Syntax error in ALTER TABLE statement.
-2147217900 | Syntax error in ALTER TABLE statement.
Database set-up finished..
__________________________________
How can I fix this? Please I need fast help, 'cause my forum shows bad error messages!!!
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
The second errors mean you already had the tables etc ignore it.
The first error ?
Do you already have an objRec defined somewhere else ?
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
No, I don't <img src=icon_smile_sad.gif border=0 align=middle>
|
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 23 December 2000 : 10:39:23
|
if you bear with me, I will bost a new setup file, to delete the tables and recreate them, it may be they haven't created correctly. will post in a few hours
<font color=blue>'Resistance is futile'</font id=blue> |
|
|
|
pinozz
New Member
53 Posts |
Posted - 23 December 2000 : 10:43:30
|
Huwr, I can't find the words to thank you<img src=icon_smile_approve.gif border=0 align=middle>
|
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 23 December 2000 : 11:03:27
|
I've managed to figure out the problem, you have got some duplicate records in your FORUM_MODS table.
you should have three records for the fileattachment mod, like this
<pre id=code><font face=courier size=2 id=code>
M_NAME M_CODE M_VALUE
Attachment faMaxSize 512
Attachment faExtensions .zip;.mdb;.txt;.asp
Attachment faAllowUploads 1
</font id=code></pre id=code>
If you have any others where M_NAME= Attachment, delete them.
<font color=blue>'Resistance is futile'</font id=blue> |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 23 December 2000 : 11:17:11
|
if you copy this code int an asp file and execute it, it should sort out your problem
<pre id=code><font face=courier size=2 id=code>
strSql = "DELETE FROM FORUM_MODS WHERE M_NAME='Attachment'"
Response.Write "<p>" & strSql & "</p>"
my_Conn.Execute strSql
strSql = "INSERT INTO FORUM_MODS (M_NAME,M_CODE,M_VALUE) VALUES ('Attachment','faMaxSize','512')"
Response.Write "<p>" & strSql & "</p>"
my_Conn.Execute strSql
strSql = "INSERT INTO FORUM_MODS (M_NAME,M_CODE,M_VALUE) VALUES ('Attachment','faExtensions','.zip;.mdb;.txt;.asp')"
Response.Write "<p>" & strSql & "</p>"
my_Conn.Execute strSql
strSql = "INSERT INTO FORUM_MODS (M_NAME,M_CODE,M_VALUE) VALUES ('Attachment','faAllowUploads','0')"
Response.Write "<p>" & strSql & "</p>"
my_Conn.Execute strSql
</font id=code></pre id=code>
<font color=blue>'Resistance is futile'</font id=blue> |
|
|
|
pinozz
New Member
53 Posts |
Posted - 23 December 2000 : 12:35:37
|
I say thanx once more, it fixed it!!
But still havin two little problems:
1)my files are all uploaded into the "uploaded" directory, not creating a new directory called as the username of the uploader
2)when I post an attachment it shows a broken link in te message body like this:
_______________________________________
download
_______________________________________
Any ideas?
well, on this forum it is NOT a broken link?!? why?
Edited by - pinozz on 23 December 2000 12:37:20 |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 23 December 2000 : 12:46:30
|
I emailed you the answer to this
<font color=blue>'Resistance is futile'</font id=blue> |
|
|
|
pinozz
New Member
53 Posts |
Posted - 23 December 2000 : 13:02:19
|
| sorry, no changes <img src=icon_smile_sad.gif border=0 align=middle> |
|
|
|
frankie
Junior Member
Vatican City
304 Posts |
Posted - 23 December 2000 : 14:08:49
|
HuwR,
Thanks a punch , but do I have to have animjd's mod in order for this to work?
ô¿~ |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 23 December 2000 : 14:32:02
|
Yes, although the setup will create everything you need
<font color=blue>'Resistance is futile'</font id=blue> |
|
|
|
frankie
Junior Member
Vatican City
304 Posts |
Posted - 23 December 2000 : 18:47:39
|
HuwR,
I'm sorry for the bother once again, is there any chance you could walk me thru this I'm bid lost here. I did all the code addition like you emphesized in all the mentioned files(post.asp - post_info.asp -pop_profile.asp -pop_profile.asp - pop_delete.asp..etc.).
When it came to amnidj's code I had no clue what he's talking about beside that inc link in the admin_home file...the rest was french to me. Doesn't mention anything about creating tables or that sort plus he talks about a mod directory and you talkd about mods directory..what's going on here?...In addition, and I know I'm asking for much is there any way you could share with me the add-ons in your test site wher in the active topics page it gives the user the choice between all/his-her/bookmarked. I was wondering too about the cool way you added in the topic page to give the user the choice between seeing the original post/last reply/etc....
That's enough for now <img src=icon_smile_shy.gif border=0 align=middle>
consider this my Christmas present <img src=icon_smile.gif border=0 align=middle><img src=icon_smile_big.gif border=0 align=middle><img src=icon_smile_wink.gif border=0 align=middle>
ô¿~ |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 23 December 2000 : 20:38:57
|
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> |
|
|
|
Topic |
|
Topic Locked
