Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/Code)
 Snitz Forums Archiving - 1.0 FINAL
 New Topic  Topic Locked
 Printer Friendly
Previous Page | Next Page
Author Previous Topic Topic Next Topic
Page: of 8

Capt_Dunzell
Junior Member

USA
160 Posts

Posted - 15 February 2001 :  23:31:27  Show Profile  Visit Capt_Dunzell's Homepage
I did notice that images dont work in the archives.

Is this by design, or still open for correction?

http://www.dunzellsden.com/forum/
Go to Top of Page

Da_Stimulator
DEV Team Forum Moderator

USA
3373 Posts

Posted - 16 February 2001 :  13:26:28  Show Profile  Send Da_Stimulator an AOL message  Send Da_Stimulator a Yahoo! Message
there is a directory /images/ added to the image tags, cuz huwr has all his images in a separate directory. If you open up archive.asp, archive_display.asp, and search_archive.asp near the top you should find the image tags, just change to fit.

I'm gonna update the zip in a couple minutes to fix this if ya wanna wait.

----
Da_Stimulator
Snitz Forums Dev Team Member
http://stimmy.cfm-resources.com/forum - my testing forums.
Go to Top of Page

Capt_Dunzell
Junior Member

USA
160 Posts

Posted - 16 February 2001 :  13:38:45  Show Profile  Visit Capt_Dunzell's Homepage
I got that repaired to fit my forum.
I was talking about smilies and other links.
Not really a big deal I suppose.

I just tried deleting some archived posts on a test server, but they wont delete. I get this error:

MS JET Database Engine Error '80040e07'

Data type mismatch in criteria expression

/admin_forums.asp, line 251

Everything else seems to work perfectly for me with this mod except that I cannot delete any archived posts.

Any ideas on how to fix it?





http://www.dunzellsden.com/forum/

Edited by - Capt_Dunzell on 16 February 2001 16:40:03
Go to Top of Page

Da_Stimulator
DEV Team Forum Moderator

USA
3373 Posts

Posted - 16 February 2001 :  14:05:25  Show Profile  Send Da_Stimulator an AOL message  Send Da_Stimulator a Yahoo! Message
Line 151 for me is a %>

Can you give me the code that is surrounding that line?
I just updated the zip btw with those image fixes.

----
Da_Stimulator
Snitz Forums Dev Team Member
http://stimmy.cfm-resources.com/forum - my testing forums.
Go to Top of Page

Capt_Dunzell
Junior Member

USA
160 Posts

Posted - 16 February 2001 :  14:09:46  Show Profile  Visit Capt_Dunzell's Homepage
This is line 251 - 255 of my admin_forums.asp

my_conn.execute(strsql)
strsql = "DELETE FROM " & strTablePrefix & "ARCHIVE_REPLY WHERE FORUM_ID=" & strForum_id & " AND R_DATE < " & strDateOlderThan
my_conn.execute(strsql)
Call subdoupdates()
End Sub

http://www.dunzellsden.com/forum/

Edited by - Capt_Dunzell on 16 February 2001 16:40:26
Go to Top of Page

rick7165
Senior Member

USA
1094 Posts

Posted - 16 February 2001 :  14:27:11  Show Profile  Visit rick7165's Homepage
If you're using HuwR's Forum Code you will need to add this:
<%=strImageURL %> between src="????.gif

I just do a replace of this: Replace src=" with This: src="<%=strImageURL %>

Works fine.



quote:

I did notice that images dont work in the archives.

Is this by design, or still open for correction?

http://www.dunzellsden.com/forum/



Test Site
www.eastpasco.com
Running on HuwR's SR4 release. Colors and Graphic scheme done by Richard Kinser.
Go to Top of Page

Capt_Dunzell
Junior Member

USA
160 Posts

Posted - 16 February 2001 :  14:29:07  Show Profile  Visit Capt_Dunzell's Homepage
I had already done that, thanks though.

I was refering to the images within posts of the archives.



http://www.dunzellsden.com/forum/
Go to Top of Page

Da_Stimulator
DEV Team Forum Moderator

USA
3373 Posts

Posted - 16 February 2001 :  14:55:50  Show Profile  Send Da_Stimulator an AOL message  Send Da_Stimulator a Yahoo! Message
Wierd, thats line 251 for me... download the updated files from the zip and see if anything changes.

----
Da_Stimulator
Snitz Forums Dev Team Member
http://stimmy.cfm-resources.com/forum - my testing forums.
Go to Top of Page

Capt_Dunzell
Junior Member

USA
160 Posts

Posted - 16 February 2001 :  15:15:02  Show Profile  Visit Capt_Dunzell's Homepage
Will do.



http://www.dunzellsden.com/forum/
Go to Top of Page

Capt_Dunzell
Junior Member

USA
160 Posts

Posted - 16 February 2001 :  15:21:07  Show Profile  Visit Capt_Dunzell's Homepage
Okay, same error. And I see I made a goof, line 251 is what it is, not 151. I need more coffee I think.



http://www.dunzellsden.com/forum/
Go to Top of Page

Da_Stimulator
DEV Team Forum Moderator

USA
3373 Posts

Posted - 16 February 2001 :  16:21:04  Show Profile  Send Da_Stimulator an AOL message  Send Da_Stimulator a Yahoo! Message
lol, ok, I looked at it but I cant find an error...
Huwr??

----
Da_Stimulator
Snitz Forums Dev Team Member
http://stimmy.cfm-resources.com/forum - my testing forums.
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 16 February 2001 :  16:57:38  Show Profile  Visit HuwR's Homepage
try changing it so that it starts

strsql = "DELETE * FROM " &

Notice the *

Go to Top of Page

Capt_Dunzell
Junior Member

USA
160 Posts

Posted - 16 February 2001 :  17:10:57  Show Profile  Visit Capt_Dunzell's Homepage
Still gives me the same error.



http://www.dunzellsden.com/forum/
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 16 February 2001 :  17:22:21  Show Profile  Visit HuwR's Homepage
i have just relooked at your post, is this exactly as it appears in your file

strsql = "DELETE FROM " & strTablePrefix & "ARCHIVE_REPLY WHERE FORUM_ID=" & strForum_id & " AND R_DATE < " & strDateOlderThan


if so it should be

strsql = "DELETE FROM " & strTablePrefix & "ARCHIVE_REPLY WHERE FORUM_ID=" & strForum_id & " AND R_DATE < '" & strDateOlderThan & "'"


Go to Top of Page

Capt_Dunzell
Junior Member

USA
160 Posts

Posted - 16 February 2001 :  18:06:18  Show Profile  Visit Capt_Dunzell's Homepage
That is how it appears, I made the changes you showed, but its still is giving me the exact same error.



http://www.dunzellsden.com/forum/
Go to Top of Page
Page: of 8 Previous Topic Topic Next Topic  
Previous Page | Next Page
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.1 seconds. Powered By: Snitz Forums 2000 Version 3.4.07