<p dir="ltr">Hi Ron thanks we' ll give it a try to that. Cheers</p>
<div class="gmail_quote">On 12 May 2014 18:36, "Ron Mitchell" <<a href="mailto:ronm@mitchellmedia.co.uk">ronm@mitchellmedia.co.uk</a>> wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div lang="EN-GB" link="blue" vlink="purple"><div><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Hi<u></u><u></u></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.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">HTH<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Ron<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></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""> <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 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<u></u><u></u></span></p></div><p class="MsoNormal">
<u></u> <u></u></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<u></u><u></u></p><div><p class="MsoNormal">
On 12 May 2014 16:46, "Ron Mitchell" <<a href="mailto:ronm@mitchellmedia.co.uk" target="_blank">ronm@mitchellmedia.co.uk</a>> wrote:<u></u><u></u></p><div><div><p class="MsoNormal"><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><u></u><u></u></p>
<p class="MsoNormal"><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><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span><u></u><u></u></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""> <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><u></u><u></u></p>
</div><p class="MsoNormal"> <u></u><u></u></p><div><div><p class="MsoNormal"><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><u></u><u></u></p>
</div><div><p class="MsoNormal"><span style="font-family:"Verdana","sans-serif"">When going through the setup we ran into the following issue:</span><u></u><u></u></p></div><div><p class="MsoNormal"><span style="font-family:"Verdana","sans-serif""> </span><u></u><u></u></p>
</div><div><p class="MsoNormal"><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><u></u><u></u></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><u></u><u></u></p>
<p class="MsoNormal" style="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><u></u><u></u></p>
<p class="MsoNormal"><span style="font-family:"Verdana","sans-serif""> </span><u></u><u></u></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><u></u><u></u></p>
<h2 style="margin-top:9.0pt;background:#ededed"><span style="font-family:"Verdana","sans-serif";color:black">Using given MySQL account failed!</span><u></u><u></u></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><u></u><u></u></p>
</div><div><div><div><p class="MsoNormal"><span style="font-family:"Verdana","sans-serif"">Any help is highly appreciated, </span><u></u><u></u></p></div><div><p class="MsoNormal"><span style="font-family:"Verdana","sans-serif"">t</span><u></u><u></u></p>
</div><p class="MsoNormal"><span style="font-family:"Verdana","sans-serif"">hanks!</span><u></u><u></u></p></div><div><p class="MsoNormal"> <u></u><u></u></p></div><div><p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana","sans-serif"">With Kind Regards,<br>
Maurizio Bricola<br>Technical Advisor Solutions and Innovations</span><u></u><u></u></p><div><p class="MsoNormal"><b><span style="font-size:7.5pt;font-family:"Verdana","sans-serif"">Working days: Mon - Tue - Wed - Thu</span></b><u></u><u></u></p>
</div><div><p class="MsoNormal"><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><u></u><u></u></p><div><p class="MsoNormal"><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><u></u><u></u></p>
</div><div><p class="MsoNormal"><b><span style="font-size:7.5pt;font-family:"Arial","sans-serif";color:#e69138">People | ICT | Development</span></b><u></u><u></u></p></div><p class="MsoNormal" style="margin-bottom:12.0pt">
<span style="font-size:7.5pt;font-family:"Verdana","sans-serif""><br><br></span><u></u><u></u></p></div></div></div></div></div><p class="MsoNormal"><u></u> <u></u></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.<u></u><u></u></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.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p></div><p class="MsoNormal" style="margin-bottom:12.0pt"><br>_______________________________________________<br>Xerte mailing list<br><a href="mailto:Xerte@lists.nottingham.ac.uk" target="_blank">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><u></u><u></u></p></div></div>
<br><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.</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.</p>
<br></div><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><br>
<br></blockquote></div>