<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=idOWAReplyText99849 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 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 13:35<BR><B>To:</B> xerte@lists.nottingham.ac.uk<BR><B>Subject:</B> [Xerte] Xerte Online Toolkit - Setup Errors<BR></FONT><BR></DIV>
<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/">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>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>
<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></LI></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/">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/">www.BroadstreetConsulting.net</A><BR></DIV></DIV></BODY></HTML>