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 DEV-Group
 DEV Bug Reports (Closed)
 v3.3 BUG+FIX: Archiving when using MySQL
 Forum Locked  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

toad
Starting Member

22 Posts

Posted - 03 January 2002 :  01:00:26  Show Profile
version 3.3 is supposed to support archiving and viewing archived posts. when i go the archive section of the admin page my only option is to delete posts. where is the archive function?

Changed topic title - Davio

Edited by - Davio on 03 January 2002 23:56:19

Davio
Development Team Member

Jamaica
12217 Posts

Posted - 03 January 2002 :  01:03:02  Show Profile
Those options are only avilable to users who are not using MySQL.

- David
Go to Top of Page

toad
Starting Member

22 Posts

Posted - 03 January 2002 :  01:07:25  Show Profile
are there any mods available that you are aware of that support Archiving with MySql?

quote:

Those options are only avilable to users who are not using MySQL.

- David



Go to Top of Page

Davio
Development Team Member

Jamaica
12217 Posts

Posted - 03 January 2002 :  01:11:44  Show Profile
There was a good reason why archiving wasn't supported for MySQL database. Don't remember it right now.
Would have to do a search for it.

For mods, no. I don't know of any.

- David
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 03 January 2002 :  03:45:57  Show Profile  Visit HuwR's Homepage
To be honest I have no idea why, I did a lot of the coding, but the original mod was by someone else, I can't see any reason why it wouldn't work, most of the queeries look pretty standard.

toad, if you wish to try it, obviously take a backup of your DB.
check to see whether you have the FORUM_A_REPLY and FORUM_A_TOPICS tables, then just uncomment the if strDBType <> "MySQL" from admin_forums.asp, I would be interrested to know the result if you do try.

Go to Top of Page

toad
Starting Member

22 Posts

Posted - 03 January 2002 :  15:01:53  Show Profile
Ok, the archive seems to work fine except for a small problem which is cosmetic and should be simple to fix
after removing the <% and %> tags before and after the "if" and "end if" in the menu i now see those, so my menu looks like this....

if strDBType <> "mysql" then
Archive topics from a forum
delete selected topics from an archive
configure archive reminder End If
Delete ALL topics from a forum

i'm sure there is just something i did a bit wrong and should be easilly fixed. i ran an archive of a non important topic, and it seemed to work. i then viewed the contents of the new archive and it also works. is there any other test i need to look into?


quote:

To be honest I have no idea why, I did a lot of the coding, but the original mod was by someone else, I can't see any reason why it wouldn't work, most of the queeries look pretty standard.

toad, if you wish to try it, obviously take a backup of your DB.
check to see whether you have the FORUM_A_REPLY and FORUM_A_TOPICS tables, then just uncomment the if strDBType <> "MySQL" from admin_forums.asp, I would be interrested to know the result if you do try.





Go to Top of Page

Nathan
Help Moderator

USA
7664 Posts

Posted - 03 January 2002 :  15:13:36  Show Profile  Visit Nathan's Homepage
This topic might be better in the Development(General) forum.

If MySQL archiving works here. . . there might not be a reason to leave it out of the base code anymore.

 Nathan Bales - Romans 15:13
---------------------------------

Snitz Exchange | Mod Resource
Go to Top of Page

Davio
Development Team Member

Jamaica
12217 Posts

Posted - 03 January 2002 :  15:32:14  Show Profile
It would be better in the Bug Forums.

- David
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 03 January 2002 :  17:36:03  Show Profile  Visit HuwR's Homepage
toad,

rather than remove the <% %>, remove the whole line.

Go to Top of Page

toad
Starting Member

22 Posts

Posted - 03 January 2002 :  17:38:21  Show Profile
So remove the "if strDBType <> "mysql" " and "end if" ?


quote:

toad,

rather than remove the <% %>, remove the whole line.





Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 03 January 2002 :  18:03:50  Show Profile  Visit HuwR's Homepage
yes

Go to Top of Page

toad
Starting Member

22 Posts

Posted - 03 January 2002 :  18:44:38  Show Profile
That worked. Thank you for your help

quote:

yes





Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 28 January 2002 :  16:44:17  Show Profile
removed the check for MySql.

fixed in v3.4
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.12 seconds. Powered By: Snitz Forums 2000 Version 3.4.07