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

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: MOD Implementation
 Using New FAQ Mod, Old Added FAQs Disappear
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

richfed
Average Member

United States
999 Posts

Posted - 17 January 2004 :  09:22:27  Show Profile  Visit richfed's Homepage
I have been using the FAQ Administration MOD [v1.0] for a long time & have added many new FAQs.

Just upgraded to F.A.Q. Administration v1.1 & no longer can see any of the added questions/answers, though they are still in the database. I'm sure that I am missing something, but what?

[if I re-upload my previous version faq.asp & admin_faq.asp all the FAQs are there, though the formatting appears a bit off]

Rich
[size=1]A Complete Idiot's Guide to MOD Implementation || On the Trail of the Last of the Mohicans[/size=1]

masterao
Senior Member

Sweden
1678 Posts

Posted - 17 January 2004 :  12:40:00  Show Profile  Visit masterao's Homepage
richfed, the db-fields are named differently in the new faq. You have to rename them in either the db or the script to make it work (or remove the old faq-table and add the faqs anew).

Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod
Go to Top of Page

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts

Posted - 17 January 2004 :  18:17:34  Show Profile  Visit OneWayMule's Homepage  Send OneWayMule an ICQ Message
masterao, this is not true. No table names/fields have changed (but the FAQ_CATEGORY table is added and a few fields are added to the FAQ table) and upgrading should work fine and did in my testing processes...
Which fields do you think are named differently?
richfed, i will take a look at this.

My MODs:
Birthdays - Custom Policy - F.A.Q. Administration - Forum Rules - Guestbook
Links Manager - MyOwnGoogle - Profile Views - Search Log - WebSearch

Useful stuff:
Forum and MOD Installation - MOD Installation Guide - Snitz v3.4.05 Readme - Free ASP Hosts - Support Snitz
Go to Top of Page

richfed
Average Member

United States
999 Posts

Posted - 17 January 2004 :  20:50:32  Show Profile  Visit richfed's Homepage
Thanks ... if it makes a difference, my database is MS-SQL. No error messages during the updates; all appeared fine.
Go to Top of Page

masterao
Senior Member

Sweden
1678 Posts

Posted - 17 January 2004 :  21:20:48  Show Profile  Visit masterao's Homepage
OneWayMule, you are quite right. I checked my old db and new, and I could have sworn that they were different. I must have been more tired than I though when updated the mod on my forum.

Sorry for the mis-information, richfed .

I think you need to add which category your original faqs belong to in the FAQ table ( field F_FAQ_CATEGORY).

Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod
Go to Top of Page

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts

Posted - 18 January 2004 :  00:13:06  Show Profile  Visit OneWayMule's Homepage  Send OneWayMule an ICQ Message
No problem, masterao.

