johnrajbd / bots

Automatically exported from code.google.com/p/bots
0 stars 0 forks source link

mimefile msgid may exceed 70 chars (too big for database) #318

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago
in communication.py file2mime a message id is generated. This can be longer 
than 70 characters depending on your server name. Later it is put in ta 
reference which is 70 long. Does not cause a problem with SQLite but it is an 
error for MySQL.

reference = email.Utils.make_msgid(unicode(ta_to.idta))

ta_to.update(frommail=frommail,tomail=tomail,cc=ccto,reference=reference)

I changed this to:
ta_to.update(frommail=frommail,tomail=tomail,cc=ccto,reference=reference[:70])

Original issue reported on code.google.com by mjg1964 on 25 Mar 2015 at 6:01

GoogleCodeExporter commented 8 years ago

Original comment by hjebb...@gmail.com on 25 Mar 2015 at 6:42

GoogleCodeExporter commented 8 years ago
yes. 
think it is good to expand the ID field with next database change

Original comment by hjebb...@gmail.com on 26 Mar 2015 at 3:41

GoogleCodeExporter commented 8 years ago

Original comment by hjebb...@gmail.com on 26 Mar 2015 at 3:52