Web Wiz Support and Community Forums : Poll Creation Problem https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 04 Apr 2026 08:15:35 +0000 Sat, 01 Dec 2007 14:04:54 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=24926 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Poll Creation Problem : If you&#039;re running 8.05 then...]]> https://forums.webwiz.net/poll-creation-problem_topic24926_post129738.html#129738 Author: Jono
Subject: 24926
Posted: 01 December 2007 at 2:04pm

If you're running 8.05 then it's probably a different field that's returned (probably some form of ID as it is a CLng error).
Upgrades from Access to SQl can be awkward. You'll need to find out what the field types and constraints should be and then ensure you live database is configured the same (you could do this by creating a blank database and running the forum setup script - your SQL guru may need to do this).
]]> Sat, 01 Dec 2007 14:04:54 +0000 https://forums.webwiz.net/poll-creation-problem_topic24926_post129738.html#129738 <![CDATA[Poll Creation Problem : Oops, just spotted it&#039;s 8.05a,...]]> https://forums.webwiz.net/poll-creation-problem_topic24926_post129737.html#129737 Author: SSRR
Subject: 24926
Posted: 01 December 2007 at 12:39pm

Oops, just spotted it's 8.05a, so I'm technically in the wrong forum. I think the backend is SQL Server.

I believe we migrated from Access to SQL Server, and from that point onwards polls were broken.
]]> Sat, 01 Dec 2007 12:39:51 +0000 https://forums.webwiz.net/poll-creation-problem_topic24926_post129737.html#129737 <![CDATA[Poll Creation Problem : Error &#039;800a005e&#039;is &#034;invalid...]]> https://forums.webwiz.net/poll-creation-problem_topic24926_post129736.html#129736 Author: Jono
Subject: 24926
Posted: 01 December 2007 at 12:07pm

Error '800a005e' is "invalid use of null". It looks like the SQL query has returned NULL for the field "Poll_question" from the tblPoll table.
boRg may be able to offer better assistance, however, we could do with knowing what version of WWF you're running and on which database type.
Have you had polls before or is this the first time you've tried?
]]> Sat, 01 Dec 2007 12:07:57 +0000 https://forums.webwiz.net/poll-creation-problem_topic24926_post129736.html#129736 <![CDATA[Poll Creation Problem : Hi folks,When I try to view or...]]> https://forums.webwiz.net/poll-creation-problem_topic24926_post129734.html#129734 Author: SSRR
Subject: 24926
Posted: 01 December 2007 at 11:32am

Hi folks,

When I try to view or create a poll in the forum I get the following error:

Microsoft VBScript runtime error '800a005e'

Invalid use of Null: 'CLng'

/forum/includes/poll_display_inc.asp, line 93


I'm not the technical person who setup the forum, but I can forward any advice to our developer if it's a complex solution.


Thanks


]]> Sat, 01 Dec 2007 11:32:50 +0000 https://forums.webwiz.net/poll-creation-problem_topic24926_post129734.html#129734