View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
04725 | Bug reports | Import/Export | public | 2010-11-08 12:15 | 2010-11-08 23:49 |
Reporter | tobyrhodes | Assigned To | c_schmitz | ||
Priority | high | Severity | partial_block | ||
Status | closed | Resolution | no change required | ||
Product Version | 1.90+ | ||||
Summary | 04725: 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 |
| ||||
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. | ||||
Tags | No 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> 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> 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> | ||||
Bug heat | 8 | ||||
Complete LimeSurvey version number (& build) | 9406 | ||||
I will donate to the project if issue is resolved | Yes | ||||
Browser | Firefox, v3.6.12 | ||||
Database type & version | MySQL, 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 Version | 5.2.5 | ||||
|
|
Did you update from a previous version? |
|
Hi Mazi |
|
Hi c_schmitz. I have regularly updated, whenever it notifies me of a new version. |
|
What version did you originally install? |
|
hmmm ... I can't remember ... it would have been about 18 months ago. Sorry. |
|
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. Do you know how to handle a database tool like phpMyAdmin? |
|
If yes: run on your LimeSurvey database: ALTER TABLE lime_questions COLLATE utf8_unicode_ci; and to prevent this from happening again: ALTER DATABASE Please report if that fixed your problem. |
|
Hi - thanks. |
|
Hi |
|
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. |
|
I forgot to mention ... Following the fix, I have managed to successfully copy surveys, so please consider this problem to be resolved. |
|
Great to hear. We are looking forward to your donation. |
|
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 |