| Author |
 Topic  |
|
|
Sting-USA
Starting Member
USA
34 Posts |
 Posted - 05 November 2007 : 21:47:12
|
Hi,
Thanks again for helping me last time in getting rid of that guy that hacked in and gave himself admin privliges. He's still gone and I'm more careful now about who gets approved for membership...
I'm using v3.4.06 I have recently discovered another problem (used to work okay). When I go into "Admin options" and click on "Archive Forum Topic" I get a progress meter that completes and disappears, but I never see the next window where I select which forum I want to archive. Any suggestions? |
Steve "Sting-USA" |
Edited by - Sting-USA on 05 November 2007 21:57:00 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Sting-USA
Starting Member
USA
34 Posts |
Posted - 06 November 2007 : 15:08:16
|
Hi,
I didn't know there was going to be a quiz, lol. This forum has been operating pretty much flawlessly for me since 2002. I don't remember anything about the original configuration. I think the database is MS access. The file extension is .mdb How can I confirm? |
Steve "Sting-USA" |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 06 November 2007 : 15:35:50
|
| It's Access then. Unfortunately, that being the case, I don't think there is much you can do about it. For SQL Server or MySQL you could use different archiving code, but with Access you can use stored procs to archive. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Sting-USA
Starting Member
USA
34 Posts |
Posted - 07 November 2007 : 11:54:01
|
Hi,
Thank you very much for your assistance.
What leads you to believe it's the DB that's the problem. When I click on this link, I'm expecting another Snitz page that doesn't ever appear. Why doesn't that page appear and then fail when I choose which forum to archive?
It's very hard for me to believe I'm just stuck and there's "nothing much I can do about it". That's completely unacceptable. I can't keep operating the way it is now. I've been happy with Snitz software for 5 years. Why can't I replace the DB or something? This makes no sense to me...
Do you know ANY way I can get past this problem? |
Steve "Sting-USA" |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 07 November 2007 : 12:11:11
|
The problem is that its timing out due to the number of items you are trying to archive. With Access, your options are unfortunately limited.
You could try reducing the amount of topics you are archiving at any given shot, and archive in small chunks until you get to where you want to be.
You could upgrade to a better database system - either MS SQL Server or MySQL - which will open up some new options and you'll get a good overall performance boost too (assuming you properly upgrade). |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Sting-USA
Starting Member
USA
34 Posts |
Posted - 07 November 2007 : 12:49:27
|
Hi,
Thanks for your assistance. I don't mean to dispute what you're telling me, I just want to understand correctly.
Here are the symptoms again...
I'm not actually getting to select any items to archive. From the options menu, I click on "Achive Forum Topic." I used to get another window here that opened and gave me the opportunity to select which forum(s) to archive (or not). It's no longer going to that page. I'm not receiving any error messages or other indicators. When I click the link I get a progress meter (like I get when I change pages) for 5 seconds so. When the progress meter disappears, I'm still in the admin options menu and no other windows have opened. It seems to my inexperienced logic like an .asp problem or something. I would expect to find a db problem possibly after a selection on that "next" screen that doesn't appear anymore.
1. Does this still sound like a db issue?
2. Are there instructions available for switching to a MS SQL db?
3. Am I going to be able to convert my Access db to MS SQL, or are we going to be starting over?
Thanks again... |
Steve "Sting-USA" |
|
|
|
Sting-USA
Starting Member
USA
34 Posts |
Posted - 07 November 2007 : 12:59:45
|
Hi,
I just looked and that link seems to go to admin_forums.asp The file size of that file is 0kb. Does that sound right? |
Steve "Sting-USA" |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 07 November 2007 : 13:01:43
|
| No that doesn't sound right. Re-upload admin_forums.asp |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 07 November 2007 : 13:03:55
|
quote:
Originally posted by Sting-USA
2. Are there instructions available for switching to a MS SQL db?
3. Am I going to be able to convert my Access db to MS SQL, or are we going to be starting over?
Just for future reference,
2. Yes, there are some very detailed instructions for moving up to SQL Server.
3. No, you will not have to start over. You will want to make a backup just in case (that actually applies any time you do any extra work to/with the database). |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 07 November 2007 : 13:11:54
|
Hmmm... it seems your problem may not be a performance problem, which may mean I didn't understand correctly what was happening. Upload admin_forums.asp again and see if the problem is solved.
|
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Sting-USA
Starting Member
USA
34 Posts |
Posted - 07 November 2007 : 16:31:38
|
Hi,
Problem solved! Thanks once again guys!  
Can you tell me where to find the instructions for converting to the MS SQL db? |
Steve "Sting-USA" |
Edited by - Sting-USA on 07 November 2007 16:36:45 |
|
|
|
phy1729
Average Member
USA
589 Posts |
|
|
AnonJr
Moderator
United States
5768 Posts |
|
| |
Topic |
|
Topic Locked
