LAKostis / mailman2sympa

mailman2sympa migration scripts
3 stars 2 forks source link

Update loadsubscribers.pl for timestamp #3

Closed kepon85 closed 2 years ago

kepon85 commented 2 years ago

A timestamp is expected in the Sympa database, except in the CSV I have a YYYY-MM-DD format. It is therefore necessary to convert them in the script so as not to have the error:

Finished with users - now handling their subscription
DBD::mysql::st execute failed: Data truncated for column 'date_epoch_subscriber' at row 1 at ./scripts/loadsubscribers.pl line 202.
Can't call method "finish" on an undefined value at
    ./scripts/loadsubscribers.pl line 265 (#1)
    (F) You used the syntax of a method call, but the slot filled by the
    object reference or package name contains an undefined value.  Something
    like this will reproduce the error:

        $BADREF = undef;
        process $BADREF 1,2,3;
        $BADREF->process(1,2,3);

Uncaught exception from user code:
    Can't call method "finish" on an undefined value at ./scripts/loadsubscribers.pl line 265.

Note : Debian 9, mailman and sympa in debian package version