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

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: MOD Implementation
 Points Mod Error
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Philnguyen44
Junior Member

164 Posts

Posted - 11 November 2003 :  16:47:13  Show Profile  Visit Philnguyen44's Homepage  Send Philnguyen44 an AOL message
When I setup the db, I get this:



-2147217900 | Cannot insert explicit value for identity column in table 'FORUM_STORE_ITEMS' when IDENTITY_INSERT is set to OFF.

http://www.coasterfuel.com

Philnguyen44
Junior Member

164 Posts

Posted - 11 November 2003 :  17:35:07  Show Profile  Visit Philnguyen44's Homepage  Send Philnguyen44 an AOL message
I have another error while viewing a topic:


Microsoft VBScript runtime error '800a000d'

Type mismatch: '[string: ""]'

/inc_func_common.asp, line 904

http://philsserver.gotdns.com:81/topic.asp?TOPIC_ID=58

http://www.coasterfuel.com
Go to Top of Page

Philnguyen44
Junior Member

164 Posts

Posted - 11 November 2003 :  18:02:48  Show Profile  Visit Philnguyen44's Homepage  Send Philnguyen44 an AOL message
anyone? I need this fixed asap!

http://www.coasterfuel.com
Go to Top of Page

Philnguyen44
Junior Member

164 Posts

Posted - 11 November 2003 :  18:57:58  Show Profile  Visit Philnguyen44's Homepage  Send Philnguyen44 an AOL message
Anyone? i Really need help!

http://www.coasterfuel.com
Go to Top of Page

weeweeslap
Senior Member

USA
1077 Posts

Posted - 12 November 2003 :  01:53:24  Show Profile  Visit weeweeslap's Homepage  Send weeweeslap an AOL message  Send weeweeslap a Yahoo! Message
this happens when installing it on SQL server, I didn't have any luck getting a fix here but got the fix from ruirib when on the crashsite.nl forums, you can use the query analyzer and type this in:

Set IDENTITY_INSERT FORUM_STORE_ITEMS ON 
INSERT INTO FORUM_STORE_ITEMS (P_ITEM,P_COST,P_TITLE,P_DESCRIPTION) VALUES (1500,2,'Donate money to other user','With this action, you can donate some of your points to other members.')
INSERT INTO FORUM_STORE_ITEMS (P_ITEM,P_COST,P_TITLE,P_DESCRIPTION) VALUES (1501,200,'Create custom title','With this action you can get a custom title and if you dont have one already then you can get one')
INSERT INTO FORUM_STORE_ITEMS (P_ITEM,P_COST,P_TITLE,P_DESCRIPTION) VALUES (1505,575,'Use Custom Avatar','With this action you can get a custom avatar or if you already have one you can change it')
INSERT INTO FORUM_STORE_ITEMS (P_ITEM,P_COST,P_TITLE,P_INSTORE) VALUES (1509,2,'Send Private message',0)

quote:

Just paste this into Query Analizer and execute it. It should add the values you need.



coaster crazy
Go to Top of Page

Philnguyen44
Junior Member

164 Posts

Posted - 18 November 2003 :  21:51:47  Show Profile  Visit Philnguyen44's Homepage  Send Philnguyen44 an AOL message
I queryed but I get these errors:

Cannot insert explicit value for identity column in table 'FORUM_STORE_ITEMS' when IDENTITY_INSERT is set to OFF.

http://www.coasterfuel.com
Go to Top of Page

Anacrusis
Junior Member

USA
219 Posts

Posted - 18 November 2003 :  22:43:48  Show Profile  Visit Anacrusis's Homepage  Send Anacrusis an AOL message
you forgot the line:
Set IDENTITY_INSERT FORUM_STORE_ITEMS ON

The Internet ClubHouse
www.internet-clubhouse.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.42 seconds. Powered By: Snitz Forums 2000 Version 3.4.07