| Author |
 Topic Search  Topic Options
|
bobrobert 
Groupie
Joined: 15 February 2007
Status: Offline
Points: 51
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: post approval
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
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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?
|
|
|
|
bobrobert
Groupie
Joined: 15 February 2007
Status: Offline
Points: 51
|
Post Options
Thanks(0)
Quote Reply
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
|
|
123Simples
Senior Member
Joined: 08 July 2007
Location: United Kingdom
Status: Offline
Points: 1192
|
Post Options
Thanks(0)
Quote Reply
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
|
|
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
bobrobert
Groupie
Joined: 15 February 2007
Status: Offline
Points: 51
|
Post Options
Thanks(0)
Quote Reply
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
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
bobrobert
Groupie
Joined: 15 February 2007
Status: Offline
Points: 51
|
Post Options
Thanks(0)
Quote Reply
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
|
|
