| Author |
 Topic  |
|
|
lockstock
Starting Member
United Kingdom
13 Posts |
 Posted - 30 June 2010 : 10:00:10
|
Hi,
Made a school boy error by not backing up the forum when adding new files.
1) Saw there was an upgrade from 3.4.06 to 3.4.07
2) Downloaded it and began to transfer the files manually in batches of three then checked to see if the web site was okay.
3) Got to the config.asp file and of course that is when the error message kicked in. :-
There has been a problem...
Your strDBType is not set, please edit your config.asp
to reflect your database type.
The forum is :- http://www.leedsu-forum.org.uk/
I have attempted to follow the instructions in the config.asp file, but to no avail.
Can anyone help, I don't have an old 3.4.06 config.asp file. However I do have a 3.4.04 file but that also has errors in, ( it allows me to see the website and its contents but not the posted comments etc.) |
Edited by - lockstock on 30 June 2010 10:01:40 |
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 30 June 2010 : 10:09:23
|
In "config.asp" look for the following lines (appx 55-57 ):
You need to remove the apostrophe from the front of the line which applies. In the case of Access, line 56. |
 |
|
|
lockstock
Starting Member
United Kingdom
13 Posts |
Posted - 30 June 2010 : 14:52:57
|
Thanks for the reply CF
I have done that but I am still getting the same error message.
How do I address the next statement below that, at present I have altered line 63
'## Make sure to uncomment one of the strConnString lines and edit it so that it points to where your database is!
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(""dbase/snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/USERNAME/db/snitz_forums_2000.mdb") '## MS Access 2000 on Brinkster
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\dbase\snitz_forums_2000.mdb" '## MS Access 2000 using physical path
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath(2../private/snitz_forums_2000.mdb") '## MS Access 97 using virtual path
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/USERNAME/db/snitz_forums_2000.mdb") '## MS Access 97 on Brinkster
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\inetpub\dbase\snitz_forums_2000.mdb" '## MS Access 97 using physical path
'strConnString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & Server.MapPath("dbase/snitz_forums_2000.accdb") '## MS Access 2007 using virtual path
'strConnString = "Provider=SQLOLEDB;Data Source=SERVER_NAME;database=DB_NAME;uid=UID;pwd=PWD;" '## MS SQL Server 6.x/7.x/2000 (OLEDB connection)
'strConnString = "driver={SQL Server};server=SERVER_NAME;uid=UID;pwd=PWD;database=DB_NAME" '## MS SQL Server 6.x/7.x/2000 (ODBC connection)
'strConnString = "Provider=SQLNCLI;server=SERVER_NAME;database=DB_NAME;uid=UID;pwd=PWD;" '## MS SQL Server 2005 w/ SQL Native Client
'strConnString = "driver={MySQL ODBC 3.51 Driver};option=16387;server=SERVER_IP;user=UID;password=PWD;DATABASE=DB_NAME;" '## MySQL w/ MyODBC v3.51
'strConnString = "driver=MySQL;server=SERVER_IP;uid=UID;pwd=PWD;database=DB_NAME" '## MySQL w/ MyODBC v2.50
'strConnString = "DSN_NAME" |
Edited by - lockstock on 30 June 2010 14:53:42 |
|
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 30 June 2010 : 15:33:03
|
| Look in the functional (with errors) "config.asp" file and copy the uncommented (missing apostrophe) line which defines the "strConnString" variable into your new "config.asp" file. |
|
|
|
lockstock
Starting Member
United Kingdom
13 Posts |
Posted - 30 June 2010 : 15:49:31
|
Hello again- CF
www.leedsu-forum.org.uk
Got a little bit further,I can now see the forum again, but when you click on a topic, you cannot open it and I am getting this message
Microsoft VBScript runtime error '800a01c3'
Object not a collection
/topic.asp, line 1349
NB: I have only uploaded half the new files 3.4.06 up 3.4.07, could this be the problem?
Is there any way you could sort this out from your end? In years gone by, the mod from Portugal used to help us out. |
Edited by - lockstock on 30 June 2010 15:56:51 |
|
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 30 June 2010 : 17:09:26
|
Having only uploaded half the files could definitely have an impact lol. Since I have no idea which were uploaded and which were not, we could be fixing an error at a time for quite a while. It would be best to finish the upgrade and upload all of the new files, then we can see what has to be done. Do not re-upload config.asp  |
|
|
|
lockstock
Starting Member
United Kingdom
13 Posts |
Posted - 30 June 2010 : 17:32:29
|
Okay, 
As you can see, I am a bit of a novice when it comes to all of this, I do my best, but some times it's akin to wading through treacle.
I will finishing uploading all the files from the upgrade folder 3.4.06 up 3.4.07. and then report back.
Cheers |
|
|
|
lockstock
Starting Member
United Kingdom
13 Posts |
Posted - 30 June 2010 : 17:55:59
|
Wahey,
back up and running. It was the missing files :-)
Lost some of the mods though, calendar, who is online. the section that allows you to separate the run of the mill topics from the more important topics.
The above 3 are the ones that readily spring to mind and stand out as missing, I cannot remember if the latter is a mod or just a function with in the forum. |
|
|
| |
Topic |
|
Topic Locked
