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
 Poll mod help?
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Sirius
Starting Member

45 Posts

Posted - 03 April 2001 :  14:35:09  Show Profile
My board: http://utknights.dhs.org/forum/default.asp
I have the following mods installed already:
Category/Forum order
Fader announcements
Events Calender
Avatar 2
Private Messaging

I've taken a first stab at installing the poll mod, and when I click on Set Active Poll, I get the following error:

Microsoft JET Database Engine error '80040e07'

Data type mismatch in criteria expression.

/forum/admin_poll.asp, line 22


Any ideas? Thanks in advance.


Davio
Development Team Member

Jamaica
12217 Posts

Posted - 03 April 2001 :  14:44:13  Show Profile
That error occurs when you haven't selected a poll to be Active. Here are the steps.

1. First, Create a poll.
2. Go in your admin options and select Set Active Poll.
3. Click the Radio button from the list of polls that are shown, for the poll you want to be active.
4. Click Set Active Poll.

Oh, and make sure you have the "Featured Poll" option set to "On" in your Feature Options.

Go to Top of Page

Sirius
Starting Member

45 Posts

Posted - 03 April 2001 :  18:12:13  Show Profile
Okay, let's back up here then. How do you create a poll? I thought that was done from admin, but I guess not. I don't see an option on any of my pages to create a new poll.

Also, when I try to click into an existing topic I now get this error:
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'FORUM_TOPICS.T_MESSAGE FORUM_TOPICS.answer1'.

/forum/topic.asp, line 522


Edited by - Sirius on 03 April 2001 18:20:15
Go to Top of Page

Davio
Development Team Member

Jamaica
12217 Posts

Posted - 03 April 2001 :  22:44:48  Show Profile
A few lines above line 522, you will see where you added the poll mod code. You need to have a comma , after the TOPICS.T_MESSAGE. Should look like this:
	strSql = strSql & strTablePrefix & "TOPICS.TOPIC_ID, " & strTablePrefix & "TOPICS.T_MESSAGE, "
If you correctly entered the code into your files, there should be a "Add Poll" link on your forum.asp and topic.asp pages, where the "New Topic" link is. Click on it and you will create a new poll.

Edited by - Davio on 03 April 2001 22:46:04
Go to Top of Page

Sirius
Starting Member

45 Posts

Posted - 04 April 2001 :  00:05:56  Show Profile
Okay here's where we're at now:

The comma addition helped - I can now get into my existing topics again.
Also, I have my create poll link now - that was my fault. Oops! :o

The only problem left now is I'm getting the "first post in the thread gets duplicated" problem that was mentioned in another thread. You didn't say what you did to fix it for him though.
I can send you any of my files if it would help.
Thanks for your help!

Edited by - Sirius on 04 April 2001 01:29:13
Go to Top of Page

Sirius
Starting Member

45 Posts

Posted - 04 April 2001 :  01:49:31  Show Profile
Never mind. Finally tracked down the problem. Working like a charm now.
Thanks again!

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