Welcome, Guest
Username: Password: Remember me

TOPIC: Error when trying to import old responses

Error when trying to import old responses 3 years 6 months ago #61506

  • theZ
  • theZ's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 3
  • Karma: 1
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: 3 years 6 months ago by theZ.
The administrator has disabled public write access.

Re: Error when trying to import old responses 3 years 6 months ago #61508

  • theZ
  • theZ's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 3
  • Karma: 1
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: 3 years 6 months ago by theZ.
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.110 seconds
Donation Image