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
 Error when adding default FAQ question's		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Niox
Starting Member

31 Posts
Posted - 27 January 2004 :  09:06:31  Show Profile
Hi,

I was trying to install the F.A.Q. Administration v1.1 mod into snitz 3.4.04. When i run the: 'MOD: FAQ Administration v1.1 - Add default FAQS' i get an error:


MOD: F.A.Q. Administration v1.1 - Add Default FAQs

Adding new records..
INSERT INTO FORUM_FAQ_CATEGORY (FCAT_TITLE,FCAT_ORDER,FCAT_LEVEL) VALUES ('General',1,4)

Value(s) updated succesfully
--------------------------------------------------------------------------------

Adding new records..
INSERT INTO FORUM_FAQ (F_FAQ_QUESTION,F_FAQ_ANSWER,F_FAQ_ORDER,F_FAQ_CATEGORY,F_FAQ_TYPE) VALUES ('Do I have to register?','',1,1,1)
INSERT INTO FORUM_FAQ (F_FAQ_QUESTION,F_FAQ_ANSWER,F_FAQ_ORDER,F_FAQ_CATEGORY,F_FAQ_TYPE) VALUES ('How can I use smilies and images?','',1,1,2)
INSERT INTO FORUM_FAQ (F_FAQ_QUESTION,F_FAQ_ANSWER,F_FAQ_ORDER,F_FAQ_CATEGORY,F_FAQ_TYPE) VALUES ('Can I add a hyperlink to my messages?','',1,1,3)
INSERT INTO FORUM_FAQ
INSERT INTO FORUM_FAQ (F_FAQ_QUESTION,F_FAQ_ANSWER,F_FAQ_ORDER,F_FAQ_CATEGORY,F_FAQ_TYPE) VALUES ('Can I change the format of my text?','',1,1,4)
INSERT INTO FORUM_FAQ (F_FAQ_QUESTION,F_FAQ_ANSWER,F_FAQ_ORDER,F_FAQ_CATEGORY,F_FAQ_TYPE) VALUES ('What are Moderators?','',1,1,5)
INSERT INTO FORUM_FAQ (F_FAQ_QUESTION,F_FAQ_ANSWER,F_FAQ_ORDER,F_FAQ_CATEGORY,F_FAQ_TYPE) VALUES ('Are cookies used?','',1,1,6)
INSERT INTO FORUM_FAQ (F_FAQ_QUESTION,F_FAQ_ANSWER,F_FAQ_ORDER,F_FAQ_CATEGORY,F_FAQ_TYPE) VALUES ('What are active topics?','',1,1,7)
INSERT INTO FORUM_FAQ (F_FAQ_QUESTION,F_FAQ_ANSWER,F_FAQ_ORDER,F_FAQ_CATEGORY,F_FAQ_TYPE) VALUES ('Can I edit my own posts?','',1,1,8)
INSERT INTO FORUM_FAQ (F_FAQ_QUESTION,F_FAQ_ANSWER,F_FAQ_ORDER,F_FAQ_CATEGORY,F_FAQ_TYPE) VALUES ('Can I attach files?','',1,1,9)
INSERT INTO FORUM_FAQ (F_FAQ_QUESTION,F_FAQ_ANSWER,F_FAQ_ORDER,F_FAQ_CATEGORY,F_FAQ_TYPE) VALUES ('Can I search?','',1,1,10)
INSERT INTO FORUM_FAQ (F_FAQ_QUESTION,F_FAQ_ANSWER,F_FAQ_ORDER,F_FAQ_CATEGORY,F_FAQ_TYPE) VALUES ('Can I edit my profile?','',1,1,11)
INSERT INTO FORUM_FAQ (F_FAQ_QUESTION,F_FAQ_ANSWER,F_FAQ_ORDER,F_FAQ_CATEGORY,F_FAQ_TYPE) VALUES ('Can I attach my own signature to my posts?','',1,1,12)
INSERT INTO FORUM_FAQ
INSERT INTO FORUM_FAQ (F_FAQ_QUESTION,F_FAQ_ANSWER,F_FAQ_ORDER,F_FAQ_CATEGORY,F_FAQ_TYPE) VALUES ('Are there any censor features?','',1,1,13)
INSERT INTO FORUM_FAQ (F_FAQ_QUESTION,F_FAQ_ANSWER,F_FAQ_ORDER,F_FAQ_CATEGORY,F_FAQ_TYPE) VALUES ('What do I do if I forget my Password?','',1,1,14)
INSERT INTO FORUM_FAQ
INSERT INTO FORUM_FAQ (F_FAQ_QUESTION,F_FAQ_ANSWER,F_FAQ_ORDER,F_FAQ_CATEGORY,F_FAQ_TYPE) VALUES ('Can I be notified by e-mail when there are new posts?','',1,1,15)
INSERT INTO FORUM_FAQ
INSERT INTO FORUM_FAQ (F_FAQ_QUESTION,F_FAQ_ANSWER,F_FAQ_ORDER,F_FAQ_CATEGORY,F_FAQ_TYPE) VALUES ('What does it mean if a forum has Moderation enabled?','',1,1,16)
INSERT INTO FORUM_FAQ
INSERT INTO FORUM_FAQ (F_FAQ_QUESTION,F_FAQ_ANSWER,F_FAQ_ORDER,F_FAQ_CATEGORY,F_FAQ_TYPE) VALUES ('What is COPPA?','',1,1,17)
INSERT INTO FORUM_FAQ (F_FAQ_QUESTION,F_FAQ_ANSWER,F_FAQ_ORDER,F_FAQ_CATEGORY,F_FAQ_TYPE) VALUES ('Where can I get my own copy of this Forum?','',1,1,18)
INSERT INTO FORUM_FAQ
INSERT INTO FORUM_FAQ
-2147467259 | SQLState: 42000
Native Error Code: 1064
[TCX][MyODBC]You have an error in your SQL syntax near '' at line 1

