View Issue Details

This bug affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
09153Bug reportsOtherpublic2014-08-11 11:57
Reporterboutinn Assigned Toc_schmitz  
PrioritynormalSeveritypartial_block 
Status closedResolutionfixed 
Product Version2.05+ 
Fixed in Version2.05+ 
Summary09153: Data check integrity function not work and import a full database backup with sql and phpadmin give me a sql error #1064
Description

The data check integrity function not work, i receive a internal error server (http 500). Of more, a restore (with the sql import function witn phpadmin) following a full backup database with LimeSurvey give me sgl error #1064

TagsNo tags attached.
Attached Files
Bug heat4
Complete LimeSurvey version number (& build)140730
I will donate to the project if issue is resolvedNo
BrowserIE8 or IE 11 or last version of 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-07-31 09:12

administrator   ~30380

For the data integrity check error please active debug mode in /application/config/debug.php and see if you get a more detailed error when trying again.

What instruction gives the #1064 error in the database dump?

boutinn

boutinn

2014-07-31 13:09

reporter   ~30383

Last edited: 2014-08-08 13:36

Erreur
Requête SQL :

INSERT INTO lime_survey_381866 (id,token,submitdate,lastpage,startlanguage,381866X1106X109681,`3818

MySQL a répondu:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1037', NULL, '1980-01-01 00:00:00', '6', 'fr', '2', '2', '3', '4', '4', '97', '9' at line 99

boutinn

boutinn

2014-07-31 13:13

reporter   ~30384

not debug.php in /application/config/debug.php

boutinn

boutinn

2014-07-31 13:49

reporter   ~30385

I did the test witn the full backup this morning and i lost more data in a active survey ..... i would like a correction as soon as possible. Thanks

c_schmitz

c_schmitz

2014-07-31 14:49

administrator   ~30386

Sorry, it is /application/config/config.php - please activate and try again.
For the backup - I would need the complete line that starts with

'1037', NULL, '1980-01-01 00:00:00', '6', 'fr', '2', '2', '3', '4', '4', '97', etc..

boutinn

boutinn

2014-07-31 15:29

reporter   ~30387

My backup sql this morning before the test has 2 229K ... just a little bit more the limit 2 097k. Do you have a email because i would like to send you the zip file of my limesurvey backup of this morning (july 31, 2014).

boutinn

boutinn

2014-07-31 15:57

reporter   ~30388

It's more important to resolve the load of backup. OK I will send you two backup's: LimeSurvey_dacsgqc_lime1_dump_2014-04-14.zip and
LimeSurvey_dacsgqc_lime1_dump_2014-07-31.zip

The version of april, it's with limesurvey_Version 2.00+ Build 131206. Give me 30 minutes to produce the wwo zip files with the line that starts with

'1037', NULL, '1980-01-01 00:00:00', '6', 'fr', '2', '2', '3', '4', '4', '97', etc..

boutinn

boutinn

2014-07-31 16:09

reporter   ~30389

IT'S DONE. Thanks

boutinn

boutinn

2014-07-31 16:12

reporter   ~30390

I forgot to say than the backup with 2.00 work !!!!!!!!!!!!!

boutinn

boutinn

2014-07-31 17:50

reporter   ~30391

I think the problem is with the backup function of LimeSurvey 2.05 + (in recent versions). I managed to retrieve the response table whose name is 381866 with several manipulations with backup 2.0 + late June and LimeSurvey version: Version 2.05 Build 140320 +

c_schmitz

c_schmitz

2014-08-08 13:34

administrator   ~30403

Yes, it is/was a problem with the backup function. In your backup the problem is in the previous line:

NULL, 'Le service en ligne est plus pratique, facile et rapide, nous préfèrons l\'utiliser. Merci\'),

Needs to be:

NULL, 'Le service en ligne est plus pratique, facile et rapide, nous préfèrons l\'utiliser. Merci\'),

c_schmitz

c_schmitz

2014-08-08 13:41

administrator   ~30404

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

c_schmitz

c_schmitz

2014-08-11 11:57

administrator   ~30405

2.05+ Build 140811 released

Related Changesets

LimeSurvey: master 27fb38c8

2014-08-08 11:35:25

c_schmitz

Details Diff
Fixed issue 09153: Database dump tool not properly quoting all special chars Affected Issues
09153
mod - application/helpers/admin/backupdb_helper.php Diff File

Issue History

Date Modified Username Field Change
2014-07-30 21:26 boutinn New Issue
2014-07-31 09:12 c_schmitz Note Added: 30380
2014-07-31 09:12 c_schmitz Assigned To => c_schmitz
2014-07-31 09:12 c_schmitz Status new => feedback
2014-07-31 13:09 boutinn Note Added: 30383
2014-07-31 13:09 boutinn Status feedback => assigned
2014-07-31 13:13 boutinn Note Added: 30384
2014-07-31 13:49 boutinn Note Added: 30385
2014-07-31 14:49 c_schmitz Note Added: 30386
2014-07-31 14:50 c_schmitz Status assigned => feedback
2014-07-31 15:29 boutinn Note Added: 30387
2014-07-31 15:29 boutinn Status feedback => assigned
2014-07-31 15:57 boutinn Note Added: 30388
2014-07-31 16:08 boutinn File Added: LimeSurvey_dacsgqc_lime1_dump_2014-04-14.zip
2014-07-31 16:08 boutinn File Added: LimeSurvey_dacsgqc_lime1_dump_2014-07-31.zip
2014-07-31 16:09 boutinn Note Added: 30389
2014-07-31 16:12 boutinn Note Added: 30390
2014-07-31 17:50 boutinn Note Added: 30391
2014-08-08 13:34 c_schmitz Note Added: 30403
2014-08-08 13:35 c_schmitz Status assigned => resolved
2014-08-08 13:35 c_schmitz Fixed in Version => 2.05+
2014-08-08 13:35 c_schmitz Resolution open => fixed
2014-08-08 13:36 c_schmitz Note Edited: 30383
2014-08-08 13:41 c_schmitz Changeset attached => LimeSurvey master 27fb38c8
2014-08-08 13:41 c_schmitz Note Added: 30404
2014-08-11 11:57 c_schmitz Note Added: 30405
2014-08-11 11:57 c_schmitz Status resolved => closed