| Author |
 Topic  |
|
rneuner
Starting Member
23 Posts |
 Posted - 24 June 2002 : 13:43:47
|
Hey folks,
I am trying to configure an upgrade from an older version of snitz and am getting the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'CAT_ORDER'.
/forums/default.asp, line 100
Any ideas? I am hoping that I am just being dumb and that its something simple. Thanks for your help.
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
rneuner
Starting Member
23 Posts |
Posted - 24 June 2002 : 13:50:48
|
i downloaded the upgraded version into a separate test folder and am trying to link the current database from the old forum up to this new version...
|
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 24 June 2002 : 13:54:09
|
You can do that without running setup.asp. And running setup.asp will change your database structure. I'm admiting that you have a version prior to 3.3 (possibly 3.1, since CAT_ORDER didn't exist in 3.1).
Maybe you should just backup your current database and upgrade it using setup.asp. Otherwise create a blank DB, use DTS to export all DB objects and run setup.asp over the new DB.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
rneuner
Starting Member
23 Posts |
Posted - 24 June 2002 : 15:58:42
|
ok, so we created a new DB and used DTS to export everything. I am now running the new version, but still getting the same error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'CAT_ORDER'.
/forums/iii/default.asp, line 100
any ideas? perhaps I didn't run the right upgrade -- should i do it again?
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 24 June 2002 : 16:17:48
|
Did you run setup.asp? Did it ask you if you wanted to upgrade your database?
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
rneuner
Starting Member
23 Posts |
Posted - 24 June 2002 : 16:18:22
|
yes, and yes.
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 24 June 2002 : 16:47:50
|
Did setup.asp show any message at all, when upgrading your DB or after doing it?
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
rneuner
Starting Member
23 Posts |
Posted - 24 June 2002 : 16:49:38
|
yes, it said that the upgrade was successful. there were clearly some changes -- now i have access to the members list, and the snitz 2000 logo is in the upper left corner (whereas it used to not be), but i get that same error.
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 24 June 2002 : 16:56:55
|
Did you have a look at the database, maybe with Enterprise Manager? Does the CAT_ORDER column exist?
Also can you provide a link to a text version of your default.asp?
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
rneuner
Starting Member
23 Posts |
Posted - 25 June 2002 : 09:00:12
|
we have looked through the database but cannot seem to figure out which table CAT_ORDER is in.
nothing in the default.asp file was changed from when i downloaded it yesterday...
|
|
|
|
rneuner
Starting Member
23 Posts |
Posted - 25 June 2002 : 09:03:17
|
also, when i go to update the counts, i get similar errors in all of the four steps, including one on the R_STATUS and one on the F_A_COUNT:
Updating Counts Step 4 of 4
Totals: Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'F_A_TOPICS'.
/forums/iii/admin_count.asp, line 352
|
|
|
|
rneuner
Starting Member
23 Posts |
Posted - 25 June 2002 : 09:38:38
|
nevermind, we fixed it. thanks so much for your help!
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 25 June 2002 : 09:46:18
|
You're welcome  , but since we're into this maybe you can tell me what was going wrong...
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
rneuner
Starting Member
23 Posts |
Posted - 26 June 2002 : 16:37:22
|
I was running the upgrade and choosing the wrong old version to upgrade from...
NOW, there's a new problem, and I am getting this same error on 5 different boards that I have just upgraded:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]The column prefix 'FORUM_FORUM' does not match with a table name or alias name used in the query.
/usergroups/forums/iii/default.asp, line 211
Why would they all be doing this exact same thing? We looked in the database and there is a table called FORUM_FORUM but no column. And when I search default.asp I can't anything calling FORUM_FORUM.
Any ideas?
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 26 June 2002 : 17:09:12
|
Try upgrading again, this time from the correct version. And next time, maybe check an upgrade imediately after doing it, to find out whether it was successful or not?
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
Topic |
|
Topic Locked
