<HTML dir=ltr><HEAD>
<META http-equiv=Content-Type content="text/html; charset=unicode">
<META content="MSHTML 6.00.6001.18385" name=GENERATOR></HEAD>
<BODY>
<DIV id=idOWAReplyText16505 dir=ltr>
<DIV dir=ltr><FONT face=Arial color=#000000 size=2>Yeah, then it should work.</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>So it fails going from page 3 onto page 4? I'll make a debug tomorrow to see what happens.</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 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<BR></FONT><BR></DIV>
<DIV>
<DIV>I think so-- everything is on the same server. according to BlueHost /MY Sql screen: </DIV>
<DIV><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><BR></DIV>
<DIV>The attached screenshot shows the PHPMyAdmin screen, which seems to imply that is localhost. </DIV>
<DIV> </DIV>
<DIV>What do you think? </DIV>
<DIV> </DIV>
<DIV>TS<BR></DIV>
<DIV class=gmail_quote>On Sun, Jan 24, 2010 at 12:07 PM, Patrick Lockley <SPAN dir=ltr><<A href="mailto:Patrick.Lockley@nottingham.ac.uk">Patrick.Lockley@nottingham.ac.uk</A>></SPAN> wrote:<BR>
<BLOCKQUOTE class=gmail_quote style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<DIV>
<DIV dir=ltr>
<DIV dir=ltr><FONT face=Arial color=#000000 size=2>Is your host definitely localhost?</FONT></DIV></DIV>
<DIV dir=ltr><BR>
<HR>
<FONT face=Tahoma size=2><B>From:</B> <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<BR></FONT><BR></DIV>
<DIV>
<DIV></DIV>
<DIV class=h5>
<DIV>
<DIV>I'm getting errors when I get to Page 3 of the setup process for the Online Toolkit. </DIV>
<DIV> </DIV>
<DIV>Maybe the issues relate to my lack of knowledge of MySQL. I am hosting at BlueHost. </DIV>
<DIV> </DIV>
<DIV>Via CPanel I go to MySQL Databases and see there is a database with: </DIV>
<DIV>name: brucesne_xerte</DIV>
<DIV>users: brucesne_bruce and brucesne_xerte (both have ALL privileges)</DIV>
<DIV> </DIV>
<DIV>I've tried letting the wizard create the database and tried creating an empty one myself. For this attempt I have an empty database</DIV>
<DIV> </DIV>
<DIV>I run the Setup wizard at <A href="http://www.brucesnell.com/xerte/setup/" target=_blank>http://www.brucesnell.com/xerte/setup/</A> </DIV>
<UL>
<LI>I chose Full Install
<LI>I believe my installation meets all the requirements
<LI>On page 1 (DB Creation) I enter:
<UL>
<LI>host: localhost
<LI>user: brucesne_bruce
<LI>password: [the correct password]
<LI>db name: brucesne_xerte
<LI>prefix: [left blank]</LI></UL></LI></UL>
<LI>Page 2 says db successfully created. At this page I enter:
<UL>
<LI>user: brucesne_bruce [in other attempts I also tried just bruce]
<LI>pw: [the correct passsword]</LI></UL>
<UL></UL>
<LI>On Page 3:
<UL>
<LI>I leave all defaults except for admin user and password. For this I use the same account for Cpanel login:
<LI>admin: brucesne
<LI>pw: correct password</LI></UL>
<UL></UL>
<UL></UL>
<DIV>I get the dreaded "No Database Selected" error. Here's an example: </DIV>
<DIV><EM>The sitedetails site ID query insert into sitedetails(site_id) VALUES ( "1") has failed due to No database selected<BR>The sitedetails site url query update sitedetails set site_url="<A href="http://www.brucesnell.com/xerte/" target=_blank>http://www.brucesnell.com/xerte/</A>" where site_id="1" has failed due to No database selected<BR>The sitedetails apache query update sitedetails set apache="false" where site_id="1" has failed due to No database selected<BR>The sitedetails apache query update sitedetails set apache="false" where site_id="1" has failed due to No database selected<BR>The sitedetails mimetypes query update sitedetails set mimetypes="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" where site_id="1" has failed due to No database selected</EM></DIV>
<DIV><EM>[it goes on for quite a bit longer.]</EM><BR></DIV>
<DIV> </DIV>
<DIV>I believe the security on the folders is set correctly to 777. </DIV>
<DIV>Database.php in the root of xerte folder includes the following: </DIV>
<DIV><?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>*/</DIV>
<DIV>/*<BR>* Host where database is<BR>*/<BR>$xerte_toolkits_site->database_host = "localhost";</DIV>
<DIV>/*<BR>* Username for database<BR>*/<BR>$xerte_toolkits_site->database_username ="brucesne_bruce";</DIV>
<DIV>/*<BR>* Password for database<BR>*/<BR>$xerte_toolkits_site->database_password ="[correct password]";</DIV>
<DIV>/*<BR>* Database name<BR>*/<BR>$xerte_toolkits_site->database_name ="xerte";</DIV>
<DIV>/*<BR>* Database table prefix<BR>*/<BR>$xerte_toolkits_site->database_table_prefix ="";<BR>?></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>Can anyone lend a hand? </DIV>
<DIV> </DIV>
<DIV>Thanks, </DIV>
<DIV> </DIV>
<DIV>Tom Sliker</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><BR clear=all><BR>-- <BR>Tom Sliker / : \<BR><A href="http://www.broadstreetconsulting.net/" target=_blank>www.BroadstreetConsulting.net</A><BR></DIV></LI></DIV></DIV></DIV></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><BR><BR clear=all><BR>-- <BR>Tom Sliker / : \<BR><A href="http://www.broadstreetconsulting.net/">www.BroadstreetConsulting.net</A><BR></DIV></BODY></HTML>