 |
|
Web Wiz Web Hosting 30 Day Free TrialWindows Hosting 30 Day Free Trial, with no obligation, on all our Windows Web and Reseller Hosting Packages.For more information see our Windows Hosting 30 Day Free Trial page. |
Unable to create New Blog/Newsletter |
Post Reply 
|
| Author | |
pbanks 
Groupie 
Joined: 22 August 2008 Location: Ireland Status: Offline Points: 67 |
 Post Options
 Thanks(0)
 Quote Reply
 Topic: Unable to create New Blog/NewsletterPosted: 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. Edited by pbanks - 05 July 2011 at 2:10pm |
|
 |
|
|
WebWiz-Bruce
Admin Group 
Web Wiz Developer Joined: 03 September 2001 Location: Poole, England Status: Offline Points: 8039 |
Post Options
Thanks(0)
Quote Reply
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. |
|
|
|
|
pbanks
Groupie
Joined: 22 August 2008 Location: Ireland Status: Offline Points: 67 |
Post Options
Thanks(0)
Quote Reply
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 |
|
|
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer Joined: 03 September 2001 Location: Poole, England Status: Offline Points: 8039 |
Post Options
Thanks(1)
Quote Reply
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.
|
|
|
|
|
pbanks
Groupie
Joined: 22 August 2008 Location: Ireland Status: Offline Points: 67 |
Post Options
Thanks(0)
Quote Reply
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 ... |
|
|
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer Joined: 03 September 2001 Location: Poole, England Status: Offline Points: 8039 |
Post Options
Thanks(0)
Quote Reply
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. |
|
|
|
Topic Options|
Post Reply
|
|
Tweet
|
| Forum Jump | Forum Permissions 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 |
