[Xerte] Full install failing on page 4: System #2

Wed Mar 10 15:30:33 GMT 2010

Don't I feel dumb... ok, spelling corrected and it works like it should.  Echoing at the top of integration.php. 

sr

From: Patrick Lockley 
Sent: Wednesday, March 10, 2010 10:06 AM
To: Xerte discussion list 
Subject: RE: [Xerte] Full install failing on page 4: System #2

no it looks like i spelt response wrong

query_repsonse 

where do you echo the session?

--------------------------------------------------------------------------------
From: xerte-bounces at lists.nottingham.ac.uk on behalf of Steve Ricketts
Sent: Wed 10/03/2010 14:48
To: Xerte discussion list
Subject: Re: [Xerte] Full install failing on page 4: System #2

I thought the typo you referred to was: if($query_response===false) {  and changed === to ==

Session variables look ok except creator_id which is ""... that doesn't look right

Yes, this is using integration.php.  I echoed the $_SESSION['toolkits_username, firstname, surname] and they all look correct.  The cooresponding values are in logindetails.

The receiving garbage is what I'm thinking too... back to the database errors on the initial install that showed up on page4.php.  Was there anything in sitedetails (below) that looks out of place?  I thought the "'c:\inetpub\wwwroot\xertetoolkits\'" might be causing problems with the "\" so I changed those to "/" but no difference.

sr

From: Patrick Lockley 
Sent: Wednesday, March 10, 2010 8:37 AM
To: Xerte discussion list 
Subject: RE: [Xerte] Full install failing on page 4: System #2

it says there is still an error on line 21

most of those are session variables right?

Is this using integration.php?

the errors are coming back as the javascript is reliant on the right result coming back on the ajax query. If it receives garbage it'll fail.

--------------------------------------------------------------------------------
From: xerte-bounces at lists.nottingham.ac.uk on behalf of Steve Ricketts
Sent: Wed 10/03/2010 13:21
To: Xerte discussion list
Subject: RE: [Xerte] Full install failing on page 4: System #2

Fixed line 21 and got a slew of new errors:

>>xmlHttp.responseText
"<br />
<b>Notice</b>: Undefined index: toolkits_logon_username in <b>C:\Inetpub\wwwroot\XerteToolkits\website_code\php\database_library.php</b> on line <b>57</b><br />
<br />
<b>Notice</b>: Undefined index: toolkits_logon_id in <b>C:\Inetpub\wwwroot\XerteToolkits\website_code\php\user_library.php</b> on line <b>238</b><br />
<br />
<b>Notice</b>: Undefined index: toolkits_logon_username in <b>C:\Inetpub\wwwroot\XerteToolkits\website_code\php\user_library.php</b> on line <b>238</b><br />
<br />
<b>Notice</b>: Undefined variable: query_repsonse in <b>C:\Inetpub\wwwroot\XerteToolkits\website_code\php\template_library.php</b> on line <b>21</b><br />
<br />
<b>Notice</b>: Undefined index: toolkits_logon_username in <b>C:\Inetpub\wwwroot\XerteToolkits\website_code\php\template_library.php</b> on line <b>23</b><br />
<br />
<b>Notice</b>: Undefined index: toolkits_logon_id in <b>C:\Inetpub\wwwroot\XerteToolkits\website_code\php\user_library.php</b> on line <b>238</b><br />
<br />
<b>Notice</b>: Undefined index: toolkits_logon_username in <b>C:\Inetpub\wwwroot\XerteToolkits\website_code\php\user_library.php</b> on line <b>238</b><br />
<br />
<b>Notice</b>: Undefined index: toolkits_logon_id in <b>C:\Inetpub\wwwroot\XerteToolkits\website_code\php\templates\new_template.php</b> on line <b>46</b><br />
<br />
<b>Notice</b>: Undefined index: toolkits_logon_username in <b>C:\Inetpub\wwwroot\XerteToolkits\website_code\php\templates\new_template.php</b> on line <b>72</b><br />
FAILED-Failed to create new template record for the database INSERT INTO templatedetails (template_id, creator_id, template_type_id, date_created, date_modified, access_to_whom, template_name) VALUES ("1","", "5","2010-03-10","2010-03-10","Private","Onemore")"

One of the things I'm not understanding is why so many JS and other errors on this Windows system and not my other Windows install?  JS errors are JS errors no matter what they are on.  Only difference may be what comes out of the database and I'll refer back to the errors on install earlier in this thread.  I dont' know what they mean, but I didn't get those in my other Windows install.  Thoughts?

sr

--------------------------------------------------------------------------------
Subject: RE: [Xerte] Full install failing on page 4: System #2
Date: Tue, 9 Mar 2010 18:49:56 +0000
From: Patrick.Lockley at nottingham.ac.uk
To: xerte at lists.nottingham.ac.uk; xerte at lists.nottingham.ac.uk

looks like a typo in template_library.php on line 21?

--------------------------------------------------------------------------------
From: xerte-bounces at lists.nottingham.ac.uk on behalf of Steve Ricketts
Sent: Tue 09/03/2010 17:22
To: Xerte discussion list
Subject: RE: [Xerte] Full install failing on page 4: System #2

Added mime type .rlm, text/xml, and got the main body to show.  Thought I'd live dangerously and send username, first, and last to integration.php (changed from txt) and replace the variables with the querystring variables:

$_SESSION['toolkits_firstname'] = $_GET['PF'];

$_SESSION['toolkits_surname'] = $_GET['PL'];
$_SESSION['toolkits_logon_username'] = $_GET['PK'];

Got an error that it couldn't find $_SESSION['toolkits_logon_username'] so I moved the setting of the variable up before the references to:

include $xerte_toolkits_site->php_library_path . "database_library.php";
include $xerte_toolkits_site->php_library_path . "user_library.php";

And that seemed to work (no more error).  I looked at the database and have the proper information in logindetails.

However, when I went to create a project, I get a JS error on line 1183 of the function tutorial_created() 

var neweditorwindow = window.open(site_url + url_return("edit" , xmlHttp.responseText), "editwindow" + xmlHttp.responseText, "height=665, width=800" );

xmlHttp.responseText contains:

Notice:  Undefined variable: query_repsonse in C:\Inetpub\wwwroot\XerteToolkits\website_code\php\template_library.php on line 21

No project are shown as having been created, even if I get out and back in.  But if I go back to using index.php, the newly created projects are showing.

sr

--------------------------------------------------------------------------------
Subject: RE: [Xerte] Full install failing on page 4: System #2
Date: Tue, 9 Mar 2010 15:45:06 +0000
From: Patrick.Lockley at nottingham.ac.uk
To: xerte at lists.nottingham.ac.uk

Sounds like a mimetype, possibly on the rlms?

Fiddler should show you a failed load.

From: xerte-bounces at lists.nottingham.ac.uk [mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Steve Ricketts
Sent: 09 March 2010 13:06
To: Xerte discussion list
Subject: RE: [Xerte] Full install failing on page 4: System #2

Yep, that would have been better! ;-)   So, I set $link_id = null in the else clause and the preview loads the project and displays it... mostly.  It displays the title and number of pages correctly, but the main display portion of the page is blank regardless of the type of component I've used (ie. title page, text, orientation, graphic, etc.).  Mime type??

sr

--------------------------------------------------------------------------------

Subject: RE: [Xerte] Full install failing on page 4: System #2
Date: Tue, 9 Mar 2010 12:29:06 +0000
From: Patrick.Lockley at nottingham.ac.uk
To: xerte at lists.nottingham.ac.uk

Which if? Ah ok

I was think you'd do this on the if

If(isset($_GET['linkID'])){

                $link_id = $_GET['linkID'];

}else{

                $link_id = null;

}

From: xerte-bounces at lists.nottingham.ac.uk [mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Steve Ricketts
Sent: 09 March 2010 12:22
To: Xerte discussion list
Subject: RE: [Xerte] Full install failing on page 4: System #2

Ok, mime type changed to text/xml.  No flash on right click... However, I put the new rloObject inside the if statement so it wouldn't be executed if the "if" fails.  Otherwise, I get a javascript error.  The output below is the view source when the rloObject is placed outside the if statement.  The JS error obviously comes from the error notification being inside the <script> tags.

<!-- 

University of Nottingham Xerte Online Toolkits

HTML to use at the top of the Xerte preview and play windows
Version 1.0

-->

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html style="width:100%; height:100%; min-height:100%;">
<head>
<title>Interactive Learning Content</title>
<script type="text/javascript"> 
function enableTTS(){
  if (navigator.appName.indexOf("Microsoft") != -1){
    VoiceObj = new ActiveXObject("Sapi.SpVoice");
  }
}
</script>

<script type="text/javascript" src = "rloObject.js"></script>
</head>

<body style="margin:0; width:100%; height:100%; min-height:100%;">

<!--<div style="margin:0px auto;">-->

<div style="min-height:100%; width:100%; height:100%;">

<script type="text/javascript" language="JavaScript">
<b>Notice</b>:  Undefined variable: link_id in <b>C:\Inetpub\wwwroot\XerteToolkits\modules\xerte\preview.php</b> on line <b>53</b><br />
myRLO = new rloObject('800','600','modules/xerte/parent_templates/Nottingham/Nottingham.rlt','USER-FILES/2-guest-Nottingham/', 'USER-FILES/2-guest-Nottingham/preview.xml?time=1268136698', 'http://www.cade-etutor.com/xertetoolkits/' , '')
</script></div></body></html>

--------------------------------------------------------------------------------

Subject: RE: [Xerte] Full install failing on page 4: System #2
Date: Tue, 9 Mar 2010 12:03:16 +0000
From: Patrick.Lockley at nottingham.ac.uk
To: xerte at lists.nottingham.ac.uk

Ok, so no flash loader screen, if you right click do you get flash?

Is there any source code if you do view source?

We usually set xwd to be served as xml?

From: xerte-bounces at lists.nottingham.ac.uk [mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Steve Ricketts
Sent: 09 March 2010 12:01
To: Xerte discussion list
Subject: RE: [Xerte] Full install failing on page 4: System #2

LOL... Michigan has winter!!  Moved here from Scottsdale, AZ!.. Weybridge, Surrey before that!

By no preview, the preview.php window opens.  With the "isSet" code in place, it just is a blank window.  The "else" clause in the if(isSet block is executed (I put an alert in there).

No red or anything I can tell is "bad" in Fiddler.  Installed the mime type .xwd as application/x-xwd (also image/x-xwindowdump).  Would the Fiddler output be helpful?

sr

--------------------------------------------------------------------------------

Subject: RE: [Xerte] Full install failing on page 4: System #2
Date: Tue, 9 Mar 2010 00:09:49 +0000
From: Patrick.Lockley at nottingham.ac.uk
To: xerte at lists.nottingham.ac.uk

Michigan's not too bad.

Let me know what you mean by no preview?

any red in fiddler?

you might need xwd mime type as well

--------------------------------------------------------------------------------

From: xerte-bounces at lists.nottingham.ac.uk on behalf of Steve Ricketts
Sent: Mon 08/03/2010 21:32
To: Xerte discussion list
Subject: RE: [Xerte] Full install failing on page 4: System #2

Ok, that took the error out of line 47 and the else clause is executed.  But we don't have a preview. Checked mime types and they are in as:

.rlo = flv-application/octet-stream
.rlt = text/xml

printed the following just to see if it meant anything to you:

myRLO = new rloObject('800','600','modules/xerte/parent_templates/Nottingham/Nottingham.rlt','USER-FILES/2-guest-Nottingham/', 'USER-FILES/2-guest-Nottingham/preview.xml?time=1268082184', 'http://www.cade-etutor.com/xertetoolkits/' , '')

Just for fun, I copied the preview.php from my other system and got the same results.  

Can't help but think there is something in the database so here's a copy of sitedetails:

1, 'http://www.cade-etutor.com/xertetoolkits/', 'false', '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,application/vnd.openxmlformats-officedocument.spreadsheetml.sheet,application/vnd.openxmlformats-officedocument.wordprocessingml.document,application/vnd.openxmlformats-officedocument.presentationml.presentation', 'XERTE_TOOLKITS', 'sAMAccountName', 'cn=', '', 'admin', 'password', 'Welcome to Xerte Online Toolkits', 'Xerte Online Toolkits', 'website_code/images/xerteLogo.jpg', 'website_code/images/UofNLogo.jpg', 'Welcome to Xerte online toolkits', 'Welcome to the toolkits front page, developed by the University of Nottingham', 'PHAgY2xhc3M9Im5ld3NfdGl0bGUiPk90aGVyIHJlc291cmNlczwvcD48cCBjbGFzcz0ibmV3c19zdG9yeSI+PGEgaHJlZj0iIj5TaXRlIDE8L2E+PC9wPjxwIGNsYXNzPSJuZXdzX3N0b3J5Ij48YSBocmVmPSIiPlNpdGUgMjwvYT48L3A+PHAgY2xhc3M9Im5ld3Nfc3RvcnkiPjxhIGhyZWY9IiI+U2l0ZSAzPC9hPjwvcD4=', 'PHAgY2xhc3M9Im5ld3NfdGl0bGUiPkhvdyB0bzwvcD48cCBjbGFzcz0iZGVtbyI+PGEgaHJlZj0iamF2YXNjcmlwdDphbGVydCgnU29ycnkuIFRoaXMgaXMgbm90IHlldCBhdmFpbGFibGUnKSI+MzAgU2Vjb25kIERlbW88L2E+PGJyIC8+QSB2ZXJ5IHNob3J0IGNhcHRpdmF0ZSBmaWxlIHNob3dpbmcgYSBzaW1wbGUgcHJvamVjdCBiZWluZyBzdGFydGVkLCBidWlsdCBhbmQgcHVibGlzaGVkIGZvciB0aGUgd2ViLjwvcD48cCBjbGFzcz0iZGVtbyI+PGEgaHJlZj0iamF2YXNjcmlwdDphbGVydCgnU29ycnkuIFRoaXMgaXMgbm90IHlldCBhdmFpbGFibGUnKSI+TGVhcm5pbmcgT2JqZWN0IERlbW88L2E+PGJyIC8+QSB2ZXJ5IHNpbXBsZSBkZW1vIG9mIGEgbGVhcm5pbmcgb2JqZWN0LjwvcD4=', 'PHAgY2xhc3M9Im5ld3NfdGl0bGUiPldhbnQgdG8gc2hhcmUgc29tZSB0aG91Z2h0cz88L3A+PHAgY2xhc3M9ImdlbmVyYWwiPklmIHlvdSBoYXZlIGFueSBxdWVzdGlvbnMsIHJlcXVlc3RzIGZvciBoZWxwLCBpZGVhcyBmb3IgbmV3IHByb2plY3RzIG9yIHByb2JsZW1zIHRvIHJlcG9ydCwgdGhlbiBwbGVhc2UgZ2V0IGluIHRvdWNoLjwvcD48cCBjbGFzcz0iZ2VuZXJhbCI+UGxlYXNlIHVzZSBvdXIgPGEgaHJlZj0iZmVlZGJhY2svIiBzdHlsZT0iY29sb3I6IzAwMCI+RmVlZGJhY2sgRm9ybTwvYT48L3A+', '© Copyright University of Nottingham 2008', 'Xerte Online Toolkits RSS Feed', 'Put your institution's name here', 'Licensed under a Creative Commons Attribution - NonCommercial-ShareAlike 2.0 Licence - see http://creativecommons.org/licenses/by-nc-sa/2.0/uk/', 'Licensed under a Creative Commons Attribution - NonCommercial-ShareAlike 2.0 Licence - see http://creativecommons.org/licenses/by-nc-sa/2.0/uk/', 'modules/xerte/training/toolkits.htm', 'PGh0bWw+PGJvZHk+PGNlbnRlcj48cD48Zm9ybSBtZXRob2Q9InBvc3QiIGFjdGlvbj0iIj48cD5Vc2VybmFtZSA8aW5wdXQgdHlwZT0idGV4dCIgc2l6ZT0iMjAiIG1heGxlbmd0aD0iMTIiIG5hbWU9ImxvZ2luIiAvPjwvcD48cD5QYXNzd29yZCA8aW5wdXQgdHlwZT0icGFzc3dvcmQiIHNpemU9IjIwIiBtYXhsZW5ndGg9IjM2IiBuYW1lPSJwYXNzd29yZCIgLz48L3A+PHA+PGlucHV0IHR5cGU9ImltYWdlIiBzcmM9IndlYnNpdGVfY29kZS9pbWFnZXMvQnR0bl9Mb2dpbk9mZi5naWYiIG9ubW91c2VvdmVyPSJ0aGlzLnNyYz0nd2Vic2l0ZV9jb2RlL2ltYWdlcy9CdHRuX0xvZ2luT24uZ2lmJyIgb25tb3VzZWRvd249InRoaXMuc3JjPSd3ZWJzaXRlX2NvZGUvaW1hZ2VzL0J0dG5fTG9naW5DbGljay5naWYnIiBvbm1vdXNlb3V0PSJ0aGlzLnNyYz0nd2Vic2l0ZV9jb2RlL2ltYWdlcy9CdHRuX0xvZ2luT2ZmLmdpZiciIC8+PC9wPg==', 'PGh0bWw+PGJvZHk+PGNlbnRlcj48cD48Zm9ybSBtZXRob2Q9InBvc3QiIGFjdGlvbj0iIj48cD5QYXNzd29yZCA8aW5wdXQgdHlwZT0icGFzc3dvcmQiIHNpemU9IjIwIiBtYXhsZW5ndGg9IjM2IiBuYW1lPSJwYXNzd29yZCIgLz48L3A+PHA+PGlucHV0IHR5cGU9ImltYWdlIiBzcmM9IndlYnNpdGVfY29kZS9pbWFnZXMvQnR0bl9Mb2dpbk9mZi5naWYiIG9ubW91c2VvdmVyPSJ0aGlzLnNyYz0nd2Vic2l0ZV9jb2RlL2ltYWdlcy9CdHRuX0xvZ2luT24uZ2lmJyIgb25tb3VzZWRvd249InRoaXMuc3JjPSd3ZWJzaXRlX2NvZGUvaW1hZ2VzL0J0dG5fTG9naW5DbGljay5naWYnIiBvbm1vdXNlb3V0PSJ0aGlzLnNyYz0nd2Vic2l0ZV9jb2RlL2ltYWdlcy9CdHRuX0xvZ2luT2ZmLmdpZiciIC8+PC9wPg==', 'modules/', 'website_code/', 'USER-FILES/', 'website_code/php/', 'c:/inetpub/wwwroot/xertetoolkits/import/', 'c:\inetpub\wwwroot\xertetoolkits\', 'c2VsZWN0ICIgLiAkeGVydGVfdG9vbGtpdHNfc2l0ZS0+ZGF0YWJhc2VfdGFibGVfcHJlZml4IC4gIm9yaWdpbmFsdGVtcGxhdGVzZGV0YWlscy50ZW1wbGF0ZV9uYW1lLCAiIC4gJHhlcnRlX3Rvb2xraXRzX3NpdGUtPmRhdGFiYXNlX3RhYmxlX3ByZWZpeCAuICJsb2dpbmRldGFpbHMudXNlcm5hbWUsICIgLiAkeGVydGVfdG9vbGtpdHNfc2l0ZS0+ZGF0YWJhc2VfdGFibGVfcHJlZml4IC4gIm9yaWdpbmFsdGVtcGxhdGVzZGV0YWlscy50ZW1wbGF0ZV9mcmFtZXdvcmssICIgLiAkeGVydGVfdG9vbGtpdHNfc2l0ZS0+ZGF0YWJhc2VfdGFibGVfcHJlZml4IC4gInRlbXBsYXRlcmlnaHRzLnVzZXJfaWQsICIgLiAkeGVydGVfdG9vbGtpdHNfc2l0ZS0+ZGF0YWJhc2VfdGFibGVfcHJlZml4IC4gInRlbXBsYXRlcmlnaHRzLmZvbGRlciwgIiAuICR4ZXJ0ZV90b29sa2l0c19zaXRlLT5kYXRhYmFzZV90YWJsZV9wcmVmaXggLiAidGVtcGxhdGVyaWdodHMudGVtcGxhdGVfaWQsICIgLiAkeGVydGVfdG9vbGtpdHNfc2l0ZS0+ZGF0YWJhc2VfdGFibGVfcHJlZml4IC4gInRlbXBsYXRlZGV0YWlscy5hY2Nlc3NfdG9fd2hvbSBmcm9tICIgLiAkeGVydGVfdG9vbGtpdHNfc2l0ZS0+ZGF0YWJhc2VfdGFibGVfcHJlZml4IC4gIm9yaWdpbmFsdGVtcGxhdGVzZGV0YWlscywgIiAuICR4ZXJ0ZV90b29sa2l0c19zaXRlLT5kYXRhYmFzZV90YWJsZV9wcmVmaXggLiAidGVtcGxhdGVyaWdodHMsICIgLiAkeGVydGVfdG9vbGtpdHNfc2l0ZS0+ZGF0YWJhc2VfdGFibGVfcHJlZml4IC4gInRlbXBsYXRlZGV0YWlscywgIiAuICR4ZXJ0ZV90b29sa2l0c19zaXRlLT5kYXRhYmFzZV90YWJsZV9wcmVmaXggLiAibG9naW5kZXRhaWxzIHdoZXJlICIgLiAkeGVydGVfdG9vbGtpdHNfc2l0ZS0+ZGF0YWJhc2VfdGFibGVfcHJlZml4IC4gInRlbXBsYXRlZGV0YWlscy50ZW1wbGF0ZV90eXBlX2lkID0gIiAuICR4ZXJ0ZV90b29sa2l0c19zaXRlLT5kYXRhYmFzZV90YWJsZV9wcmVmaXggLiAib3JpZ2luYWx0ZW1wbGF0ZXNkZXRhaWxzLnRlbXBsYXRlX3R5cGVfaWQgYW5kICIgLiAkeGVydGVfdG9vbGtpdHNfc2l0ZS0+ZGF0YWJhc2VfdGFibGVfcHJlZml4IC4gInRlbXBsYXRlZGV0YWlscy5jcmVhdG9yX2lkID0gIiAuICR4ZXJ0ZV90b29sa2l0c19zaXRlLT5kYXRhYmFzZV90YWJsZV9wcmVmaXggLiAibG9naW5kZXRhaWxzLmxvZ2luX2lkIGFuZCAiIC4gJHhlcnRlX3Rvb2xraXRzX3NpdGUtPmRhdGFiYXNlX3RhYmxlX3ByZWZpeCAuICJ0ZW1wbGF0ZXJpZ2h0cy50ZW1wbGF0ZV9pZCA9ICIgLiAkeGVydGVfdG9vbGtpdHNfc2l0ZS0+ZGF0YWJhc2VfdGFibGVfcHJlZml4IC4gInRlbXBsYXRlZGV0YWlscy50ZW1wbGF0ZV9pZCBhbmQgIiAuICR4ZXJ0ZV90b29sa2l0c19zaXRlLT5kYXRhYmFzZV90YWJsZV9wcmVmaXggLiAidGVtcGxhdGVyaWdodHMudGVtcGxhdGVfaWQ9IlRFTVBMQVRFX0lEX1RPX1JFUExBQ0UiIGFuZCByb2xlPSJjcmVhdG9yIg==', 'error_logs/', '', 'false', '1000', '10', '', '', '', '', '', 'modules/xerte/engine/save.php', 'upload.php?path=', 'modules/xerte/engine/file_exists.php', 'modules/xerte/engine/tools/SteelOverAll.swf', '', '', '', '', '', ''

Ran out of ideas...

So... confused in Ann Arbor!  ;-)

sr

--------------------------------------------------------------------------------

Subject: RE: [Xerte] Full install failing on page 4: System #2
Date: Mon, 8 Mar 2010 18:57:02 +0000
From: Patrick.Lockley at nottingham.ac.uk
To: xerte at lists.nottingham.ac.uk

i would try putting an if(isset($_GET['linkID)){ } else { } around line 47

--------------------------------------------------------------------------------

From: xerte-bounces at lists.nottingham.ac.uk on behalf of Steve Ricketts
Sent: Mon 08/03/2010 17:36
To: Xerte discussion list
Subject: RE: [Xerte] Full install failing on page 4: System #2

Was able to edit now with those changes.  Just added a couple of pages and tried to preview... got the JS error and lookin at the source found:

Notice  Undefined index:  linkID in C:\Inetpub\wwwroot\XerteToolkits\modules\xerte\preview.php on line 47

sr 

--------------------------------------------------------------------------------

Subject: RE: [Xerte] Full install failing on page 4: System #2
Date: Mon, 8 Mar 2010 14:08:14 +0000
From: Patrick.Lockley at nottingham.ac.uk
To: xerte at lists.nottingham.ac.uk

"Tried edit.php
Notice: Undefined variable: xerte_toolkits_site in C:\Inetpub\wwwroot\XerteToolkits\edit.php on line 34

Notice: Trying to get property of non-object in C:\Inetpub\wwwroot\XerteToolkits\edit.php on line 34"

Try adding the line

global $xerte_toolkits_site;

inside the update_access_time function.

Looking in template library.php, I can see a typo

Swap $query_reponse, for $query_response.

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 14:03
To: Xerte discussion list
Subject: RE: [Xerte] Full install failing on page 4: System #2

System 2

That change removed the error from the initial page, but there are still errors, both JS and php, in other pages.  You know, I can't help but think a lot of this was caused in the initial installation when I got the original errors on page4 of the install (bottom of this post).  Anyway, here are some of the errors still coming up:

Tried edit.php
Notice: Undefined variable: xerte_toolkits_site in C:\Inetpub\wwwroot\XerteToolkits\edit.php on line 34

Notice: Trying to get property of non-object in C:\Inetpub\wwwroot\XerteToolkits\edit.php on line 34

Tried Preview, nothing shows on screen, but JS error shows:
Message: Syntax error
Line: 31
Char: 1
Code: 0
URI: http://www.cade-etutor.com/xertetoolkits/preview.php?template_id=1
Notice:  Undefined index:  linkID in C:\Inetpub\wwwroot\XerteToolkits\modules\xerte\preview.php on line 47

Creating a new project gives JS error on:
var neweditorwindow = window.open(site_url + url_return("edit" , xmlHttp.responseText), "editwindow" + xmlHttp.responseText, "height=665, width=800" );
>>xmlHttp.responseText
Notice:  Undefined variable: query_reponse in C:\Inetpub\wwwroot\XerteToolkits\website_code\php\template_library.php on line 21

sr

--------------------------------------------------------------------------------

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

                mysql_select_db($xerte_toolkits_site->database_name) or die($database_fail = true);

                /*

                * database failing code

                */

                if($database_fail){

lines 43-49 of database_library.php

suggest putting a line above the mysql_select along the lines of

$database_fail = false;

Then seeing what happens

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:28
To: Xerte discussion list
Subject: Re: [Xerte] Full install failing on page 4: No database selected

SYSTEM 2 - Windows Server 2003, IIS 6

I'm going to start referring to these by number these because I'm having different problems on two different systems.  Hopefully, the solutions will both relate.

When I click Create Project, I get a JS error on line 1183 var neweditorwindow = window.open(site_url + url_return("edit",xmlHttp.responseText,"editwindow"  + xmlHttp.responseText, "height=665,width=800");

It's caused by the responseText having three undefined variable errors.  Two in database_library.php (database_fail) at line 49 and one in template_library.php (query_response) on line 21

Keep in mind that there is already an error message on the index page (demo.php) of Notice:  Undefined variable: database_fail in <b>C:\Inetpub\wwwroot\XerteToolkits\website_code\php\database_library.php on line 49

sr

From: Steve Ricketts 

Sent: Sunday, March 07, 2010 4:57 PM

To: Xerte discussion list 

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

I tried to install Xerte on another computer and made sure I applied the lessons learned.  All defaults in the parameters were taken (except the database of course).  This is a Windows Server 2003 with IIS 6 so it was a little different.  Here's the output from page 4 and then index.php and demo.txt (changed to index.php).

Notice: Use of undefined constant get_magic_quotes_gpc - assumed 'get_magic_quotes_gpc' in C:\Inetpub\wwwroot\XerteToolkits\setup\page4.php on line 9
The sitedetails site ID query succeeded 
The sitedetails site url query succeeded 
The sitedetails apache query succeeded 
The sitedetails apache query succeeded 
The sitedetails mimetypes query succeeded 
The sitedetails LDAP preference query succeeded 
The sitedetails LDAP preference query succeeded 
The sitedetails LDAP_filter query succeeded 
The sitedetails integration_config_path query succeeded 
The sitedetails admin_username query succeeded 
The sitedetails admin_password query succeeded 
The sitedetails site_session_name query succeeded 
The sitedetails site_title query succeeded 
The sitedetails site_name query succeeded 
The sitedetails site_logo query succeeded 
The sitedetails organisational_logo query succeeded 
The sitedetails welcome_message query succeeded 
The sitedetails site_text query succeeded 
The sitedetails news_text query succeeded 
The sitedetails pod_one query succeeded 
The sitedetails pod_two query succeeded 
The sitedetails copyright query succeeded 
The sitedetails rss_title query succeeded 
The sitedetails synd_publisher query succeeded 
The sitedetails synd_rights query succeeded 
The sitedetails synd_license query succeeded 
The sitedetails demonstration_page query succeeded 
The sitedetails form_string query succeeded 
The sitedetails peer_form_string query succeeded 
The sitedetails module_path query succeeded 
The sitedetails website_code_path query succeeded 
The sitedetails users_file_area_short query succeeded 
The sitedetails php_library_path query succeeded 
The sitedetails import_path query succeeded 
The sitedetails root_file_path query update sitedetails set root_file_path='c:\inetpub\wwwroot\xertetoolkits\' where site_id="1" has failed due to You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''c:\inetpub\wwwroot\xertetoolkits\' where site_id="1"' at line 1
The sitedetails play_edit_preview_queryquery succeeded 
The sitedetails error_log_path query succeeded 
The sitedetails email_error_list query succeeded 
The sitedetails error_log_message query succeeded 
Notice: Undefined index: max_error_size in C:\Inetpub\wwwroot\XerteToolkits\setup\page4.php on line 587
The sitedetails max_error_size query succeeded 
The sitedetails error_email_message query succeeded 
The sitedetails ldap_host query succeeded 
The sitedetails ldap_port query succeeded 
The sitedetails bind_pwd query succeeded 
The sitedetails basedn query succeeded 
The sitedetails bind_dn query succeeded 
The sitedetails flash_save_path query succeeded 
The sitedetails flash_upload_path query succeeded 
The sitedetails flash_preview_check_path query succeeded 
The sitedetails flash_flv_skin query succeeded 
The sitedetails site_email_account query succeeded 
The sitedetails headers query succeeded 
The sitedetails email_to_add_to_username query succeeded 
The sitedetails proxy1 query succeeded 
The sitedetails port1 query succeeded 
The sitedetails feedback_list query succeeded 
Install complete 
Your site URL is www.svr.com/xertetoolkits/ 
If you have installed this on a public facing server, please look to remove the php file you are not planning to use. Index, demo, integration, webctlink and management.php all can access the site in some way. You should rename the files you do not plan to use. 
Please see the Xerte site at http://www.nottingham.ac.uk/xerte and please consider joining the mailing list. 

[INDEX.PHP (original)]
Notice: Undefined variable: form_string in C:\Inetpub\wwwroot\XerteToolkits\index.php on line 39

[Demo changed to index.php]
Notice:  Undefined variable: database_fail in <b>C:\Inetpub\wwwroot\XerteToolkits\website_code\php\database_library.php on line 49
Notice:  Undefined index:  toolkits_logon_username in <b>C:\Inetpub\wwwroot\XerteToolkits\website_code\php\database_library.php on line 57

It throws excepts on pretty much any page you try to call, but I assume it's all connected to the original problem... whatever that is.

sr

--------------------------------------------------------------------------------

From: velocedge at hotmail.com
To: xerte at lists.nottingham.ac.uk
Subject: RE: [Xerte] Full install failing on page 4: No database selected
Date: Sun, 7 Mar 2010 16:51:30 -0500

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. 

--------------------------------------------------------------------------------

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. Sign up now.

--------------------------------------------------------------------------------

Hotmail: Trusted email with powerful SPAM protection. Sign up now. 

--------------------------------------------------------------------------------

Hotmail: Powerful Free email with security by Microsoft. Get it now. 

--------------------------------------------------------------------------------

Hotmail: Powerful Free email with security by Microsoft. Get it now.

--------------------------------------------------------------------------------

Hotmail: Trusted email with powerful SPAM protection. Sign up now.

--------------------------------------------------------------------------------

Hotmail: Free, trusted and rich email service. Get it now.

--------------------------------------------------------------------------------
Hotmail: Powerful Free email with security by Microsoft. Get it now. 

--------------------------------------------------------------------------------
Hotmail: Powerful Free email with security by Microsoft. Get it now. 

--------------------------------------------------------------------------------

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

--------------------------------------------------------------------------------

_______________________________________________
Xerte mailing list
Xerte at lists.nottingham.ac.uk
http://lists.nottingham.ac.uk/mailman/listinfo/xerte
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.nottingham.ac.uk/pipermail/xerte/attachments/20100310/655e66d3/attachment.html