View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 8
IDProjectCategoryView StatusDate SubmittedLast Update
08165Bug reportsAccessibilitypublic2013-09-17 09:102013-10-11 15:55
ReporterTristan Assigned Tomdekker  
PrioritynormalSeveritycrash 
Status closedResolutionduplicate 
Product Version2.05 RC 
Summary08165: Request error
Description

For the same data set, since the version 2.05 beta. When I want to access data, I have the follow error :

Request error: CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'id' in where clause is ambiguous

Steps To Reproduce

Upload the .lss (id questionnaire 446628), try to access data of the .lss with

-> $objetExtraction->export_responses($sessionKey, 446628, 'json', 'fr', 'complete', 'code', 'short');

Additional Information

the return is "Request error: CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'id' in where clause is ambiguous"

TagsNo tags attached.
Attached Files
survey_archive_15543.lsa (28,705 bytes)
bugTracker.php (1,211 bytes)
Bug heat8
Complete LimeSurvey version number (& build)Version 2.05b6 Build 130816
I will donate to the project if issue is resolvedNo
Browserfirefox
Database type & versionMySQL 5.6.12
Server OS (if known)windows 7 64 bits pro
Webserver software & version (if known)apache 2.4.4
PHP Versionphp 5.4.16

Relationships

Relationship GraphDependency Graph
duplicate of 08216 closedmdekker Unable to get results when timing is on. 

Users monitoring this issue

There are no users monitoring this issue.

Activities

Mazi

Mazi

2013-09-17 17:21

updater   ~26262

Tristan,

  1. Do you mean that you are using the Limesurvey API?

  2. Can you please attach your survey as .LSA file? This should also contain some test data which makes it easier to reproduce the problem.

  3. Can you attach an API test script?
Tristan

Tristan

2013-09-17 18:00

reporter   ~26263

Yes I use the limesurvey API, I attack the JSON-RPC interface.

I join a .lsa, file from an other survey

I join a script ;)
Mazi

Mazi

2013-09-17 18:57

updater   ~26264

trougakoss, can you check if you can reproduce this with Limesurvey 2.05?
trougakoss

trougakoss

2013-09-18 09:00

reporter   ~26267

Yes, i am on it.
bendechrai

bendechrai

2013-09-20 08:39

reporter   ~26298

Hi all,

I just encountered this issue when trying to export as HTML or PDF too, and tracked it down to line 119 in /application/helpers/admin/export/SurveyDao.php (v2.05b6); the $selection variable has id without a qualifying survey table name. I altered that line to read:

$selection = '{{survey_' . $survey->id . '}}.id >= :min AND {{survey_' . $survey->id . '}}.id <= :max';

and I'm able to export the data again.

I hope this helps resolve your issue too.

Ben

Issue History

Date Modified Username Field Change
2013-09-17 09:10 Tristan New Issue
2013-09-17 09:10 Tristan File Added: limesurvey_survey_446628(1).lss
2013-09-17 17:20 Mazi Assigned To => Mazi
2013-09-17 17:20 Mazi Status new => assigned
2013-09-17 17:21 Mazi Note Added: 26262
2013-09-17 17:21 Mazi Status assigned => feedback
2013-09-17 18:00 Tristan Note Added: 26263
2013-09-17 18:00 Tristan Status feedback => assigned
2013-09-17 18:00 Tristan File Added: survey_archive_15543.lsa
2013-09-17 18:03 Tristan File Added: bugTracker.php
2013-09-17 18:57 Mazi Assigned To Mazi => trougakoss
2013-09-17 18:57 Mazi Note Added: 26264
2013-09-18 09:00 trougakoss Note Added: 26267
2013-09-20 08:39 bendechrai Note Added: 26298
2013-10-11 15:54 c_schmitz Relationship added duplicate of 08216
2013-10-11 15:55 c_schmitz Status assigned => closed
2013-10-11 15:55 c_schmitz Assigned To trougakoss => mdekker
2013-10-11 15:55 c_schmitz Resolution open => duplicate