View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
09153 | Bug reports | Other | public | 2014-07-30 21:26 | 2014-08-11 11:57 |
Reporter | boutinn | Assigned To | c_schmitz | ||
Priority | normal | Severity | partial_block | ||
Status | closed | Resolution | fixed | ||
Product Version | 2.05+ | ||||
Fixed in Version | 2.05+ | ||||
Summary | 09153: 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 | ||||
Tags | No tags attached. | ||||
Attached Files | |||||
Bug heat | 4 | ||||
Complete LimeSurvey version number (& build) | 140730 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | IE8 or IE 11 or last version of Chrome | ||||
Database type & version | MySql 5.6.17 | ||||
Server OS (if known) | CentOs 5.10 | ||||
Webserver software & version (if known) | Apache 2,2,26 | ||||
PHP Version | 5.4.26 (phpadmin 4.1.8) | ||||
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? |
|
Erreur INSERT INTO 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 |
|
not debug.php in /application/config/debug.php |
|
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 |
|
Sorry, it is /application/config/config.php - please activate and try again. '1037', NULL, '1980-01-01 00:00:00', '6', 'fr', '2', '2', '3', '4', '4', '97', etc.. |
|
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). |
|
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 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.. |
|
IT'S DONE. Thanks |
|
I forgot to say than the backup with 2.00 work !!!!!!!!!!!!! |
|
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 + |
|
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\'), |
|
Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=14372 |
|
2.05+ Build 140811 released |
|
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 |