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

 All Forums
 Community Forums
 Code Support: ASP (Non-Forum Related)
 Cannot insert vallue NULL into column '..._id'		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

jschuur
Starting Member

Netherlands
2 Posts
Posted - 02 March 2002 :  13:01:48  Show Profile
Hi All.
It looks like the forum doesn't create ID's that has to be placed into columns for id's (example below). I'm using SQL 2000 for the dbase. Can anyone help?
Thanx!

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'MEMBER_ID', table 'snitz_forums_2000.dbo.FORUM_MEMBERS'; column does not allow nulls. INSERT fails.
/SForum/register.asp, line 294


Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)

Page:
POST 346 bytes to /SForum/register.asp

POST Data:
Refer=http%3A%2F%2Flocalhost%3A65500%2FSForum%2Fpost.asp%3Fmethod%3DTopic%26FORUM_ID%3D1%26CAT_ID%3D1%26Forum_Title%3DTesting%2BForum&Email=testuser@mydomain.com&Email2=&ICQ=&YAHOO=&AIM=&Homepage=&L . . .

jschuur
Starting Member

Netherlands
2 Posts
Posted - 02 March 2002 :  13:24:07  Show Profile
He There!
I already found the problem, well, a workaround that is. This is what I did.

I couldn't create the database, because I have to log in as the forum admin for that. You can never logon, because the column 'forum_members' is then not created yet (!).

Here's the workaround.
Import the Access database (in the admin zip file) into a tmp sql database. Create a new sql database (e.g. snitz_forums_2000). Copy the column 'forum_members' into the new database. Make sure you update the config.asp file to use the new database!
Goto the the setup.asp page and login as user admin, pass admin. Create the tables and columns by clicking on the link. Delete the column 'forum_members' in the new database. DO NOT LOGOUT THE SETUP.ASP PAGE! Again, create the columns and tables by clicking on the link. You'll get a lot of errors, but these can be ignored. Check you database and have fun with the forum!

Best regards!

Jan Martijn
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.25 seconds. Powered By: Snitz Forums 2000 Version 3.4.07