[Xerte] Xerte Online Toolkit - Setup Errors

[Patrick Lockley]

Swap the mysql_db_select on   line 17 of page4.php for this

 

if(!mysql_select_db($xerte_toolkits_site->database_name,
$mysql_connect_id)){

                

                                echo "Cannot select the database<br>";

                                

                                echo mysql_errno($mysql_connect_id) . ":
" . mysql_error($mysql_connect_id) . "\n";

                                

                                die();

 

                

                }

 

From: xerte-bounces at lists.nottingham.ac.uk
[mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Patrick
Lockley
Sent: 25 January 2010 00:20
To: Xerte discussion list
Subject: RE: [Xerte] Xerte Online Toolkit - Setup Errors

 

Yeah, then it should work.

 

So it fails going from page 3 onto page 4? I'll make a debug tomorrow to
see what happens.

 

________________________________

From: xerte-bounces at lists.nottingham.ac.uk on behalf of Tom Sliker
Sent: Sun 24/01/2010 18:12
To: Xerte discussion list
Subject: Re: [Xerte] Xerte Online Toolkit - Setup Errors

I think so-- everything is on the same server.  according to BlueHost
/MY Sql screen: 

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
box257.bluehost.com <http://box257.bluehost.com/> . 

The attached screenshot shows the PHPMyAdmin screen, which seems to
imply that is localhost.  

 

What do you think? 

 

TS

On Sun, Jan 24, 2010 at 12:07 PM, Patrick Lockley
<Patrick.Lockley at nottingham.ac.uk> wrote:

Is your host definitely localhost?

 

________________________________

From: xerte-bounces at lists.nottingham.ac.uk on behalf of Tom Sliker
Sent: Sun 24/01/2010 13:35
To: xerte at lists.nottingham.ac.uk
Subject: [Xerte] Xerte Online Toolkit - Setup Errors

I'm getting errors when I get to Page 3 of the setup process for the
Online Toolkit. 

 

Maybe the issues relate to my lack of knowledge of MySQL.  I am hosting
at BlueHost. 

 

Via CPanel I go to MySQL Databases and see there is a database with: 

name: brucesne_xerte

users:  brucesne_bruce and brucesne_xerte  (both have ALL privileges)

 

I've tried letting the wizard create the database and tried creating an
empty one myself.  For this attempt I have an empty database

 

I run the Setup wizard at http://www.brucesnell.com/xerte/setup/ 

*         I chose Full Install 

*         I believe my installation meets all the requirements 

*         On page 1 (DB Creation) I enter:  

o    host: localhost 

o    user:  brucesne_bruce 

o    password: [the correct password] 

o    db name:  brucesne_xerte 

o    prefix:  [left blank]

*  Page 2 says db successfully created.  At this page I enter: 

*         user: brucesne_bruce   [in other attempts I also tried just
bruce] 

*         pw:  [the correct passsword]

*  On Page 3: 

*         I leave all defaults except for admin user and password.  For
this I use the same account for Cpanel login: 

*         admin:  brucesne 

*         pw:  correct password

I get the dreaded "No Database Selected" error.  Here's an example: 

The sitedetails site ID query insert into sitedetails(site_id) VALUES (
"1") has failed due to No database selected
The sitedetails site url query update sitedetails set
site_url="http://www.brucesnell.com/xerte/" where site_id="1" has failed
due to No database selected
The sitedetails apache query update sitedetails set apache="false" where
site_id="1" has failed due to No database selected
The sitedetails apache query update sitedetails set apache="false" where
site_id="1" has failed due to No database selected
The sitedetails mimetypes query update sitedetails set
mimetypes="text/xml,application/msword,application/x-shockwave-flash,ima
ge/jpeg,image/pjpeg,image/png,image/gif,image/x-png,audio/mpeg,applicati
on/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

[it goes on for quite a bit longer.]

   

I believe the security on the folders is set correctly to 777.  

Database.php in the root of xerte folder includes the following: 

<?PHP /**
* 
* database page, has the settings for database connection
*
* @author Patrick Lockley
* @version 1.0
* @copyright Copyright (c) 2008,2009 University of Nottingham
* @package
*/

/*
* Host where database is
*/
$xerte_toolkits_site->database_host = "localhost";

/*
* Username for database
*/
$xerte_toolkits_site->database_username ="brucesne_bruce";

/*
* Password for database
*/
$xerte_toolkits_site->database_password ="[correct password]";

/*
* Database name
*/
$xerte_toolkits_site->database_name ="xerte";

/*
* Database table prefix
*/
$xerte_toolkits_site->database_table_prefix ="";
?>

 

 

Can anyone lend a hand?   

 

Thanks, 

 

Tom Sliker

 

 

 



-- 
Tom Sliker    / : \
www.BroadstreetConsulting.net <http://www.broadstreetconsulting.net/> 


_______________________________________________
Xerte mailing list
Xerte at lists.nottingham.ac.uk
http://lists.nottingham.ac.uk/mailman/listinfo/xerte




-- 
Tom Sliker    / : \
www.BroadstreetConsulting.net <http://www.broadstreetconsulting.net/> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.nottingham.ac.uk/pipermail/xerte/attachments/20100125/3f2e12cb/attachment.html