Author |
Topic  |
|
weeweeslap
Senior Member
   
USA
1077 Posts |
Posted - 13 September 2004 : 16:41:34
|
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 |
|
weeweeslap
Senior Member
   
USA
1077 Posts |
Posted - 13 September 2004 : 19:17:48
|
I am sorry, the links have been fixed. Thank you. |
coaster crazy |
 |
|
ruirib
Snitz Forums Admin
    
Portugal
26364 Posts |
|
weeweeslap
Senior Member
   
USA
1077 Posts |
Posted - 14 September 2004 : 12:07:00
|
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 |
 |
|
ruirib
Snitz Forums Admin
    
Portugal
26364 Posts |
Posted - 15 September 2004 : 07:58:17
|
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 |
 |
|
weeweeslap
Senior Member
   
USA
1077 Posts |
Posted - 15 September 2004 : 19:46:37
|
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 |
 |
|
ruirib
Snitz Forums Admin
    
Portugal
26364 Posts |
|
|
Topic  |
|