post approval
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=27249
Printed Date: 02 April 2026 at 7:08pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: post approval
Posted By: bobrobert
Subject: post approval
Date Posted: 12 April 2009 at 9:57am
|
I have a member who I want to have post approval as an individual In the individual members permissions I tick the box post approval and the categories and the update members permissions and get a error message Microsoft OLE DB Provider for SQL Server error '80040e2f' Cannot insert the value NULL into column 'Group_ID', table 'db195912349.dbo195912349.tblPermissions'; column does not allow nulls. INSERT fails. /forum/forum/admin_user_permissions.asp, line 122 Is there a solution? TIA Bobrobert
|
Replies:
Posted By: WebWiz-Bruce
Date Posted: 13 April 2009 at 8:38am
|
The error sounds like either a corrupted file or an issue with the setup of the database. First try reuploading the original files again, if that doesn't help need to know more about your database installation, such as if it is an upgrade, has the database been migrated. etc? ------------- 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: bobrobert
Date Posted: 13 April 2009 at 8:46am
| My company 1&1 upgraded my database MSQL last week to 2008 Everything else appears to be functioning ok I will try uploading the files again Thanks for the prompt reply |
Posted By: 123Simples
Date Posted: 13 April 2009 at 10:05am
|
Hi bob If you get stuck let me know because I used to host with that company previously before I discovered Web Wiz ------------- http://www.123simples.com/" rel="nofollow - Visit 123 Simples Web Design |
Posted By: WebWiz-Bruce
Date Posted: 13 April 2009 at 10:51am
|
It sounds like 1&1 didn't do the migration correctly to SQL Server 2008 and the database has lost all it's default values. This could be a BIG problem. I would ask them to roll back your database to your old unmigrated database, or hopefully you may have made a backup before they did the migration. ------------- 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: bobrobert
Date Posted: 13 April 2009 at 6:24pm
|
Thanks for your help I didn't do a back up because I thought there wouldn't be a problem In the past they have stated that they only keep back ups for three days Can you say what you mean by a BIG problem? If I re load all of the files will it cause more problems? As stated the forum appears to be working ok Bobrobert |
Posted By: WebWiz-Bruce
Date Posted: 14 April 2009 at 8:21am
|
There are many different ways to migrate SQL Server databases. Unfortunately some of them particularly with SQL Server 2008 will drop allot of the schema like default values, primary keys, indexes, etc. Although your forum will still run you will have stability problems, performance issues, and errors like the one you have reported here. The only way to fix this would be to place your database and a clean database side by side and go through recreating all the missing schema. I've done this before and it's a long horrible job which takes quite a few hours. I would also look at moving for 1&1 and their track record is not very good. They are actually listed as one of only five windows web hosts that do not fully support our Premium Edition software due to limitations they put in place on their servers. ------------- 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: bobrobert
Date Posted: 14 April 2009 at 3:07pm
|
Thanks for your replies It looks like it is too late to remedy the problems I will wait to see how the problems manifest themselves and make a decision about possibly starting over again You learn by experience Can a corrupted database be moved to a new hosting company and be remedied? I am essentially a newbie learning as I make mistakes Bobrobert |
Posted By: 123Simples
Date Posted: 14 April 2009 at 3:23pm
|
Bob My advice to you would be to http://www.webwiz.net?AID=203" rel="nofollow - move to web wiz hosting because I'm not just saying this, but trust me, you will not regret it I had been with 1 and 1 for a while and it was the best thing I did moving out The problem with your database though may not be fixable as it is already corrupted - however, some of the information may be recoverable. Have you asked 1&1 if they preformed a backup prior to the upgrade as they should have done this at the very least ------------- http://www.123simples.com/" rel="nofollow - Visit 123 Simples Web Design |
Posted By: WebWiz-Bruce
Date Posted: 15 April 2009 at 9:19am
If you moved your Web Wiz Forums hosting to us there is a £19.99 migration fee, which includes going through and correcting any errors in the database. For more information please see the page below:- http://www.webwiz.net/webhosting/community_hosting.asp" rel="nofollow - http://www.webwiz.net/webhosting/community_hosting.asp ------------- 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 |
bobrobert wrote:Posted By: bobrobert
Date Posted: 15 April 2009 at 2:35pm
|
I am now interested in moving my website and forum to Web Wiz for hosting One question I would like answered is: You quote a fee of £ 20.00 for migration? No problem Does this mean that you back up my database and transfer the database and my web files from my present server 1&1 and up load them to your server which means I pass on my password and user details to you or do I do this myself? Your hosting looks attractive Bobrobert |
Posted By: 123Simples
Date Posted: 15 April 2009 at 3:37pm
|
Bob The best thing I can suggest is that you contact the http://www.webwiz.net/contact/contact_sales.asp" rel="nofollow - sales department directly and then I'm sure Bruce will be able to sort this for you. When I transferred from 1&1 to Web Wiz I had a similar situation which required bringing across the database too All I can say is Bruce was absolutely wonderful at helping me through the process. A word of caution though for you - when closing down your 1&1 account - be careful how to navigate the process as their shut down procedure is not made simple - This is http://faq.oneandone.co.uk/contract/2.html" rel="nofollow - their explanation here But to clarify if you are bringing across a domain too, then choose Change provider If you would like your domain to be maintained by another provider (and only then), you must select this option. The change is effected differently for every TLD (Top Level Domain, e.g.: .com). If you choose this option, we will automatically acknowledge a transfer request by another provider How I worked it through with Bruce when I did was I cancelled the domain first, got that away and over to Web Wiz, then when I was happy everything was up and running, I then pulled the plug on the contract ------------- http://www.123simples.com/" rel="nofollow - Visit 123 Simples Web Design |
Posted By: bobrobert
Date Posted: 15 April 2009 at 4:32pm
Thanks I will make contact tomorrow and arrange a contract I would make one point in passing I have a business package with 1&1 and when I had a problem last year with my database I contacted them and they told me that they hadn't done a back up of the database A good reason for leaving them
|
Posted By: 123Simples
Date Posted: 15 April 2009 at 5:42pm
I had a business package too bob but I just had the wrong provider  and I will leave it at that  For what its worth though I do not think you will regret making the move into Web Wiz - its a great company with the personal touch that larger companies often lack nowadays ------------- http://www.123simples.com/" rel="nofollow - Visit 123 Simples Web Design |