View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 10
IDProjectCategoryView StatusDate SubmittedLast Update
03723Bug reportsSurvey takingpublic2009-09-22 23:492009-10-04 12:35
Reporterdarknico84 Assigned Toc_schmitz  
PrioritynormalSeveritypartial_block 
Status closedResolutionno change required 
Product Version1.85+ 
Summary03723: SQL problem on Iterate Survey
Description

Hello,

When trying to re activate a survey with the "Iterate Survey" function, I get the following message :

Delete incomplete answers with duplicate tokens failed:
You can't specify target table 'lime_survey_82935' for update in FROM clause
DELETE from lime_survey_82935 WHERE submitdate IS NULL AND token in (SELECT * FROM ( SELECT answ2.token from lime_survey_82935 AS answ2 WHERE answ2.submitdate IS NOT NULL) tmp );

I upgraded to release 7670 but nothing changes.

If someone resolved this issue a hint would be appreciated ;)

Thanks a lot in advance

Nicolas

TagsNo tags attached.
Bug heat10
Complete LimeSurvey version number (& build)7670
I will donate to the project if issue is resolved
BrowserFirefox 3.0.14
Database type & versionmysql 4.1.11
Server OS (if known)Debian Sarge
Webserver software & version (if known)Apache 2.2.3
PHP Version5.2.8

Users monitoring this issue

darknico84

Activities

user372

2009-09-23 11:02

  ~09642

I couldn't reproduce the issue at my installation.
Can you reproduce the issue on your installation with another simple sample survey?
If yes, please give us a step-by-step instruction - Thx!
c_schmitz

c_schmitz

2009-10-04 00:17

administrator   ~09707

Thibault, line 50 in iterate_survey.php looks strange to me - can you take a look at it?
lemeur

lemeur

2009-10-04 00:26

developer   ~09708

@c_schmitz,

This query is a very advanced one. I had to find a very tricky workaround because in mysql you can't update a table and use it at the same time in a join: you have to use a temporary table:
See http://lists.mysql.com/mysql/211232

I used the ugly method, and this may not be supported in all cases.

What database is it?
What version?
darknico84

darknico84

2009-10-04 09:37

reporter   ~09713

Hello,

Sorry to not have answered before so :

  • to answer to ElMatador69, I can reproduce the issue just by clicking on reiterate survey icon,
  • the database being used for the survey is a mysql 4.1.11 on a Debian sarge with a limesurvey 1.85+ : not working
  • have been testing the function with mysql 5.1.34 on a mandriva 2009.1 with a limesurvey 1.86 : working.

I'll maybe try to upgrade from 1.85+ to 1.86, hoping it will help caus I cannot do anything on the database side :( I'll let you know if it helps or not
c_schmitz

c_schmitz

2009-10-04 12:35

administrator   ~09714

1.85+ does not support MySQL 4.1.
I am wondering that you got it to work at all? Anway - closing issue.

Issue History

Date Modified Username Field Change
2009-09-22 23:49 darknico84 New Issue
2009-09-22 23:49 darknico84 Status new => assigned
2009-09-22 23:49 darknico84 Assigned To => user372
2009-09-22 23:49 darknico84 Build Number => 7670
2009-09-22 23:49 darknico84 Browser => Firefox 3.0.14
2009-09-22 23:49 darknico84 Database & DB-Version => mysql 4.1.11
2009-09-22 23:49 darknico84 Operating System (Server) => Debian Sarge
2009-09-22 23:49 darknico84 Webserver => Apache 2.2.3
2009-09-22 23:49 darknico84 PHP Version => 5.2.8
2009-09-23 00:27 darknico84 Issue Monitored: darknico84
2009-09-23 11:02 user372 Note Added: 09642
2009-09-23 11:02 user372 Status assigned => feedback
2009-10-04 00:17 c_schmitz Status feedback => assigned
2009-10-04 00:17 c_schmitz Assigned To user372 => lemeur
2009-10-04 00:17 c_schmitz Note Added: 09707
2009-10-04 00:26 lemeur Note Added: 09708
2009-10-04 09:37 darknico84 Note Added: 09713
2009-10-04 12:35 c_schmitz Assigned To lemeur => c_schmitz
2009-10-04 12:35 c_schmitz Note Added: 09714
2009-10-04 12:35 c_schmitz Status assigned => closed
2009-10-04 12:35 c_schmitz Resolution open => no change required
2010-10-25 00:18 c_schmitz Category Survey at Runtime => Survey taking