[Xerte] Full install failing on page 4: No database selected

Patrick Lockley Patrick.Lockley at nottingham.ac.uk
Mon Mar 8 12:51:57 GMT 2010


It doesn't trigger here.

 

Maybe do an alert in the open and close functions to see what is
defined?

 

From: xerte-bounces at lists.nottingham.ac.uk
[mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Steve
Ricketts
Sent: 08 March 2010 12:35
To: Xerte discussion list
Subject: RE: [Xerte] Full install failing on page 4: No database
selected

 

System 1 - Windows Vista, IIS 7
 
I have the debugger active in the browser that opens any time there is a
JS error and didn't see any errors upon open or in the status window.
The debugger kicks up when the edit window is closed.  Anything else I
can check for while I'm in the debug mode?
 
sr
 

________________________________

Subject: RE: [Xerte] Full install failing on page 4: No database
selected
Date: Mon, 8 Mar 2010 10:48:40 +0000
From: Patrick.Lockley at nottingham.ac.uk
To: xerte at lists.nottingham.ac.uk

We don't get a JS error here?

 

Maybe there was a JS error before you opened the editor window which
would stop window_reference being defined?

 

From: xerte-bounces at lists.nottingham.ac.uk
[mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Steve
Ricketts
Sent: 07 March 2010 22:19
To: Xerte discussion list
Subject: RE: [Xerte] Full install failing on page 4: No database
selected

 

Makes a ton of difference!  Things working much better.
 
The only thing that's still hanging around is a JS error when you exit
edit.php.
 
Line: 30
Error: 'window_reference' is undefined
 
function bunload(){
path = "5-guest-Nottingham/";
window_reference.edit_window_close(path);  <-- error here
}

 

________________________________

Subject: RE: [Xerte] Full install failing on page 4: No database
selected
Date: Sun, 7 Mar 2010 22:00:44 +0000
From: Patrick.Lockley at nottingham.ac.uk
To: xerte at lists.nottingham.ac.uk

i don't think it cannot write, more it doesn't know where to write to.

 

If ''c:\inetpub\wwwroot\xertetoolkits\' isn't set as the root_file_path
in the install script on page 4 of the installer, then no file writing
will occur.

 

Set that in the database (sitedetails table), then try again.

 

________________________________

From: xerte-bounces at lists.nottingham.ac.uk on behalf of Steve Ricketts
Sent: Sun 07/03/2010 21:51
To: Xerte discussion list
Subject: RE: [Xerte] Full install failing on page 4: No database
selected

Ah, sorry... I was one e-mail off... In regard to the errors on page 4,
that was resolved when I put the database name in database.php.  It was
after that, the sitedetails table was populated.  You know, the strange
thing was that the host name, user, and password were there, just no
database name.
 
I've never used fiddler, but I downloaded it and ran edit.php... not
sure what it means but I did get a red line, can't find the following
file:
 
MailScanner has detected a possible fraud attempt from "learnnet"
claiming to be
http://learnnet:80/xertetoolkits/USER-FILES/1-guest-Nottingham/preview.x
ml?myvar=1267992069172
<http://learnnet/xertetoolkits/USER-FILES/1-guest-Nottingham/preview.xml
?myvar=1267992069172>  
 
Nothing is in that directory so makes sense but wondering why it can't
write to that directory.  NTFS permissions have been set to full access
for Everyone, Network Services, and IUSR just to make sure.
 
sr
 

________________________________

Subject: RE: [Xerte] Full install failing on page 4: No database
selected
Date: Sun, 7 Mar 2010 19:10:17 +0000
From: Patrick.Lockley at nottingham.ac.uk
To: xerte at lists.nottingham.ac.uk

Your later paragraphs may well reflect the fact your sitedetails table
is basically empty, as your setup failed.

SR: Actually, no.  The sitedetails table is full of entries.  It was the
php_library_path field that I thought might have been incorrect... turns
out, it wasn't!.. so I put it back.

 

Well, all page 4 of the installer does is populate this table. So to get
errors - the table wouldn't be populated?

 

Switching from index to demo will not really achieve anything other than
removing the requirement for LDAP.

SR: Yep, that's what I was going for.  The developers will enter through
our LMS and as such will have already been authenticated.

 

Then ignore demo, and use integration.txt

 

Locked buttons - in the editor window? that's usually mimetypes, I would
put fiddler on your pc, and see if the xwd is being loaded. I'd expect
to see it appear in red.

 

 

________________________________

From: xerte-bounces at lists.nottingham.ac.uk on behalf of Steve Ricketts
Sent: Sun 07/03/2010 16:35
To: Xerte discussion list
Subject: Re: [Xerte] Full install failing on page 4: No database
selected

Amazing!!  Just like magic, thanks!  For some reason the database name
was blank in database.php.  Switched demo.txt to index.php.  Works fine
now... the setup that is.   Sad smile emoticon<http://> 

 

Thought I was home free, but tried to create a project.  That went fine.
Tried to edit... that didn't.  Got a 500 error.  Checked properties of
that project.  Got a JS error yelling about properties_ajax_php_path
being undefined.  Tried edit again... no 500 error but display basically
locked.   Not "locked" locked, just the buttons didn't to anything.
Exited the window, go another JS error: on line 30,
window_reference.edit_window_close_path(path)

 

Figured I had something wrong in the php path, took your #3 suggestion,
and found php_library_path field in sitedetails table set to
website_code/PHP/... thought I missed a config parameter and changed it
to where my PHP install physically resides (c:\program files
(x86)\PHP\)... not a good thing to do!  Nothing worked.  Decided I
didn't know what the H I'm doing and better post before I destroy more. 

 

sr

 

PS.  php_library_path returned to normal.

 

From: RonM <mailto:ronm at mitchellmedia.co.uk>  

Sent: Sunday, March 07, 2010 10:12 AM

To: 'Xerte discussion list' <mailto:xerte at lists.nottingham.ac.uk>  

Subject: RE: [Xerte] Full install failing on page 4: No database
selected

 

Hi Steve

I've had this kind of problem on windows/IIS installations too. So a
couple of suggestions but from memory...

 

1.       Try the installation again but before you submit page3 to page
4 check database.php which should be created automatically in the root
of your install but may not have all the correct values. If it doesn't
edit that so that it does and then submit page 3 to page 4.

2.       If that all works remember that if you haven't used ldap you
will need to rename index.php and either use switch.txt or demo.txt
renamed to index.php

3.       If steps 2 & 3 don't work check the site details table for
errors if some of the paths are incorrect try fixing those in the
database.

 

Pat may have other suggestions but try this and post back to the list.

HTH

Ron

 

From: xerte-bounces at lists.nottingham.ac.uk
[mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Steve
Ricketts
Sent: 07 March 2010 14:41
To: Xerte discussion list
Subject: [Xerte] Full install failing on page 4: No database selected

 

I'm trying a new full install on Windows Vista with IIS.  It creates the
database fine but when I get to the 4th page there are a ton of errors
all ending with no database selected.  I've changed the
setup/database.txt file to reflect the current installation (found that
in post) but there is no change in the errors.  I basically left the
mysql information on page3.php alone.  Can anyone help me to the next
step?


Thanks,

 

sr

 

PS. Regarding the discussion of forum vs. e-mail, as a newcomer the
response of the e-mail replies is terrific and very helpful.  However,
what I really would like is a way to easily look back at a threaded
discussion on a specific issue... I have many I need to chase and am
reluctant to ask questions about every silly thing that pops into my
head.   Today, I used the newly reference search function to find some
information on the problem mentioned above, but it was very difficult to
follow.  There are multiple topics in the threads and it's easy to loose
your way... I'm not sure I found all the references.

 

Is there no way to have your cake and eat it too... (then again what's
the purpose of having the cake in the first place!) where you can e-mail
each post in a forum to the mailing list?   You could have your forum
topic areas and those that wanted to follow that route could deal with a
regular forum (sub topics, search threads, etc.) and the mailing list
people still get to receive each post in their e-mail.

________________________________


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

 

________________________________

Hotmail: Trusted email with powerful SPAM protection. Sign up now.
<http://clk.atdmt.com/GBL/go/201469227/direct/01/>  

 

________________________________

Hotmail: Trusted email with Microsoft's powerful SPAM protection. Sign
up now. <http://clk.atdmt.com/GBL/go/201469226/direct/01/>  

 

________________________________

Your E-mail and More On-the-Go. Get Windows Live Hotmail Free. Sign up
now. <http://clk.atdmt.com/GBL/go/201469229/direct/01/> 

 

________________________________

Your E-mail and More On-the-Go. Get Windows Live Hotmail Free. Sign up
now. <http://clk.atdmt.com/GBL/go/201469229/direct/01/> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.nottingham.ac.uk/pipermail/xerte/attachments/20100308/243fcc9c/attachment.html


More information about the Xerte mailing list