View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 6
IDProjectCategoryView StatusDate SubmittedLast Update
04241Bug reportsOtherpublic2010-03-24 12:072010-06-02 11:33
Reporteruser617Assigned Toc_schmitz  
PriorityurgentSeverityblock 
Status closedResolutionwon't fix 
Product Version1.87+ 
Summary04241: Problem when importing deactivated survey responses
Description

Error: INSERT INTO lime_survey_89194 ( submitdate, lastpage, startlanguage, 89194X892X2877, 89194X892X2878, 89194X892X2879, 89194X892X2880, 89194X892X2880comment) VALUES( '1980-01-01 00:00:00', 'en', NULL, NULL, NULL, 'Q4A', 'Because it is a way for people to keep in touch and find out information.', NULL); Column 'startlanguage' cannot be null

This is the error I receive when importing deactivated survey responses, it means users cannot acces their results

TagsNo tags attached.
Bug heat6
Complete LimeSurvey version number (& build)8472
I will donate to the project if issue is resolved
Browser
Database type & versionmysql
Server OS (if known)xp
Webserver software & version (if known)redhat
PHP Version5

Users monitoring this issue

There are no users monitoring this issue.

Activities

user617

2010-04-07 14:09

  ~11595

Hi Carsten, Do you need any more information?
Mazi

Mazi

2010-05-12 00:17

updater   ~11772

Last edited: 2010-05-12 00:20

I can't reproduce this problem at the latest 1.90betae version. This are the steps I tried:

  1. deactivate a running survey which has answers.
  2. Activate the survey
  3. Go to the browse response screen and choose the "import answers from deactivated survey table"
  4. everything went fine.

jak82,
can you provide step-by-step instructions on how to reproduce the problem?

Can you also attach your survey fro testing?
c_schmitz

c_schmitz

2010-06-02 11:33

administrator   ~12080

You are most probably trying to import results from an earlier LimeSurvey version which isn't really supported.

Issue History

Date Modified Username Field Change
2010-03-24 12:07 user617 New Issue
2010-03-24 12:07 user617 Status new => assigned
2010-03-24 12:07 user617 Assigned To => user372
2010-03-26 07:20 user372 Assigned To user372 => c_schmitz
2010-04-07 14:09 user617 Note Added: 11595
2010-05-12 00:17 Mazi Note Added: 11772
2010-05-12 00:17 Mazi Status assigned => feedback
2010-05-12 00:20 Mazi Note Edited: 11772
2010-06-02 11:33 c_schmitz Note Added: 12080
2010-06-02 11:33 c_schmitz Status feedback => closed
2010-06-02 11:33 c_schmitz Resolution open => won't fix
2010-10-25 00:21 c_schmitz Category Data Access => (No Category)