| Author |
 Topic  |
|
|
tomasalsbro
Average Member
Sweden
818 Posts |
 Posted - 23 February 2001 : 03:13:31
|
I suddenly received the following after updating:
=========
The database needs to be upgraded !!
The database you are using needs to be upgraded !!
Code : -2147217904
Click here to upgrade the database.
Click here to retry.
================
I use Access 2000 and my strings in config.asp are:
===============
on error resume next
Session.LCID = 1033 '## Do Not Edit
Response.Buffer = true
dim strDBType, strConnString, strTablePrefix, strMemberTablePrefix '## Do Not Edit
'#################################################################################
'## SELECT YOUR DATABASE TYPE AND CONNECTION TYPE (access, sqlserver or mysql)
'#################################################################################
'strDBType = "sqlserver"
strDBType = "access"
'strDBType = "mysql"
'## Make sure to uncomment one of the strConnString lines!
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=d:\inetusers\f-102152\fpdb\snitz_forums_2000.mdb" '## MS Access 97
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/fpdb/snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\dbroot\forum.snitz.com\snitz_forum.mdb;" '## MS Access 2000
'strConnString = "driver={SQL Server};server=SERVER_NAME;uid=SQL_USER;pwd=PASSWORD;database=DATABASE_NAME" '## MS SQL Server 7
'strConnString = "driver=MySQL;server=SERVER_NAME;uid=MYSQL_USER;pwd=PARRWORD;database=DATABASE_NAME" '## MySQL
strTablePrefix = "FORUM_"
strMemberTablePrefix = "FORUM_"
'#################################################################################
============
Is it this trouble that suddenly made my forum lost all graphics and table lines?
I've tryed everthing my limited knowledge aloud me to do so far....
Tomas 
"Learning everyday"
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 23 February 2001 : 04:41:50
|
Well, go ahead and have it upgrade your database then.
Depending on what version your upgrading from, the minimum it does is update the version string in the database so that shows the new version you are using.
The loss of styling probably means you are upgrading from a "all strCookie version" to a newer version were that is fixed.
Upgrading should return your styling. Or else running setup.asp?RC=5 should also do that.
Pierre |
 |
