Search found 32 matches
- Fri Mar 11, 2011 7:03 pm
- Forum: Bounce Management
- Topic: Can't get my e-mail server to accept incoming e-mails
- Replies: 8
- Views: 24116
Can't get my e-mail server to accept incoming e-mails
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...
- Tue Dec 14, 2010 4:12 pm
- Forum: Bugs, bug fixes & releases
- Topic: customer_id = 0 gets assigned
- Replies: 21
- Views: 28569
- Tue Dec 14, 2010 3:41 pm
- Forum: Bugs, bug fixes & releases
- Topic: customer_id = 0 gets assigned
- Replies: 21
- Views: 28569
- Tue Dec 14, 2010 3:09 pm
- Forum: Bugs, bug fixes & releases
- Topic: customer_id = 0 gets assigned
- Replies: 21
- Views: 28569
mysql> desc customer_1_tbl; +---------------+--------------+------+-----+--------------------------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+--------------+------+-----+--------------------------+-------+ | customer_id | int(11) | NO | | 0 | | | email | varchar(100)...
- Tue Dec 14, 2010 2:40 pm
- Forum: Bugs, bug fixes & releases
- Topic: customer_id = 0 gets assigned
- Replies: 21
- Views: 28569
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...
- Tue Dec 14, 2010 2:02 pm
- Forum: Bugs, bug fixes & releases
- Topic: customer_id = 0 gets assigned
- Replies: 21
- Views: 28569
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...
- Tue Dec 14, 2010 1:43 pm
- Forum: Bugs, bug fixes & releases
- Topic: customer_id = 0 gets assigned
- Replies: 21
- Views: 28569
thanks - I tried that, see result:
Code: Select all
mysql> ALTER TABLE `customer_1_tbl` MODIFY `customer_id` int(11) AUTO_INCREMENT;
ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be defined as a key
- Tue Dec 14, 2010 1:40 pm
- Forum: Bugs, bug fixes & releases
- Topic: customer_id = 0 gets assigned
- Replies: 21
- Views: 28569
- Tue Dec 14, 2010 1:32 pm
- Forum: Bugs, bug fixes & releases
- Topic: customer_id = 0 gets assigned
- Replies: 21
- Views: 28569
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...
- Tue Dec 14, 2010 1:25 pm
- Forum: Bugs, bug fixes & releases
- Topic: customer_id = 0 gets assigned
- Replies: 21
- Views: 28569
- Tue Dec 14, 2010 1:17 pm
- Forum: Bugs, bug fixes & releases
- Topic: customer_id = 0 gets assigned
- Replies: 21
- Views: 28569
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...
- Mon Dec 13, 2010 3:20 pm
- Forum: Bugs, bug fixes & releases
- Topic: customer_id = 0 gets assigned
- Replies: 21
- Views: 28569
version
I use 6.2 but and I noticed the bug after I did the update.ma wrote:Which version of OpenEMM do you use?
- Sat Dec 11, 2010 9:53 pm
- Forum: Bugs, bug fixes & releases
- Topic: customer_id = 0 gets assigned
- Replies: 21
- Views: 28569
customer_id = 0 gets assigned
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...
- Mon Feb 22, 2010 2:15 pm
- Forum: Installation & Upgrades
- Topic: running - but missing table and configs
- Replies: 6
- Views: 7487
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.
Code: Select all
sudo apt-get install python-mysqldb
- Sun Feb 21, 2010 2:17 pm
- Forum: Installation & Upgrades
- Topic: Sending mails failed
- Replies: 16
- Views: 47008
Thanks!
This was it for me as well, thank you! Under Ubuntu it was installing the python-mysqldb package.
Best, Peter
Code: Select all
sudo apt-get install python-mysqldb