Henrique de Moraes Holschuh <[email protected]> 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
('[email protected]','@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 <[email protected]>
