View Issue Details

This bug affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
14409Bug reportsComfortUpdatepublic2021-03-11 07:47
ReporterDenisChenu Assigned To 
PrioritynoneSeverityminor 
Status newResolutionopen 
Product Version3.15.x 
Summary14409: Upgrade from an old old instance : 2.6 OK, 3.16 not ok at 255
Description

CDbCommand n'a pas pu exécuter la commande SQL: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes

Fichier updatedb_helper.php, ligne 3866.

Steps To Reproduce

Surely with a 2.6 is same ?

Additional Information

Unsure of DB version, of start, but issue is in upgradeTokenTables256, deactivate this update fix the issue

TagsNo tags attached.
Attached Files
UpdateLimeSurvey.html (13,739 bytes)   
<!DOCTYPE html>
<html dir="ltr" lang="fr"><head>
    <meta http-equiv="content-type" content="text/html; charset=UTF-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">

    <!-- Assets load -->

    <!--
        Notice to developers :


        If you turn debug mode on, the asset manager will be off.
        If you turn degug mode off, the asset manager will be on.

        Without the asset manager, the CSS/JS files are published from their real url (eg: http://yourlimesurvey.url/scripts/admin/admin_core.js)
        So, once a browser loaded once those files, it cache it, and don't load it anymore.
        Then, if you change some css/js files, final user must clean its browser cache to get the new version of the cache.
        This was the old LS behaviour, if debug mode is on, you'll have this very behaviour

        The asset manager resolve the browser cache problem. It copy the css/js files to a tmp directory before publishing it:
        http://yourlimesurvey.url/tmp/assets/e929b9d4/admin_core.js

        For admin GUI, the asset manager works on a base of a "file by file" : each single css/js file is published as a single asset.
        So if you touch any css/js file published via the asset (updating its date of modification), the asset manager will AUTOMATICALLY create a new tmp directory:
        http://yourlimesurvey.url/tmp/assets/eb139b88/admin_core.js

        Then, the browser will automatically reload the file, and the final user don't need to refresh its cache.
        You should never have to delete the tmp/assets directory. You can do it to free some space on your server, but that all.

        notice: the css/js files from third party extension use the package system. It means that the asset manager will publish them on the base of the directory logic.
        So, if you update any css/js file from a third party extension, make sure that the modification date of the root directory is updated.
    -->

                <!-- Debug mode is off, so the asset manager will be used-->
    
        <title>Groupe Axiome - LimeSurvey</title>
    <link rel="shortcut icon" href="http://groupeaxiome.fr/survey/themes/admin/favicon.ico" type="image/x-icon">
    <link rel="icon" href="http://groupeaxiome.fr/survey/themes/admin/favicon.ico" type="image/x-icon">
            <style>.cke{visibility:hidden;}</style></head>
<body>
    <div id="beginScripts">
        
    </div>
<!-- Loading wrapper -->
<div id="ls-loading">
    <span id="ls-loading-spinner" class="fa fa-spinner fa-spin fa-4x"></span>
    <span class="sr-only">Chargement ...</span>
</div>


<script type="text/javascript" src="UpdateLimeSurvey_fichiers/bootstrap-switch.js"></script>
<script type="text/javascript" src="UpdateLimeSurvey_fichiers/bootstrap-datetimepicker.js"></script>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link rel="stylesheet" type="text/css" href="UpdateLimeSurvey_fichiers/jquery-ui.css">
<link rel="stylesheet" type="text/css" href="UpdateLimeSurvey_fichiers/font-awesome.css">
<link rel="stylesheet" type="text/css" href="UpdateLimeSurvey_fichiers/bootstrap.css">
<link rel="stylesheet" type="text/css" href="UpdateLimeSurvey_fichiers/yiistrap.css">
<link rel="stylesheet" type="text/css" href="UpdateLimeSurvey_fichiers/bootstrap-switch.css">
<link rel="stylesheet" type="text/css" href="UpdateLimeSurvey_fichiers/select2.css">
<link rel="stylesheet" type="text/css" href="UpdateLimeSurvey_fichiers/select2-bootstrap.css">
<link rel="stylesheet" type="text/css" href="UpdateLimeSurvey_fichiers/bootstrap-datetimepicker.css">
<link rel="stylesheet" type="text/css" href="UpdateLimeSurvey_fichiers/roboto.css">
<link rel="stylesheet" type="text/css" href="UpdateLimeSurvey_fichiers/icomoon.css">
<link rel="stylesheet" type="text/css" href="UpdateLimeSurvey_fichiers/lime-admin-common.css">
<link rel="stylesheet" type="text/css" href="UpdateLimeSurvey_fichiers/jcarousel.css">
<link rel="stylesheet" type="text/css" href="UpdateLimeSurvey_fichiers/attributeMap.css">
<link rel="stylesheet" type="text/css" href="UpdateLimeSurvey_fichiers/attributeMapToken.css">
<link rel="stylesheet" type="text/css" href="UpdateLimeSurvey_fichiers/displayParticipants.css">
<link rel="stylesheet" type="text/css" href="UpdateLimeSurvey_fichiers/adminbasics.css">
<link rel="stylesheet" type="text/css" href="UpdateLimeSurvey_fichiers/lsadminpanel.css">
<link rel="stylesheet" type="text/css" href="UpdateLimeSurvey_fichiers/lstutorial.css">
<link rel="stylesheet" type="text/css" href="UpdateLimeSurvey_fichiers/lime-admin-colors.css">
<link rel="stylesheet" type="text/css" href="UpdateLimeSurvey_fichiers/statistics.css">
<script type="text/javascript">window.debugState = {frontend : (0 === 1), backend : (0 === 1)};</script><script type="text/javascript" src="UpdateLimeSurvey_fichiers/jquery-3.js" class="headScriptTag"></script>
<script type="text/javascript" src="UpdateLimeSurvey_fichiers/jquery-migrate-3.js" class="headScriptTag"></script>
<script type="text/javascript" src="UpdateLimeSurvey_fichiers/jquery-ui.js" class="headScriptTag"></script>
<script type="text/javascript" src="UpdateLimeSurvey_fichiers/adminbasics.js" class="headScriptTag"></script>
<script type="text/javascript" src="UpdateLimeSurvey_fichiers/js.js" class="headScriptTag"></script>
<script type="text/javascript" src="UpdateLimeSurvey_fichiers/bootstrap.js" class="headScriptTag"></script>
<script type="text/javascript" src="UpdateLimeSurvey_fichiers/bootstrapconfirm.js" class="headScriptTag"></script>
<script type="text/javascript" src="UpdateLimeSurvey_fichiers/moment-with-locales.js" class="headScriptTag"></script>
<script type="text/javascript" src="UpdateLimeSurvey_fichiers/select2.js" class="headScriptTag"></script>
<script type="text/javascript" src="UpdateLimeSurvey_fichiers/lslog.js" class="headScriptTag"></script>
<script type="text/javascript" src="UpdateLimeSurvey_fichiers/pjax.js" class="headScriptTag"></script>
<script type="text/javascript" src="UpdateLimeSurvey_fichiers/lsadminpanel.js" class="headScriptTag"></script>
<script type="text/javascript" src="UpdateLimeSurvey_fichiers/surveysettings.js" class="headScriptTag"></script>
<script type="text/javascript" src="UpdateLimeSurvey_fichiers/hammer.js" class="headScriptTag"></script>
<script type="text/javascript" src="UpdateLimeSurvey_fichiers/ckeditor_002.js" class="headScriptTag"></script><script type="text/javascript" src="UpdateLimeSurvey_fichiers/loader.js"></script><script src="UpdateLimeSurvey_fichiers/event.js" type="text/javascript"></script><script src="UpdateLimeSurvey_fichiers/editor_basic.js" type="text/javascript"></script><script src="UpdateLimeSurvey_fichiers/env.js" type="text/javascript"></script><script src="UpdateLimeSurvey_fichiers/ckeditor_basic.js" type="text/javascript"></script><script src="UpdateLimeSurvey_fichiers/log.js" type="text/javascript"></script><script src="UpdateLimeSurvey_fichiers/dom.js" type="text/javascript"></script><script src="UpdateLimeSurvey_fichiers/tools.js" type="text/javascript"></script><script src="UpdateLimeSurvey_fichiers/dtd.js" type="text/javascript"></script><script src="UpdateLimeSurvey_fichiers/event_002.js" type="text/javascript"></script><script src="UpdateLimeSurvey_fichiers/domobject.js" type="text/javascript"></script><script src="UpdateLimeSurvey_fichiers/node.js" type="text/javascript"></script><script src="UpdateLimeSurvey_fichiers/window.js" type="text/javascript"></script><script src="UpdateLimeSurvey_fichiers/document.js" type="text/javascript"></script><script src="UpdateLimeSurvey_fichiers/nodelist.js" type="text/javascript"></script><script src="UpdateLimeSurvey_fichiers/element.js" type="text/javascript"></script><script src="UpdateLimeSurvey_fichiers/documentfragment.js" type="text/javascript"></script><script src="UpdateLimeSurvey_fichiers/walker.js" type="text/javascript"></script><script src="UpdateLimeSurvey_fichiers/range.js" type="text/javascript"></script><script src="UpdateLimeSurvey_fichiers/iterator.js" type="text/javascript"></script><script src="UpdateLimeSurvey_fichiers/command.js" type="text/javascript"></script><script src="UpdateLimeSurvey_fichiers/ckeditor_base.js" type="text/javascript"></script><script src="UpdateLimeSurvey_fichiers/config.js" type="text/javascript"></script><script src="UpdateLimeSurvey_fichiers/filter.js" type="text/javascript"></script><script src="UpdateLimeSurvey_fichiers/focusmanager.js" type="text/javascript"></script><script src="UpdateLimeSurvey_fichiers/keystrokehandler.js" type="text/javascript"></script><script src="UpdateLimeSurvey_fichiers/lang.js" type="text/javascript"></script><script src="UpdateLimeSurvey_fichiers/scriptloader.js" type="text/javascript"></script><script src="UpdateLimeSurvey_fichiers/resourcemanager.js" type="text/javascript"></script><script src="UpdateLimeSurvey_fichiers/plugins.js" type="text/javascript"></script><script src="UpdateLimeSurvey_fichiers/ui.js" type="text/javascript"></script><script src="UpdateLimeSurvey_fichiers/editor.js" type="text/javascript"></script><script src="UpdateLimeSurvey_fichiers/htmlparser.js" type="text/javascript"></script><script src="UpdateLimeSurvey_fichiers/basicwriter.js" type="text/javascript"></script><script src="UpdateLimeSurvey_fichiers/node_002.js" type="text/javascript"></script><script src="UpdateLimeSurvey_fichiers/comment.js" type="text/javascript"></script><script src="UpdateLimeSurvey_fichiers/text.js" type="text/javascript"></script><script src="UpdateLimeSurvey_fichiers/cdata.js" type="text/javascript"></script><script src="UpdateLimeSurvey_fichiers/fragment.js" type="text/javascript"></script><script src="UpdateLimeSurvey_fichiers/filter_002.js" type="text/javascript"></script><script src="UpdateLimeSurvey_fichiers/htmldataprocessor.js" type="text/javascript"></script><script src="UpdateLimeSurvey_fichiers/element_002.js" type="text/javascript"></script><script src="UpdateLimeSurvey_fichiers/template.js" type="text/javascript"></script><script src="UpdateLimeSurvey_fichiers/ckeditor.js" type="text/javascript"></script><script src="UpdateLimeSurvey_fichiers/inline.js" type="text/javascript"></script><script src="UpdateLimeSurvey_fichiers/themedui.js" type="text/javascript"></script><script src="UpdateLimeSurvey_fichiers/editable.js" type="text/javascript"></script><script src="UpdateLimeSurvey_fichiers/selection.js" type="text/javascript"></script><script src="UpdateLimeSurvey_fichiers/style.js" type="text/javascript"></script><script src="UpdateLimeSurvey_fichiers/comment_002.js" type="text/javascript"></script><script src="UpdateLimeSurvey_fichiers/elementpath.js" type="text/javascript"></script><script src="UpdateLimeSurvey_fichiers/text_002.js" type="text/javascript"></script><script src="UpdateLimeSurvey_fichiers/rangelist.js" type="text/javascript"></script><script src="UpdateLimeSurvey_fichiers/skin.js" type="text/javascript"></script><script src="UpdateLimeSurvey_fichiers/_bootstrap.js" type="text/javascript"></script>
<script type="text/javascript" src="UpdateLimeSurvey_fichiers/config_002.js" class="headScriptTag"></script>
<script type="text/javascript" src="UpdateLimeSurvey_fichiers/ckeditoradditions.js" class="headScriptTag"></script>
<script type="text/javascript" src="UpdateLimeSurvey_fichiers/script.js" class="headScriptTag"></script>
<script type="text/javascript">
/*<![CDATA[*/

           LS.globalUserId = "";
LS.data = {"baseUrl":"http:\/\/groupeaxiome.fr\/survey","showScriptName":true,"urlFormat":"path","adminImageUrl":"\/survey\/themes\/admin\/Sea_Green\/images\/","csrfTokenName":"YII_CSRF_TOKEN","csrfToken":"4c0f3cf8f66e24ae7fa0cecb423b50286f6997f9","csrfTokenData":{"YII_CSRF_TOKEN":"4c0f3cf8f66e24ae7fa0cecb423b50286f6997f9"},"language":"fr","replacementFields":{"path":"\/survey\/index.php\/admin\/limereplacementfields\/sa\/index"}};
LS.lang = {
                        confirm: {
                            confirm_cancel: 'Annuler',
                            confirm_ok: 'OK'
                        }
                    };
$.ajaxSetup({data: {YII_CSRF_TOKEN: LS.data.csrfToken}});
var frameSrc = "/login";

/*]]>*/
</script>
<!-- BEGIN LAYOUT_MAIN --><div class="container-fluid">
    <div class="row">
        <div id="notif-container" class="col-sm-12 content-right" style="z-index: 999">
                    </div>
    </div>
</div> <div id="pjax-file-load-container" class="ls-flex-row col-12"><div style="height:2px;width:0px;"></div></div><!-- Full page, started in Survey_Common_Action::render_wrapped_template() -->
                    <div class="container-fluid full-page-wrapper" id="in_survey_common_action">
                        <div class="alert alert-danger flash-error">Erreur non récupérable durant la mise à jour. Détails de cette erreur :<p>CDbCommand
 n'a pas pu exécuter la commande SQL: SQLSTATE[42000]: Syntax error or 
access violation: 1071 Specified key was too long; max key length is 
1000 bytes</p><br>Fichier updatedb_helper.php, ligne 3866.</div>
<p><a href="http://groupeaxiome.fr/survey/index.php/admin/databaseupdate/sa/db">Veuillez corriger cette erreur dans la base de données et recommencer</a></p></div> <!-- END LAYOUT_MAIN --><script type="text/javascript" src="UpdateLimeSurvey_fichiers/lstutorial.js"></script>
<script type="text/javascript">
/*<![CDATA[*/
jQuery('body').popover({'selector':'a\x5Brel\x3Dpopover\x5D'});
jQuery('body').tooltip({'selector':'a\x5Brel\x3Dtooltip\x5D'});
jQuery('body').popover({'selector':'a\x5Brel\x3Dpopover\x5D'});
jQuery('body').tooltip({'selector':'a\x5Brel\x3Dtooltip\x5D'});
/*]]>*/
</script>

    </body></html>
UpdateLimeSurvey.html (13,739 bytes)   
Bug heat4
Complete LimeSurvey version number (& build)3.15.5 github
I will donate to the project if issue is resolvedNo
Browsernot relevant
Database type & versionmysql / 5.5.62
Server OS (if known)Linux webm236.90.ha.ovh.net 4.14.66-ovh-vps-grsec-zfs-classid
Webserver software & version (if known)Apache
PHP Version5.6.38

Users monitoring this issue

There are no users monitoring this issue.

Activities

ollehar

ollehar

2021-03-10 22:40

administrator   ~63204

Please update to the latest version and check if the bug can still be reproduced. Thank you.

DenisChenu

DenisChenu

2021-03-11 07:47

developer   ~63258

I really don't take time to create a 2.6 and update …

Issue History

Date Modified Username Field Change
2019-01-08 18:48 DenisChenu New Issue
2019-01-08 18:48 DenisChenu Status new => assigned
2019-01-08 18:48 DenisChenu Assigned To => LouisGac
2019-01-08 18:48 DenisChenu File Added: UpdateLimeSurvey.html
2021-03-10 22:40 ollehar Assigned To LouisGac =>
2021-03-10 22:40 ollehar Status assigned => feedback
2021-03-10 22:40 ollehar Note Added: 63204
2021-03-11 07:47 DenisChenu Note Added: 63258
2021-03-11 07:47 DenisChenu Status feedback => new