| Author |
 Topic  |
|
Capt_Dunzell
Junior Member
USA
160 Posts |
 Posted - 16 February 2001 : 18:13:21
|
Okay, I got rid of the error, and it gives the updated count report, but the archive topics are not being deleted.
http://www.dunzellsden.com/forum/ |
 |
|
|
Capt_Dunzell
Junior Member
USA
160 Posts |
Posted - 16 February 2001 : 18:15:51
|
I cannot delete indivudual posts in the archives with the delete icon either.
And the drop down page number selector brings up a page cannot be found error, but the page numbers at the bottom still function.
Could this all be related? Im using the latest zip for this mod.
http://www.dunzellsden.com/forum/ |
|
|
|
Capt_Dunzell
Junior Member
USA
160 Posts |
Posted - 16 February 2001 : 18:34:43
|
If I remove line 251, my_conn.execute(strsql) ,
the error goes away.
I dont know if that is helpful or not.
http://www.dunzellsden.com/forum/ |
|
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 16 February 2001 : 20:19:59
|
No, thats the part that executes the script...
When you confirm the delete, and it gives the error, can you paste the url in here? I wanna see if the date querystring looks ok. I think that might be it.
----
Da_Stimulator
Snitz Forums Dev Team Member
http://stimmy.cfm-resources.com/forum - my testing forums. |
|
|
|
Capt_Dunzell
Junior Member
USA
160 Posts |
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 17 February 2001 : 19:32:42
|
capt_dunzel
Is this what your archive delete sub looks like ?
Sub subdeletearchivetopics(strForum_id, strDateOlderThan)
strsql = "Delete from " & strTablePrefix & "ARCHIVE_TOPICS WHERE FORUM_ID=" & strForum_id & " AND T_LAST_POST < '" & strDateOlderThan & "'"
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
|
|
|
|
Capt_Dunzell
Junior Member
USA
160 Posts |
|
|
Capt_Dunzell
Junior Member
USA
160 Posts |
Posted - 17 February 2001 : 19:51:44
|
Got it, there was a typo. 
Outstanding! Thanks to you Huwr and Da_Stimulator!
The only other problem I am having with this is that the drop down page selector at the top is not working. It lists all the page numbers but it sends you to an unavailable page.
http://www.dunzellsden.com/forum/ |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 17 February 2001 : 19:52:35
|
I am looking in to that at the moment, just discovered it myself
|
|
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 17 February 2001 : 20:02:59
|
Where was the typo? was it only on yours or did it come with the package... I might need to fix it.
----
Da_Stimulator
Snitz Forums Dev Team Member
http://stimmy.cfm-resources.com/forum - my testing forums. |
|
|
|
Capt_Dunzell
Junior Member
USA
160 Posts |
Posted - 17 February 2001 : 20:07:35
|
It looks like it was part of the admin_forum.asp that I got out of the download.
Yes, just downloaded it again to double check, thats it.
http://www.dunzellsden.com/forum/ |
|
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 18 February 2001 : 20:34:00
|
Since no bugs have been reported in a while, I'm declaring it stable for normal use... 'final' version.
----
Da_Stimulator
Snitz Forums Dev Team Member
http://stimmy.cfm-resources.com/forum - my testing forums. |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 18 February 2001 : 20:54:45
|
couple of minor fixes, and a small enhancement.
Added a new column to FORUM which records the last archived date. So you can se in admin when it was last archived, also enclosed the admin stuff in a table to match the rest of the forum, thanks to kycable for doing the table stuff.
If you overwrite your dbs file with the one in the zip and re-run it, it will add the field, ignore the table creation errors if you get them, it's because you have already installed the mod.
updated files are here
also minor tweak to archive display, to allow you to reply if the archived topic id still in the main forum
sorry Stim
|
|
|
|
Topic |
|
Topic Locked
