View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 05523 | Bug reports | Import/Export | public | 2011-10-20 22:45 | 2011-11-08 10:01 |
| Reporter | Assigned To | c_schmitz | |||
| Priority | high | Severity | minor | ||
| Status | closed | Resolution | fixed | ||
| Product Version | 1.91+ | ||||
| Summary | 05523: Duplication in 'subquestions' | ||||
| Description | Hello, 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. Duplication is seen in the editor as well as in the running survey. Franck | ||||
| Additional Information | database integrity check reports nothing. | ||||
| Tags | No tags attached. | ||||
| Attached Files | |||||
| Bug heat | 4 | ||||
| Complete LimeSurvey version number (& build) | 11163 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | |||||
| Database type & version | Mysql 5.1.41 | ||||
| Server OS (if known) | Ubuntu 10.04 LTS server | ||||
| Webserver software & version (if known) | Apache/2.2.14 (Ubuntu) | ||||
| PHP Version | PHP Version 5.3.2-1ubuntu4.10 | ||||
| Git branch / Pull Request URL | |||||
|
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. |
|
|
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 |
|
|
Hello Franck, I uploaded your dump, ran the upgrade and it came out just fine. 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). |
|
|
Hello, 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.... Thank you |
|
|
They are duplicated in the database so you need to check the questions table for duplicates where the parent_qid <>0 |
|
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2011-10-20 22:45 |
|
New Issue | |
| 2011-10-20 22:45 |
|
File Added: limesurveybug.png | |
| 2011-10-20 22:50 |
|
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 |
|
File Added: dup_152.sql.gz | |
| 2011-10-21 22:13 |
|
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 |
|
Note Added: 16610 | |
| 2011-11-07 23:47 |
|
Status | closed => feedback |
| 2011-11-07 23:47 |
|
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 |