Hi,

We have a manual workaround in place that when a user finds no emails being 
sent they copy and paste the text fields from the existing review into 
notepad++, encode to UTF8 which highlights the invalid character(s), 
removes/edits them and copy pastes them back into reviewboard so the system 
behaves and emails are sent out.

If anyone knows of a way to automate the conversion to UTF8 (+strip out or 
replace invalid characters) that would be greatly appreciated.

Regards,
Adam Driscoll


On Friday, 16 January 2015 17:28:47 UTC+11, Adam Driscoll wrote:
>
> Hi,
>
> "Some" old reviews dont work.
>
> I'm not yet sure what it is, but it might be special characters in any of 
> the review text fields.
>
> Hope this adds more information.
>
> Cheers,
> Adam
>
>
> On Friday, 16 January 2015 15:56:13 UTC+11, Adam Driscoll wrote:
>>
>> Hi Folks,
>>
>> I hope everyone is doing well.
>>
>> We recently upgraded from 1.7.11 to 2.0.12 and have sorted out most of 
>> the problems except this weird one.
>>
>> New reviews work fine. Old reviews dont and this is the "slightly edited" 
>> error call stack from the error log reviewboard.log
>>
>>
>> **********************************************
>>
>> 2015-01-16 04:12:17,687 - ERROR -  - Error sending e-mail notification 
>> with subject 'Re: Review Request 3782: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx' on 
>> behalf of '"Paul xxxxx" <paul.xx...@xxxxx.com>' to '"Roger xxxx" <
>> roger.x...@xxxxxxxx.com>,"Paul xxxxx" <paul.x...@xxxxxxx.com>,"Dzianis 
>> xxxxxx" <dzianis.xx...@xxxxxx.com>': 'ascii' codec can't encode 
>> character u'\u2026' in position 2058: ordinal not in range(128)
>> Traceback (most recent call last):
>>   File 
>> "/usr/local/lib/python2.6/dist-packages/ReviewBoard-2.0.12-py2.6.egg/reviewboard/notifications/email.py",
>>  
>> line 293, in send_review_mail
>>     message.send()
>>   File 
>> "/usr/local/lib/python2.6/dist-packages/Django-1.6.10-py2.6.egg/django/core/mail/message.py",
>>  
>> line 276, in send
>>     return self.get_connection(fail_silently).send_messages([self])
>>   File 
>> "/usr/local/lib/python2.6/dist-packages/Django-1.6.10-py2.6.egg/django/core/mail/backends/smtp.py",
>>  
>> line 94, in send_messages
>>     sent = self._send(message)
>>   File 
>> "/usr/local/lib/python2.6/dist-packages/Django-1.6.10-py2.6.egg/django/core/mail/backends/smtp.py",
>>  
>> line 110, in _send
>>     self.connection.sendmail(from_email, recipients, message.as_bytes())
>>   File 
>> "/usr/local/lib/python2.6/dist-packages/Django-1.6.10-py2.6.egg/django/core/mail/message.py",
>>  
>> line 137, in as_string
>>     g.flatten(self, unixfrom=unixfrom)
>>   File "/usr/lib/python2.6/email/generator.py", line 84, in flatten
>>     self._write(msg)
>>   File "/usr/lib/python2.6/email/generator.py", line 109, in _write
>>     self._dispatch(msg)
>>   File "/usr/lib/python2.6/email/generator.py", line 135, in _dispatch
>>     meth(msg)
>>   File "/usr/lib/python2.6/email/generator.py", line 201, in 
>> _handle_multipart
>>     g.flatten(part, unixfrom=False)
>>   File "/usr/lib/python2.6/email/generator.py", line 84, in flatten
>>     self._write(msg)
>>   File "/usr/lib/python2.6/email/generator.py", line 109, in _write
>>     self._dispatch(msg)
>>   File "/usr/lib/python2.6/email/generator.py", line 135, in _dispatch
>>     meth(msg)
>>   File "/usr/lib/python2.6/email/generator.py", line 178, in _handle_text
>>     self._fp.write(payload)
>> UnicodeEncodeError: 'ascii' codec can't encode character u'\u2026' in 
>> position 2058: ordinal not in range(128)
>>
>> ******************************************************
>>
>>
>> Any ideas?
>>
>>
>> I happy to run some SQL to clean out old reviews that have invalid 
>> characters for the subject lines. Just not sure what is supported in RB and 
>> what the SQL to update it would be.
>>
>> Cheers,
>> Adam Driscoll
>>
>>

-- 
Get the Review Board Power Pack at http://www.reviewboard.org/powerpack/
---
Sign up for Review Board hosting at RBCommons: https://rbcommons.com/
---
Happy user? Let us know at http://www.reviewboard.org/users/
--- 
You received this message because you are subscribed to the Google Groups 
"reviewboard" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to reviewboard+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to