View Issue Details

This bug affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
09181Bug reportsOtherpublic2014-10-10 10:43
Reporterboutinn Assigned Toc_schmitz  
PriorityurgentSeveritypartial_block 
Status closedResolutionfixed 
Product Version2.05+ 
Fixed in Version2.05+ 
Summary09181: Bug with the full backup function
Description

Full backup not work correctly... i lost a answer (for exeample id 569 for the survey 62444). I have this problem with more surveys!!!!!!!

Additional Information

See the upload files

TagsNo tags attached.
Attached Files
results-survey62444.xls (210,432 bytes)
Bug heat4
Complete LimeSurvey version number (& build)build 140811
I will donate to the project if issue is resolvedNo
Browserie8, ie11, last version for Chrome
Database type & versionmysql 5.6.17
Server OS (if known)centos 5.10
Webserver software & version (if known)Apache 2,2,26
PHP Version5.4.26 (phpadmin 4.1.8)

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2014-09-11 00:05

administrator   ~30540

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

c_schmitz

c_schmitz

2014-09-11 00:06

administrator   ~30541

I was not able to reproduce it so I think it is depending on your PHP version.
However we reconstructed the code in question so please check out the new patch and let us know if it works as expected now.

c_schmitz

c_schmitz

2014-09-11 01:36

administrator   ~30549

2.05 Build 140911 released.

boutinn

boutinn

2014-09-12 14:06

reporter   ~30604

With the last build 140911, i reproduce the same problem with the completed survey 62444 and the missing record is the same (id 569). In the database dump, between id 568 and id 570, the insert command "INSERT INTO lime_survey_62444 (id,submitdate,lastpage,startlanguage,62444X27X189,62444X27X190,62444X27X191,....).

This problem is present for many surveys. Is it possible to reopen this problem ? PHP or not ? I don't know.

boutinn

boutinn

2014-09-12 14:19

reporter   ~30605

I did a another test .... full backup with phpadmin :
-- phpMyAdmin SQL Dump
-- version 4.1.8
-- http://www.phpmyadmin.net

-- Client : localhost
-- Généré le : Ven 12 Septembre 2014 à 17:35
-- Version du serveur : 5.6.17
-- Version de PHP : 5.4.23

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

/!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT /;
/!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS /;
/!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION /;
/!40101 SET NAMES utf8 /;

--
-- Base de données : dacsgqc_lime1

Between id 568 and id 570, i have not the problem. See below:

(568, NULL, NULL, 'fr', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(569, '1980-01-01 00:00:00', 2, 'fr', '1', '1', '1', '1', '2', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(570, NULL, NULL, 'fr', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(571,

c_schmitz

c_schmitz

2014-09-12 22:50

administrator   ~30609

Can you update your PHP version (or use a different server with a different DB version) and try again? As I can not reproduce this it is most likely somehow specific to your system.

boutinn

boutinn

2014-09-16 15:56

reporter   ~30663

It's not necessary because (see the last note). The full dump with phpadmin 4.1.8 (vith the same environment) work correctly (see the last note 2014-09-12.
With my message for the issue #9182, i have included a copy of full dump with phpinfo and limesurvey. You will see ... the differences!

c_schmitz

c_schmitz

2014-09-16 16:08

administrator   ~30665

PHPMyAdmin uses a different method to backup your data so it is not comparable. I will have a look at your db dump but I am afraid that won't change anything.

c_schmitz

c_schmitz

2014-09-16 17:23

administrator   ~30666

I stand corrected - I was able to reproduce the issue using your database dump. Thank you very much!

c_schmitz

c_schmitz

2014-09-16 17:25

administrator   ~30667

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

c_schmitz

c_schmitz

2014-10-10 10:43

administrator   ~30771

2.05+ Build 141003 released

Related Changesets

LimeSurvey: master ba251361

2014-09-10 22:04:58

c_schmitz

Details Diff
Fixed issue 09181: When dumping database sometimes lines are left out Affected Issues
09181
mod - application/helpers/admin/backupdb_helper.php Diff File

LimeSurvey: master e5f25c8d

2014-09-16 15:24:43

c_schmitz

Details Diff
Fixed issue 09181: When dumping database sometimes lines are left out Affected Issues
09181
mod - application/helpers/admin/backupdb_helper.php Diff File

Issue History

Date Modified Username Field Change
2014-08-20 16:46 boutinn New Issue
2014-08-20 16:46 boutinn File Added: results-survey62444.xls
2014-08-20 16:47 boutinn File Added: Full backup (only 62444).sql
2014-09-11 00:02 c_schmitz Assigned To => c_schmitz
2014-09-11 00:02 c_schmitz Status new => assigned
2014-09-11 00:05 c_schmitz Changeset attached => LimeSurvey master ba251361
2014-09-11 00:05 c_schmitz Note Added: 30540
2014-09-11 00:05 c_schmitz Resolution open => fixed
2014-09-11 00:06 c_schmitz Note Added: 30541
2014-09-11 00:06 c_schmitz Status assigned => resolved
2014-09-11 00:06 c_schmitz Fixed in Version => 2.05+
2014-09-11 01:36 c_schmitz Note Added: 30549
2014-09-11 01:36 c_schmitz Status resolved => closed
2014-09-12 14:06 boutinn Note Added: 30604
2014-09-12 14:06 boutinn Status closed => feedback
2014-09-12 14:06 boutinn Resolution fixed => reopened
2014-09-12 14:19 boutinn Note Added: 30605
2014-09-12 14:19 boutinn Status feedback => assigned
2014-09-12 22:50 c_schmitz Note Added: 30609
2014-09-12 22:50 c_schmitz Status assigned => feedback
2014-09-16 15:56 boutinn Note Added: 30663
2014-09-16 15:56 boutinn Status feedback => assigned
2014-09-16 16:08 c_schmitz Note Added: 30665
2014-09-16 17:23 c_schmitz Note Added: 30666
2014-09-16 17:24 c_schmitz Status assigned => resolved
2014-09-16 17:24 c_schmitz Resolution reopened => fixed
2014-09-16 17:25 c_schmitz Changeset attached => LimeSurvey master e5f25c8d
2014-09-16 17:25 c_schmitz Note Added: 30667
2014-10-10 10:43 c_schmitz Note Added: 30771
2014-10-10 10:43 c_schmitz Status resolved => closed