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
 What's up with the F.A.Q. Administration MOD
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

brduran
New Member

Canada
98 Posts

Posted - 12 May 2003 :  18:49:33  Show Profile  Visit brduran's Homepage
Judging by the title of this topic you probably expect to find an outraged user. But no, this is just to save you some time if you make the same mistake I did.

If you install the "F.A.Q. Administration MOD" and try to post a question like: What's the Capital of Canada?

You'll find that it'll give you an error message like this
quote:
Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error (missing operator) in query expression "What's the Capital of Canada?', ' ')'.
/forum/admin_faq.asp, line 383

It happens when you type a question with an apostrofe(') in it. Only in the Question Text, not in the Answer Text. Don't ask me why, I just know so by trial and error.

Other than that. What an excellent MOD!

By the way the answer is Vancouver.


Bernardo Duran
www.teknician.com


Edited by - brduran on 12 May 2003 19:23:51

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts

Posted - 13 May 2003 :  14:59:12  Show Profile  Visit OneWayMule's Homepage  Send OneWayMule an ICQ Message
This is a bug I'm aware of - will be fixed in the next release (in about 2 weeks).

You can fix it by changing 2 lines in admin_faq.asp:

1. change line 343:
	   strFormT = ChkString(strFormT,"title")


to
	   strFormT = ChkString(strFormT,"SQLString")



2. change line 379
	   strFormT = ChkString(strFormT,"title")


to
	   strFormT = ChkString(strFormT,"SQLString")

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

brduran
New Member

Canada
98 Posts

Posted - 14 May 2003 :  11:17:57  Show Profile  Visit brduran's Homepage
Voila' Problem solved indeed.

Thank you very much, OneWayMule.


Bernardo Duran
www.teknician.com

Go to Top of Page

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts

Posted - 14 May 2003 :  11:19:25  Show Profile  Visit OneWayMule's Homepage  Send OneWayMule an ICQ Message
You're welcome!

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.33 seconds. Powered By: Snitz Forums 2000 Version 3.4.07