View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 8
IDProjectCategoryView StatusDate SubmittedLast Update
04725Bug reportsImport/Exportpublic2010-11-08 12:152010-11-08 23:49
Reportertobyrhodes Assigned Toc_schmitz  
PriorityhighSeveritypartial_block 
Status closedResolutionno change required 
Product Version1.90+ 
Summary04725: Copy survey feature crashes
Description

When I try to copy a survey using the "Copy Survey" tab on the Create New Survey, I get an error message:

Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=':SELECT lime_defaultvalues.* FROM lime_defaultvalues JOIN lime_questions ON lime_questions.qid = lime_defaultvalues.qid AND lime_questions.sid=96848 AND lime_questions.language=lime_defaultvalues.language

Steps To Reproduce
  1. Click on menu item to create new survey
  2. Navigate to "Copy Survey" tab
  3. Select survey to copy from drop down box
  4. Type in name of new survey
  5. All boxes left un-ticked
  6. Click "Copy Survey" button
  7. get error message as above
Additional Information

I have also tried to export / import a survey as I used to do, but this doesn't seem to work either, so am stuck with having to re-create surveys from scratch.

I have moderate technical skills, but am not an expert.

TagsNo tags attached.
Attached Files
survey_96848.xml (9,756 bytes)    
<?xml version="1.0" encoding="UTF-8"?>
<questionnaire id="96848">
  <title>Workshop Feedback (TR tracked)</title>
  <investigator/>
  <dataCollector/>
  <questionnaireInfo>
    <position>before</position>
    <text>{TOKEN:ATTRIBUTE_1} {TOKEN:ATTRIBUTE_2} Workshop on {TOKEN:ATTRIBUTE_3}</text>
    <administration>self</administration>
  </questionnaireInfo>
  <section id="54">
    <sectionInfo>
      <position>title</position>
      <text>Your Reflections</text>
      <administration>self</administration>
    </sectionInfo>
    <question>
      <text>&#13;
&#13;
&#13;
&#13;
&#13;
Please tell us about any "Ah ha" moments or insights from the workshop</text>
      <response varName="insights">
        <free>
          <format>longtext</format>
          <length>4</length>
          <label></label>
        </free>
      </response>
    </question>
    <question>
      <text>&#13;
