New email grabs lots of contacts, but doesn't create draft

[dabrowski]

I set up an email and when I click New Email, I get the Back button and the whitespace below is populated with dozens of contacts, but it is not editable and there are no tools for writing the email.

It seems to be grabbing Company names separated by commas.

[dabrowski]

forums.fengoffice.com/index.php?topic=3648.0 (Can't post links)

Just found this old message in Bugs:

Can't reply to it, but it seems like exactly what's happening to me. However, with the solution the author suggested, I'm still not seeing any anomalies in the Contacts table, so if anyone can point me to what I should be looking for, I'd appreciate it.

Thanks.

[dabrowski]

Okay, me,

I looked over the companies table, since it seemed to be trying to output companies before it fails. (The other thread has contacts.)

I saw that all of the companies that have an apostrophe aren't escaped, and I wondered if that was killing the query. So I removed the apostrophe from the 30 or so company names via PHPMyAdmin.

Problem persists, but now, for a company name that was "Brown's Company," and is now "Browns Company," I can't find the record in Feng with "brown's" or "browns," but it is still in the system and can be found by searching for "company."

Is that because I changed it on the backend and there is a cached index value or something?

Still not sure what's causing the problem in the Compose mode.

[dabrowski]

Ultimately discovered one company name that had a tagline snuck in with the company name, leaving Company Name "The best Company around." in the field. The double quotes killed the SQL statement.

So this is resolved. Hope it helps someone else on the forums.

[franponce87]

Thanks a lot for your inputs. No doubt they are useful in the future!

Best regards,
Francisco