<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:SimSun;
        panose-1:2 1 6 0 3 1 1 1 1 1;}
@font-face
        {font-family:SimSun;
        panose-1:2 1 6 0 3 1 1 1 1 1;}
@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:"\@SimSun";
        panose-1:2 1 6 0 3 1 1 1 1 1;}
 /* Style Definitions */
 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
        {mso-style-priority:99;
        color:blue;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {mso-style-priority:99;
        color:purple;
        text-decoration:underline;}
span.EmailStyle18
        {mso-style-type:personal-reply;
        font-family:"Calibri","sans-serif";
        color:#1F497D;}
.MsoChpDefault
        {mso-style-type:export-only;
        font-size:10.0pt;}
@page Section1
        {size:612.0pt 792.0pt;
        margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.Section1
        {page:Section1;}
 /* List Definitions */
 @list l0
        {mso-list-id:40785735;
        mso-list-template-ids:55594990;}
@list l0:level1
        {mso-level-number-format:bullet;
        mso-level-text:\F0B7;
        mso-level-tab-stop:36.0pt;
        mso-level-number-position:left;
        text-indent:-18.0pt;
        mso-ansi-font-size:10.0pt;
        font-family:Symbol;}
@list l0:level2
        {mso-level-number-format:bullet;
        mso-level-text:o;
        mso-level-tab-stop:72.0pt;
        mso-level-number-position:left;
        text-indent:-18.0pt;
        mso-ansi-font-size:10.0pt;
        font-family:"Courier New";
        mso-bidi-font-family:"Times New Roman";}
@list l1
        {mso-list-id:370888499;
        mso-list-template-ids:788562858;}
@list l1:level1
        {mso-level-number-format:bullet;
        mso-level-text:\F0B7;
        mso-level-tab-stop:36.0pt;
        mso-level-number-position:left;
        text-indent:-18.0pt;
        mso-ansi-font-size:10.0pt;
        font-family:Symbol;}
@list l2
        {mso-list-id:801657503;
        mso-list-template-ids:-301681948;}
@list l2:level1
        {mso-level-number-format:bullet;
        mso-level-text:\F0B7;
        mso-level-tab-stop:36.0pt;
        mso-level-number-position:left;
        text-indent:-18.0pt;
        mso-ansi-font-size:10.0pt;
        font-family:Symbol;}
@list l3
        {mso-list-id:1124887840;
        mso-list-template-ids:1592529618;}
@list l3:level1
        {mso-level-number-format:bullet;
        mso-level-text:\F0B7;
        mso-level-tab-stop:36.0pt;
        mso-level-number-position:left;
        text-indent:-18.0pt;
        mso-ansi-font-size:10.0pt;
        font-family:Symbol;}
@list l4
        {mso-list-id:1358698967;
        mso-list-template-ids:306758320;}
@list l4:level1
        {mso-level-number-format:bullet;
        mso-level-text:\F0B7;
        mso-level-tab-stop:36.0pt;
        mso-level-number-position:left;
        text-indent:-18.0pt;
        mso-ansi-font-size:10.0pt;
        font-family:Symbol;}
@list l5
        {mso-list-id:1626346803;
        mso-list-template-ids:-237624022;}
@list l5:level1
        {mso-level-number-format:bullet;
        mso-level-text:\F0B7;
        mso-level-tab-stop:36.0pt;
        mso-level-number-position:left;
        text-indent:-18.0pt;
        mso-ansi-font-size:10.0pt;
        font-family:Symbol;}
ol
        {margin-bottom:0cm;}
ul
        {margin-bottom:0cm;}
-->
</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=Section1>

<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Swap the mysql_db_select on &nbsp; line 17 of page4.php for this<o:p></o:p></span></p>

<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p>&nbsp;</o:p></span></p>

<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>if(!mysql_select_db($xerte_toolkits_site-&gt;database_name,
$mysql_connect_id)){<o:p></o:p></span></p>

<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <o:p></o:p></span></p>

<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; echo &quot;Cannot select the
database&lt;br&gt;&quot;;<o:p></o:p></span></p>

<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <o:p></o:p></span></p>

<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; echo
mysql_errno($mysql_connect_id) . &quot;: &quot; .
mysql_error($mysql_connect_id) . &quot;\n&quot;;<o:p></o:p></span></p>

<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <o:p></o:p></span></p>

<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; die();<o:p></o:p></span></p>

<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p>&nbsp;</o:p></span></p>

<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <o:p></o:p></span></p>

<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<o:p></o:p></span></p>

<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p>&nbsp;</o:p></span></p>

<div>

<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>

<p class=MsoNormal style='margin-left:36.0pt'><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>Patrick
Lockley<br>
<b>Sent:</b> 25 January 2010 00:20<br>
<b>To:</b> Xerte discussion list<br>
<b>Subject:</b> RE: [Xerte] Xerte Online Toolkit - Setup Errors<o:p></o:p></span></p>

</div>

</div>

<p class=MsoNormal style='margin-left:36.0pt'><o:p>&nbsp;</o:p></p>

<div id=idOWAReplyText16505>

<div>

<p class=MsoNormal style='margin-left:36.0pt'><span style='font-size:10.0pt;
font-family:"Arial","sans-serif";color:black'>Yeah, then it should work.</span><o:p></o:p></p>

</div>

<div>

<p class=MsoNormal style='margin-left:36.0pt'>&nbsp;<o:p></o:p></p>

</div>

<div>

<p class=MsoNormal style='margin-left:36.0pt'><span style='font-size:10.0pt;
font-family:"Arial","sans-serif"'>So it fails going from page 3 onto page 4?
I'll make a&nbsp;debug&nbsp;tomorrow to see what happens.</span><o:p></o:p></p>

</div>

</div>

<div>

<p class=MsoNormal style='margin-left:36.0pt'><o:p>&nbsp;</o:p></p>

<div class=MsoNormal align=center style='margin-left:36.0pt;text-align:center'>

<hr size=2 width="100%" align=center>

</div>

<p class=MsoNormal style='mso-margin-top-alt:0cm;margin-right:0cm;margin-bottom:
12.0pt;margin-left:36.0pt'><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 on behalf of Tom Sliker<br>
<b>Sent:</b> Sun 24/01/2010 18:12<br>
<b>To:</b> Xerte discussion list<br>
<b>Subject:</b> Re: [Xerte] Xerte Online Toolkit - Setup Errors</span><o:p></o:p></p>

</div>

<div>

<div>

<p class=MsoNormal style='margin-left:36.0pt'>I think so-- everything is on the
same server.&nbsp; according to BlueHost&nbsp; /MY Sql screen: <o:p></o:p></p>

</div>

<div>

<p class=MsoNormal style='margin-left:36.0pt'><em>When connecting to your
database the hostname you will almost always use is localhost. The exception to
this will be if the script or program you wish to connect to the database is
running on a different system than the one hosted with Bluehost, in which case
the hostname will be <a href="http://box257.bluehost.com/">box257.bluehost.com</a>.
</em><o:p></o:p></p>

</div>

<div>

<p class=MsoNormal style='margin-left:36.0pt'>The attached screenshot shows the
PHPMyAdmin screen, which seems to imply that is localhost.&nbsp; <o:p></o:p></p>

</div>

<div>

<p class=MsoNormal style='margin-left:36.0pt'>&nbsp;<o:p></o:p></p>

</div>

<div>

<p class=MsoNormal style='margin-left:36.0pt'>What do you think? <o:p></o:p></p>

</div>

<div>

<p class=MsoNormal style='margin-left:36.0pt'>&nbsp;<o:p></o:p></p>

</div>

<div>

<p class=MsoNormal style='margin-left:36.0pt'>TS<o:p></o:p></p>

</div>

<div>

<p class=MsoNormal style='margin-left:36.0pt'>On Sun, Jan 24, 2010 at 12:07 PM,
Patrick Lockley &lt;<a href="mailto:Patrick.Lockley@nottingham.ac.uk">Patrick.Lockley@nottingham.ac.uk</a>&gt;
wrote:<o:p></o:p></p>

<div>

<div>

<div>

<p class=MsoNormal style='margin-left:36.0pt'><span style='font-size:10.0pt;
font-family:"Arial","sans-serif";color:black'>Is your host definitely
localhost?</span><o:p></o:p></p>

</div>

</div>

<div>

<p class=MsoNormal style='margin-left:36.0pt'><o:p>&nbsp;</o:p></p>

<div class=MsoNormal align=center style='margin-left:36.0pt;text-align:center'>

<hr size=2 width="100%" align=center>

</div>

<p class=MsoNormal style='mso-margin-top-alt:0cm;margin-right:0cm;margin-bottom:
12.0pt;margin-left:36.0pt'><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"'> <a
href="mailto:xerte-bounces@lists.nottingham.ac.uk" target="_blank">xerte-bounces@lists.nottingham.ac.uk</a>
on behalf of Tom Sliker<br>
<b>Sent:</b> Sun 24/01/2010 13:35<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] Xerte Online Toolkit - Setup Errors</span><o:p></o:p></p>

</div>

<div>

<div>

<div>

<div>

<p class=MsoNormal style='margin-left:36.0pt'>I'm getting errors when I get to
Page 3 of the setup process for the Online Toolkit. <o:p></o:p></p>

</div>

<div>

<p class=MsoNormal style='margin-left:36.0pt'>&nbsp;<o:p></o:p></p>

</div>

<div>

<p class=MsoNormal style='margin-left:36.0pt'>Maybe the issues relate to my
lack of knowledge of MySQL.&nbsp; I am hosting at BlueHost. <o:p></o:p></p>

</div>

<div>

<p class=MsoNormal style='margin-left:36.0pt'>&nbsp;<o:p></o:p></p>

</div>

<div>

<p class=MsoNormal style='margin-left:36.0pt'>Via CPanel I go to MySQL
Databases and see there is a database with: <o:p></o:p></p>

</div>

<div>

<p class=MsoNormal style='margin-left:36.0pt'>name: brucesne_xerte<o:p></o:p></p>

</div>

<div>

<p class=MsoNormal style='margin-left:36.0pt'>users:&nbsp; brucesne_bruce and
brucesne_xerte&nbsp; (both have ALL privileges)<o:p></o:p></p>

</div>

<div>

<p class=MsoNormal style='margin-left:36.0pt'>&nbsp;<o:p></o:p></p>

</div>

<div>

<p class=MsoNormal style='margin-left:36.0pt'>I've tried letting the wizard
create the database and tried creating an empty one myself.&nbsp; For this
attempt I have an empty database<o:p></o:p></p>

</div>

<div>

<p class=MsoNormal style='margin-left:36.0pt'>&nbsp;<o:p></o:p></p>

</div>

<div>

<p class=MsoNormal style='margin-left:36.0pt'>I run the Setup wizard at <a
href="http://www.brucesnell.com/xerte/setup/" target="_blank">http://www.brucesnell.com/xerte/setup/</a>&nbsp;<o:p></o:p></p>

</div>

<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:72.0pt;text-indent:-18.0pt;mso-list:l0 level1 lfo1'><![if !supportLists]><span
style='font-size:10.0pt;font-family:Symbol'><span style='mso-list:Ignore'>&middot;<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></span></span><![endif]>I chose Full Install <o:p></o:p></p>

<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:72.0pt;text-indent:-18.0pt;mso-list:l0 level1 lfo1'><![if !supportLists]><span
style='font-size:10.0pt;font-family:Symbol'><span style='mso-list:Ignore'>&middot;<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></span></span><![endif]>I believe my installation meets all the requirements
<o:p></o:p></p>

<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:72.0pt;text-indent:-18.0pt;mso-list:l0 level1 lfo1'><![if !supportLists]><span
style='font-size:10.0pt;font-family:Symbol'><span style='mso-list:Ignore'>&middot;<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></span></span><![endif]>On page 1 (DB Creation) I enter:&nbsp; <o:p></o:p></p>

<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:108.0pt;text-indent:-18.0pt;mso-list:l0 level2 lfo1'><![if !supportLists]><span
style='font-size:10.0pt;font-family:"Courier New"'><span style='mso-list:Ignore'>o<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp; </span></span></span><![endif]>host:
localhost <o:p></o:p></p>

<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:108.0pt;text-indent:-18.0pt;mso-list:l0 level2 lfo1'><![if !supportLists]><span
style='font-size:10.0pt;font-family:"Courier New"'><span style='mso-list:Ignore'>o<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp; </span></span></span><![endif]>user:&nbsp;
brucesne_bruce <o:p></o:p></p>

<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:108.0pt;text-indent:-18.0pt;mso-list:l0 level2 lfo1'><![if !supportLists]><span
style='font-size:10.0pt;font-family:"Courier New"'><span style='mso-list:Ignore'>o<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp; </span></span></span><![endif]>password:
[the correct password] <o:p></o:p></p>

<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:108.0pt;text-indent:-18.0pt;mso-list:l0 level2 lfo1'><![if !supportLists]><span
style='font-size:10.0pt;font-family:"Courier New"'><span style='mso-list:Ignore'>o<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp; </span></span></span><![endif]>db
name:&nbsp; brucesne_xerte <o:p></o:p></p>

<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:108.0pt;text-indent:-18.0pt;mso-list:l0 level2 lfo1'><![if !supportLists]><span
style='font-size:10.0pt;font-family:"Courier New"'><span style='mso-list:Ignore'>o<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp; </span></span></span><![endif]>prefix:&nbsp;
[left blank]<o:p></o:p></p>

<p class=MsoNormal style='margin-left:36.0pt'><span style='font-family:Symbol'>&middot;</span>&nbsp;
Page 2 says db successfully created.&nbsp; At this page I enter: <o:p></o:p></p>

<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:72.0pt;text-indent:-18.0pt;mso-list:l5 level1 lfo2'><![if !supportLists]><span
style='font-size:10.0pt;font-family:Symbol'><span style='mso-list:Ignore'>&middot;<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></span></span><![endif]>user: brucesne_bruce&nbsp;&nbsp; [in other
attempts I also tried just bruce] <o:p></o:p></p>

<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:72.0pt;text-indent:-18.0pt;mso-list:l5 level1 lfo2'><![if !supportLists]><span
style='font-size:10.0pt;font-family:Symbol'><span style='mso-list:Ignore'>&middot;<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></span></span><![endif]>pw:&nbsp; [the correct passsword]<o:p></o:p></p>

<p class=MsoNormal style='margin-left:36.0pt'><span style='font-family:Symbol'>&middot;</span>&nbsp;
On Page 3: <o:p></o:p></p>

<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:72.0pt;text-indent:-18.0pt;mso-list:l4 level1 lfo4'><![if !supportLists]><span
style='font-size:10.0pt;font-family:Symbol'><span style='mso-list:Ignore'>&middot;<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></span></span><![endif]>I leave all defaults except for admin user and
password.&nbsp; For this I use the same account for Cpanel login: <o:p></o:p></p>

<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:72.0pt;text-indent:-18.0pt;mso-list:l4 level1 lfo4'><![if !supportLists]><span
style='font-size:10.0pt;font-family:Symbol'><span style='mso-list:Ignore'>&middot;<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></span></span><![endif]>admin:&nbsp; brucesne <o:p></o:p></p>

<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:72.0pt;text-indent:-18.0pt;mso-list:l4 level1 lfo4'><![if !supportLists]><span
style='font-size:10.0pt;font-family:Symbol'><span style='mso-list:Ignore'>&middot;<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></span></span><![endif]>pw:&nbsp; correct password<o:p></o:p></p>

<div>

<p class=MsoNormal style='margin-left:36.0pt'>I get the dreaded &quot;No
Database Selected&quot; error.&nbsp; Here's an example:&nbsp;<o:p></o:p></p>

</div>

<div>

<p class=MsoNormal style='margin-left:36.0pt'><em>The sitedetails site ID query
insert into sitedetails(site_id) VALUES ( &quot;1&quot;) has failed due to No
database selected</em><i><br>
<em>The sitedetails site url query update sitedetails set site_url=&quot;<a
href="http://www.brucesnell.com/xerte/" target="_blank">http://www.brucesnell.com/xerte/</a>&quot;
where site_id=&quot;1&quot; has failed due to No database selected</em><br>
<em>The sitedetails apache query update sitedetails set
apache=&quot;false&quot; where site_id=&quot;1&quot; has failed due to No
database selected</em><br>
<em>The sitedetails apache query update sitedetails set
apache=&quot;false&quot; where site_id=&quot;1&quot; has failed due to No
database selected</em><br>
<em>The sitedetails mimetypes query update sitedetails set
mimetypes=&quot;text/xml,application/msword,application/x-shockwave-flash,image/jpeg,image/pjpeg,image/png,image/gif,image/x-png,audio/mpeg,application/vnd.ms-excel,application/pdf,application/vnd.ms-powerpoint,video/x-ms-wmv,text/html,video/mp4,video/avi,audio/wav,text/plain,video/quicktime&quot;
where site_id=&quot;1&quot; has failed due to No database selected</em></i><o:p></o:p></p>

</div>

<div>

<p class=MsoNormal style='margin-left:36.0pt'><em>[it goes on for quite a bit
longer.]</em><o:p></o:p></p>

</div>

<div>

<p class=MsoNormal style='margin-left:36.0pt'>&nbsp;&nbsp; <o:p></o:p></p>

</div>

<div>

<p class=MsoNormal style='margin-left:36.0pt'>I believe the security on the
folders is set correctly to 777.&nbsp; <o:p></o:p></p>

</div>

<div>

<p class=MsoNormal style='margin-left:36.0pt'>Database.php in the root of xerte
folder includes the following: <o:p></o:p></p>

</div>

<div>

<p class=MsoNormal style='margin-left:36.0pt'>&lt;?PHP /**<br>
* <br>
* database page, has the settings for database connection<br>
*<br>
* @author Patrick Lockley<br>
* @version 1.0<br>
* @copyright Copyright (c) 2008,2009 University of Nottingham<br>
* @package<br>
*/<o:p></o:p></p>

</div>

<div>

<p class=MsoNormal style='margin-left:36.0pt'>/*<br>
* Host where database is<br>
*/<br>
$xerte_toolkits_site-&gt;database_host = &quot;localhost&quot;;<o:p></o:p></p>

</div>

<div>

<p class=MsoNormal style='margin-left:36.0pt'>/*<br>
* Username for database<br>
*/<br>
$xerte_toolkits_site-&gt;database_username =&quot;brucesne_bruce&quot;;<o:p></o:p></p>

</div>

<div>

<p class=MsoNormal style='margin-left:36.0pt'>/*<br>
* Password for database<br>
*/<br>
$xerte_toolkits_site-&gt;database_password =&quot;[correct password]&quot;;<o:p></o:p></p>

</div>

<div>

<p class=MsoNormal style='margin-left:36.0pt'>/*<br>
* Database name<br>
*/<br>
$xerte_toolkits_site-&gt;database_name =&quot;xerte&quot;;<o:p></o:p></p>

</div>

<div>

<p class=MsoNormal style='margin-left:36.0pt'>/*<br>
* Database table prefix<br>
*/<br>
$xerte_toolkits_site-&gt;database_table_prefix =&quot;&quot;;<br>
?&gt;<o:p></o:p></p>

</div>

<div>

<p class=MsoNormal style='margin-left:36.0pt'>&nbsp;<o:p></o:p></p>

</div>

<div>

<p class=MsoNormal style='margin-left:36.0pt'>&nbsp;<o:p></o:p></p>

</div>

<div>

<p class=MsoNormal style='margin-left:36.0pt'>Can anyone lend a
hand?&nbsp;&nbsp; <o:p></o:p></p>

</div>

<div>

<p class=MsoNormal style='margin-left:36.0pt'>&nbsp;<o:p></o:p></p>

</div>

<div>

<p class=MsoNormal style='margin-left:36.0pt'>Thanks, <o:p></o:p></p>

</div>

<div>

<p class=MsoNormal style='margin-left:36.0pt'>&nbsp;<o:p></o:p></p>

</div>

<div>

<p class=MsoNormal style='margin-left:36.0pt'>Tom Sliker<o:p></o:p></p>

</div>

<div>

<p class=MsoNormal style='margin-left:36.0pt'>&nbsp;<o:p></o:p></p>

</div>

<div>

<p class=MsoNormal style='margin-left:36.0pt'>&nbsp;<o:p></o:p></p>

</div>

<div>

<p class=MsoNormal style='margin-left:36.0pt'>&nbsp;<o:p></o:p></p>

</div>

<div>

<p class=MsoNormal style='margin-left:36.0pt'><br clear=all>
<br>
-- <br>
Tom Sliker &nbsp; &nbsp;/ : \<br>
<a href="http://www.broadstreetconsulting.net/" target="_blank">www.BroadstreetConsulting.net</a><o:p></o:p></p>

</div>

</div>

</div>

</div>

</div>

<p class=MsoNormal style='mso-margin-top-alt:0cm;margin-right:0cm;margin-bottom:
12.0pt;margin-left:36.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>

<p class=MsoNormal style='margin-left:36.0pt'><br>
<br clear=all>
<br>
-- <br>
Tom Sliker &nbsp; &nbsp;/ : \<br>
<a href="http://www.broadstreetconsulting.net/">www.BroadstreetConsulting.net</a><o:p></o:p></p>

</div>

</div>

</body>

</html>