| Author |
 Topic  |
|
|
james0812
Starting Member
United Kingdom
4 Posts |
 Posted - 12 December 2003 : 09:01:11
|
Hi, I am trying to upgrade from 3.3.03 to the latest version, I have followed all the instruction and still having problem :
Old DB was on SQL 7 and I moved it to a new server with SQL 2000.
When I started the upgrade process it took me to a page where it listed out all the processes row by row :
Upgraded: F_DESCRIPTION Field has been changed...etc ... but there are errors on two row as follows :
Error: 80040E37 [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot drop the table 'FORUM_MEMBERS_PENDING', because it does not exist in the system catalog.
strUpdateSql: DROP TABLE FORUM_MEMBERS_PENDING
Also at the bottom of the page :
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'ID', table 'ghanaforum.dbo.FORUM_CONFIG_NEW'; column does not allow nulls. INSERT fails.
/forum2/setup.asp, line 4425
Any idea what might be the problem and how to rectify it?
many many thanks
James |
Edited by - ruirib on 12 December 2003 09:32:42 |
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 12 December 2003 : 09:23:20
|
Don't worry about the first error, it just mean that that particular table doesn't exist in your database, i.e. you didn't have the Members Pending mod installed. Can't be of much help with the second issue, I'm afraid.
|
 Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 12 December 2003 : 09:36:49
|
The 2nd issue is a consequence of the way you created the table in SQL 2000. I would suggest that you setup a 3.3.x forum in SQL 2000, by running setup.asp?RC=5 to create the table structure properly. Then transfer your data from the SQL 7 DB to the SQL 2000 DB, by using DTS, making sure that for each transformation column you set it to delete existing row data and that you choose enable identity insert.
Once the data is transfered from SQL 7 to SQL 2000, upgrade the forum.
If you choose not to follow this path, several problems with table structure might plague you for sometime. The previous path is the surest way to overcome the existing (and future) problems. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
| |
Topic |
|
|
|
Topic Locked
