| Author |
 Topic  |
|
|
lin
Starting Member
18 Posts |
 Posted - 05 July 2003 : 11:54:03
|
After uppgrading from access db to sql db and transfered all exsiting members and posts I see no posts at all in the forum, but when I press active topics - all the posts are there!!...
Why is that and what has happend, how can I fix this? |
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
|
|
lin
Starting Member
18 Posts |
Posted - 05 July 2003 : 17:20:37
|
Sorry but I'm behind a firewall....
Do you have any ideas of what I might check? |
 |
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
|
|
lin
Starting Member
18 Posts |
Posted - 06 July 2003 : 01:45:05
|
I have now found the problem I belive.
When I made the import from access to SQL with DTS there where this problem with the FORUM_FORUM table....
Error at destination for row number 1. Errors encountered so far in ths task: 1
Insert error, column 27 ('F_DELETE', DBTYPE_WSTR), status 10: Integrety violatio; attempt to insert NULL data or data which violates constraints.
Insert error, column 25 ('F_LARCHIVE', DBTYPE_WSTR), Status 10: Integrety violation; attempt to insert NULL data or data which violates constraints.
Unspecified error
When I check that table, there haven't been any data entered in that one so thats why no posts show up. But why is this, and how can I correct it? |
|
|
|
lin
Starting Member
18 Posts |
Posted - 06 July 2003 : 03:39:09
|
Hmmm
I did the import data once more and didn't transfer the FORUM_FORUM table and that worked.
Hope this was the right thing to do.
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 06 July 2003 : 05:25:53
|
So right now you have no FORUM_FORUM table in the SQL Server DB?
Those error messages probably mean that those columns have values in your current Access tables that are not allowed in the SQL Server Db. Can you have a look at your table and check what those values are?
This is weird, never saw an error happen with those two columns, but I'm sure it can be overcome. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
lin
Starting Member
18 Posts |
Posted - 06 July 2003 : 06:21:44
|
I do have the original FORUM_FORUM table created by Snitz, I just skipped that table when I transfered the access data to sql server.
I then just changed the text in FORUM_FORUM so that it reflected the text entered in the original Access database.
Seem to work. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
| |
Topic |
|
Topic Locked
