View Issue Details

This bug affects 1 person(s).
 18
IDProjectCategoryView StatusLast Update
08216Bug reportsRemoteControlpublic2013-10-11 15:54
Reportermlhess Assigned Tomdekker  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version2.05 RC 
Fixed in Version2.05 RC 
Summary08216: Unable to get results when timing is on.
Description

SQL is invalid. The ID needs to be shown correctly.

{s:5:"%type";s:9:"Exception";s:8:"!message";s:7644:"Request error: CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'id' in where clause is ambiguous. The S
QL statement executed was: SELECT submitdate, lastpage, startlanguage, startdate, datestamp, ipaddr, refurl, 893581X40X2261, 893581X40X2262, 893581X40X22701, 893581X40X22702, 893581X40X22703, 893581X40X2271, 893581X40X2272, 893581X40X2273, 893581X40X2274, 893581X40X2275, 893581X40 X2276, 893581X40X2277, 893581X40X2278, 893581X40X2279, 893581X40X2280, 893581X40X2281, 893581X40X2282, 893581X40X2283, 893581X40X2284, 893581X40X2285, 893581X40X3863, 893581X40X2287, 893581X40X2288, 893581X40X2289, 893581X40X2290, 893581X41X2291, 893581X41X2292, 893581X41X2293, 8 93581X41X2294, 893581X41X2295, 893581X41X2296, 893581X41X2297, 893581X41X2298, 893581X41X2299, 893581X41X2300, 893581X41X2301, 893581X41X2302, 893581X41X2303, 893581X41X2304, 893581X41X2305, 893581X41X2306, 893581X41X2307, 893581X41X2308, 893581X41X23091, 893581X41X23092, 893581X41 X23093, 893581X41X23094, 893581X41X23095, 893581X41X2316, 893581X41X2317, 893581X41X2318, 893581X41X2319, 893581X41X2320, 893581X41X2321, 893581X41X2322, 893581X41X2323, 893581X41X2324, 893581X41X23251, 893581X41X23252, 893581X41X23253, 893581X41X23254, 893581X41X23255, 893581X41X2 3256, 893581X41X23257, 893581X41X23258, 893581X41X2335, 893581X41X2336, 893581X41X2337, 893581X41X2338, 893581X41X3864, 893581X41X2339, 893581X42X23401, 893581X42X23402, 893581X42X23403, 893581X42X23404, 893581X42X23405, 893581X42X23406, 893581X42X23407, 893581X42X23408, 893581X42X 23409, 893581X42X234010, 893581X42X234011, 893581X42X234012, 893581X42X234013, 893581X42X234014, 893581X42X234015, 893581X42X234016, 893581X42X234017, 893581X42X234018, 893581X42X234019, 893581X42X234020, 893581X42X234021, 893581X42X234022, 893581X42X234023, 893581X42X234024, 893581X 42X234025, 893581X43X2367, 893581X43X2368, 893581X43X2369, 893581X43X2370, 893581X43X2371, 893581X43X2372, 893581X43X2373, 893581X43X3738, 893581X43X3739, 893581X43X3740, 893581X43X3741, 893581X43X37421, 893581X43X37422, 893581X43X37423, 893581X43X37424, 893581X43X3748, 893581X43X3 749, 893581X43X3750, 893581X43X37511, 893581X43X37512, 893581X43X37513, 893581X43X3756, 893581X43X3757, 893581X43X3758, 893581X44X3728, 893581X44X3729, 893581X44X3730, 893581X44X3731, 893581X44X3732, 893581X44X3733, 893581X44X3734, 893581X44X3735, 893581X44X3736, 893581X44X3737, 893581X45X3759, 893581X45X37601, 893581X45X37602, 893581X45X37603, 893581X45X37604, 893581X45X37605, 893581X45X37606, 893581X45X37607, 893581X45X37608, 893581X45X37609, 893581X45X376010, 893581X45X376011, 893581X45X376012, 893581X45X376013, 893581X45X376014, 893581X45X376015, 893581X 45X376016, 893581X45X376017, 893581X45X376018, 893581X45X376019, 893581X45X376020, 893581X45X3782, 893581X45X37831, 893581X45X37832, 893581X45X37833, 893581X45X37834, 893581X45X37835, 893581X45X37836, 893581X45X3791, 893581X45X3792, 893581X45X3793, 893581X45X3794, 893581X45X3795, 8 93581X45X3796, 893581X45X3797, 893581X45X3798, 893581X45X3799, 893581X45X3800, 893581X45X3801, 893581X45X3802, 893581X45X3803, 893581X45X3804, 893581X45X3805, 893581X45X3806, 893581X45X3807, 893581X45X3808, 893581X45X3809, 893581X45X3810, 893581X45X3811, 893581X45X3812, 893581X46X3 825, 893581X46X3826, 893581X46X3827, 893581X47X3828, 893581X47X3829, 893581X47X3830, 893581X47X3831, 893581X47X3832, 893581X48X3821, 893581X48X3822, 893581X48X3823, 893581X48X3824, 893581X49X3813, 893581X49X3814, 893581X49X3815, 893581X49X3816, 893581X49X3817, 893581X49X3818, 893 581X49X3819, 893581X49X3820, tid, participant_id, firstname, lastname, email, emailstatus, language, blacklisted, sent, remindersent, remindercount, completed, usesleft, validfrom, validuntil, mpid, lime_survey_893581.token, interviewtime, 893581X40time, 893581X40X2261tim e, 893581X40X2262time, 893581X40X2270time, 893581X40X2271time, 893581X40X2272time, 893581X40X2273time, 893581X40X2274time, 893581X40X2275time, 893581X40X2276time, 893581X40X2277time, 893581X40X2278time, 893581X40X2279time, 893581X40X2280time, 893581X40X2281time, 893581X40X2282time, 893 581X40X2283time, 893581X40X2284time, 893581X40X2285time, 893581X40X3863time, 893581X40X2287time, 893581X40X2288time, 893581X40X2289time, 893581X40X2290time, 893581X41time, 893581X41X2291time, 893581X41X2292time, 893581X41X2293time, 893581X41X2294time, 893581X41X2295time, 893581X41X2296ti me, 893581X41X2297time, 893581X41X2298time, 893581X41X2299time, 893581X41X2300time, 893581X41X2301time, 893581X41X2302time, 893581X41X2303time, 893581X41X2304time, 893581X41X2305time, 893581X41X2306time, 893581X41X2307time, 893581X41X2308time, 893581X41X2309time, 893581X41X2316time, 89 3581X41X2317time, 893581X41X2318time, 893581X41X2319time, 893581X41X2320time, 893581X41X2321time, 893581X41X2322time, 893581X41X2323time, 893581X41X2324time, 893581X41X2325time, 893581X41X2335time, 893581X41X2336time, 893581X41X2337time, 893581X41X2338time, 893581X41X3864time, 893581X41X 2339time, 893581X42time, 893581X42X2340time, 893581X43time, 893581X43X2367time, 893581X43X2368time, 893581X43X2369time, 893581X43X2370time, 893581X43X2371time, 893581X43X2372time, 893581X43X2373time, 893581X43X3738time, 893581X43X3739time, 893581X43X3740time, 893581X43X3741time, 893581X43X3742time, 893581X43X3748time, 893581X43X3749time, 893581X43X3750time, 893581X43X3751time, 893581X43X3756time, 893581X43X3757time, 893581X43X3758time, 893581X44time, 893581X44X3728time, 893581X44X3729time, 893581X44X3730time, 893581X44X3731time, 893581X44X3732time, 893581X44X3733time$,893581X44X3734time,893581X44X3735time,893581X44X3736time,893581X44X3737time,893581X45time,893581X45X3759time,893581X45X3760time,893581X45X3782time,893581X45X3783time,893581X45X3791time,893581X45X3792time,893581X45X3793time,893581X45X3794time,893581X45X3795time,893581X45$3796time,893581X45X3797time,893581X45X3798time,893581X45X3799time,893581X45X3800time,893581X45X3801time,893581X45X3802time,893581X45X3803time,893581X45X3804time,893581X45X3805time,893581X45X3806time,893581X45X3807time,893581X45X3808time,893581X45X3809time,893581X45X3810tim$,893581X45X3811time,893581X45X3812time,893581X46time,893581X46X3825time,893581X46X3826time,893581X46X3827time,893581X47time,893581X47X3828time,893581X47X3829time,893581X47X3830time,893581X47X3831time,893581X47X3832time,893581X48time,893581X48X3821time,893581X48X3822time$, 893581X48X3823time, 893581X48X3824time, 893581X49time, 893581X49X3813time, 893581X49X3814time, 893581X49X3815time, 893581X49X3816time, 893581X49X3817time, 893581X49X3818time, 893581X49X3819time, 893581X49X3820time, lime_survey_893581.id
FROM lime_survey_893581
LEFT JOIN lime_tokens_893581 tokentable ON tokentable.token=lime_survey_893581.token
LEFT JOIN lime_survey_893581_timings survey_timings ON lime_survey_893581.id = survey_timings.id

Steps To Reproduce

Enable a survey with timing.

TagsNo tags attached.
Bug heat18
Complete LimeSurvey version number (& build)b6597da82c5dbfe07e016c2c9304
I will donate to the project if issue is resolvedNo
Browser
Database type & versionmysql
Server OS (if known)ubuntu
Webserver software & version (if known)apache
PHP Version5.4

Relationships

has duplicate 08165 closedmdekker Request error 

Users monitoring this issue

There are no users monitoring this issue.

Activities

mdekker

mdekker

2013-10-08 13:23

reporter   ~26617

Fix committed to 2.05 branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=13187

mdekker

mdekker

2013-10-08 13:25

reporter   ~26618

If you are able to patch your local system please verify the above patch fixes the problem for you.

mdekker

mdekker

2013-10-08 13:46

reporter   ~26619

Feel free to reopen if patch does not solve (all) problems

c_schmitz

c_schmitz

2013-10-11 11:08

administrator   ~26696

2.05RC2 released

Related Changesets

LimeSurvey: 2.05 c0cccb39

2013-10-08 10:58:20

mdekker

Details Diff
Fixed 08216: Unable to get results when timing is on (ambiguous column id) Affected Issues
08216
mod - application/helpers/admin/export/SurveyDao.php Diff File

Issue History

Date Modified Username Field Change
2013-10-02 00:38 mlhess New Issue
2013-10-03 14:24 DenisChenu Product Version => 2.05 RC
2013-10-03 14:24 DenisChenu Description Updated
2013-10-08 12:55 mdekker Assigned To => mdekker
2013-10-08 12:55 mdekker Status new => assigned
2013-10-08 13:23 mdekker Changeset attached => LimeSurvey 2.05 c0cccb39
2013-10-08 13:23 mdekker Note Added: 26617
2013-10-08 13:23 mdekker Resolution open => fixed
2013-10-08 13:25 mdekker Note Added: 26618
2013-10-08 13:46 mdekker Note Added: 26619
2013-10-08 13:46 mdekker Status assigned => resolved
2013-10-08 13:46 mdekker Fixed in Version => 2.05 RC
2013-10-11 11:08 c_schmitz Note Added: 26696
2013-10-11 11:08 c_schmitz Status resolved => closed
2013-10-11 15:54 c_schmitz Relationship added has duplicate 08165