Creating a poll causes an error


Hi I was hoping someone might be able to point us in the correct direction with a strange error we are getting when trying to post with a poll. When the error appears it still creates the post but without the poll feature.

Any ideas.

Screen grab attached.

Ant

P.S still running 2013-2 as we cant get 2015 to work correctly yet!
Attachments
Poll error.jpg (1 view, 546.00 KB)
Edited
9 Months Ago by G4OC

Hi Ant,

Great to hear from you. Thank you for posting. I'm sorry to hear of the trouble. 

Thankfully I do know what's causing this. This was an issue that effected customers upgrading from 4.1.4 to newer versions. You can read more on this issue and find steps to resolve the problem within the following knowledgebase article...

http://support.instantasp.co.uk/Knowledgebase/12625/Cannot-insert-null-exception-after-upgrading-from-InstantForum-414-to-2010-or-above

Once you've added default values for the columns specified within the article this should resolve the problem. 

If this is the only column effected you could also run the following TSQL to add the default value via code...

ALTER TABLE InstantForum_Polls
ADD CONSTRAINT InstantForum_Polls_Closed
DEFAULT 0 FOR Closed;


I hope this helps Ant. 
If the problem persists of course please don't hesitate to respond,

http://www.instantasp.co.uk/images/line.gif
Kindest Regards,

Ryan Healey



ryan@instantasp.co.uk
www.instantasp.co.uk
Blog | Community | Docs

http://www.instantasp.co.uk/core/assets/images/email/facebook.png http://www.instantasp.co.uk/core/assets/images/email/twitter.png http://www.instantasp.co.uk/core/assets/images/email/google.png http://www.instantasp.co.uk/core/assets/images/email/linkedin.png

Hi Ryan

That has worked a treat many thanks!

Ant
GO

Login
Existing Account
Email Address:


Password:


Social Logins

Select a Forum....








InstantASP Forums


Search