Web Wiz Forums - Poll Creation Problem

Print Page | Close Window

Poll Creation Problem

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=24926
Printed Date: 04 April 2026 at 8:11am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Poll Creation Problem

Posted By: SSRR
Subject: Poll Creation Problem
Date 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

Replies:

Posted By: Jono
Date 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?

Posted By: SSRR
Date 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.

Posted By: Jono
Date 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).