Poll Creation Problem

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
SSRR Members Profile Find Members Posts Newbie Joined: 19 August 2006 Status: Offline Points: 16	Post Options Post Reply Quote SSRR Report Post Thanks(0) Quote Reply Topic: Poll Creation Problem 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

Jono Members Profile Find Members Posts Mod Builder Group Joined: 18 September 2006 Location: United Kingdom Status: Offline Points: 100	Post Options Post Reply Quote Jono Report Post Thanks(0) Quote Reply 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?

SSRR Members Profile Find Members Posts Newbie Joined: 19 August 2006 Status: Offline Points: 16	Post Options Post Reply Quote SSRR Report Post Thanks(0) Quote Reply 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.

Jono Members Profile Find Members Posts Mod Builder Group Joined: 18 September 2006 Location: United Kingdom Status: Offline Points: 100	Post Options Post Reply Quote Jono Report Post Thanks(0) Quote Reply 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).

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum