Author |
Topic |
|
toad
Starting Member
22 Posts |
Posted - 03 January 2002 : 01:00:26
|
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
|
Those options are only avilable to users who are not using MySQL.
- David |
|
|
toad
Starting Member
22 Posts |
Posted - 03 January 2002 : 01:07:25
|
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
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 03 January 2002 : 01:11:44
|
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 |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 03 January 2002 : 03:45:57
|
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.
|
|
|
toad
Starting Member
22 Posts |
Posted - 03 January 2002 : 15:01:53
|
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.
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 03 January 2002 : 15:13:36
|
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 |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 03 January 2002 : 15:32:14
|
It would be better in the Bug Forums.
- David |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 03 January 2002 : 17:36:03
|
toad,
rather than remove the <% %>, remove the whole line.
|
|
|
toad
Starting Member
22 Posts |
Posted - 03 January 2002 : 17:38:21
|
So remove the "if strDBType <> "mysql" " and "end if" ?
quote:
toad,
rather than remove the <% %>, remove the whole line.
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 03 January 2002 : 18:03:50
|
yes
|
|
|
toad
Starting Member
22 Posts |
Posted - 03 January 2002 : 18:44:38
|
That worked. Thank you for your help
quote:
yes
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 28 January 2002 : 16:44:17
|
removed the check for MySql.
fixed in v3.4 |
|
|
|
Topic |
|