&#13;
&#13;
&#13;
What actions are you going to take to ensure that you put your learning into practice?</text>
      <response varName="action">
        <free>
          <format>longtext</format>
          <length>4</length>
          <label></label>
        </free>
      </response>
    </question>
  </section>
  <section id="55">
    <sectionInfo>
      <position>title</position>
      <text>Your Feedback</text>
      <administration>self</administration>
    </sectionInfo>
    <question>
      <text>On a scale of 1 (worst) to 10 (best), please rate the workshop</text>
      <subQuestion varName="rating_rate">
        <text>How useful was this course to you</text>
      </subQuestion>
      <response varName="rating">
        <fixed>
          <category>
            <label>1</label>
            <value>1</value>
          </category>
          <category>
            <label>2</label>
            <value>2</value>
          </category>
          <category>
            <label>3</label>
            <value>3</value>
          </category>
          <category>
            <label>4</label>
            <value>4</value>
          </category>
          <category>
            <label>5</label>
            <value>5</value>
          </category>
          <category>
            <label>6</label>
            <value>6</value>
          </category>
          <category>
            <label>7</label>
            <value>7</value>
          </category>
          <category>
            <label>8</label>
            <value>8</value>
          </category>
          <category>
            <label>9</label>
            <value>9</value>
          </category>
          <category>
            <label>10</label>
            <value>10</value>
          </category>
        </fixed>
      </response>
    </question>
    <question>
      <text>Please tick 5 of the following that best describe this learning event</text>
      <response varName="5words_1">
        <fixed>
          <category>
            <label>Exceptional</label>
            <value>1</value>
          </category>
        </fixed>
      </response>
      <response varName="5words_2">
        <fixed>
          <category>
            <label>Boring</label>
            <value>1</value>
          </category>
        </fixed>
      </response>
      <response varName="5words_3">
        <fixed>
          <category>
            <label>Dull</label>
            <value>1</value>
          </category>
        </fixed>
      </response>
      <response varName="5words_4">
        <fixed>
          <category>
            <label>Valuable</label>
            <value>1</value>
          </category>
        </fixed>
      </response>
      <response varName="5words_5">
        <fixed>
          <category>
            <label>Slow</label>
            <value>1</value>
          </category>
        </fixed>
      </response>
      <response varName="5words_6">
        <fixed>
          <category>
            <label>Happy</label>
            <value>1</value>
          </category>
        </fixed>
      </response>
      <response varName="5words_7">
        <fixed>
          <category>
            <label>Standard</label>
            <value>1</value>
          </category>
        </fixed>
      </response>
      <response varName="5words_8">
        <fixed>
          <category>
            <label>Challenging</label>
            <value>1</value>
          </category>
        </fixed>
      </response>
      <response varName="5words_9">
        <fixed>
          <category>
            <label>Rewarding</label>
            <value>1</value>
          </category>
        </fixed>
      </response>
      <response varName="5words_10">
        <fixed>
          <category>
            <label>Cramped</label>
            <value>1</value>
          </category>
        </fixed>
      </response>
      <response varName="5words_11">
        <fixed>
          <category>
            <label>Precise</label>
            <value>1</value>
          </category>
        </fixed>
      </response>
      <response varName="5words_12">
        <fixed>
          <category>
            <label>Inadequate</label>
            <value>1</value>
          </category>
        </fixed>
      </response>
      <response varName="5words_13">
        <fixed>
          <category>
            <label>Unhappy</label>
            <value>1</value>
          </category>
        </fixed>
      </response>
      <response varName="5words_14">
        <fixed>
          <category>
            <label>Participative</label>
            <value>1</value>
          </category>
        </fixed>
      </response>
      <response varName="5words_15">
        <fixed>
          <category>
            <label>Energetic</label>
            <value>1</value>
          </category>
        </fixed>
      </response>
      <response varName="5words_16">
        <fixed>
          <category>
            <label>Exciting</label>
            <value>1</value>
          </category>
        </fixed>
      </response>
      <response varName="5words_17">
        <fixed>
          <category>
            <label>Relaxed</label>
            <value>1</value>
          </category>
        </fixed>
      </response>
      <response varName="5words_18">
        <fixed>
          <category>
            <label>Tedious</label>
            <value>1</value>
          </category>
        </fixed>
      </response>
      <response varName="5words_19">
        <fixed>
          <category>
            <label>Disappointing</label>
            <value>1</value>
          </category>
        </fixed>
      </response>
      <response varName="5words_20">
        <fixed>
          <category>
            <label>Repetitive</label>
            <value>1</value>
          </category>
        </fixed>
      </response>
      <response varName="5words_21">
        <fixed>
          <category>
            <label>Informative</label>
            <value>1</value>
          </category>
        </fixed>
      </response>
      <response varName="5words_22">
        <fixed>
          <category>
            <label>Practical</label>
            <value>1</value>
          </category>
        </fixed>
      </response>
      <response varName="5words_23">
        <fixed>
          <category>
            <label>Helpful</label>
            <value>1</value>
          </category>
        </fixed>
      </response>
      <response varName="5words_24">
        <fixed>
          <category>
            <label>Effective</label>
            <value>1</value>
          </category>
        </fixed>
      </response>
      <response varName="5words_25">
        <fixed>
          <category>
            <label>Cold</label>
            <value>1</value>
          </category>
        </fixed>
      </response>
      <response varName="5words_26">
        <fixed>
          <category>
            <label>Acceptable</label>
            <value>1</value>
          </category>
        </fixed>
      </response>
      <response varName="5words_27">
        <fixed>
          <category>
            <label>Adequate</label>
            <value>1</value>
          </category>
        </fixed>
      </response>
      <response varName="5words_28">
        <fixed>
          <category>
            <label>Satisfactory</label>
            <value>1</value>
          </category>
        </fixed>
      </response>
      <response varName="5words_29">
        <fixed>
          <category>
            <label>Irrelevant</label>
            <value>1</value>
          </category>
        </fixed>
      </response>
      <response varName="5words_30">
        <fixed>
          <category>
            <label>Insensitive</label>
            <value>1</value>
          </category>
        </fixed>
      </response>
      <response varName="5words_31">
        <fixed>
          <category>
            <label>Fun</label>
            <value>1</value>
          </category>
        </fixed>
      </response>
      <response varName="5words_32">
        <fixed>
          <category>
            <label>Worthwhile</label>
            <value>1</value>
          </category>
        </fixed>
      </response>
    </question>
    <question>
      <text>Are there any other immediate compliments, comments or suggestions you would like to make about this workshop? </text>
      <response varName="comments">
        <free>
          <format>longtext</format>
          <length>4</length>
          <label></label>
        </free>
      </response>
    </question>
    <question>
      <text>Please give us some specific feedback for the facilitator(s)</text>
      <response varName="trainerfeedback">
        <free>
          <format>longtext</format>
          <length>4</length>
          <label></label>
        </free>
      </response>
    </question>
  </section>
</questionnaire>
survey_96848.xml (9,756 bytes)   
Bug heat8
Complete LimeSurvey version number (& build)9406
I will donate to the project if issue is resolvedYes
BrowserFirefox, v3.6.12
Database type & versionMySQL, v5.0.81
Server OS (if known)Linux, 2.6.28.5-grsec-sg2
Webserver software & version (if known)Apache: 1.3.41 ???? is this what you mean????
PHP Version5.2.5

