Someone edited an answer in my database manually because they were too lazy to login and edit an active survey. For some reason though, any one who chose that option as answer now shows a blank line in the statistic report. Is there a cache somewhere that has not been updated? FYI, the answer code is the same....just the text for that code was changed. How can I fix this?

Hi,
1. the usual question: Which version of LS?
2. what kind od question is affected: Single punch or multi punch?
3. what do you mean by "blank line in the statistic report"?

Best regards
Joffm

1) I am using the latest version of LS 3.6.2.
2) It is a single punch question (radio).
3) When I go to check off the questions to include in the statistics, each question is displayed with a list of the answers. I can see the answer text for all questions except the answer that was edited on the question selection page for statistics.

Hi,
I just created a test survey in 3.6.2.
Entered a few responses and got this in the statistics page:


and this statistic result:


Well, now I changed one answer option in phpMyAdmin in table [lime_prefix]_answers:


and entered again a few responses in this question

In the statistics page I saw the following:


So, unfortunately I could not reproduce.

So probably the person destroyed a bit more than only editing a text.

Best regards
Joffm