View Issue Details

This issue affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
05523Bug reportsImport/Exportpublic2011-11-08 10:01
Reporteruser16168Assigned Toc_schmitz  
PriorityhighSeverityminor 
Status closedResolutionfixed 
Product Version1.91+ 
Summary05523: Duplication in 'subquestions'
Description

Hello,
sorry for imprecision of report, I'm not the user of limesurvey.

I made an upgrade+move new server of an 1.52 version to 1.91+

The sql upgrade was very very very long (2h00) for ~50 surveys with some cryptic errors at end.
Anyway, most of survey seems OK except that duplication problem.

Duplication is seen in the editor as well as in the running survey.

Franck

Additional Information

database integrity check reports nothing.

TagsNo tags attached.
Attached Files
limesurveybug.png (261,829 bytes)
Bug heat4
Complete LimeSurvey version number (& build)11163
I will donate to the project if issue is resolvedNo
Browser
Database type & versionMysql 5.1.41
Server OS (if known)Ubuntu 10.04 LTS server
Webserver software & version (if known)Apache/2.2.14 (Ubuntu)
PHP VersionPHP Version 5.3.2-1ubuntu4.10
Git branch / Pull Request URL

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2011-10-21 21:23

administrator   ~16489

If you got errors at the upgrade then that is most likely the reason for the duplication. If you can provide the 1.52 database I can have a look at it.

I switched the bug to private so you can attach it to this issue.

user16168

2011-10-21 22:13

  ~16490

Done uploading!

I will try to help as you need. I'm not the final user of limesurvey.

After conversion is done (very long) I made a database check (OK) and cleaned the proposed olds_tables.

Franck

c_schmitz

c_schmitz

2011-11-07 22:49

administrator   ~16608

Hello Franck,

I uploaded your dump, ran the upgrade and it came out just fine.
The duplicates may only have happened if the conversion was interrupted and you just reloaded the update page and it ran again. If that happens you have to restore the data from backup and start over.

I suggest you raise your max_execution_time for scripts, also deleting all old tables from your database before doing the upgrade will shorten it alot too (all limeold* tables).

user16168

2011-11-07 23:47

  ~16610

Hello,
thank you.
It is too late now for going backward you an premigration database ;-)

So it is duplicated. Do you have an idea if it is sofware bug displaying twice the same 'line' or it is really two identical lines in the table database ?

In other word, if you tell me the table to look at, can I remove lines without altering database integrity....
My user told me he open/edit/close surveys to fix it. Maybe simpler thing to do!
Can you erase the useless dup152.sql.gz file now and remove private status?

Thank you
Franck

c_schmitz

c_schmitz

2011-11-08 10:00

administrator   ~16614

They are duplicated in the database so you need to check the questions table for duplicates where the parent_qid <>0

Issue History

Date Modified Username Field Change
2011-10-20 22:45 user16168 New Issue
2011-10-20 22:45 user16168 File Added: limesurveybug.png
2011-10-20 22:50 user16168 Issue Monitored: user16168
2011-10-21 21:23 c_schmitz Note Added: 16489
2011-10-21 21:23 c_schmitz View Status public => private
2011-10-21 21:23 c_schmitz Assigned To => c_schmitz
2011-10-21 21:23 c_schmitz Status new => assigned
2011-10-21 22:11 user16168 File Added: dup_152.sql.gz
2011-10-21 22:13 user16168 Note Added: 16490
2011-11-07 22:49 c_schmitz Note Added: 16608
2011-11-07 22:49 c_schmitz Status assigned => closed
2011-11-07 22:49 c_schmitz Resolution open => unable to reproduce
2011-11-07 23:47 user16168 Note Added: 16610
2011-11-07 23:47 user16168 Status closed => feedback
2011-11-07 23:47 user16168 Resolution unable to reproduce => reopened
2011-11-08 10:00 c_schmitz Note Added: 16614
2011-11-08 10:00 c_schmitz Status feedback => closed
2011-11-08 10:00 c_schmitz Resolution reopened => fixed
2011-11-08 10:00 c_schmitz File Deleted: dup_152.sql.gz
2011-11-08 10:01 c_schmitz View Status private => public