Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 DEV-Group
 DEV Bug Reports (Closed)
 V33(.02) BUG+FIX : Archive Setup error		  Forum Locked  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Twig
Starting Member

5 Posts
Posted - 30 July 2001 :  12:24:53  Show Profile
Hi,

When I try to use any of the archive functions it throws the following error (using SQL 7):


No replies were archived, none found

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert explicit value for identity column in table 'FORUM_A_TOPICS' when IDENTITY_INSERT is set to OFF.

/snitz3302/admin_forums.asp, line 618

Any ideas?


HuwR
Forum Admin

United Kingdom
20584 Posts
Posted - 30 July 2001 :  12:53:05  Show Profile  Visit HuwR's Homepage
If you are able to edit your database, remove the Auto property from REPLY_ID in A_REPLY and TOPIC_ID in A_TOPICS.


gor,

You need to change the setup for these tables, they should not have id fields
Go to Top of Page

gor
Retired Admin

Netherlands
5511 Posts
Posted - 30 July 2001 :  13:27:32  Show Profile  Visit gor's Homepage
I know they shouldn't, but don't understand why I added them there
There is this line (line 209) in inc_create_forums_sqlx.asp :

	strSql = strSql & "TOPIC_ID int IDENTITY (1, 1) NOT NULL , "

that should be:

	strSql = strSql & "TOPIC_ID int NOT NULL , "

and this line (line 230):

	strSql = strSql & "REPLY_ID int IDENTITY (1, 1) NOT NULL , "

that should be:

	strSql = strSql & "REPLY_ID int NOT NULL , "


and in inc_create_forums_mysql.asp, line 280:

strSql = strSql & "TOPIC_ID int (11) DEFAULT '' NOT NULL auto_increment, "

should be:

strSql = strSql & "TOPIC_ID int (11) DEFAULT '' NOT NULL, "

and line 306:

strSql = strSql & "REPLY_ID int (11) DEFAULT '' NOT NULL auto_increment, "

should be:

strSql = strSql & "REPLY_ID int (11) DEFAULT '' NOT NULL, "


The same problem in setup.asp
Line 1333:

 		SpecialSql5(Access) = SpecialSql5(Access) & "TOPIC_ID COUNTER CONSTRAINT PrimaryKey PRIMARY KEY , "

should be:

 		SpecialSql5(Access) = SpecialSql5(Access) & "TOPIC_ID int CONSTRAINT PrimaryKey PRIMARY KEY , "


Line 1350:

 		SpecialSql5(SQL6) = SpecialSql5(SQL6) & "TOPIC_ID int IDENTITY (1, 1) NOT NULL , "

should be:

 		SpecialSql5(SQL6) = SpecialSql5(SQL6) & "TOPIC_ID int NOT NULL , "


Line 1367:

 		SpecialSql5(SQL7) = SpecialSql5(SQL7) & "TOPIC_ID int IDENTITY (1, 1) NOT NULL , "

should be:

 		SpecialSql5(SQL7) = SpecialSql5(SQL7) & "TOPIC_ID int NOT NULL , "

Line 1384:

		SpecialSql5(MySql) = SpecialSql5(MySql) & "TOPIC_ID int (11) DEFAULT '' NOT NULL auto_increment, "

should be:

		SpecialSql5(MySql) = SpecialSql5(MySql) & "TOPIC_ID int (11) DEFAULT '' NOT NULL, "


Only the Access database in the tools.zip file is correct.
Users performing a new install using Access won't have a problem.


Pierre
Join a Snitz Mailinglist

Fixed typo...Thanks Huw !!
Go to Top of Page

Reinsnitz
Snitz Forums Admin

USA
3545 Posts
Posted - 30 July 2001 :  13:39:57  Show Profile  Visit Reinsnitz's Homepage  Send Reinsnitz an AOL message  Send Reinsnitz an ICQ Message  Send Reinsnitz a Yahoo! Message
remember to document and forward all fixes to bozden!

Reinsnitz (Mike)
><)))'> Need a Mod?
"Therefore go and make disciples of all nations,..." Matthew 28:19a
Go to Top of Page

gor
Retired Admin

Netherlands
5511 Posts
Posted - 30 July 2001 :  13:45:08  Show Profile  Visit gor's Homepage
quote:

