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

Sun Mar 7 22:18:45 GMT 2010

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.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.  

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 
Sent: Sunday, March 07, 2010 10:12 AM
To: 'Xerte discussion list' 
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. 

Hotmail: Trusted email with Microsoft’s powerful SPAM protection. Sign up now.  		 	   		  
_________________________________________________________________
Your E-mail and More On-the-Go. Get Windows Live Hotmail Free.
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/20100307/4d3de670/attachment.html