View Issue Details

This bug affects 1 person(s).
 10
IDProjectCategoryView StatusLast Update
03815Bug reportsConditionspublic2010-03-09 21:02
Reportermdekker Assigned Tomdekker  
PrioritynormalSeverityminor 
Status closedResolutionunable to reproduce 
Product Version1.86 
Summary03815: New condition can not be copied
Description

When I create a new condition and then try to copy it to (multiple) following questions I get a mysql error. When I then go back and go to the conditions editor again I can copy my condition without any problem.

Additional Information

Couldn't delete condition
DELETE FROM ls__conditions WHERE cid=
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

TagsNo tags attached.
Bug heat10
Complete LimeSurvey version number (& build)7697
I will donate to the project if issue is resolved
Browser
Database type & versiondna
Server OS (if known)dna
Webserver software & version (if known)dna
PHP Versiondna

Users monitoring this issue

lemeur

Activities

user372

2009-11-04 18:33

  ~09975

I can't reproduce the issue on the latest branch (=v1.87RC1), but I have a MySQL-DB.

@ Lemeur: was there a change between v1.86 to v1.87RC1

lemeur

lemeur

2009-11-07 13:10

developer   ~09988

I can't reproduce either...
I'm not sure if this was really fixed, but I changed some parts of the condition editor recently...

I run Mysql as well so I can't test for other DB.

lemeur

lemeur

2009-11-07 13:19

developer   ~09989

Matador, Can you find someone who could test 1.87-latest with another DB ?

What is the DB used by mdekker ?

user372

2009-11-09 21:37

  ~10036

@ mdekker:
1) Am I right, that you are using a MySQL database?
2) Can you reproduce the issue on the latest v1.87RC1-branch?

user372

2009-11-18 00:31

  ~10133

@ mdekker: can you have a look at v1.87RC2 and tell us, if you still can reproduce a problem?

user372

2009-11-22 19:21

  ~10203

@ mdekker: Any news?

mdekker

mdekker

2009-11-24 15:59

reporter   ~10237

Just back from my holiday... still can reproduce using mysql.

Steps:
1 create a new condition
2 hit the copy condition button
3 copy the new condition to a different question
4 there is the mysql error: Couldn't delete condition
DELETE FROM lime_conditions WHERE cid=
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

mdekker

mdekker

2009-11-24 16:11

reporter   ~10238

It is a browser related problem I found out. Chrome (4.0.249.11) doesn't work while Firefox (3.5.4) works ok...

user372

2009-11-24 17:53

  ~10241

@ mdekker: can you fix this issue on your own or do you need help by lemeur?

mdekker

mdekker

2009-11-25 08:56

reporter   ~10245

I don't know how or where to fix this, but ofcourse I am willing to test any patch. I suppose it has something to do with javascript since that is the main difference and probably timing could be a problem too.

lemeur

lemeur

2009-11-26 18:15

developer   ~10280

This is very very weird...

The error message that is reported can only be triggered by a 'delete condition' action !

This won't be easy to troubleshoot.

I'll try to have a look when time permits.

Thibault

c_schmitz

c_schmitz

2010-02-11 16:21

administrator   ~11041

mdekker, is this issue still present?

Issue History

Date Modified Username Field Change
2009-11-04 13:24 mdekker New Issue
2009-11-04 13:24 mdekker Status new => assigned
2009-11-04 13:24 mdekker Assigned To => user372
2009-11-04 13:24 mdekker LimeSurvey build number => 7697
2009-11-04 13:24 mdekker Database & DB-Version => dna
2009-11-04 13:24 mdekker Operating System (Server) => dna
2009-11-04 13:24 mdekker Webserver => dna
2009-11-04 13:24 mdekker PHP Version => dna
2009-11-04 18:33 user372 Note Added: 09975
2009-11-04 18:34 user372 Assigned To user372 => lemeur
2009-11-07 13:10 lemeur Note Added: 09988
2009-11-07 13:18 lemeur Assigned To lemeur => user372
2009-11-07 13:19 lemeur Issue Monitored: lemeur
2009-11-07 13:19 lemeur Note Added: 09989
2009-11-07 13:19 lemeur Status assigned => feedback
2009-11-09 21:37 user372 Note Added: 10036
2009-11-18 00:31 user372 Note Added: 10133
2009-11-22 19:21 user372 Note Added: 10203
2009-11-24 15:59 mdekker Note Added: 10237
2009-11-24 16:11 mdekker Note Added: 10238
2009-11-24 17:53 user372 Note Added: 10241
2009-11-24 17:54 user372 Status feedback => assigned
2009-11-24 17:54 user372 Assigned To user372 => lemeur
2009-11-25 08:56 mdekker Note Added: 10245
2009-11-26 18:15 lemeur Note Added: 10280
2010-02-11 16:21 c_schmitz Note Added: 11041
2010-02-11 16:21 c_schmitz Assigned To lemeur => mdekker
2010-02-11 16:21 c_schmitz Status assigned => feedback
2010-03-09 21:02 c_schmitz Status feedback => closed
2010-03-09 21:02 c_schmitz Resolution open => unable to reproduce