| Author |
 Topic  |
|
|
amaddr
Starting Member
USA
2 Posts |
 Posted - 12 March 2004 : 14:05:07
|
After upgrading to V3.4.04, I get this error when I attempt to post a new topic:
Microsoft OLE DB Provider for SQL Server error '80040e2f'
Cannot insert the value NULL into column 'TOPIC_ID', table 'CitySkirt.csshop.CSBBS_TOPICS'; column does not allow nulls. INSERT fails.
/CitySkirtBBS/post_info.asp, line 889
Has anyone else bumped into this problem?
Dan Richardson
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
amaddr
Starting Member
USA
2 Posts |
Posted - 12 March 2004 : 16:27:20
|
I've managed to fix the problem  , but read on for how it cropped up in the first place:
I recently upgraded the service plan for my web site in order to get a dedicated SSL certificate and so forth. The process required erasing my web site(s) and then re-creating them with a dedicated IP and so on. Blah, blah, blah. (This was carried out by my hosting company.)
Much to my chagrin, I did not realize that it also required wiping out my database tables as well, even though my hosting company has the SQL Server database on a different server. (Go figure.) Fortunately, they did have a backup of my data that was only a day old and they restored that image quite promptly. (I had diligently backed-up my non-database source onto multiple storage formats previous to the upgrade.)
However, during the restore process, the identity seed attribute did not get set correctly on a number of table columns. So when the Snitz Forum software attempted to insert a new message into the Topics table, SQL Server horked up an error.  This problem turned up in my own ASP.NET code that handles new customer sign up for my Web Shop. (As you can imagine, this got my first and undivided attention.) Then it dawned on me that the same problem might be affecting the Snitz Forum tables. I was correct. Once I fixed the identity seed attribute on the column, it worked as predicted.
Breathing a sigh of relief,
Dan Richardson
|
 |
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 12 March 2004 : 18:32:22
|
You might check the db for other missing things, like default values & such.
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 12 March 2004 : 19:23:34
|
| Glad it's working now. Anyway, I reinforce Doug's advice, because it looks like the restore may have not been done in the best way, so check your tables to make sure everything is well. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
| |
Topic |
|
Topic Locked
