| Author |
 Topic  |
|
|
hbez
Starting Member
South Africa
11 Posts |
 Posted - 31 March 2002 : 03:15:14
|
I'm using mySQL with version 3 and tried it with Beta - everything worked fine on first go, tho I had to make a few changes:
=======================
In the file inc_create_forum_mysql.asp :
Added <!--#INCLUDE FILE="config.asp" --> at the top of the file.
Added the lines
set my_Conn = Server.CreateObject("ADODB.Connection")
my_Conn.Open strConnString
prior to the first my_Conn.Execute statement.
===========================
Lacked execute statements to create the tables SUBSCRIPTIONS and A_TOPICS.
===========================
Chnaged config.sys a bit:
strDBType = "mysql"
const SQLdb="databasename"
const SQLUser="" ' root if on localhost
const SQLPwd="password"
const SQLServer="Server IP address"
strConnString = "DRIVER={MySQL}; Server=" & SQLServer & "; Database=" & SQLdb & "; UID=" & SQLUser & "; PWD=" & SQLPwd ==================================
I got a 'Divide by zero' in forum.asp and fixed it by adding a line wherever I found a \ strPageSize:
if NOT(strPageSize)>0 then strPageSize=1
maxpages = (rsCount("PAGECOUNT") \ strPageSize )
I'm no guru with asp, so I will appreciate any comment on the changes I made.
Hannes
Moved from Help/Current Version
Edited by - Nathan on 31 March 2002 04:05:28 |
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 31 March 2002 : 04:04:40
|
There appear to be a few bugs in admin_config_features.asp Three numbers are inputted, hot topics number, items per page, and page number per row.
There needs to be a method for checking to make sure that they are positive intergers. In version 3.3.03 putting a 0 in items per page results in a devide by zero error, and putting a float in there results in no pageing (so far, I am not able to make infinate posts in my testing forum  )
Nathan Bales - Romans 15:13
----------------------------------
Snitz Exchange | Do's and Dont's |
 |
|
|
hbez
Starting Member
South Africa
11 Posts |
Posted - 31 March 2002 : 08:31:42
|
Hi Nathan
Thkx for the reply. The few problems I had (both version 3 and 4) I sorted out in short time and I like the product! My only bit of inconvenience is that one has to use Refresh quite a bit. Is there a way to have a page refresh everytime you use a 'Back to Forum' link?
Hannes
quote:
There appear to be a few bugs in admin_config_features.asp Three numbers are inputted, hot topics number, items per page, and page number per row.
There needs to be a method for checking to make sure that they are positive intergers. In version 3.3.03 putting a 0 in items per page results in a devide by zero error, and putting a float in there results in no pageing (so far, I am not able to make infinate posts in my testing forum )
Nathan Bales - Romans 15:13
----------------------------------
Snitz Exchange | Do's and Dont's
|
|
|
|
hbez
Starting Member
South Africa
11 Posts |
Posted - 31 March 2002 : 08:33:45
|
and by the way, the Refresh appears to be a problem only with Opera (I have version 6), which also does not respond to the "Back to...' link at all (see my post on this subject in current version forum).
Hannes
quote:
There appear to be a few bugs in admin_config_features.asp Three numbers are inputted, hot topics number, items per page, and page number per row.
There needs to be a method for checking to make sure that they are positive intergers. In version 3.3.03 putting a 0 in items per page results in a devide by zero error, and putting a float in there results in no pageing (so far, I am not able to make infinate posts in my testing forum )
Nathan Bales - Romans 15:13
----------------------------------
Snitz Exchange | Do's and Dont's
|
|
|
| |
Topic |
|
Topic Locked