|
|
tomasalsbro
Average Member
Sweden
818 Posts |
Posted - 23 February 2001 : 04:57:09
|
quote:
Well, go ahead and have it upgrade your database then.
Depending on what version your upgrading from, the minimum it does is update the version string in the database so that shows the new version you are using.
The loss of styling probably means you are upgrading from a "all strCookie version" to a newer version were that is fixed.
Upgrading should return your styling. Or else running setup.asp?RC=5 should also do that.
Pierre
Hi Pierre and thanks for your quick replay!
Well, I was not sure what og all the upgrade alternativ I schould use - In fact I'm not sure what version of I have at the moment.
When you say I schould run setup.asp?RC=5 - how do I do that?
Sorry for my lack of probably elementary knowledge - but I'm learning as fast as I can! And for the first time in my (long)life I think this is funny! My neurology said i will never be able to learn advanced things any more due to a car crash (whiplash and brain-damage) - but I will prove him wrong!
Yours truly admireer (or what it schould be spelled)
Tomas Alsbro 
|
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 23 February 2001 : 05:13:51
|
Just forget about the RC=5 thing for a second and have it upgrade the forum, if that doesn't restore the styling, we'll try that next.
The upgrade procedure is error-safe.
That means you can select the oldest version of the forum (the one way down in the selectbox) and have it upgrade from there.
Even if you have a newer version than that, it isn't going to break anything.
You only get a lot of non-critical errors stating that field X allready existed etc.
Try that first and see if the styling is ok after that, if not let me know.
Pierre |
|
|
|
tomasalsbro
Average Member
Sweden
818 Posts |
Posted - 23 February 2001 : 05:22:49
|
quote:
Just forget about the RC=5 thing for a second and have it upgrade the forum, if that doesn't restore the styling, we'll try that next.
The upgrade procedure is error-safe.
That means you can select the oldest version of the forum (the one way down in the selectbox) and have it upgrade from there.
Even if you have a newer version than that, it isn't going to break anything.
You only get a lot of non-critical errors stating that field X allready existed etc.
Try that first and see if the styling is ok after that, if not let me know.
Pierre
I did that without result.
===========
Please Wait until the upgrade has been completed !
Upgraded: Added default values for new fields in CONFIG table
The Upgrade has been completed without errors !
Please Wait until the upgrade has been completed !
Click here to return to the forum....
===========
But when I go further and try to return to the forum I try to enter a topic I receive this when entering:
http://www.whiplash.pp.se/forum/forum.asp?FORUM_ID=5&CAT_ID=2&Forum_Title=F%F6rs%E4kringsl%E4karf%F6reningar " target="_blank"> http://www.whiplash.pp.se/forum/forum.asp?FORUM_ID=5&CAT_ID=2&Forum_Title=F%F6rs%E4kringsl%E4karf%F6reningar
========
ADODB.Recordset error '800a0bb9'
The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another.
/forum/forum.asp, line 197
============
Tomas
|
|
|
|
tomasalsbro
Average Member
Sweden
818 Posts |
Posted - 23 February 2001 : 05:41:29
|
quote:
quote:
Just forget about the RC=5 thing for a second and have it upgrade the forum, if that doesn't restore the styling, we'll try that next.
The upgrade procedure is error-safe.
That means you can select the oldest version of the forum (the one way down in the selectbox) and have it upgrade from there.
Even if you have a newer version than that, it isn't going to break anything.
You only get a lot of non-critical errors stating that field X allready existed etc.
Try that first and see if the styling is ok after that, if not let me know.
Pierre
I did that without result.
===========
Please Wait until the upgrade has been completed !
Upgraded: Added default values for new fields in CONFIG table
The Upgrade has been completed without errors !
Please Wait until the upgrade has been completed !
Click here to return to the forum....
===========
But when I go further and try to return to the forum I try to enter a topic I receive this when entering:
http://www.whiplash.pp.se/forum/forum.asp?FORUM_ID=5&CAT_ID=2&Forum_Title=F%F6rs%E4kringsl%E4karf%F6reningar " target="_blank"> http://www.whiplash.pp.se/forum/forum.asp?FORUM_ID=5&CAT_ID=2&Forum_Title=F%F6rs%E4kringsl%E4karf%F6reningar
========
ADODB.Recordset error '800a0bb9'
The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another.
/forum/forum.asp, line 197
============
Tomas
OK I have gone trough the databas updates without result. I receive the same message:
========
The database needs to be upgraded !!
The database you are using needs to be upgraded !!
Code : -2147217904
Click here to upgrade the database.
Click here to retry.
========
What's confuse me is that it stated that I have Access 97 - in fact I have Access 2000(well that doesn't show up here above)
Tomas
|
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 23 February 2001 : 06:10:25
|
The fact that the upgrade talks about Access 97 while you use Access 2000 is no problem. There is no difference in upgrading either of them.
In you first post you posted this line:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/fpdb/snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
If you really are using the datbase file named snitz_forums_2000.mdb in /fpdb I can understand that this doens't work.
That database isn't a Snitz database, there are only two tables in there, but not the ones needed.
Pierre |
|
|
|
tomasalsbro
Average Member
Sweden
818 Posts |
Posted - 26 February 2001 : 01:28:50
|
quote:
The fact that the upgrade talks about Access 97 while you use Access 2000 is no problem. There is no difference in upgrading either of them.
In you first post you posted this line:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/fpdb/snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
If you really are using the datbase file named snitz_forums_2000.mdb in /fpdb I can understand that this doens't work.
That database isn't a Snitz database, there are only two tables in there, but not the ones needed.
Pierre
Well Pierre, I'v tryed everything you suggested. I'm using the snitz_forums_2000.mdb in /fpdb and tryed to upgrade through all the alternatives in the uppgrade databas form without success. This is the last part of the message I receive:
=======
Error: -2147217900 There is no field named 'F_PASSWORD' in table 'FORUM_FORUM'.
strUpdateSql: ALTER TABLE FORUM_FORUM DROP COLUMN F_PASSWORD
Upgraded: Added default values for new fields in CONFIG table
Error: -2147217900 Table 'FORUM_ALLOWED_MEMBERS' already exists.
strUpdateSql: CREATE TABLE FORUM_ALLOWED_MEMBERS (MEMBER_ID INT NOT NULL, FORUM_ID INT NOT NULL, CONSTRAINT FORUM_SnitzC373 PRIMARY KEY (MEMBER_ID, FORUM_ID) )
Upgrading: Starting transferring Member List to ALLOWED_MEMBERS table
Critical error: Error while getting Memberlist for transfer
Upgrading: Transferring of Member List to ALLOWED_MEMBERS table was NOT succesfull !
Upgraded: Added default values for new fields in CONFIG table
=========
Tomas 
|
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 26 February 2001 : 01:48:41
|
No offence, but you are not listening to/reading what I'm trying to tell you:
The database /fpdb/snitz_forums_2000.mdb at your site isn't a valid Snitz Forums 2000 database !!
I know because I was able to dowload it by just typing http://www.whiplash.pp.se/fpdb/snitz_forums_2000.mdb
You can try to upgrade that database a 1000 times, but it just wont work!
You say you are trying to upgrade, well then I hope you've got a copy of your database somewhere else, because it isn't that database file in /fpdb/
If you replace that databse with the default database supplied with the forum, it all probably will work ok, but with that file there it will never work.
(don't want to yell at you, was just trying to be really clear this time)
Pierre |
|
|
|
tomasalsbro
Average Member
Sweden
818 Posts |
Posted - 26 February 2001 : 02:29:42
|
quote:
No offence, but you are not listening to/reading what I'm trying to tell you:
The database /fpdb/snitz_forums_2000.mdb at your site isn't a valid Snitz Forums 2000 database !!
I know because I was able to dowload it by just typing http://www.whiplash.pp.se/fpdb/snitz_forums_2000.mdb
You can try to upgrade that database a 1000 times, but it just wont work!
You say you are trying to upgrade, well then I hope you've got a copy of your database somewhere else, because it isn't that database file in /fpdb/
If you replace that databse with the default database supplied with the forum, it all probably will work ok, but with that file there it will never work.
(don't want to yell at you, was just trying to be really clear this time)
Pierre
That's OK Pierre, things go wrong in my head after a carcrash and braindamage(se my homepage).
How on earth has the databas changed from beeing a valid Snitz Forums 2000 database to a nonvalid one? I need to figure out what I have done wrong so I won't repeat that misstake again.
Tomas
|
|
|
| |
Topic |
|
Topic Locked
