Check out the LimeSurvey source code on GitHub!

Error when trying to import old responses

More
5 years 7 months ago - 5 years 7 months ago #61506 by theZ
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 '9, 75114X70X201Mega, 75114X70X201El Z, 75114X70X201Powe, 75114X70X201Coast, 7511' at line 1:SELECT id, submitdate, lastpage, startlanguage, token, datestamp, startdate, ipaddr, refurl, 75114X67X189, 75114X67X190, 75114X67X190other, 75114X67X205, 75114X67X191, 75114X67X192, 75114X67X193, 75114X67X193other, 75114X68X194, 75114X68X195, 75114X68X196, 75114X68X197, 75114X69X198, 75114X69X198other, 75114X69X199, 75114X69X200, 75114X70X201clasi, 75114X70X201new93, 75114X70X201MIA 9, 75114X70X201Mega, 75114X70X201El Z, 75114X70X201Powe, 75114X70X201Coast, 75114X70X201RMF, 75114X70X201Mix 9, 75114X70X201WEDR, 75114X70X201Y-10, 75114X70X201Lite, 75114X70X201Magic, 75114X70X201Super, 75114X70X201Cima, 75114X70X201Roman, 75114X70X201Amor, 75114X70X201Carac, 75114X70X201sport, 75114X70X201news, 75114X70X201WAQI, 75114X70X201ticke, 75114X70X201WINZ, 75114X70X201other, 75114X71X202, 75114X71X202other, 75114X72X203, 75114X72X203other, 75114X73X204, 75114X125X402, 75114X125X398, 75114X125X399, 75114X125X400, 75114X80X229, 75114X80X212, 75114X80X213, 75114X80X214, 75114X83X230, 75114X83X231, 75114X83X232, 75114X83X233, 75114X84X234, 75114X84X235, 75114X84X236, 75114X84X237, 75114X85X238, 75114X85X239, 75114X85X240, 75114X85X241, 75114X86X242, 75114X86X243, 75114X86X244, 75114X86X245, 75114X87X262, 75114X87X263, 75114X87X264, 75114X87X265, 75114X88X266, 75114X88X267, 75114X88X268, 75114X88X269, 75114X89X270, 75114X89X271, 75114X89X272, 75114X89X273, 75114X90X274, 75114X90X275, 75114X90X276, 75114X90X277, 75114X91X278, 75114X91X279, 75114X91X280, 75114X91X281, 75114X92X282, 75114X92X283, 75114X92X284, 75114X92X285, 75114X93X286, 75114X93X287, 75114X93X288, 75114X93X289, 75114X94X290, 75114X94X291, 75114X94X292, 75114X94X293, 75114X95X294, 75114X95X295, 75114X95X296, 75114X95X297, 75114X75X210, 75114X75X210other, 75114X76X215, 75114X76X215other, 75114X77X216, 75114X77X216other, 75114X78X217, 75114X78X217other, 75114X79X218, 75114X79X218other, 75114X126X403, 75114X81X219 FROM lime_old_survey_75114_20110526003706

Any ideas?
Last Edit: 5 years 7 months ago by theZ.

Please Log in to join the conversation.

More
5 years 7 months ago - 5 years 7 months ago #61508 by theZ
So I copied the survey to a different one with another name, activate the survey and try to import again, this time no error message but the data isnt there.

It did import the start language, data last action take, date started, IP address and even the referrer URL, all those are there for all responses, but none of the survey answers.

I went to PHPmyadmin and I see all the answers are there in the table I asked it to import.
Last Edit: 5 years 7 months ago by theZ.

Please Log in to join the conversation.

Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form