Dennis Putnam via Mailman-users writes:
> From database mailmanweb:
>
> mysql> show tables;
I'm sorry for the typo for account_emailaddress, but I don't need
this. I know what tables mailmanweb creates, and what tables mailman
creates.
> The table account_emailaddress has 3 entries:
>
> mysql> select * from account_emailaddress;
> +----+-----------------------+----------+---------+---------+
> | id | email | verified | primary | user_id |
> +----+-----------------------+----------+---------+---------+
> | 1 | [email protected] | 1 | 1 | 2 |
> | 2 | [email protected] | 0 | 0 | 3 |
> | 3 | [email protected] | 1 | 1 | 4 |
> +----+-----------------------+----------+---------+---------+
> 3 rows in set (0.00 sec)
>
> Yes, id 1 and 2 are the same email address.
I asked for the superuser ONLY. I assume "xxxxxxxx" is irrelevant and
"uuuu" is the superuser, and I guess the duplicate is probably why you
have the verification loop, as Mark did. Please check the logs for a
backtrace indicating that the address [email protected] was found
twice. I'm not sure it will be there, but if it is, I'd like to see
it (the whole thing including the specific exception).
> I'm not sure what you want to see in this address table.
I want to see the address of the superuser (if it's there, it might
not be). That's why I specified a WHERE clause.
> There is a lot of unexpected email addresses that I have no idea
> where they came from.
Why "unexpected"? I seem to recall you tried a migration of your list
from Mailman 2 at some point. Deleting your Mailman 3 installation
will not delete the MySQL databases. You need to do explicit DROPs on
them from an SQL application. Mailman 3 does not do that for you.
> In any case the user_id in this table does not correspond to the
> user_id in the table from the previous mailmanweb table.
I still want to see the query results (with the WHERE clause, please).
The user_ids need not be equal. Addresses in mailmanweb are many-to-
one with users, and addresses in mailman are many-to-one with users,
so addresses are used to identify users in both databases.
--
GNU Mailman consultant (installation, migration, customization)
Sirius Open Source https://www.siriusopensource.com/
Software systems consulting in Europe, North America, and Japan
_______________________________________________
Mailman-users mailing list -- [email protected]
To unsubscribe send an email to [email protected]
https://lists.mailman3.org/mailman3/lists/mailman-users.mailman3.org/
Archived at:
https://lists.mailman3.org/archives/list/[email protected]/message/JOEBDBYUAGNZ2IPCA76H3WZ7N4M65DDD/
This message sent to [email protected]
