Using "User mailman register" 5.x-1.x-dev, I receive such this warning for each subscription and unsubscription to a list:

user warning: Data too long for column 'type' at row 1 query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (10, 'user mailman register', 'Unsubscription to..."

Really, the "type" column in the "watchdog" table is a char(16). "user mailman register" string is 21 chars.. it doesn't fit :)

I suggest to replace every occurrence of:
watchdog('user mailman register',
with something like: watchdog('usermailmanreg',
in user_mailman_register.module.

Am I the only one having this error???

Comments

samuelet’s picture

samuelet commented

You're right. This bug was missed because it depends on the database backend.
In mysql 5, the one i'm using now, chars too long are trimmed automatically by the database itself.
I guess yours is postgresql or an old version of mysql.
I'm going to change all the occurency with the same string trimmed by mysql: 'user mailman reg'
Thanks

samuelet’s picture

samuelet commented
Status: Active » Fixed
lbertrand’s picture

lbertrand commented

I was able to edit the file on my own system and there are no more errors. Thanks.

francoud’s picture

francoud commented

It was on Mysql 5.0.37 really, so not so old... but who knows :) Anyway, thanks :)

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.