View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
06595Bug reportsStatisticspublic2012-09-27 01:202012-10-09 22:39
Reporteruser21196Assigned Toc_schmitz  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version1.92+ 
Fixed in Version2.00+ 
Summary06595: Data restore from oldsurvey... table returns ERROR: invalid input syntax for type double precision: ""
Description

Using a Postgres database, the data restore from an oldsurvey... table produces the error

ERROR: invalid input syntax for type double precision: ""

when the old_survey and survey tables contain a double precision column and null values in a data record. Instead of using a null value for the INSERT statement, the restore tool uses empty strings '' which causes the error. Double precision fields only accept strings in scientific number notation.

I have a workaround of copying the data manually on a SQL command line using
INSERT into survey_... select * from oldsurvey... but that's not accessible to the

Additional Information

It would be great to have a restore function for old token data as well.

Also, when deactivating a survey data and tokens are archived in the old... tables. When reactivating the survey and initializing a new token table it would be great to have an option to reapply the custom attributes right there. The attribute definitions seem to be stored in the background, but one has to go to custom attribute management and enter the correct number of attributes for them to reappear.

Along these lines, I haven't seen a function to remove custom attributes.

TagsNo tags attached.
Attached Files
grad_exit_survey_27464.lss (303,103 bytes)
Bug heat4
Complete LimeSurvey version number (& build)120919
I will donate to the project if issue is resolvedNo
Browser
Database type & versionPostgres 8.3
Server OS (if known)Ubuntu
Webserver software & version (if known)Apache 2.2.22
PHP Version5.3.8

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2012-09-27 08:52

administrator   ~20837

Please attach the survey that is producing this error as .lss file. Thank you.
c_schmitz

c_schmitz

2012-10-07 13:21

administrator   ~21104

Feedback please?
c_schmitz

c_schmitz

2012-10-09 13:56

administrator   ~21127

Closed due to missing feedback.

user21196

2012-10-09 15:45

  ~21131

Last edited: 2012-10-09 15:47

Was out. Attached the survey export. The field causing issues in the survey table is:

"27464X164X1549" double precision
c_schmitz

c_schmitz

2012-10-09 21:32

administrator   ~21136

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=9683
c_schmitz

c_schmitz

2012-10-09 22:39

administrator   ~21139

2.00+ Build 121009 released. Please update.

Related Changesets

LimeSurvey: master f535bbbb

2012-10-09 14:32

c_schmitz


Details Diff		 Fixed issue 06595: Data restore from old_survey_... table fails when using Postgres Affected Issues
06595
mod - application/controllers/admin/dataentry.php Diff File
mod - application/helpers/admin/import_helper.php Diff File
mod - application/helpers/database_helper.php Diff File
mod - application/helpers/frontend_helper.php Diff File

Issue History

Date Modified Username Field Change
2012-09-27 01:20 user21196 New Issue
2012-09-27 08:52 c_schmitz Note Added: 20837
2012-09-27 08:52 c_schmitz Assigned To => c_schmitz
2012-09-27 08:52 c_schmitz Status new => feedback
2012-10-07 13:21 c_schmitz Note Added: 21104
2012-10-09 13:56 c_schmitz Note Added: 21127
2012-10-09 13:56 c_schmitz Status feedback => closed
2012-10-09 13:56 c_schmitz Resolution open => unable to reproduce
2012-10-09 15:45 user21196 Note Added: 21131
2012-10-09 15:45 user21196 Status closed => feedback
2012-10-09 15:45 user21196 Resolution unable to reproduce => reopened
2012-10-09 15:45 user21196 File Added: grad_exit_survey_27464.lss
2012-10-09 15:47 user21196 Note Edited: 21131
2012-10-09 21:32 c_schmitz Changeset attached => LimeSurvey master f535bbbb
2012-10-09 21:32 c_schmitz Note Added: 21136
2012-10-09 21:32 c_schmitz Status feedback => resolved
2012-10-09 21:32 c_schmitz Fixed in Version => 2.00+
2012-10-09 21:32 c_schmitz Resolution reopened => fixed
2012-10-09 22:39 c_schmitz Note Added: 21139
2012-10-09 22:39 c_schmitz Status resolved => closed