remember to document and forward all fixes to bozden!



Pierre
Join a Snitz Mailinglist
Go to Top of Page

DreaMasteR
Starting Member

36 Posts
Posted - 30 July 2001 :  21:34:24  Show Profile
quote:

If you are able to edit your database, remove the Auto property from REPLY_ID in A_REPLY and TOPIC_ID in A_TOPICS.


gor,

You need to change the setup for these tables, they should not have id fields




I changed them to "number" (and had to update to 2000 :-( )

Is that the field type we should be using instead of AutoNumber?
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts
Posted - 03 August 2001 :  05:28:49  Show Profile
Gor, in setup.asp the same needs to be done for A_REPLY

Line #1413:

 		SpecialSql5(Access) = SpecialSql5(Access) & "REPLY_ID COUNTER CONSTRAINT PrimaryKey PRIMARY KEY , "


should be:

 		SpecialSql5(Access) = SpecialSql5(Access) & "REPLY_ID int CONSTRAINT PrimaryKey PRIMARY KEY , "



Line #1425:

 		SpecialSql5(SQL6) = SpecialSql5(SQL6) & "REPLY_ID int IDENTITY (1, 1) NOT NULL , "


should be:

 		SpecialSql5(SQL6) = SpecialSql5(SQL6) & "REPLY_ID int NOT NULL , "



Line #1437:

 		SpecialSql5(SQL7) = SpecialSql5(SQL7) & "REPLY_ID int IDENTITY (1, 1) NOT NULL , "


should be:

 		SpecialSql5(SQL7) = SpecialSql5(SQL7) & "REPLY_ID int NOT NULL , "



Line #1449:

		SpecialSql5(MySql) = SpecialSql5(MySql) & "REPLY_ID int (11) DEFAULT '' NOT NULL auto_increment, "


should be:

		SpecialSql5(MySql) = SpecialSql5(MySql) & "REPLY_ID int (11) DEFAULT '' NOT NULL , "
Go to Top of Page

GhorZonia
New Member

Finland
60 Posts
Posted - 10 August 2001 :  10:20:39  Show Profile  Visit GhorZonia's Homepage
Richard, this gives a syntax error:

SpecialSql5(Access) = SpecialSql5(Access) & "REPLY_ID CONSTRAINT PrimaryKey PRIMARY KEY , "


I think it should be:

SpecialSql5(Access) = SpecialSql5(Access) & "REPLY_ID int CONSTRAINT PrimaryKey PRIMARY KEY , "


Edited by - GhorZonia on 10 August 2001 10:21:28
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts
Posted - 10 August 2001 :  14:52:22  Show Profile
corrected in the above post.
Go to Top of Page

Deleted
deleted

4116 Posts
Posted - 16 August 2001 :  18:30:02  Show Profile
Didn't apply to the offline v40b02 code until now, but the time comes in a couple of days:) The topic is also left unlocked till now ! Shall I carry them over?

Think Pink
Go to Top of Page

gor
Retired Admin

Netherlands
5511 Posts
Posted - 17 August 2001 :  17:56:27  Show Profile  Visit gor's Homepage
Fixed in the source of version 3.3.03
I updated
inc_create_forum_sql6.asp
inc_create_forum_sql7.asp
inc_create_forum_mysql.asp
and
setup.asp
also added code to recreate the two tables if needed when upgrading with a check to make sure it doesn't DROP tables in databases that have been fixed by hand allready.

Pierre
Join a Snitz Mailinglist
Go to Top of Page

Deleted
deleted

4116 Posts
Posted - 17 August 2001 :  21:17:08  Show Profile
Pierre, can you please e-mail me these 4 files?

Think Pink
Go to Top of Page

gor
Retired Admin

Netherlands
5511 Posts
Posted - 18 August 2001 :  01:56:36  Show Profile  Visit gor's Homepage
quote:

Pierre, can you please e-mail me these 4 files?


Don't think that is much use until I now they don't change. I want to release version 3.3.03 before the end of this weekend (because the number of fixed bugs sofar is important enough), so you'll have them then.
Shouldn't have changed in your version anyhow though.

Pierre
Join a Snitz Mailinglist
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.14 seconds. Powered By: Snitz Forums 2000 Version 3.4.07