Reporting Module Conversations Report: Graph shows all conversations on last day of selected period about freescout HOT 10 CLOSED

The only way to figure it out is for someone to check on your server.

from freescout.

today the graph showed up as this:

The new conversation from today is reported correctly.

As I installed the reporting module yesterday, together with an upgrade of free scout, I believe that might be the cause. (Does the reporting module use other DB columns than freescout uses for date/timestaming? I have not yet looked at the code.)

As this issue seems to no longer appears for new conversations, I think this case can be closed.

from freescout.

Cool, thanks!

Installed the update and I can confirm the issue has been resolved! Great work!

from freescout.

Can you provide a screenshot of some conversation from that period?

from freescout.

These conversations are (new) from may tenth:

from freescout.

Have been looking into this a bit; for the new conversations the DB query seems to look at the updated_at column, where I would expect a created_at column:

I changed this to created_at as test, now the graph appears correct:

I also changed this for the Messages Received query, which also fixed the issue.

For now, I am assuming the modified column got overwritten by the most recent upgrade of freescout, as these messages have not been edited since creation. create date should be modified date, but apparently are not.

from freescout.

I to am having the same issue,

where can I go to fix this please ?

from freescout.

I changed the chartNewConvData and chartMessagesData functions in ReportsControllers.php file in ./Modules/Reports/Http/Controllers to use the created_at columns in stead of updated_at.

Please beware, this is a temporary fix as I am sure this will be overwritten in the next automatic update.

I believe something went wrong in the last upgrade to the latest FreeScout release which caused all the updated_at columns to be overwritten with the current date. That is probably the reason the report stopped working. I have not looked at the database yet, as I don't have phpMyAdmin or a similar tool installed at our server.

I have tried to re-open this issue to let this know to the maintainer but have not found a way yet.

from freescout.

I just did a quick check from the console:

2024-05-28 10:10:04 is the moment I did the last upgrade of Freescout. I will submit this as a separate issue for the maintainer to look at.

from freescout.

It has been fixed in Reports Module v1.0.41

from freescout.