Also when i open the faq.asp page this error is on top of the faq tabel:

Microsoft VBScript runtime error '800a0005'
Invalid procedure call or argument

/forum/faq.asp, line 125

I changed nothing in faq.asp or in the dbs files.

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts
Posted - 27 January 2004 :  09:18:06  Show Profile  Visit OneWayMule's Homepage  Send OneWayMule an ICQ Message
Delete the FORUM_FAQ and FORUM_FAQ_CATEGORY table from the database and try again.
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

Niox
Starting Member

31 Posts
Posted - 27 January 2004 :  09:28:26  Show Profile
I get the same error
Go to Top of Page

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts
Posted - 27 January 2004 :  09:32:29  Show Profile  Visit OneWayMule's Homepage  Send OneWayMule an ICQ Message
I'm not sure what causes this problem.
I got 2 possible solutions to offer:

1 - add the values manually
2 - don't add the default FAQ (if you can live with that)

I'll investigate what might be the problem and will let you know as soon as I got news.
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

Niox
Starting Member

31 Posts
Posted - 27 January 2004 :  09:51:04  Show Profile
quote:

2 - don't add the default FAQ (if you can live with that)


I tried this. Add one categorie en one question. And now i get this error:

Microsoft VBScript runtime error '800a0005'
Invalid procedure call or argument

/forum/faq.asp, line 125

and the answer of the question isn't displayed.

link: http://www.vermonden.nl/forum/faq.asp
Go to Top of Page

Niox
Starting Member

31 Posts
Posted - 27 January 2004 :  09:56:40  Show Profile
I added the values manually and i didn't get the sql error this time.
But i still got the VBScript runtime error.

http://www.vermonden.nl/forum/faq.asp

[edit]
When i trie to set thhe Faq order this error appears:

ADODB.Recordset.1 error '80004005'
SQLState: 42S22
Native Error Code: 1054
[TCX][MyODBC]Unknown column 'F.FAQ_ID' in 'field list'


/forum/admin_faq_order.asp, line 144
[/edit]
Edited by - Niox on 27 January 2004 09:58:48
Go to Top of Page

Niox
Starting Member

31 Posts
Posted - 04 February 2004 :  05:38:32  Show Profile
quote:
Originally posted by OneWayMule
I'll investigate what might be the problem and will let you know as soon as I got news.


Any ideas yet?
Go to Top of Page

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts
Posted - 04 February 2004 :  06:24:39  Show Profile  Visit OneWayMule's Homepage  Send OneWayMule an ICQ Message
Not yet, sorry.
Will try to test and find out this week.
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

Jezmeister
Senior Member

United Kingdom
1141 Posts
Posted - 21 February 2004 :  10:13:01  Show Profile  Visit Jezmeister's Homepage
any news? ive given up aswell - i resorted to changing faq.asp manually
Go to Top of Page

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts
Posted - 26 February 2004 :  05:17:08  Show Profile  Visit OneWayMule's Homepage  Send OneWayMule an ICQ Message
Haven't had the chance to do a test with MySQL yet.
I'll let you know as soon as I find the time.
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.27 seconds. Powered By: Snitz Forums 2000 Version 3.4.07