Web Wiz NewsPad - Unable to create New Blog/Newsletter

Print Page | Close Window

Unable to create New Blog/Newsletter

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz NewsPad
Forum Description: Support forum for the Web Wiz NewsPad application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=29499
Printed Date: 29 March 2026 at 10:15am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Unable to create New Blog/Newsletter

Posted By: pbanks
Subject: Unable to create New Blog/Newsletter
Date Posted: 05 July 2011 at 1:49pm

Hi there ...

As soon as I try and save either a blog or a Newsletter I'm thrown into a 500 error. The file killing the process is http://irishdogs.ie/newspad/admin_save_editor_data.asp so I wonder if there is some permissioning problem here?

OK, this ONLY happens when trying to create a New Blog. Editing old stuff seems to be OK.

P.S. this Beta 2

Of course, I badly need to get a Newsletter out and it's killing me ...

Thanks.

Replies:

Posted By: WebWiz-Bruce
Date Posted: 05 July 2011 at 2:19pm

Would need a detailed error messaging including line number from the server, not just the generic 500 error message, to know what the issue is.

If your website is not returning detailed error messages contact your web host and ask them to enabled detailed error messaging for classic ASP for your website.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: pbanks
Date Posted: 05 July 2011 at 3:40pm

Detailed error message as follows:

Microsoft OLE DB Provider for SQL Server error '80040e2f'

Cannot insert the value NULL into column 'Description', table 'db1067200_ForumNews.dbo.tblNPNewsletter'; column does not allow nulls. INSERT fails.

/newspad/admin_save_editor_data.asp, line 195

Posted By: WebWiz-Bruce
Date Posted: 05 July 2011 at 4:34pm

Will need to change the database upgrade to fix this but for the moment you need to delete the field 'Description' from the database table tblNPNewsletter as this field is no longer used.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: pbanks
Date Posted: 05 July 2011 at 4:59pm

Cool ... glad I picked this up for you!

Newsletter and blog now going out successfully to my 3,000+ subscribers ...

Posted By: WebWiz-Bruce
Date Posted: 05 July 2011 at 5:26pm

Have updated the database update for the next beta to remove the old columns to prevent others who are upgrading from having the same issue.

We have been using it ourselves for blogs and eNewsletters and so far only found some minor issues, but if you do find any let us know as I don't think many people have taken the plunge so far and have upgraded.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting