Managing email signatures?
Click download Free Trial
Manage Email Signatures centrally from your Desktop - For All Users
extend your brand and promote your products, services, special events and news
 
The Ultimate Resource for eMailSignaturer eMailSignature Wiki Add URL in your RSS reader Send answers to my inbox Add URL in your RSS reader Get answers  RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Error in database consistency

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


Joined: 19 Jul 2007
Posts: 46

Posted: Sat Feb 06, 2010 1:45 am    Post subject: Error in database consistency Reply with quote

I upgraded successfully from v5.5 to 7.0.2. When I run Check Settings Database Consistency, I get the following error:

"Cheking table lgdaUsers - No value given for one or more required parameters."

I also had this error a couple of years ago and you told me to do the following which I did:
"Please create a col in the table lgdaUsers called vcf and of type ntext."

So, I looked in the lgdaUsers table this time but I already have that column. What do I do now to fix the error?
Back to top
View user's profile Send private message
Jesper Frier
Certified Professional
Certified Professional


Joined: 09 Sep 2006
Posts: 1924
Location: Stoevring, Denmark

Posted: Sat Feb 06, 2010 9:16 am    Post subject: eMailSignature 7.1.0 supports Outlook 2010 Beta Reply with quote

Could you please ZIP and forward your settings.mdb to jf@brandedmails.com.

Then I will fix your database.

Exclamation You should use Cockpit.exe and Sign.exe version 7.0.4 which is the latest version. Or wait a few days as we will soon release version 7.1.0 which supports Outlook 2010 Beta (you will be notified by email as a registered user on these forums).
_________________
</Jesper> | Manage Email Signatures from your Desktop | Test Email Signature in All In-boxes | Email Signature Showcase
Back to top
View user's profile Send private message Visit poster's website
mlouie
Just can't stay away


Joined: 19 Jul 2007
Posts: 46

Posted: Sun Feb 07, 2010 1:22 am    Post subject: Re: eMailSignature 7.1.0 supports Outlook 2010 Beta Reply with quote

Jesper Frier wrote:
Could you please ZIP and forward your settings.mdb to jf@brandedmails.com.

Then I will fix your database.


I have just e-mailed the database to you and will upgrade to 7.0.4.
Back to top
View user's profile Send private message
mlouie
Just can't stay away


Joined: 19 Jul 2007
Posts: 46

Posted: Sun Feb 07, 2010 1:27 am    Post subject: Re: eMailSignature 7.1.0 supports Outlook 2010 Beta Reply with quote

I just upgraded from 7.0.2 to 7.0.4 and looks like it fixed the database problem:

Checking database consistency.
Database: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\eMailSignature\settings.mdb
---------------------------------------
If any 'invalid column names' are reported here, you will need to create that column in
the table. The reason for the column to missing is that the database has not been upgraded
to match this version of eMailSignature. Please consult www.emailsignature.eu
Documentation section for data types by viewing the SQL create script.

Cheking table campaign - OK
Cheking table categories - OK
Cheking table disclaimer - OK
Cheking table general - OK
Cheking table License - OK
Cheking table livemessage - OK
Cheking table lgdaCampaignGroups - OK
Cheking table lgdaDefault - OK
Cheking table lgdaGroups - OK
Cheking table lgdaNoUsers - OK
Cheking table lgdaUsers - OK
Cheking table licenseGroups - OK
Cheking table OWA - OK
Cheking table pictures - OK
Cheking table Preview - OK
Cheking table rootcontext - OK
Cheking table settings - OK
Cheking table stationery - OK
Cheking table lgdaCollect - OK
Cheking table lgdaOWA - OK
Cheking table settingsLegal - OK
Cheking table users - OK
--------------------------------
Database check completed.
Back to top
View user's profile Send private message
mlouie
Just can't stay away


Joined: 19 Jul 2007
Posts: 46

Posted: Tue Apr 13, 2010 12:36 am    Post subject: Re: eMailSignature 7.1.0 supports Outlook 2010 Beta Reply with quote

Jesper Frier wrote:
Could you please ZIP and forward your settings.mdb to jf@brandedmails.com.

Then I will fix your database.

Exclamation You should use Cockpit.exe and Sign.exe version 7.0.4 which is the latest version. Or wait a few days as we will soon release version 7.1.0 which supports Outlook 2010 Beta (you will be notified by email as a registered user on these forums).


I just upgraded from 7.0.4 to 7.3 and when I run the database consistency checker, I get the error again:
Checking table lgdaUsers - No value given for one or more rquired parameters. So I guess I will zip and send the mdb to you.
Back to top
View user's profile Send private message
Jesper Frier
Certified Professional
Certified Professional


Joined: 09 Sep 2006
Posts: 1924
Location: Stoevring, Denmark

Posted: Tue Apr 13, 2010 5:00 am    Post subject: No value given for one or more rquired parameters Reply with quote

A database checked OK in version 7.0.4 consistency checker is also OK in version 7.3.0 consistency checker.

Please check that your Cockpit is connected to the upgraded database, and try again - or follow instructions here: How to upgrade.

Thanks.
_________________
</Jesper> | Manage Email Signatures from your Desktop | Test Email Signature in All In-boxes | 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 from your Desktop - 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 Aps.