Group Email has messages, but shows empty

[sugarnoah]

Hello,

I have a strange error.

We have a group e-mail box. (support@xxx.com). E-mails ARE sucessfully making it into the box.

On the left panel, I see the group email box with a count of new messages in it.
When I click on the "folder" for that group e-mail box, IT DOESN'T SHOW ANY MESSAGES IN THE LIST VIEW ON THE RIGHT. NO MATTER WHAT I CLICK, I CAN'T SEE THE ACTUAL MESSAGES IN THE GROUP BOX.

For some reason this is a new behavior. It has been working fine for months, and just recently started this problem.

Since I know a bit about software development, I took a look at the activity using firebug. (A javascript debugger.) It show that the messages ARE being returned back from the ajax request. So the database, query, message, email, etc are fine. The problem seems to be with the code to display the listview.

Can anybody help?

-Noah

[sugarnoah]

I still haven't resolved this issue. Does anybody have any suggestions??

[sugarnoah]

bump bump bump bump bump bump

[clusters]

No kidding! The same thing had just happened to us. Have you found the fix yet? Or anyone know what to do to fix this issue? I appreciate your help. Thanks! Tim

[sgandhi]

Hi All,
Can you please try this. Goto Emails/EmailUI.php file. There is a function arrayToXML. In that there is a line

$good = array(...) with the one of the array entries has data of 145

replace that data with

39

and see if it works ??

Let me know.

Thanks
-Samir

[clusters]

I did that and changed the value from 145 to 39 but received the same thing. The messages may or may not show and let's take one of our group email sales. Sales has a total of 279 messges so based on 20 messages per page I would have 14 pages; however, when I get to page 3 it would say page 3 of 1 and no/0 email messages. Page 4 and on is again okay? Please help. Thx! Tim

p.s. I select multiple messages for delete could that cause a problem?

[sgandhi]

Make, Number of Emails per Page: to lets say 10 on the Emails General tab. I believe that for a particular page you are not seeing the data. Look at the page data. If you have a firefox browser then you can see the data in firebug. Grap the uid column data and query the Emails_text table as thats the email_id colukn data and see all the data expecially from_addr, reply_to_addr column and tell me what do you see. I believe it a data issue.

Thanks
-Samir

[clusters]

Hello Samir:

I tried that but the problem is that when the right pane is showing 0 messages I am not able to select a message so the uid has no value. Hence, I am not able to make a selection at the emails_text table with a uid. Also, do you think I can go delete some of the spam in the emails_text table and it may fix the problem? There is a good chance that our info and sales group folder received the same spam that is crashing our sugar email. If deleteing from the emails_text table, what other table(s) joins the emails_text table? Any comments are greatly appreciaed!

Thank you so much!

Regards,

Tim

[clusters]

Okay, our customer service and sales are waiting for me with hopes...

I did the below query...

select a.id, b.from_addr, b.to_addrs from emails a, emails_text b where a.id = b.email_id and a.mailbox_id = 'd44f24d0-ffe4-09e4-15db-4873adb018f3' and a.deleted = 'NO';

where mailbox_id belongs to a group folder. Strange enough, both group mailboxes contain an identical spam email that contains null from_addr and to_addr.

+--------------------------------------+-----------+----------+
| id | from_addr | to_addrs |
+--------------------------------------+-----------+----------+
| 8ecfc98a-f7d0-859c-0b0e-4891564d1735 | | |
+--------------------------------------+-----------+----------+

So could this be it? If so, can I just delete these two records in emails and emails_text tables as they do not belong to any cases or projects? Further, is there a setting in Sugar where I could set to prevent such error to occur again? I know we need better spam filtering and perhaps make all the spams non-deliverable instead of tag and deliver. But for now we are not ready for that yet. Thanks ahead for your help!

Sincerely,

Tim

[clusters]

%$#@&!...people with nothing to do but sending spam...yeah, that was it. I updated the records in the emails_text table to contain not null from_addr and to_addr and email is working fine again. I can now use surgar to delete the emails instead of using mysql. thank goodness i got to go to sleep...I would still appreciate to hear if there is a setting that allows me to prevent this from happenning again...thank you so much for being a sugar super hero and offering help!

Sincerely,

Tim