OpenEMM Technical Support Forum

I am not sure what I am doing wrong, I have not been able to get bounce management to work because I can't get my e-mail server to accept e-mails. Each time I send an e-mail to it to see, it bounces, I get the following: This is an automatically generated Delivery Status Notification THIS IS A WARNI...

I tested it and it does what it is supposed to, thank you very much! Very happy!

Fantastic, that did the trick!

mysql> desc customer_1_tbl; +---------------+--------------+------+-----+--------------------------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+--------------+------+-----+--------------------------+-------+ | customer_id | int(11) | NO | | 0 | | | email | varchar(100)...

I don't understand either, but how do I make it an autoincrement field? if I do the code you gave me, ALTER TABLE `customer_1_tbl` MODIFY `customer_id` int(11) AUTO_INCREMENT; I get an error message as you saw - and if I do what I did which is alter table customer_1_tbl change customer_id customer_i...

before I did this I restored the original customer_1_tbl so there wasn't an auto increment column, the current structure is: | Field | Type | Null | Key | Default | Extra | +---------------+--------------+------+-----+--------------------------+-------+ | customer_id | int(11) | NO | | 0 | | I haven...

thanks - I tried that, see result:

I see. Well I can't remember changing anything on that - I did get some error message on the update to 6.2 but I did not see that it would have caused this - and I did not have this problem up until 3 days ago.

how should I handle it?

and I am not sure how to fix it... After backing up my customer_1_tbl, I did alter table customer_1_tbl change customer_id customer_id Int(11) auto_increment not null; So now | Field | Type | Null | Key | Default | Extra | customer_id | int(11) unsigned | NO | PRI | NULL | auto_increment | But now w...

hmmm, good question, I think 6.0.1.

Oh, good customer_1_tbl_seq is not used any more. Can I just drop that table then? I just looked, I think that's what the bug is. DESCRIBE customer_1_tbl; gives | Field | Type | Null | Key | Default | Extra | customer_id | int(11) | NO | | 0 | | so that might be the bug - that customer_id is not set...

ma wrote:Which version of OpenEMM do you use?

I use 6.2 but and I noticed the bug after I did the update.

I recently imported a large amount of data - and then I noticed that all of the customer_IDs that imported are 0 - it is not incrementing any more. I fixed that with some SQL gymnastics and I also entered the highest customer_id I generated from customer_1_tbl into customer_1_tbl_seq - but then I tr...

Thanks. It looks like missing that table actually was not the problem for me - it was that I did not have the package python-mysqldb installed.

was the solution.

This was it for me as well, thank you! Under Ubuntu it was installing the python-mysqldb package.
Best, Peter