<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 12 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
h2
{mso-style-priority:9;
mso-style-link:"Heading 2 Char";
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:18.0pt;
font-family:"Times New Roman","serif";
font-weight:bold;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.Heading2Char
{mso-style-name:"Heading 2 Char";
mso-style-priority:9;
mso-style-link:"Heading 2";
font-family:"Cambria","serif";
color:#4F81BD;
font-weight:bold;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-GB link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Hi<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>I think if no database.php is getting created then you need to check/change permissions on the root directory to allow that to happen if only temporarily.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>HTH<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Ron<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> xerte-bounces@lists.nottingham.ac.uk [mailto:xerte-bounces@lists.nottingham.ac.uk] <b>On Behalf Of </b>Maurizio Bricola<br><b>Sent:</b> 12 May 2014 17:15<br><b>To:</b> Xerte discussion list<br><b>Cc:</b> Andrei Barburas<br><b>Subject:</b> [Xerte] Re: SQL error while instaling Xerte on our server<o:p></o:p></span></p></div><p class=MsoNormal><o:p> </o:p></p><p>Hi Ron, thanks for your prompt reply. Yes we did that, still non database.php file gets created. Hence the error I believe. <br>Anything else we should look at?<br>Cheers<o:p></o:p></p><div><p class=MsoNormal>On 12 May 2014 16:46, "Ron Mitchell" <<a href="mailto:ronm@mitchellmedia.co.uk">ronm@mitchellmedia.co.uk</a>> wrote:<o:p></o:p></p><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Did you create the empty database and database user first and then use those credentials during setup?</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Check that database.php has been created in the root of your install and that the entries it contains are correct.</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> </span><o:p></o:p></p><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> <a href="mailto:xerte-bounces@lists.nottingham.ac.uk" target="_blank">xerte-bounces@lists.nottingham.ac.uk</a> [mailto:<a href="mailto:xerte-bounces@lists.nottingham.ac.uk" target="_blank">xerte-bounces@lists.nottingham.ac.uk</a>] <b>On Behalf Of </b>Maurizio Bricola<br><b>Sent:</b> 12 May 2014 10:57<br><b>To:</b> <a href="mailto:xerte@lists.nottingham.ac.uk" target="_blank">xerte@lists.nottingham.ac.uk</a><br><b>Subject:</b> [Xerte] SQL error while instaling Xerte on our server</span><o:p></o:p></p></div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-family:"Verdana","sans-serif"'>Dear All, we have first tried Xerte on a Xammp installation and everything went fine. We decided to make it available online for the schools we are currently supporting.</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-family:"Verdana","sans-serif"'>When going through the setup we ran into the following issue:</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-family:"Verdana","sans-serif"'> </span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><b><span style='font-size:8.0pt;font-family:"Verdana","sans-serif";color:black;background:#EDEDED'>Warning</span></b><span style='font-size:8.0pt;font-family:"Verdana","sans-serif";color:black;background:#EDEDED'>: session_start() [</span><span style='font-family:"Verdana","sans-serif"'><a href="http://cdn3.iicd.org/xerte/setup/function.session-start" target="_blank"><span style='font-size:8.0pt;color:black;background:#EDEDED'>function.session-start</span></a></span><span style='font-size:8.0pt;font-family:"Verdana","sans-serif";color:black;background:#EDEDED'>]: Cannot send session cookie - headers already sent by (output started at /home/cdn3iicd/public_html/xerte/setup/page_password.php:3) in<b>/home/cdn3iicd/public_html/xerte/setup/page_password.php</b> on line <b>4</b></span><span style='font-size:8.0pt;font-family:"Verdana","sans-serif";color:black'><br><br><b><span style='background:#EDEDED'>Warning</span></b><span style='background:#EDEDED'>: session_start() [</span></span><span style='font-family:"Verdana","sans-serif"'><a href="http://cdn3.iicd.org/xerte/setup/function.session-start" target="_blank"><span style='font-size:8.0pt;color:black;background:#EDEDED'>function.session-start</span></a></span><span style='font-size:8.0pt;font-family:"Verdana","sans-serif";color:black;background:#EDEDED'>]: Cannot send session cache limiter - headers already sent (output started at /home/cdn3iicd/public_html/xerte/setup/page_password.php:3) in<b>/home/cdn3iicd/public_html/xerte/setup/page_password.php</b> on line <b>4</b></span><o:p></o:p></p><p style='background:#EDEDED'><span style='font-size:8.0pt;font-family:"Verdana","sans-serif";color:black'>Sorry, the attempt to open database using account cdn3iicd_xusers failed. MySQL reports the following error -</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;background:#EDEDED'><b><span style='font-size:8.0pt;font-family:"Verdana","sans-serif";color:red'>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 '' at line 1</span></b><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-family:"Verdana","sans-serif"'> </span><o:p></o:p></p><p style='background:#EDEDED'><span style='font-size:8.0pt;font-family:"Verdana","sans-serif";color:black'>The account cdn3iicd_xusers must already exist, and have access to database</span><o:p></o:p></p><h2 style='margin-top:9.0pt;background:#EDEDED'><span style='font-family:"Verdana","sans-serif";color:black'>Using given MySQL account failed!</span><o:p></o:p></h2><p style='background:#EDEDED'><span style='font-size:8.0pt;font-family:"Verdana","sans-serif";color:black'>Your Xerte Online Toolkits database configuration file is not created! Please investigate the error messages and return to the previous page by pressing the button below!</span><o:p></o:p></p></div><div><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-family:"Verdana","sans-serif"'>Any help is highly appreciated, </span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-family:"Verdana","sans-serif"'>t</span><o:p></o:p></p></div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-family:"Verdana","sans-serif"'>hanks!</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:7.5pt;font-family:"Verdana","sans-serif"'>With Kind Regards,<br>Maurizio Bricola<br>Technical Advisor Solutions and Innovations</span><o:p></o:p></p><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><b><span style='font-size:7.5pt;font-family:"Verdana","sans-serif"'>Working days: Mon - Tue - Wed - Thu</span></b><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:7.5pt;font-family:"Verdana","sans-serif"'>International Institute for Communication and Development (IICD)<br>P.O. Box 11586, 2502 AN The Hague, the Netherlands<br>Visitors: Raamweg 5, 2596 HL The Hague<br>Phone: <a href="tel:%2B31-%280%2970-311%2073%2011" target="_blank">+31-(0)70-311 73 11</a></span><o:p></o:p></p><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:7.5pt;font-family:"Arial","sans-serif";color:#45818E'>Follow us: </span><span style='font-size:7.5pt;font-family:"Arial","sans-serif"'><a href="http://www.iicd.org/" target="_blank"><span style='color:#3D85C6'>www.iicd.org</span></a><span style='color:#45818E'> </span><span style='color:#E69138'>|</span><span style='color:#45818E'> </span><a href="http://facebook.com/iicd.org" target="_blank"><span style='color:#3D85C6'>facebook.com/iicd.org</span></a><span style='color:#45818E'> </span><span style='color:#E69138'>|</span><span style='color:#45818E'> </span><a href="http://twitter.com/iicd" target="_blank"><span style='color:#3D85C6'>twitter.com/iicd</span></a></span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><b><span style='font-size:7.5pt;font-family:"Arial","sans-serif";color:#E69138'>People | ICT | Development</span></b><o:p></o:p></p></div><p class=MsoNormal style='mso-margin-top-alt:auto;margin-bottom:12.0pt'><span style='font-size:7.5pt;font-family:"Verdana","sans-serif"'><br><br></span><o:p></o:p></p></div></div></div></div></div><p class=MsoNormal><o:p> </o:p></p><p>This message and any attachment are intended solely for the addressee and may contain confidential information. If you have received this message in error, please send it back to me, and immediately delete it. Please do not use, copy or disclose the information contained in this message or in any attachment. Any views or opinions expressed by the author of this email do not necessarily reflect the views of the University of Nottingham.<o:p></o:p></p><p>This message has been checked for viruses but the contents of an attachment may still contain software viruses which could damage your computer system, you are advised to perform your own checks. Email communications with the University of Nottingham may be monitored as permitted by UK legislation.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p></div><p class=MsoNormal style='margin-bottom:12.0pt'><br>_______________________________________________<br>Xerte mailing list<br><a href="mailto:Xerte@lists.nottingham.ac.uk">Xerte@lists.nottingham.ac.uk</a><br><a href="http://lists.nottingham.ac.uk/mailman/listinfo/xerte" target="_blank">http://lists.nottingham.ac.uk/mailman/listinfo/xerte</a><o:p></o:p></p></div></div></body></html>