Users monitoring this issue

tobyrhodes

Activities

Mazi

Mazi

2010-11-08 14:58

updater   ~13455

  1. Please attach your survey for testing.

  2. Can you reproduce the problem with al surveys?

  3. Do you make any changes to the database?
c_schmitz

c_schmitz

2010-11-08 15:03

administrator   ~13456

Did you update from a previous version?
tobyrhodes

tobyrhodes

2010-11-08 15:05

reporter   ~13457

Hi Mazi
I have not (consciously) made any changes to the database.
I have tried to copy some other surveys (randomly selected), and they all seem to produce the same error.
If it helps, I can give you access to my system
cheers
Toby
tobyrhodes

tobyrhodes

2010-11-08 15:07

reporter   ~13458

Hi c_schmitz.

I have regularly updated, whenever it notifies me of a new version.
The ones I am copying were created under previous versions (i.e. previous builds of 1.91+).
hope this helps
Toby
c_schmitz

c_schmitz

2010-11-08 15:25

administrator   ~13459

What version did you originally install?
tobyrhodes

tobyrhodes

2010-11-08 15:27

reporter   ~13460

hmmm ... I can't remember ... it would have been about 18 months ago. Sorry.
c_schmitz

c_schmitz

2010-11-08 18:23

administrator   ~13463

Ok, checked. This is actually not a bug of LimeSurvey but a left-over issue from a DB restoration or other modification of the database.

LimeSurvey always uses utf8_unicode_ci as collation.
Either your lime_defaultvalues or lime_question table does not.

Do you know how to handle a database tool like phpMyAdmin?
c_schmitz

c_schmitz

2010-11-08 18:28

administrator   ~13464

Last edited: 2010-11-08 18:29

If yes: run on your LimeSurvey database:

ALTER TABLE lime_questions COLLATE utf8_unicode_ci;
ALTER TABLE lime_defaultvalues COLLATE utf8_unicode_ci;

and to prevent this from happening again:

ALTER DATABASE <your limesurvey db name> DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;

Please report if that fixed your problem.
tobyrhodes

tobyrhodes

2010-11-08 19:07

reporter   ~13465

Hi - thanks.
I have used phpMyAdmin in the past, just to do simple things.
I will have a go to modify the database as you suggest, and report back.
many thanks
Toby
tobyrhodes

tobyrhodes

2010-11-08 19:41

reporter   ~13466

Hi
I've not had much luck so far.
lime_questions seems to be stubbornly set as utf8_general_ci
I have to go out now ... will try again later.
Thanks for your help thus far.
Toby
tobyrhodes

tobyrhodes

2010-11-08 22:32

reporter   ~13468

Hi c_schmitz

I have managed to fix it - it needed me to change the collation of individual fields within the lime_questions, lime_defaultvalues and lime_answers tables.

Many thanks for your prompt assistance. I remain hugely impressed with the LimeSurvey project.
cheers
Toby
tobyrhodes

tobyrhodes

2010-11-08 22:34

reporter   ~13469

I forgot to mention ... Following the fix, I have managed to successfully copy surveys, so please consider this problem to be resolved.
Thanks
Toby
c_schmitz

c_schmitz

2010-11-08 23:49

administrator   ~13470

Great to hear. We are looking forward to your donation.

Issue History

Date Modified Username Field Change
2010-11-08 12:15 tobyrhodes New Issue
2010-11-08 12:16 tobyrhodes Issue Monitored: tobyrhodes
2010-11-08 14:58 Mazi Note Added: 13455
2010-11-08 15:02 tobyrhodes File Added: survey_96848.xml
2010-11-08 15:03 c_schmitz Note Added: 13456
2010-11-08 15:03 c_schmitz Assigned To => c_schmitz
2010-11-08 15:03 c_schmitz Status new => assigned
2010-11-08 15:05 tobyrhodes Note Added: 13457
2010-11-08 15:07 tobyrhodes Note Added: 13458
2010-11-08 15:25 c_schmitz Note Added: 13459
2010-11-08 15:27 tobyrhodes Note Added: 13460
2010-11-08 18:23 c_schmitz Note Added: 13463
2010-11-08 18:28 c_schmitz Note Added: 13464
2010-11-08 18:28 c_schmitz Note Edited: 13464
2010-11-08 18:29 c_schmitz Note Edited: 13464
2010-11-08 19:07 tobyrhodes Note Added: 13465
2010-11-08 19:41 tobyrhodes Note Added: 13466
2010-11-08 22:32 tobyrhodes Note Added: 13468
2010-11-08 22:34 tobyrhodes Note Added: 13469
2010-11-08 23:49 c_schmitz Note Added: 13470
2010-11-08 23:49 c_schmitz Status assigned => closed
2010-11-08 23:49 c_schmitz Resolution open => no change required
2021-08-15 07:39 guest Bug heat 6 => 8