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
 cannot create forum, error indicates db but....
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

weeweeslap
Senior Member

USA
1077 Posts

Posted - 13 September 2004 :  16:41:34  Show Profile  Visit weeweeslap's Homepage  Send weeweeslap an AOL message  Send weeweeslap a Yahoo! Message
This started all of a sudden and don't know why:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'F_THEME_ID', table 'weeweeslap.weeweeslap.FORUM_FORUM'; column does not allow nulls. INSERT fails.

/forum/post_info.asp, line 1331
I get that error when trying to make a new forum, so I went ahead set the field F_THEME_ID to allow nulls. the new forum posted fine, but then I got cosmetic errors as seen here:
www.weeweeslap.com/forum/snitz/blue-square.jpg
See the new forum called "Hard Hat Area" and notice the lighter blue square at the right of it?
At first I thought it was because there was 0 posts in the new forum so I posted a test post and the problem persisted. The addition of forums was working fine, last forum I made worked without a trouble a few weeks ago and there have been 0 changes in any of the code or db since then. Here is a link to post.asp for you guys to view it and inspect it.
http://www.weeweeslap.com/forum/snitz/post.txt
Please help me out as I need to get this new forum up and running as soon as possible. I changed the field F_THEME_ID to what it was, not allow nulls so right now I cannot make new forums unless I change that around so your help will be very handy.
WWS

coaster crazy

Edited by - weeweeslap on 13 September 2004 19:17:20

Podge
Support Moderator

Ireland
3776 Posts

Posted - 13 September 2004 :  17:17:58  Show Profile  Send Podge an ICQ Message  Send Podge a Yahoo! Message
Got a "page not found" for this - http://www.weeweeslap.com/snitz/blue-square.jpg


Podge.

The Hunger Site - Click to donate free food | My Blog | Snitz 3.4.05 AutoInstall (Beta!)

My Mods: CAPTCHA Mod | GateKeeper Mod
Tutorial: Enable subscriptions on your board

Warning: The post above or below may contain nuts.
Go to Top of Page

weeweeslap
Senior Member

USA
1077 Posts

Posted - 13 September 2004 :  19:17:48  Show Profile  Visit weeweeslap's Homepage  Send weeweeslap an AOL message  Send weeweeslap a Yahoo! Message
I am sorry, the links have been fixed.
Thank you.

coaster crazy
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 14 September 2004 :  06:36:21  Show Profile  Send ruirib a Yahoo! Message
Is this a DB upgraded from Access?


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

weeweeslap
Senior Member

USA
1077 Posts

Posted - 14 September 2004 :  12:07:00  Show Profile  Visit weeweeslap's Homepage  Send weeweeslap an AOL message  Send weeweeslap a Yahoo! Message
yes it is, but it's been over a year since it was upgraded and new forums have been created since then. just this time it isn't working and not sure why.

coaster crazy

Edited by - weeweeslap on 14 September 2004 12:08:34
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 15 September 2004 :  07:58:17  Show Profile  Send ruirib a Yahoo! Message
That theme_ID field must be due to some mod. I don't know the mod, but surely the field should be an identity one. If the field is a primary key, as I suppose it is, change it so that the Identity property is set to yes.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

weeweeslap
Senior Member

USA
1077 Posts

Posted - 15 September 2004 :  19:46:37  Show Profile  Visit weeweeslap's Homepage  Send weeweeslap an AOL message  Send weeweeslap a Yahoo! Message
ok I fixed it, somehow the theme_id, mail, topics, count and ip fields lost their default values and weren't being created. I set them to default at 0 etc and now it works like a charm, thanks for the help

coaster crazy
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 16 September 2004 :  05:47:05  Show Profile  Send ruirib a Yahoo! Message
Glad you fixed it .


Snitz 3.4 Readme | Like the support? Support Snitz too
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