Skip to content

Incorrect info being stored in AWL? #8

Description

@jpotter

I'm seeing something that doesn't make any sense to me. On a new install, with TxRep set to use MySQL for storage (via the AWL stuff), I'm getting rows inserted that are impossible.

Here's the data for an email address with someone I corresponded with. I have changed the domains for privacy.

Jpotter (me) and Jeremy are emailing each other. Jeremy is on a different system.
Matt Smithon emailed another user on our system; Matt is on a different system.

I've never emailed Matt; Matt has never emailed me.

Why are there rows in AWL that have Matt and Jeremy as a row? Neither Matt or Jeremy are on this system, they don't know each other at all, there's never been any email between them in any context.

Thanks!

select * from awl where email like '%foobar%' or username like '%foobar%';
+-------------------------------------+--------------------------+-------+-------+----------+----------+---------------------+
| username                            | email                    | ip    | count | totscore | signedby | lastupdate          |
+-------------------------------------+--------------------------+-------+-------+----------+----------+---------------------+
| jpotter@somewhere.com               | jeremy.lehman@foobar.com | none  |     1 |      -25 |          | 2015-01-21 14:31:05 | 
| daemon                              | foobar.com               | 50.32 |     1 |   -0.499 |          | 2015-01-21 22:21:08 | 
| daemon                              | jeremy.lehman@foobar.com | none  |     1 |      -25 |          | 2015-01-22 07:03:27 | 
| matt smithon <smithon@widgetco.com> | jeremy.lehman@foobar.com | none  |     1 |   -0.509 | spf      | 2015-01-21 22:21:08 | 
| matt smithon <smithon@widgetco.com> | foobar.com               | none  |     1 |   -0.509 | spf      | 2015-01-21 22:21:08 | 
+-------------------------------------+--------------------------+-------+-------+----------+----------+---------------------+

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions