<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)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@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:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
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:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.msochpdefault, li.msochpdefault, div.msochpdefault
{mso-style-name:msochpdefault;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:10.0pt;
font-family:"Times New Roman","serif";}
span.emailstyle18
{mso-style-name:emailstyle18;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.emailstyle19
{mso-style-name:emailstyle19;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
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-US link=blue vlink=purple>
<div class=WordSection1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Does the path in the error really have single-quotes and the
site_id= has double-quotes, or did you re-type it? They should both be single
or both be double quotes or you’ll get a syntax error. And shouldn’t
those backslashes be forward slashes, or double (escaped) backslashes?<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-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt'>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
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>Bullman, Ian<br>
<b>Sent:</b> Friday, October 29, 2010 7:49 AM<br>
<b>To:</b> Xerte discussion list<br>
<b>Subject:</b> RE: [Xerte] xerte & moodle integration<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<div id=idOWAReplyText14135>
<div>
<p class=MsoNormal><span lang=EN-GB style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:black'>Hi Pat</span><span lang=EN-GB><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=EN-GB> <o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=EN-GB style='font-size:10.0pt;font-family:"Arial","sans-serif"'>I
am back to bother you again. I went back to basics, resetting everything,
ensuring all necessary folders have Write permissions (even up to hard disk
level so there is no doubt).</span><span lang=EN-GB><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=EN-GB> <o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=EN-GB style='font-size:10.0pt;font-family:"Arial","sans-serif"'>On
the new set up (I have tried a few times) I consistently get the following
message when it runs the set up query:</span><span lang=EN-GB><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=EN-GB> <o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal style='margin-bottom:10.0pt'><span lang=EN-GB
style='font-family:"Calibri","sans-serif";color:blue'>The sitedetails
root_file_path query update sitedetails set
root_file_path='J:\xampp\htdocs\xertetoolkits\' where site_id="1" has
failed due to 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
''J:\xampp\htdocs\xertetoolkits\' where site_id="1"' at line 1</span><span
lang=EN-GB><o:p></o:p></span></p>
<p class=MsoNormal style='margin-bottom:10.0pt'><span lang=EN-GB
style='font-size:10.0pt;font-family:"Arial","sans-serif"'>This certainly ties
in with the "No such file" message I got while trying to access the
Edit feature of Toolkits yesterday.</span><span lang=EN-GB><o:p></o:p></span></p>
<p class=MsoNormal style='margin-bottom:10.0pt'><span lang=EN-GB
style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Have you any idea why
the root_file_path is failing during setup?</span><span lang=EN-GB><o:p></o:p></span></p>
<p class=MsoNormal style='margin-bottom:10.0pt'><span lang=EN-GB
style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Thanks for your help
so far.</span><span lang=EN-GB> <o:p></o:p></span></p>
</div>
</div>
<div id=idSignature56041>
<p class=MsoNormal><span lang=EN-GB style='font-size:10.0pt;font-family:"Verdana","sans-serif";
color:blue'>Ian Bullman</span><span lang=EN-GB><o:p></o:p></span></p>
<p class=MsoNormal align=center style='text-align:center'><span lang=EN-GB> <o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-GB style='font-size:10.0pt;font-family:"Verdana","sans-serif";
color:blue'>Key Skills Tutor / Construction</span><span lang=EN-GB><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-GB style='font-size:10.0pt;font-family:"Verdana","sans-serif";
color:blue'>ILCT Champion</span><span lang=EN-GB><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-GB> <o:p></o:p></span></p>
<div>
<p class=MsoNormal><span lang=EN-GB style='font-size:10.0pt'> <o:p></o:p></span></p>
</div>
<p class=MsoNormal><span lang=EN-GB> <o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=EN-GB><o:p> </o:p></span></p>
<div class=MsoNormal align=center style='text-align:center'><span lang=EN-GB>
<hr size=2 width="100%" align=center>
</span></div>
<p class=MsoNormal style='margin-bottom:12.0pt'><b><span lang=EN-GB
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
lang=EN-GB style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
xerte-bounces@lists.nottingham.ac.uk on behalf of Patrick Lockley<br>
<b>Sent:</b> Thu 28/10/2010 17:49<br>
<b>To:</b> Xerte discussion list<br>
<b>Subject:</b> RE: [Xerte] xerte & moodle integration</span><span
lang=EN-GB><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=EN-GB style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>The moodle patch is another problem – not yours </span><span
lang=EN-GB style='font-size:11.0pt;font-family:Wingdings;color:#1F497D'>J</span><span
lang=EN-GB><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-GB> <o:p></o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal style='margin-left:.5in'><b><span style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'>From:</span></b><span 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>Bullman, Ian<br>
<b>Sent:</b> 28 October 2010 17:43<br>
<b>To:</b> Xerte discussion list<br>
<b>Subject:</b> RE: [Xerte] xerte & moodle integration</span><span
lang=EN-GB><o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB> <o:p></o:p></span></p>
<div id=idOWAReplyText14899>
<div>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:
10.0pt;font-family:"Arial","sans-serif";color:black'>Thanks Ron</span><span
lang=EN-GB><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB> <o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:
10.0pt;font-family:"Arial","sans-serif"'>I ran the demo.php and that took me
back to the toolkits My Projects workspace. I tried to edit the learning
object, but still the same message as before.</span><span lang=EN-GB><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB> <o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:
10.0pt;font-family:"Arial","sans-serif"'>I am not sure what you mean by the
Moodle patch. I am running a moodle and xerte alongside each other on the same
xampp, I have tried to integrate them at all.</span><span lang=EN-GB><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB> <o:p></o:p></span></p>
</div>
</div>
<div id=idSignature40679>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:
10.0pt;font-family:"Verdana","sans-serif";color:blue'>Ian Bullman</span><span
lang=EN-GB><o:p></o:p></span></p>
<p class=MsoNormal align=center style='margin-left:.5in;text-align:center'><span
lang=EN-GB> <o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:
10.0pt;font-family:"Verdana","sans-serif";color:blue'>Key Skills Tutor /
Construction</span><span lang=EN-GB><o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:
10.0pt;font-family:"Verdana","sans-serif";color:blue'>ILCT Champion</span><span
lang=EN-GB><o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB> <o:p></o:p></span></p>
<div>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB> <o:p></o:p></span></p>
</div>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB> <o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB> <o:p></o:p></span></p>
<div style='margin-left:.5in'>
<div class=MsoNormal align=center style='text-align:center'><span lang=EN-GB>
<hr size=2 width="100%" align=center>
</span></div>
</div>
<p class=MsoNormal style='mso-margin-top-alt:0in;margin-right:0in;margin-bottom:
12.0pt;margin-left:.5in'><b><span lang=EN-GB style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'>From:</span></b><span lang=EN-GB
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
xerte-bounces@lists.nottingham.ac.uk on behalf of Ron Mitchell<br>
<b>Sent:</b> Thu 28/10/2010 17:23<br>
<b>To:</b> 'Xerte discussion list'<br>
<b>Subject:</b> RE: [Xerte] xerte & moodle integration</span><span
lang=EN-GB><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:
11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Did the installation
work via demo.php first? Always worth trying that to ensure everything else is
ok first. So try this...</span><span lang=EN-GB><o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB> <o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:
11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>1. Restore the
original files you replaced when installing the Moodle patch</span><span
lang=EN-GB><o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:
11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>2. rename demo.txt to
demo.php and visit http://yourinstall.ac.uk/demo.php</span><span lang=EN-GB><o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:
11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>If that works the
problem is with the patch configuration but if it doesn't there is a more basic
problem</span><span lang=EN-GB><o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB> <o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:
11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>3. If demo.php does
work put the patch back in but check the readme in the patch again and make
sure the path to your moodle/config.php is correct.</span><span lang=EN-GB><o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB> <o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:
11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Going to be offline
from about 6.15 for a couple of hours but report back and I'll try to help
further</span><span lang=EN-GB><o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB> <o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:
11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Ron</span><span
lang=EN-GB><o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB> <o:p></o:p></span></p>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal style='margin-left:.5in'><b><span style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'>From:</span></b><span 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>Dan Attwood<br>
<b>Sent:</b> 28 October 2010 16:58<br>
<b>To:</b> xerte@lists.nottingham.ac.uk<br>
<b>Subject:</b> [Xerte] xerte & moodle integration</span><span lang=EN-GB><o:p></o:p></span></p>
</div>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB> <o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB>I've just tried to
set up the:moodle patch for Xerte toolkits 1.0.2 and I'm getting the this
output:<o:p></o:p></span></p>
<div>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB> <o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB>php_library_path .
"login_library.php"; include
$xerte_toolkits_site->php_library_path . "display_library.php";
include $xerte_toolkits_site->php_library_path .
"database_library.php";<o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB> <o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB>trimmed to remove
a lot of similar errors.<o:p></o:p></span></p>
<div>
<div>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB> <o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB>Is there a way to
get this working or is the Moodle integration better approached in a different
way, ie through ldap?<o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB> <o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB>Dan <o:p></o:p></span></p>
</div>
</div>
</div>
<p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB> <o:p></o:p></span></p>
<p style='margin-left:.5in'><span lang=EN-GB>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></span></p>
<p style='margin-left:.5in'><span lang=EN-GB>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></span></p>
</div>
</div>
</div>
</div>
</body>
</html>