| Author |
 Topic  |
|
|
cyberd
Starting Member
Australia
34 Posts |
|
|
RaiderUK
Average Member
United Kingdom
577 Posts |
 Posted - 19 April 2001 : 10:27:16
|
what does forum.asp, line 487 read?
|
 |
|
|
cyberd
Starting Member
Australia
34 Posts |
Posted - 21 April 2001 : 08:37:41
|
quote:
what does forum.asp, line 487 read?
if mxPages <> cint(mxPages) then
|
|
|
|
cyberd
Starting Member
Australia
34 Posts |
Posted - 21 April 2001 : 08:42:11
|
quote:
what does forum.asp, line 487 read?
I have changed the cint to int, this seems to have fixed it, can anyone say if this will generate problems elsewhere, or if other problems may exist.
The only change I have made that may have caused this is to use an sql2000 connection string on my sql7 database, to allow me to use classifieds mod...
Edited by - cyberd on 22 April 2001 19:39:22 |
|
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 21 April 2001 : 08:50:18
|
quote:
quote:
what does forum.asp, line 487 read?
I have changed the cint to int, can amyone say if this will generate problems elsewhere, or if other problems may exist.
The only change I have made that may have caused this is to use an sql2000 connection string on my sql7 database, to allow me to use classifieds mod...
Leave it as cint, the problem is with your database. Check your forum_topics table the field T_REPLIES should have a default value of 0, yours appears to have NULL in the column where it shouldn't.
What database are you using ?
|
|
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 21 April 2001 : 10:09:04
|
Could you please post a reply rather than editing your previous, it is a bit confusing.
quote:
The only change I have made that may have caused this is to use an sql2000 connection string on my sql7 database, to allow me to use classifieds mod...
Do you mean Access, there is no difference between a SQL 2000 and SQL 7 connection
|
|
|
|
cyberd
Starting Member
Australia
34 Posts |
Posted - 22 April 2001 : 19:27:30
|
No, it is an sql 7 Database. I am using an SQLOLEDB connection string to allow classifieds to work.
As to the default value of zero, no that was not set in the tabole design.
sql 7 database setup, and I'm not totally familiar with sql create strings, but there does not seem to be any default value set in the t_replies field. !!
|
|
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 22 April 2001 : 19:30:49
|
if you do not have default values set for these fielsd, how did you create the SQL DB?
setup.asp assigns a default of 0 to T_REPLIES
|
|
|
|
cyberd
Starting Member
Australia
34 Posts |
Posted - 22 April 2001 : 19:37:14
|
I have also noticed that when I create a new forum, it defaults to a locked status.
I looked at the table and the value for status was null.
I have changed the default value to 1 so it doesn't happen again.
This has nothing to do with the different connection string as I have tried both.
|
|
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 22 April 2001 : 19:46:23
|
quote:
if you do not have default values set for these fielsd, how did you create the SQL DB?
setup.asp assigns a default of 0 to T_REPLIES
If you did not create your db using setup.asp, you will have many other default values missing
|
|
|
|
cyberd
Starting Member
Australia
34 Posts |
Posted - 23 April 2001 : 00:50:46
|
The DB was setup using the setup.asp.
|
|
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 23 April 2001 : 00:57:43
|
Very strange, could you post your connection string, leave out passwords etc, and were you using the same connstr when you ran setup.asp
|
|
|
|
cyberd
Starting Member
Australia
34 Posts |
Posted - 23 April 2001 : 01:27:40
|
OK. I reran the setup.asp, and it has added in many more default values.
I'm just going to redo it. I don't know what caused it, but at least I have a definate cause for these problems. Thanks for your help.
|
|
|
|
cyberd
Starting Member
Australia
34 Posts |
Posted - 23 April 2001 : 06:00:57
|
By the way, that new connection string was
strConnString = "Provider=SQLOLEDB;Data Source=(Local);Initial Catalog=db1;User ID=user;Password=password" '##MS Sql Server 7 - or - 2000 it seems
As opposed to the original
'strConnString = "driver={SQL Server};server=MATRIX;uid=user;pwd=password;database=db1" '## MS SQL Server 7
|
|
|
|
Dan03
Starting Member
Australia
17 Posts |
Posted - 26 May 2001 : 07:01:22
|
Ok. I'm having the same problem, except I'm attempting to set up multiple forums on the same database, with the same users.
I don't have Microsoft Access, so my method of copying the tables hasn't worked. I ran setup.asp, and that seemed to have no effect at all.
Do I have to use MS Access? Or is there an alternate solution?? |
|
|
| |
Topic |
|
Topic Locked
