| Author |
 Topic  |
|
|
abhilashms
Starting Member
4 Posts |
 Posted - 08 February 2006 : 06:49:52
|
My host recently moved my database to a new host , I am not sure how e moved it at this point , I changed the IP in config.asp and then ran setup.asp
Now I am able to log in and read all the topic
but I cannot create any new objects
If I try to register a memeber
Microsoft OLE DB Provider for SQL Server error '80040e2f'
Cannot insert the value NULL into column 'MEMBER_ID', table 'MyDB.MyUser.FORUM_MEMBERS'; column does not allow nulls. INSERT fails.
/forum/register.asp, line 568
Same kind of errors if I try replying to a post
Microsoft OLE DB Provider for SQL Server error '80040e2f'
Cannot insert the value NULL into column 'TOPIC_ID', table 'MyDB.Myuser.FORUM_TOPICS'; column does not allow nulls. INSERT fails.
/Forum/post_info.asp, line 889
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 08 February 2006 : 06:56:12
|
| Your host didn't move the database correctly. Either they should have followed the directions given here or should have used DTS, but copying objects instead of tables. IMO, the best alternative is for them to do it again, this time doing it correctly. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 08 February 2006 : 15:21:54
|
Were you using SQL Server before the move ?
In your config.asp, what sort of database does it say that you are using ? |
|
|
|
abhilashms
Starting Member
4 Posts |
Posted - 10 February 2006 : 07:19:21
|
Hm... got in touch with my hosting service.. apparently I am in a little situation , the original file is now lost.. So I guess I need to fix this the hardway. I understand the issue is with the identity columns getting messed up .
but since my site itself is very new there are hardly 40 + messages ,Is there some other way to fix this |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 10 February 2006 : 07:26:00
|
Does your question mean that you wouldn't mind losing the existing forum data?
The issue with the migration as it was done means that not only identity keys, but also default values, may not have been properly defined in the new database. The surest way would be to recreate the database. Before doing it, you could move the existing data into an Access DB and then import it back, after recreating the database, using the directions in the link I posted in my earlier reply.
To recreate the database with the proper structure, you just beed to run setup.asp like this: setup.asp?RC=5
|
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
abhilashms
Starting Member
4 Posts |
Posted - 10 February 2006 : 07:37:19
|
Thanks Ruirib
I created a brand new databse , I created the tables using setup.asp ,
So now I have all the tables and everything is good.
Now I am frantically searching for my Acess installation cd
Meanwhile just wondering Is it possible now to transfer the data using T-SQL , bcp from my old tables to my new tables?
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
abhilashms
Starting Member
4 Posts |
Posted - 10 February 2006 : 07:58:19
|
From our Office I am not able to connect using Enterprise Manager :(,
That port must be blocked possibly. I only have a web based enerprise manger provided by the site :(
As I said I have 23 users , around 40 + topic threads.. might be easier to do it using plain old T-SQL that installing enterprise manager on some other machine outside office netwok . and then doing it |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 10 February 2006 : 08:03:42
|
| I don't know the web enterprise manager. Could it be used to do this, while preserving identity values? bcp I don't know it that well, hardly ever used it, but the process using T-SQL would be too tedious... several tables would need copying... |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
| |
Topic |
|
Topic Locked
