| Author |
 Topic  |
|
|
sojdev
Starting Member
43 Posts |
 Posted - 14 July 2001 : 01:50:45
|
Hello all,
I am VERY new to setting this forum up. I'm not overly familiar with ASP but I have managed to cobble scripts together in the past. I'm fairly familiar with Access and I have full admin rights to my webserver.
I'm pretty sure I won't need every detail explained to me, but I can't seem to find and "Install" document. I just need to know what I need to do first to get started setting up my forum. Do I setup the database first? If so what fields are "mandatory" to get up and running?
I'll be using Access to run the forum and utilizing FP2K to upload. The server I'm running the website from is a WIN2K server, with SQL and FP Extension support. I'm not familiar with SQL at all (hence the choice of Access) but I have the go ahead to use Access.
Thanks in advance for ANY help,
Jason
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 14 July 2001 : 01:51:54
|
There should be a readme.txt file in the .zip file you downloaded. It includes basic installation instructions.
There is an Access Database included also which already has all of the Tables setup. |
 |
|
|
sojdev
Starting Member
43 Posts |
Posted - 14 July 2001 : 02:53:41
|
You are absolutely correct. I have found the readme and now (of course) I have new problems. I read a bit farther and loaded up the whereami.asp tool so that I could get the exact location of the database.
My provider told me that I would have to map to the Db physically. So I hope I have done this correctly at least in that respect.
My database is located in the cgi-bin folder, the rest of the ASP pages are located in a sub-folder named 'forum' and the tools are unzipped into 'forum/tools'.
However, when I go to www.sojdev.com/forum/default.asp I get a 500, when I go to www.sojdev.com/forum/config.asp I get a blank page, when I go to www.sojdev.com/forum/setup.asp the page says 'way to go champ, everything works'.
I'm thinking it's supposed to say that regardless <grin>.
I get the same results regardless of the AccessDb version (2000 or 97), I currently have the 2000 version loaded.
Here is the config.asp file:
'strDBType = "sqlserver"
strDBType = "access"
'strDBType = "mysql"
'## Make sure to uncomment one of the strConnString lines!
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\inetpub\dbroot\snitz_forums_2000.mdb" '## MS Access 97
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("D:\Inet\vhost\sojdev\cgi-bin\snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Inet\vhost\sojdev\cgi-bin\snitz_forums_2000.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_"
So am I an idiot? Please say yes, I'd hate to think I have to wait until tomorrow to talk to my provider to get this setup.
Thanks again for the prompt response.
Jason
Edited by - sojdev on 14 July 2001 02:54:46 |
|
|
|
sojdev
Starting Member
43 Posts |
Posted - 14 July 2001 : 03:17:45
|
Ok, did some more research and found the root of the HTTP500 error:
Microsoft VBScript compilation error '800a0401'
Expected end of statement
/forum/default.asp, line 272
valign="top" if rsForum("F_TYPE")="1" then Response.Write(" colspan="4")" % bgcolor="<% =strForumCellColor
-------------^
This tells me that there is a "typo" in the code. I don't know exactly what that would be, but I'll add/delete stuff for a bit to check it out.
|
|
|
|
sojdev
Starting Member
43 Posts |
Posted - 14 July 2001 : 03:51:17
|
I'm going to become a top poster just on this topic, LOL.
Ok, I read in one of the other posts that this error may be caused by a corrupt file, so I re-unzipped the snitz zip file into web folders. This time FP2K told me to setup an fpdb folder and put my database into that. So I did.
I changed the config file to take note of the change as seen below:
'strDBType = "sqlserver"
strDBType = "access"
'strDBType = "mysql"
'## Make sure to uncomment one of the strConnString lines!
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\inetpub\dbroot\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=D:\Inet\vhost\sojdev\fpdb\snitz_forums_2000.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_"
I then uploaded to my webserver and attempted to get to www.sojdev.com/forum/ and received the following error:
Microsoft VBScript compilation error '800a03ee'
Expected ')'
/forum/Default.asp, line 272
if rsForum("F_TYPE")="1" then Response.Write(" colspan="4")" % bgcolor="<% =strForumCellColor
--------------------------------------------------------^
I changed the database to Access2000 and uploaded that and refreshed the page. Same error.
I have to admit that I'm at a loss.
|
|
|
|
sojdev
Starting Member
43 Posts |
Posted - 14 July 2001 : 03:59:15
|
WOOHOO!!! Searched around for that error and found a post from e3stone. He said this particular line should look like this:
<td<% if rsForum("F_TYPE") = 1 then Response.Write(" colspan=4") %> bgcolor="<% =strForumCellColor %>" valign="top">
And guess what!? He is correct!! The forum is working!!!
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 14 July 2001 : 04:11:28
|
Glad you got it working. 
You have to be careful when using Frontpage. It has a habit of modifying files without you wanting it to. That's what caused the errors you had above with the code in the lines. |
|
|
|
sojdev
Starting Member
43 Posts |
Posted - 14 July 2001 : 04:18:47
|
Yeah, I've run into that before, but it's working sweet now.
Now comes the fun part of editing the various forums. I'm assuming at this point that I just have to add them into the database.
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
|
| |
Topic |
|
Topic Locked
