This one is the current SQL schema and works
http://svn.apache.org/repos/asf/spamassassin/tags/spamassassin_current_release_3.3.x/sql/bayes_mysql.sql
- Lawrence
On 20/06/2011 7:34 PM, Dave Wreski wrote:
Hi,
I have an existing v3.3.2 on fedora14 (perl v5.12.3) that I'm trying
to convert bayes to use mysql. The restore process fails after a few
minutes due to too many errors:
dbg: bayes: error inserting token for line: t 1 0 1308114254 4fd2b3f2f0
dbg: bayes: _put_token: Updated an unexpected number of rows.
[repeats ...]
bayes: encountered too many errors (20) while parsing token line,
reverting to empty database and exiting
dbg: plugin: Mail::SpamAssassin::Plugin::Bayes=HASH(0x26b8af8)
implements 'learner_close', priority 0
ERROR: Bayes restore returned an error, please re-run with -D for more
information
This was already run with -D, so no further information is available.
I used the sql files from
spamassassin.apache.org/full/3.0.x/dist/sql/bayes_mysql.sql to create
the tables. Maybe the format has changed since then and there is a
more updated file?
I'm using the sa from
http://kojipkgs.fedoraproject.org/packages/spamassassin/3.3.2/1.fc14/x86_64/
Is there a way to skip these invalid records? Other ideas for
resolving this?
I can successfully restore back to the normal dbm database.
Thanks,
Dave
