
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-15-2005 01:44 PM
Greetings!
I've set up Lansweeper server on Win2003Server+SQLServer2k. Client successfully connects to server, but then I have a bunch of
"(XXXX) Cannot insert the value NULL into column 'Lastchanged', table 'YYYY'; column does not allow nulls. INSERT fails."
errors in the server log file. Only "LOGON" table is updated, all other tables are empty. (where "XXXX" and "YYYY" - all category and table names)
I'm absolutely new to SQLServer, so I beg you to help me. I'm almost sure I've made some mistake in SQL configuration, but I cannot find it.
I've set up Lansweeper server on Win2003Server+SQLServer2k. Client successfully connects to server, but then I have a bunch of
"(XXXX) Cannot insert the value NULL into column 'Lastchanged', table 'YYYY'; column does not allow nulls. INSERT fails."
errors in the server log file. Only "LOGON" table is updated, all other tables are empty. (where "XXXX" and "YYYY" - all category and table names)
I'm absolutely new to SQLServer, so I beg you to help me. I'm almost sure I've made some mistake in SQL configuration, but I cannot find it.
Labels:
- Labels:
-
Archive
3 REPLIES 3

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-16-2005 09:53 AM
I've downloaded and applied new script. Everything seems to be working now. 🙂 Thanks guys!

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-15-2005 02:58 PM
I've uploaded a new lansweeper.zip file, please reapply the database script (now with defaults included)

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-15-2005 02:45 PM
Looks like the default value for the field "lastchanged" isn't filled in.
The default value should be getdate().
Can you check if you have a default value for this column?
I'll take a look if there are any errors in the sql script.
The default value should be getdate().
Can you check if you have a default value for this column?
I'll take a look if there are any errors in the sql script.