richfed, I found out what the problem is: the F_FAQ_CATEGORY should have a default value of 1 (so all old FAQs are accessible by the default category that is added (must have included the wrong dbs file...).
Sorry about that.
If have access to your database, please change the default value of the field to 1, otherwise let me know and I'll provide a dbs script for you.

I've updated the zip file.

My MODs:
Birthdays - Custom Policy - F.A.Q. Administration - Forum Rules - Guestbook
Links Manager - MyOwnGoogle - Profile Views - Search Log - WebSearch

Useful stuff:
Forum and MOD Installation - MOD Installation Guide - Snitz v3.4.05 Readme - Free ASP Hosts - Support Snitz
Go to Top of Page

richfed
Average Member

United States
999 Posts

Posted - 18 January 2004 :  06:24:05  Show Profile  Visit richfed's Homepage
Here's what I have tried so far:

1 - Attempted to edit the field as you said, via Table Editor. Would not accept the value.

2 - I used your new dbs file. I got the usual error messages for duplicate errors, but it did change the value. There was no change in my FAQ page, however.

3 - I re-ran the default FAQ update to repopulate the table, thinking it would maybe now add in those FAQs I had created with version 1.0. It didn't. All it did was double up on all the standard Snitz FAQs. Left me with this:

General
Do I have to register?
How can I use smilies and images?
Can I add a hyperlink to my messages?
What are Moderators?
Are cookies used?
What are active topics?
Can I edit my own posts?
Can I attach files?
Can I search?
Can I edit my profile?
Can I attach my own signature to my posts?
Are there any censor features?
What do I do if I forget my Password?
Can I be notified by e-mail when there are new posts?
What does it mean if a forum has Moderation enabled?
What is COPPA?
Where can I get my own copy of this Forum?
Do I have to register?
How can I use smilies and images?
Can I add a hyperlink to my messages?
What are Moderators?
Are cookies used?
What are active topics?
Can I edit my own posts?
Can I attach files?
Can I search?
Can I edit my profile?
Can I attach my own signature to my posts?
Are there any censor features?
What do I do if I forget my Password?
Can I be notified by e-mail when there are new posts?
What does it mean if a forum has Moderation enabled?
What is COPPA?
Where can I get my own copy of this Forum?
General
No FAQ found.
Can't find your answer here? Send us an e-mail.

So, I deleted the second General category that was created [empty] and then deleted all the duplicates in the original category.

Back where I started.

So, yeah, if you would, send me a script ... please!

Thanks -


EDIT ----> Just discovered this - when I am logged in, as the Administrator, I see the standard Snitz Forum FAQs as described above. However, a regular user sees: NO CATEGORIES FOUND - then an E-mail for help. There are no FAQs showing for the average user.

AH! Discovered how to fix that! I thought that meant who could create/edit FAQs. Nice, so FAQs can be created that just moderators can view! I like that!

Rich
[size=1]A Complete Idiot's Guide to MOD Implementation || On the Trail of the Last of the Mohicans[/size=1]

Edited by - richfed on 18 January 2004 08:35:16
Go to Top of Page

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts

Posted - 18 January 2004 :  11:06:07  Show Profile  Visit OneWayMule's Homepage  Send OneWayMule an ICQ Message
quote:
So, yeah, if you would, send me a script ... please!

The easiest way to fix this is setting the value for F_FAQ_CATEGORY of your old FAQs to 1.
The default value is not needed but on setup, so you can forget that if you change the value for each of your v1.0 FAQs.
quote:
AH! Discovered how to fix that! I thought that meant who could create/edit FAQs. Nice, so FAQs can be created that just moderators can view! I like that!

Yeah, that's the way it works, you can set up FAQs for Moderators or other Admins while standard users/visitors cannot see them. Glad you like it!

My MODs:
Birthdays - Custom Policy - F.A.Q. Administration - Forum Rules - Guestbook
Links Manager - MyOwnGoogle - Profile Views - Search Log - WebSearch

Useful stuff:
Forum and MOD Installation - MOD Installation Guide - Snitz v3.4.05 Readme - Free ASP Hosts - Support Snitz
Go to Top of Page

richfed
Average Member

United States
999 Posts

Posted - 18 January 2004 :  12:17:23  Show Profile  Visit richfed's Homepage
OK - that took care of that. Thanks.

The only thing now is that they are all out of order ... because they are on auto-increment, I cannot renumber the questions. It would be good to be able to place them in a logical sequence.

One more thing, so when I add a new FAQ, it will now get a F_FAQ_CATEGORY value of 1 automatically?

Rich
[size=1]A Complete Idiot's Guide to MOD Implementation || On the Trail of the Last of the Mohicans[/size=1]
Go to Top of Page

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts

Posted - 18 January 2004 :  12:24:36  Show Profile  Visit OneWayMule's Homepage  Send OneWayMule an ICQ Message
quote:
The only thing now is that they are all out of order ... because they are on auto-increment, I cannot renumber the questions. It would be good to be able to place them in a logical sequence.

Click the "Set the order of F.A.Q.s and Categories" icon () on admin_faq.asp, you can define your desired order there.

quote:
One more thing, so when I add a new FAQ, it will now get a F_FAQ_CATEGORY value of 1 automatically?

No, you can choose the Category when you add/edit a F.A.Q.

My MODs:
Birthdays - Custom Policy - F.A.Q. Administration - Forum Rules - Guestbook
Links Manager - MyOwnGoogle - Profile Views - Search Log - WebSearch

Useful stuff:
Forum and MOD Installation - MOD Installation Guide - Snitz v3.4.05 Readme - Free ASP Hosts - Support Snitz
Go to Top of Page
  Previous Topic Topic Next Topic  
 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.42 seconds. Powered By: Snitz Forums 2000 Version 3.4.07