<HTML dir=ltr><HEAD>
<META http-equiv=Content-Type content="text/html; charset=unicode">
<META content="MSHTML 6.00.6001.18226" name=GENERATOR>
<STYLE>
<!--
font-face
{font-family:"MS Gothic";}
font-face
{font-family:"Cambria Math";}
font-face
{font-family:Calibri;}
font-face
{font-family:Tahoma;}
font-face
{font-family:"\@MS Gothic";}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{
color:purple;
text-decoration:underline;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{
margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:36.0pt;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
span.EmailStyle17
{
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{}
div.Section1
{page:Section1;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
-->
</STYLE>
</HEAD>
<BODY lang=EN-GB vLink=purple link=blue>
<DIV id=idOWAReplyText94987 dir=ltr>
<DIV dir=ltr><FONT face=Arial color=#000000 size=2>If you're doing XAMPP</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>Download XAMPP - install with the defaults</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>Make a folder called toolkits in c:\xampp\htdocs\toolkits\</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>put the zip file contents in there (not in a sub folder).</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>go to <A href="http://localhost/toolkits/setup/">http://localhost/toolkits/setup/</A></FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>Choose the xampp button.</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>Thats it.</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>If you do this method. demo.php is renamed to become index.php.</FONT></DIV></DIV>
<DIV dir=ltr><BR>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> xerte-bounces@lists.nottingham.ac.uk on behalf of RonM<BR><B>Sent:</B> Sun 19/04/2009 00:24<BR><B>To:</B> ktwoho@yahoo.com.hk; 'Xerte discussion list'<BR><B>Subject:</B> RE: [Xerte] Xerte Online Toolkits: Installation Guide<BR></FONT><BR></DIV>
<DIV>
<DIV class=Section1>
<P class=MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">Hi Keith (& Becky from previous posts)</SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"></SPAN> </P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">I’m guessing and there could be other issues as stake here but I suspect you both may have downloaded xertetoolkits.zip rather than toolkits.zip and xertetoolkits.zip has a hardcoded value in database.txt which slipped in at some point and causes this error during setup. There are 2 places to download toolkits from the notts site and at the moment they contain two different links e.g.</SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"></SPAN> </P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d"><A href="http://www.nottingham.ac.uk/~cczjrt/Editor/index.htm">http://www.nottingham.ac.uk/~cczjrt/Editor/index.htm</A> has a link to <A href="http://www.nottingham.ac.uk/~cczjrt/Editor/downloads/xertetoolkits.zip">http://www.nottingham.ac.uk/~cczjrt/Editor/downloads/xertetoolkits.zip</A> </SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d">and <A href="http://www.nottingham.ac.uk/~cczjrt/Editor/toolkits.htm">http://www.nottingham.ac.uk/~cczjrt/Editor/toolkits.htm</A> has a link to <A href="http://www.nottingham.ac.uk/~cczjrt/Editor/downloads/toolkits.zip">http://www.nottingham.ac.uk/~cczjrt/Editor/downloads/toolkits.zip</A></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d"></SPAN> </P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d">download <A href="http://www.nottingham.ac.uk/~cczjrt/Editor/downloads/toolkits.zip">http://www.nottingham.ac.uk/~cczjrt/Editor/downloads/toolkits.zip</A> and try again. Delete the previous database first or use a new name during setup.</SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d"></SPAN> </P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d">Also unless you are including ldap integration once installed you’ll need to visit demo.php which is the unsecured page for creating content.</SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d"></SPAN> </P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d">HTH</SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d">Ron</SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"></SPAN> </P>
<DIV style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0cm; BORDER-TOP: #b5c4df 1pt solid; PADDING-LEFT: 0cm; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; PADDING-TOP: 3pt; BORDER-BOTTOM: medium none">
<P class=MsoNormal><B><SPAN lang=EN-US style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'">From:</SPAN></B><SPAN lang=EN-US style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'"> xerte-bounces@lists.nottingham.ac.uk [mailto:xerte-bounces@lists.nottingham.ac.uk] <B>On Behalf Of </B>Keith Holney<BR><B>Sent:</B> 18 April 2009 23:52<BR><B>To:</B> xerte@lists.nottingham.ac.uk<BR><B>Subject:</B> [Xerte] Xerte Online Toolkits: Installation Guide</SPAN></P></DIV>
<P class=MsoNormal> </P>
<TABLE class=MsoNormalTable cellSpacing=0 cellPadding=0 border=0>
<TBODY>
<TR>
<TD style="PADDING-RIGHT: 0cm; PADDING-LEFT: 0cm; PADDING-BOTTOM: 0cm; PADDING-TOP: 0cm" vAlign=top>
<DIV>
<P class=MsoNormal>Dear Julian,</P></DIV>
<DIV>
<P class=MsoNormal> </P></DIV>
<DIV>
<P class=MsoNormal>Xerte is great and thanks for your efforts!</P></DIV>
<DIV>
<P class=MsoNormal> </P></DIV>
<DIV>
<P class=MsoNormal>I followed your localhost Xerte Online Toolkits Installation Guide as posted on 19 Sep 2008 but could not make it work.</P></DIV>
<DIV>
<P class=MsoNormal> </P></DIV>
<DIV>
<P class=MsoNormal>(1) I have tried both 1.6.7 and 1.7.1 of XAMPP and the results are the same.</P></DIV>
<DIV>
<P class=MsoNormal> </P></DIV>
<DIV>
<P class=MsoNormal>(2) "Setting the Xerte Toolkits": </P></DIV>
<DIV>
<P class=MsoNormal>- After setting the database account ("root" with a blank password), the setup page showed a long configuration page. </P></DIV>
<DIV>
<P class=MsoNormal>- It seemed there was no need to enter any "NULL" value in any field as you mentioned. </P></DIV>
<DIV>
<P class=MsoNormal>- So I just clicked "Submit" but was given a long list of error messages.</P></DIV>
<DIV>
<P class=MsoNormal> </P></DIV>
<DIV>
<P class=MsoNormal>(3) Error Messages: </P></DIV>
<DIV>
<P class=MsoNormal>- The 1st line is "The sitedetails site ID query insert into tk__sitedetails(site_id) VALUES ( "1") has failed due to No database selected".</P></DIV>
<DIV>
<P class=MsoNormal>- The rest are similar (all saying "site_id="1" has failed due to No database selected").</P></DIV>
<DIV>
<P class=MsoNormal> </P></DIV>
<DIV>
<P class=MsoNormal>(4) "localhost/toolkits" only displays the number "1" on a blank page.</P></DIV>
<DIV>
<P class=MsoNormal> </P></DIV>
<DIV>
<P class=MsoNormal>I have followed every step in your installation guide. Please help!</P></DIV>
<DIV>
<P class=MsoNormal> </P></DIV>
<DIV>
<P class=MsoNormal>Best regards,</P></DIV>
<DIV>
<P class=MsoNormal>Keith</P></DIV>
<DIV>
<P class=MsoNormal> </P></DIV>
<DIV>
<P class=MsoNormal> </P></DIV></TD></TR></TBODY></TABLE>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Calibri','sans-serif'"></SPAN> </P>
<DIV class=MsoNormal style="TEXT-ALIGN: center" align=center><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Calibri','sans-serif'">
<HR align=center width="100%" SIZE=1>
</SPAN></DIV>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Calibri','sans-serif'">Yahoo!</SPAN><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'MS Gothic'">香港提供網上安全攻略，教你如何防範黑客</SPAN><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Calibri','sans-serif'">!<A href="http://hk.promo.yahoo.com/security/"><B><SPAN style="FONT-FAMILY: 'MS Gothic'">了解更多</SPAN></B></A></SPAN></P></DIV></DIV></BODY></HTML>