I tried to import subsribers from file, but the field activation_key and unsubscribe_key does not fill up automatically. Why is this so?
I solved this problem by creating trigger on table cscart_user_mailing_lists.
CREATE TRIGGER cscart_user_mailing_lists_md5
BEFORE INSERT ON cscart_user_mailing_lists
FOR EACH ROW
SET NEW.activation_key = md5(rand()),
NEW.unsubscribe_key = md5(rand());
In my opinion during import subscribers, md5 keys should generate automatically.
I import subsribers from csv file, but the field activation_key and unsubscribe_key does not fill up automatically.
I tried to fix this problem by creating the trigger like you described on table cscart_user_mailing_lists.
But when I import the file there still insn't a md5 key in the field activation_key and unsubscribe_key.
But the trigger is installed because when I tried to add the trigger again sql says "only one trigger allowed.
Yesss I did it, I only had to open subsribers in cscart admin panel select all and klick on the save botton