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: Database: MS SQL Server
 Getting an Error When Trying to Post a Topi		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

itsmiles
Starting Member

USA
25 Posts
Posted - 06 January 2008 :  21:11:24  Show Profile
i am getting this Error as Admin and as a user

did not have any problems before:

I am getting the following error as an Admin and as user

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

[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'TOPIC_ID', table '801167_default.dbo.FORUM_TOPICS'; column does not allow nulls. INSERT fails.

/post_info.asp, line 901


Can you help.

cheers

HuwR
Forum Admin

United Kingdom
20600 Posts
Posted - 07 January 2008 :  02:09:37  Show Profile  Visit HuwR's Homepage
did you by any chance migrate an old Access db to SQL ?
Go to Top of Page

itsmiles
Starting Member

USA
25 Posts
Posted - 07 January 2008 :  11:58:22  Show Profile
quote:
Originally posted by HuwR

did you by any chance migrate an old Access db to SQL ?


no, before was able to post no problem
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20600 Posts
Posted - 07 January 2008 :  12:20:45  Show Profile  Visit HuwR's Homepage
well, you need to find out what has changed, the topic table can not suddenly loose its autoid field without someone editing the database to change it, if it doesn't have an autoid the only explanation I know of is that you upsized an access db rather than using the forums setup.asp
Go to Top of Page

itsmiles
Starting Member

USA
25 Posts
Posted - 07 January 2008 :  12:36:37  Show Profile
thank u

u mean the actual code of Snitz to auto SQL could have been alters.

As an Admin, this can not be done from the Admin Control Panel.

cheers
Go to Top of Page

Davio
Development Team Member

Jamaica
12217 Posts
Posted - 07 January 2008 :  12:47:26  Show Profile
No. Not the actual code of Snitz.

The database field 'TOPIC_ID' in the database table 'FORUM_TOPICS' supposed to automatically generate a number when you make a new post. But either you or your host, made some changes to the Snitz database and has caused this problem.

Did you make any changes to your database recently? Or did your host make any changes recently?
Support Snitz Forums
Edited by - Davio on 07 January 2008 12:48:03
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.18 seconds. Powered By: Snitz Forums 2000 Version 3.4.07