View Issue Details

This issue affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
05417Bug reportsImport/Exportpublic2011-08-24 08:51
Reporteruser15334Assigned Toc_schmitz  
PrioritynormalSeverityminor 
Status closedResolutionunable to reproduce 
Product Version1.91+ 
Summary05417: Export SQL error
Description

I have an error exporting survey results to application cvs or excel:
"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 'and surveyls_survey_id= and surveyls_language='en'' at line 1:SELECT * FROM lime_surveys,lime_surveys_languagesettings WHERE sid= and surveyls_survey_id= and surveyls_language='en'"

This is what i see in result file (cvs/xls)

Steps To Reproduce

Fresh install, default config.php, new survey, default survey language: PL

Additional Information

Language: PL
Fresh install
1 survey
3 records

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)10746
I will donate to the project if issue is resolvedNo
Browser
Database type & versionMySQL 5.1.41-3ubuntu12.10
Server OS (if known)Ubuntu 10.04..3 LTS
Webserver software & version (if known)apache 2.2.14
PHP Version5.3.2
Git branch / Pull Request URL

Users monitoring this issue

There are no users monitoring this issue.

Activities

user15334

2011-08-22 15:14

  ~16112

OK it works from non admin account!!!! :)

c_schmitz

c_schmitz

2011-08-23 10:37

administrator   ~16119

I can't reproduce it here. Can you attach a dump of your database, please?

user15334

2011-08-24 07:53

  ~16125

Hi
I checked an export from admin account - it works. I decided not dumping database because it doesn't make sense to me - all is working well.
I've dropped database and created/populated new one
I tried to remember all steps I had done creating the survey. Finally when its done the export works well I can't reproduce the error I'm sorry... :(

Issue History

Date Modified Username Field Change
2011-08-22 13:46 user15334 New Issue
2011-08-22 15:14 user15334 Note Added: 16112
2011-08-23 10:37 c_schmitz Note Added: 16119
2011-08-23 10:38 c_schmitz Assigned To => c_schmitz
2011-08-23 10:38 c_schmitz Status new => feedback
2011-08-24 07:53 user15334 Note Added: 16125
2011-08-24 07:53 user15334 Status feedback => assigned
2011-08-24 08:51 c_schmitz Status assigned => closed
2011-08-24 08:51 c_schmitz Resolution open => unable to reproduce