View Issue Details

This bug affects 1 person(s).
 6
IDProjectCategoryView StatusLast Update
04391Bug reportsStatisticspublic2010-07-06 11:22
Reportertringate Assigned Toc_schmitz  
PrioritynormalSeveritypartial_block 
Status closedResolutionfixed 
Product Version1.90b 
Target Version1.90RC1Fixed in Version1.90RC2 
Summary04391: User statistics not working + Install problem
Description

The user statistics are not working and give PHP errors.

Steps To Reproduce

After converting a running set of surveys to beta 1.9 version I attempted to run the user statistics.

http://www.test.my.domain/surveys/limesurvey19/statistics_user.php?sid=69215

Errors produced.

Notice: Undefined index: lid in /var/test/surveys/limesurvey19/statistics_user.php on line 249

Notice: Undefined index: lid1 in /var/test/surveys/limesurvey19/statistics_user.php on line 250

Notice: Undefined index: lid in /var/test/surveys/limesurvey19/statistics_user.php on line 255

Notice: Undefined index: lid1 in /var/test/surveys/limesurvey19/statistics_user.php on line 256

Notice: Undefined index: lid in /var/test/surveys/limesurvey19/statistics_user.php on line 249

Notice: Undefined index: lid1 in /var/test/surveys/limesurvey19/statistics_user.php on line 250

Notice: Undefined index: lid in /var/test/surveys/limesurvey19/statistics_user.php on line 255

Notice: Undefined index: lid1 in /var/test/surveys/limesurvey19/statistics_user.php on line 256

Generating summaries ...62%Couldn't do count of values:
SELECT count(*) FROM lime_survey_69215 WHERE 69215X38X1339Many = 'Y' AND submitdate is not null
Unknown column '69215X38X1339Many' in 'where clause'

Additional Information

During the database conversion after about 2/3's of the way into the conversion there were some errors, but appeared to not be significant to me. I ignored them and then looked at the surveys which all appear to be just fine and display correctly.

It was not until I tried looking at the ectual results with this program that I found errors.

This is a complete test setup, so I can re generate the database, and do another conversion using this Beta 3 version as the database was converted while I was still using beta 2 if you think it is worth doing.

I could also do the conversion over again and this time capture the actual errors if that is needed.

TagsNo tags attached.
Bug heat6
Complete LimeSurvey version number (& build)8745
I will donate to the project if issue is resolved
BrowserIE8
Database type & versionmysql 5.0.77
Server OS (if known)Fedora 2.6.27.25-78.2.56.fc9.x86_64
Webserver software & version (if known)Apache/2.2.9 (Fedora)
PHP VersionPHP Version 5.2.9

Users monitoring this issue

There are no users monitoring this issue.

Activities

Mazi

Mazi

2010-06-04 01:33

updater   ~12131

Last edited: 2010-06-04 01:35

Carsten, I remember you tried to help a user at IRC who had a similar problem. Maybe the error message helps to fix the install problem (if this isn't already fixed).
The public stats problem should already be solved at SVN.

c_schmitz

c_schmitz

2010-06-04 21:39

administrator   ~12173

tringate, can you please attach a sample survey?
Thank you!

c_schmitz

c_schmitz

2010-06-16 22:25

administrator   ~12233

It would be great if you can re-test with RC1 and if the problem persists attach the 1.87 DB dump. Switching issue to private.

tringate

tringate

2010-06-17 01:12

reporter   ~12242

Last edited: 2010-06-17 01:12

Carsten,

I have done as you have asked.

The duplicate errors are still there during the database conversion process, however I do not see any problems with the survey data once the conversion completed.

The errors do not occure until almost the very end of the process.

The problem with the user statistics is solved, and does not happen in RC1.

c_schmitz

c_schmitz

2010-07-01 18:56

administrator   ~12325

Thank you very much. The issue will be fixed in 1.90RC2.

Issue History

Date Modified Username Field Change
2010-06-03 20:50 tringate New Issue
2010-06-03 20:50 tringate Status new => assigned
2010-06-03 20:50 tringate Assigned To => user372
2010-06-04 01:33 Mazi Note Added: 12131
2010-06-04 01:34 Mazi Assigned To user372 => c_schmitz
2010-06-04 01:34 Mazi Target Version => 1.90RC1
2010-06-04 01:34 Mazi Summary User statistics not working => User statistics not working + Install problem
2010-06-04 01:35 Mazi Note Edited: 12131
2010-06-04 21:39 c_schmitz Note Added: 12173
2010-06-04 21:39 c_schmitz Status assigned => feedback
2010-06-09 03:16 tringate Status feedback => assigned
2010-06-16 22:25 c_schmitz Note Added: 12233
2010-06-16 22:25 c_schmitz Status assigned => feedback
2010-06-16 22:25 c_schmitz View Status public => private
2010-06-17 00:43 tringate File Added: survey-test.zip
2010-06-17 01:12 tringate Note Added: 12242
2010-06-17 01:12 tringate Status feedback => assigned
2010-06-17 01:12 tringate Note Edited: 12242
2010-07-01 18:56 c_schmitz Note Added: 12325
2010-07-01 18:56 c_schmitz Status assigned => resolved
2010-07-01 18:56 c_schmitz Fixed in Version => 1.90RC2
2010-07-01 18:56 c_schmitz Resolution open => fixed
2010-07-01 18:56 c_schmitz File Deleted: survey-test.zip
2010-07-01 18:56 c_schmitz View Status private => public
2010-07-06 11:22 c_schmitz Status resolved => closed