Managing email signatures?
Click download Free Trial 		Manage Email Signatures Centrally - For All Users
extend your brand and promote your products, services, special events and news
 
Your eMailSignaturer resource    Receive answers in my inbox    Add URL in your RSS reader    Join us on Facebook     RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
LiveZilla Live Help

Unable to add a group to a new campaign in Cockpit 5.0.0

 
Post new topic   Reply to topic    email signatureManage Email Signatures Centrally - For All Users Forum Index -> English Support
View previous topic :: View next topic  
Author Message
tfisk
Just can't stay away


Joined: 18 Feb 2008
Posts: 20
Location: Norwich, UK
Posted: Fri Apr 25, 2008 8:46 am    Post subject: Unable to add a group to a new campaign in Cockpit 5.0.0 Reply with quote
Hi,

We have created a new campaign, but when selecting a group for this to apply to by using the "group settings" button the following error message is displayed:

"Cannot insert the value NULL into column 'id', table 'eMailsignature_New.dbo.lgdaCampaignGroups'; column does not allow nulls. INSERT fails."

What is the reason for this?

Thanks

Tom
Back to top
View user's profile Send private message
Jesper Frier
Certified Professional
Certified Professional


Joined: 09 Sep 2006
Posts: 1940
Location: Stoevring, Denmark
Posted: Fri Apr 25, 2008 9:05 am    Post subject: Reply with quote
Please let me know:
  1. SQL Server version?
  2. Did you follow these instructions?
  3. Did you upgrade recently?


Then Post Status Monitor log file ...
_________________
</Jesper> | Test Email Signature | Showcase |
Back to top
View user's profile Send private message Visit poster's website
tfisk
Just can't stay away


Joined: 18 Feb 2008
Posts: 20
Location: Norwich, UK
Posted: Fri Apr 25, 2008 9:18 am    Post subject: Reply with quote
Jesper Frier wrote:
Please let me know:
  1. SQL Server version?
  2. Did you follow these instructions?
  3. Did you upgrade recently?


Then Post Status Monitor log file ...


Hi Jesper,

1. We are using SQL Server 2005
2. What specific instructions do you refer to? We have had the eMailSignature signature installed for quite a while now, and the campaign module has worked in the past. If I recall correctly, we setup a campaign after the DB was moved from 2000 to 2005 and that worked all ok.
3. We have upgraded to version 5.0.0 in the last month, so this may be the problem? The procedure was performed as per the instructions.

Regards,

Tom
Back to top
View user's profile Send private message
Jesper Frier
Certified Professional
Certified Professional


Joined: 09 Sep 2006
Posts: 1940
Location: Stoevring, Denmark
Posted: Fri Apr 25, 2008 9:43 am    Post subject: Reply with quote
Based on the error you have, something is wrong with your settings DB.

Using SQL 2005 settings DB, it's very simple to create a new settings DB - just execute this script.

If you use this script, you will not get the above error - please try? Cool
_________________
</Jesper> | Test Email Signature | Showcase |
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    Manage Email Signatures Centrally - For All Users Forum Index -> English Support All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Add URL in your RSS reader | About Us | Terms and conditions | © 2012 eMailSignature North America, Inc. and eMailSignature Aps.