I accidentally deleted a group of questions. Fortunately I had done a copy. I could successfully export the questions group in a .lsg file. But when importing the file I gets the error message: This is not a valid LimeSurvey group structure XML file.
Is there any known issue with XML files I should check in my file?
That file is not a valid group export. Open it in a plain-text editor and it indicates a SQL error in the export. Here is the content of the file:
Code:
<!DOCTYPE html PUBLIC"-//W3C//DTD XHTML 1.0 Transitional//EN""https://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="https://www.w3.org/1999/xhtml" xml:lang="en" lang="en"><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"/><title>Internal Server Error</title><style type="text/css">/*<![CDATA[*/
body {font-family:"Verdana";font-weight:normal;color:black;background-color:white;}
h1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red }
h2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon }
h3 {font-family:"Verdana";font-weight:bold;font-size:11pt}
p {font-family:"Verdana";font-weight:normal;color:black;font-size:9pt;margin-top:-5px}.version {color: gray;font-size:8pt;border-top:1px solid #aaaaaa;}
/*]]>*/</style></head><body><h1>Internal Server Error</h1><h2>CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation:1064 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 &#039;and q.gid=24<br />
where q.language=&#039;&#039; group by qa.qid, qa.attribute, qa.value&#039; at line 2</h2>
<p>
An internal error occurred while the Web server was processing your request.
Please contact the webmaster to report this problem.</p><p>
Thank you.</p><div class="version">2016-03-2616:17:58</div></body></html>
Cheers,
Tony Partner Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
