Author |
Topic  |
|
scubadollar
Starting Member
12 Posts |
Posted - 21 March 2006 : 16:15:39
|
Ok, I have fixed the include file problems I think but now I am having trouble when I try and open my setup file in Internet explorer. I get the following message:
Active Server Pages error 'ASP 0135'
Cyclic Include
/forum/config.asp, line 1
The file 'config.asp' is included by itself (perhaps indirectly). Please check include files for other Include statements.
Um... ??? I see at the top of my Config.asp file is an include statement with config.asp in it... is this not supposed to be there or?
Cheers
$
|
Edited by - scubadollar on 23 March 2006 07:20:49 |
|
Classicmotorcycling
Development Team Leader
    
Australia
2085 Posts |
Posted - 21 March 2006 : 16:40:27
|
now that you are on IIS6 your include file statements are in correct for the site.. The need to be:<!--#include file="config.asp"--> You may need to change all the includes to react the same way.
If you wish to call include files from outside your forum folder, or from outside your forum folder, then you need to do something like this:<!--#include file="../forum/config.asp"--> or:<!--#include virtual="/forum/config.asp"--> I am not sure if your host allows the virtual statement.
I hope that helps..
|
Cheers, David Greening |
Edited by - Classicmotorcycling on 21 March 2006 16:40:58 |
 |
|
scubadollar
Starting Member
12 Posts |
Posted - 21 March 2006 : 16:53:13
|
Sounds like excellent advice but as I am truly an Amateur, I have no idea where to find the include files and then how to change them. Just point me in the right direction if ya could..
Thanks $ |
 |
|
scubadollar
Starting Member
12 Posts |
Posted - 22 March 2006 : 12:26:50
|
Okay,
I went and changed all the include files in every asp file to show my root and forum folder on my remote host. <!--#include file="scubadollar/forum/config.asp"-->
Now I am getting this error Active Server Pages error 'ASP 0135'
Cyclic Include
/forum/config.asp, line 1
The file 'config.asp' is included by itself (perhaps indirectly). Please check include files for other Include statements.
Also, what file should I direct my link to, default.asp or? Is this the problem or did I do something wrong by changing the include file.
Cheers
$
|
 |
|
Classicmotorcycling
Development Team Leader
    
Australia
2085 Posts |
Posted - 22 March 2006 : 13:01:19
|
Just use this as your include: <!--#include file="config.asp"-->
You do not need the: scubadollar/forum/
|
Cheers, David Greening |
 |
|
scubadollar
Starting Member
12 Posts |
Posted - 22 March 2006 : 16:06:42
|
Do I have to go into every include line and replace it with this? |
 |
|
Classicmotorcycling
Development Team Leader
    
Australia
2085 Posts |
Posted - 23 March 2006 : 16:28:33
|
I am afraid to say this, but: YES  quote: Originally posted by scubadollar
Do I have to go into every include line and replace it with this?
|
Cheers, David Greening |
 |
|
scubadollar
Starting Member
12 Posts |
Posted - 23 March 2006 : 17:23:07
|
Hey David,
Thanks for the info, I changed all my include statements back to resemble your example (that is the same as the original) I took out my root and forum file reference so throughout every asp file I have checked them and they are all in that form, Example :
<!--#include file="config.asp"--> <!--#INCLUDE FILE="inc_sha256.asp"--> <!--#INCLUDE FILE="inc_header.asp" -->
and so on..... now my error is a cyclic one.... as follows:
Active Server Pages error 'ASP 0135'
Cyclic Include
/forum/config.asp, line 1
The file 'config.asp' is included by itself (perhaps indirectly). Please check include files for other Include statements
I have no idea what this means other than my config file has an include on the first line that refers back to itself.... This is how it came from Snitz.
So do I try the vitual statement, I have godaddy.com as a host?
Cheers for all your help, Paul $
|
 |
|
scubadollar
Starting Member
12 Posts |
Posted - 23 March 2006 : 17:48:56
|
Okay,
I have figured out how to get it setup to a point, I deleted the first include in my Cofig.asp file, no longer cyclic but now I am having trouble with something else as follows:
Home | Profile | Register | Active Topics | Members | Search | FAQ Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[MySQL][ODBC 3.51 Driver][mysqld-4.0.24-max-log]Table 'scubadollar.FORUM_TOTALS' doesn't exist
/forum/default.asp, line 89 No idea what that means... line 89 from my default.asp file looks like this:
'## Forum_SQL 85 strSql = "SELECT P_COUNT, T_COUNT, U_COUNT " &_ 86 " FROM " & strTablePrefix & "TOTALS" 87 88 Set rs1 = Server.CreateObject("ADODB.Recordset") 89 rs1.open strSql, my_Conn 90 91 Users = rs1("U_COUNT") 92 Topics = rs1("T_COUNT") 93 Posts = rs1("P_COUNT") 94 rs1.Close set rs1 = nothing
getting closer I think |
Edited by - scubadollar on 23 March 2006 17:50:27 |
 |
|
jwashburn
Starting Member
28 Posts |
Posted - 23 March 2006 : 22:17:12
|
did you create your tables when you setup the db? |
 |
 |
|
scubadollar
Starting Member
12 Posts |
Posted - 24 March 2006 : 01:52:26
|
No, I setup a blank database and followed the Snitz setup instructions to the letter.... I may have trouble with the String code as my Host suggests one and the Snitz setup readme suggests another.
Go Daddy says: Description:
The following is a list of database connection strings to use with various MySQL data providers. Cut and paste the connection string to use within your application. For connection strings that require a password, update the password field to the designated password for the database.
ODBC 3.51 DRIVER={MySQL ODBC 3.51 Driver};SERVER=##DBSERVER##;PORT=3306;DATABASE=##DBNAME##;USER=##DBUSER##;PASSWORD=##DBPASSWORD##;OPTION=0; OLE DB, OleDbConnection (.NET) Provider=MySQLProv;Data Source=##DBSERVER##;Initial Catalog=##DBNAME##;User Id=##DBUSER##;Password=##DBPASSWORD##; Connector/Net 1.0 (.NET) Server=##DBSERVER##;Port=3306;Database=##DBNAME##;Uid=##DBUSER##;Pwd=##DBPASSWORD##;
For additional information on how to setup your connection string using PHP, please refer to the following help resource references.
Connecting to a MySQL Database on Your Linux Hosting Account Using PHP
Connecting to MySQL Using PHP
A bit different than the Snitz layout.... I have opted for the OBDC 3.51
But not working.....???? I am new to this
$ |
 |
|
Classicmotorcycling
Development Team Leader
    
Australia
2085 Posts |
Posted - 25 March 2006 : 15:01:58
|
You are on a Windows host are you not?
The connection string that you need to be using is already in the config.asp file, but make it look like this:
strConnString = "driver={MySQL ODBC 3.51 Driver};option=16387;server=SERVER_IP;user=UID;password=PWD;DATABASE=DB_NAME;" '##MySQL w/ MyODBC v3.51
You will also need to enter your server where SERVER_IP is, user where UID is, password where PWD is and database name where DB_NAME is, then re-run your setup. Also why we are at it, did you get any errors when you run setup last time?
|
Cheers, David Greening |
 |
|
|
Topic  |
|