Statistics subtotal shows wrong values after update

More
4 days 21 hours ago - 4 days 21 hours ago #199843 by tamiel
Upgrade from 3.12 to 4.24 and now when generating statistics, the filter correctly shows the filter shows "number of records in this query" correctly, but the total (gross) value still holds to "Total records in survey" value leading to percentages that extrapolate the real (filtered) number of records and percentages are off.
Tried to find if there is a new setup where is defined and looked at the manual but could not find anything. In version 3.12 it works correctly - total (gross) is calculated correctly. It doesn't seem to matter if "Subtotals based on displayed questions" is checked or not. The same results show up.



Attachments:
Last edit: 4 days 21 hours ago by tamiel.

Please Log in to join the conversation.

LimeSurvey Partners
More
4 days 12 hours ago - 4 days 12 hours ago #199853 by tpartner
Please submit a bug report - www.limesurvey.org/community/bug-tracker .

Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
Official LimeSurvey Partner - partnersurveys.com
Last edit: 4 days 12 hours ago by tpartner.
The following user(s) said Thank You: DenisChenu, tamiel, cdorin

Please Log in to join the conversation.

More
4 days 7 hours ago #199867 by tamiel
The following user(s) said Thank You: DenisChenu, tpartner, cdorin

Please Log in to join the conversation.

More
1 day 9 hours ago #200062 by mikecouchman
Same issue here. Version 4.2.4+200520 (issue discovered in 4.2.2+200504) running on Windows Server 2012R2 + IIS8 + MSSQL Server 2014 + PHP 7.4.1. Extension to this issue - after hitting View Statistics and getting the error above, click on the Display responses button. The Survey responses will appear showing filtered results. Change the header row filter for 'completed' from All to Yes or No. Error will popup (see attached images).

Error 500: {"success":false,"message":"CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near 'datestamp'.","error"

Attachments:
The following user(s) said Thank You: cdorin

Please Log in to join the conversation.

More
1 day 7 hours ago #200075 by DenisChenu

mikecouchman wrote: Error 500: {"success":false,"message":"CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near 'datestamp'.","error"

My opinoion : another issue, must be reported separatly

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
An error happen ? Before make a new topic : remind the Debug mode .
The following user(s) said Thank You: cdorin

Please Log in to join the conversation.

More
1 day 7 hours ago #200079 by cdorin
Yes, please report them separately. I will go through more tickets in the upcoming days.

Please Log in to join the conversation.

More
1 day 2 hours ago - 1 day 2 hours ago #200111 by mikecouchman
I cant actually login to the bug tracker. I can login to limesurvey.org (using the account I am posting this with), but when I goto the bug tracker, using the same credentials, its denies me.

Attachments:
Last edit: 1 day 2 hours ago by mikecouchman. Reason: Added image

Please Log in to join the conversation.

More
1 day 23 minutes ago #200117 by holch
Usually the same credentials should work. Send an email to the Limesurvey support, if you are sure that your password is correct. If you have it changed on Limesurvey.org just shortly before trying to login into Mantis, then maybe the dabases haven't been syncronized yet.

I'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Some helpful links: Manual (EN) | Question Types | Workarounds

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now