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
 Polls Mod: problem with Show Featured Poll		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

bellan
Starting Member

7 Posts
Posted - 22 April 2001 :  14:25:37  Show Profile  Visit bellan's Homepage
I have just installed the MOD: Poll (by slemieux), and it works ok. The problem I have got is when I click 'Show Featured Poll' to 'On', I get the error message:

Featured Poll:
Microsoft OLE DB Provider for ODBC Drivers error '80020009'
"Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
?

I tried doing a fresh installation of the forum and database to see if that would help, but I got exactly the same error. www.banzaitv.com/forum/default.asp is what happens when 'Show Featured Poll' is off and www.banzaitv.com/forum1/default.asp is what happens when 'Show Featured Poll' is on.

I am using MS SQL7.

Thanks in advance if anyone has got any ideas.

Andy





Edited by - bellan on 22 April 2001 14:28:31

Davio
Development Team Member

Jamaica
12217 Posts
Posted - 23 April 2001 :  10:52:33  Show Profile
aaah, well I would need help from the other guys when it comes to MS SQL errors. But in the mean time do this: In the admin_config_features.asp file put Response.Write strSql right before my_Conn.Execute (strSql). Then do what you did before to get the error. When you get the error copy and paste the SQL code here.

You could also try changing these two lines:
On: <input type="radio" name="strAdminPolls" value="1"<% if strAdminPolls <> "0" then Response.Write(" checked") %>>

On: <input type="radio" name="strUserPolls" value="1"<% if strUserPolls <> "0" then Response.Write(" checked") %>>
to this:
On: <input type="radio" name="strAdminPolls" value="1"<% if strAdminPolls = "1" then Response.Write(" checked") %>>

On: <input type="radio" name="strUserPolls" value="1"<% if strUserPolls = "1" then Response.Write(" checked") %>>
in the same file. One is for the "Show Featured Poll:" and the other is for the "Allow member Polls:".
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts
Posted - 23 April 2001 :  13:07:26  Show Profile  Visit HuwR's Homepage
This error is generated by some versions of the ado drivers. What it is trying to tell you, but not very well is that in your select statement, there is a memo field (in this case T_MESSAGE) which is not the last item in the select list.

it needs to be moved so that it appears last in the select list.
Go to Top of Page

bellan
Starting Member

7 Posts
Posted - 24 April 2001 :  07:56:42  Show Profile  Visit bellan's Homepage
Thanks very much for the ideas, HuwR and Davio. I'll have a bash at trying out your suggestions tomorrow (I'm monster busy today!), and I'll let you know how I get on.
Go to Top of Page

Davio
Development Team Member

Jamaica
12217 Posts
Posted - 24 April 2001 :  11:37:08  Show Profile
Ok HuwR, I don't understand this.
In some of the SQL statements in the forum files, T_MESSAGE isn't the last one in the SELECT statement, but yet it runs fine. Why does it throw an error now, when adding more fields to the SELECT statement?

Ok, bellan. Don't do what I asked you to do before. On HuwR's suggestion you're gonna edit your default.asp file. Look for the '########### Poll Mod ############# code. In the first SQL statement right after this line: '## Forum_SQL - Get Poll change it to this:
strSql = "SELECT  " & strTablePrefix & "TOPICS.TOPIC_ID, " &
strTablePrefix & "TOPICS.FORUM_ID, " &
strTablePrefix & "TOPICS.CAT_ID, " &
strTablePrefix & "TOPICS.T_SUBJECT, " &
strTablePrefix & "TOPICS.answer1,  " &
strTablePrefix & "TOPICS.count1, " &
strTablePrefix & "TOPICS.answer2,  " &
strTablePrefix & "TOPICS.count2, " &
strTablePrefix & "TOPICS.answer3,  " &
strTablePrefix & "TOPICS.count3, " &
strTablePrefix & "TOPICS.answer4,  " &
strTablePrefix & "TOPICS.count4, " &
strTablePrefix & "TOPICS.answer5,  " &
strTablePrefix & "TOPICS.count5, " &
strTablePrefix & "TOPICS.answer6,  " &
strTablePrefix & "TOPICS.count6, " &
strTablePrefix & "TOPICS.answer7,  " &
strTablePrefix & "TOPICS.count7, " &
strTablePrefix & "TOPICS.answer8,  " &
strTablePrefix & "TOPICS.count8, " &
strTablePrefix & "FORUM.F_SUBJECT, " &
strTablePrefix & "CONFIG.C_ACTIVEPOLL, " &
strTablePrefix & "TOPICS.T_MESSAGE "
The code should be all on one line. I broke it up so the page wouldn't scroll. Let me know if it works.

Edited by - Davio on 24 April 2001 11:46:36
Go to Top of Page

bellan
Starting Member

7 Posts
Posted - 04 May 2001 :  10:18:35  Show Profile  Visit bellan's Homepage
thanks very much, that worked.

If I want to make a donation, is Michael Anderson the best person to make it to? It seems there are lots of other people doing the work these days.
Go to Top of Page

Davio
Development Team Member

Jamaica
12217 Posts
Posted - 07 May 2001 :  15:33:25  Show Profile
Go here:
http://forum.snitz.com/donations.asp
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.36 seconds. Powered By: Snitz Forums 2000 Version 3.4.07