Henrique de Moraes Holschuh <h...@debian.org> writes: > LOC, could you send (to this bug report) a dump of the *schema* for the > relevant tables (the ones returning 0 instead of the correct float) ?
LOC, please connect to the database using the mysql client, and type in the following commands. Send back the results. desc spamfilter_users; desc spamfilter_policy; SELECT *,spamfilter_users.id FROM spamfilter_users LEFT JOIN spamfilter_policy ON spamfilter_users.policy_id=spamfilter_policy.id WHERE spamfilter_users.email IN ('recei...@domain2.com','@domain2.com','@.domain2.com','@.com','@.') ORDER BY spamfilter_users.priority DESC; (I don't have a mysql server handy to test this on, however the first two should dump the database schema and the last should reproduce the failing query) Can I also confirm that absolutely nothing is writing to these tables? > Maybe ISPConfig is not creating them exactly the same way amavisd- > new would... I see schema information at https://git.ispconfig.org/ispconfig/ispconfig3/blob/0f9fa27a6c7026f77c7d857c971b1db1b709f583/install/sql/ispconfig3.sql - according the git blame this hasn't changed within 6 years (line endings were changed). I would like confirmation that this matches what is installed on the LOC's system. The above commands should answer that. -- Brian May <b...@debian.org>