Thank you!  I replaced PMAIL7\MAIL\ADMIN\words4.db3 with an old backup version, and now all is well.

<div style="font-size: 10pt; padding-top: 8px; padding-right: 8px; padding-bottom: 8px; padding-left: 8px; "><p>Hi!</p><p>I have been using spamhalter ever since I startet using pegasus mail in 1999. After the latest update, when starting pegasus, I recieve the following message:</p><p> "SpamHalter cannot initialize database!</p><p>Bayesian filtering cannot be used until you fix or delete you database! </p><p>For deleting database remove all files in your mail directory with names starting with "words4.db3" and "white4.db3".</p><p>Than you must start Pegasus Mail again. </p><p> Database error is:</p><p>Error executing SQL statement."</p><p><span style="font-size: 10pt; ">Error[19]: Abort due to contraint violation.</span></p><p>"VACUUM": PRIMARY KEY must be unique</p><p> </p><p>I know I could just delete the named files, but I suppose 12 years of learning would be gone from SpamHalter. Is there a way to solve this problem (or at least try) without deleting those files? </p><br class="Apple-interchange-newline"><p> </p></div>

<p>Backup of these files isn't available?</p><p>bye   Olaf</p><p> </p>

<p>[quote user="Liotec"]I know I could just delete the named files, but I suppose 12 years of learning would be gone from SpamHalter. Is there a way to solve this problem (or at least try) without deleting those files? [/quote]</p><p>If you know how to manually fix SQLite databases using a proper tool you may be able to fix the database.</p>

			Michael
--
IERenderer's Homepage
PGP Key ID (RSA 2048): 0xC45D831B
S/MIME Fingerprint: 94C6B471 0C623088 A5B27701 742B8666 3B7E657C

<P>Try rebuilding the database(s) something like:</P> <P>ren words4.db3 words4.bak sqlite3 words4.bak .output words4.sql .dump .exit sqlite3 words4.db3 .read words4.sql .exit</P> <P><IMG style="WIDTH: 352px; HEIGHT: 276px" title="sqlite3 commands" alt="sqlite3 commands" src="http://oi41.tinypic.com/15y8cpy.jpg" width=352 height=276 mce_src="http://oi41.tinypic.com/15y8cpy.jpg"></P>

<p>Hello Liotec, did you find a solution?  I am having the same problem since upgrading from 4.6.2 to 4.6.3 (English).  </p><p> Thank you. </p>

<p>[quote user="Teffy"]Hello Liotec, did you find a solution?  I am having the same problem since upgrading from 4.6.2 to 4.6.3 (English).[/quote]</p><p>All solutions are in the thread:</p><ul><li>you take your <b>BACKUP </b>and restore last working version </li><li>You know about <b>SQL </b>(Sequential Query Language) an d the commands, find the datarecord with same data in indexfiled and delete it or</li><li>you delete the whole file / database and have some training with spamhalter again</li></ul><p>bye   Olaf</p><p> </p><p> </p>