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

Tue Mar 9 15:45:06 GMT 2010

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/Notting
ham.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/Notting
ham.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,im
age/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,applicatio
n/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',
'PHAgY2xhc3M9Im5ld3NfdGl0bGUiPk90aGVyIHJlc291cmNlczwvcD48cCBjbGFzcz0ibmV
3c19zdG9yeSI+PGEgaHJlZj0iIj5TaXRlIDE8L2E+PC9wPjxwIGNsYXNzPSJuZXdzX3N0b3J
5Ij48YSBocmVmPSIiPlNpdGUgMjwvYT48L3A+PHAgY2xhc3M9Im5ld3Nfc3RvcnkiPjxhIGh
yZWY9IiI+U2l0ZSAzPC9hPjwvcD4=',
'PHAgY2xhc3M9Im5ld3NfdGl0bGUiPkhvdyB0bzwvcD48cCBjbGFzcz0iZGVtbyI+PGEgaHJ
lZj0iamF2YXNjcmlwdDphbGVydCgnU29ycnkuIFRoaXMgaXMgbm90IHlldCBhdmFpbGFibGU
nKSI+MzAgU2Vjb25kIERlbW88L2E+PGJyIC8+QSB2ZXJ5IHNob3J0IGNhcHRpdmF0ZSBmaWx
lIHNob3dpbmcgYSBzaW1wbGUgcHJvamVjdCBiZWluZyBzdGFydGVkLCBidWlsdCBhbmQgcHV
ibGlzaGVkIGZvciB0aGUgd2ViLjwvcD48cCBjbGFzcz0iZGVtbyI+PGEgaHJlZj0iamF2YXN
jcmlwdDphbGVydCgnU29ycnkuIFRoaXMgaXMgbm90IHlldCBhdmFpbGFibGUnKSI+TGVhcm5
pbmcgT2JqZWN0IERlbW88L2E+PGJyIC8+QSB2ZXJ5IHNpbXBsZSBkZW1vIG9mIGEgbGVhcm5
pbmcgb2JqZWN0LjwvcD4=',
'PHAgY2xhc3M9Im5ld3NfdGl0bGUiPldhbnQgdG8gc2hhcmUgc29tZSB0aG91Z2h0cz88L3A
+PHAgY2xhc3M9ImdlbmVyYWwiPklmIHlvdSBoYXZlIGFueSBxdWVzdGlvbnMsIHJlcXVlc3R
zIGZvciBoZWxwLCBpZGVhcyBmb3IgbmV3IHByb2plY3RzIG9yIHByb2JsZW1zIHRvIHJlcG9
ydCwgdGhlbiBwbGVhc2UgZ2V0IGluIHRvdWNoLjwvcD48cCBjbGFzcz0iZ2VuZXJhbCI+UGx
lYXNlIHVzZSBvdXIgPGEgaHJlZj0iZmVlZGJhY2svIiBzdHlsZT0iY29sb3I6IzAwMCI+RmV
lZGJhY2sgRm9ybTwvYT48L3A+', '(c) 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+PGNlbnRlcj48cD48Zm9ybSBtZXRob2Q9InBvc3QiIGFjdGlvbj0iIj4
8cD5Vc2VybmFtZSA8aW5wdXQgdHlwZT0idGV4dCIgc2l6ZT0iMjAiIG1heGxlbmd0aD0iMTI
iIG5hbWU9ImxvZ2luIiAvPjwvcD48cD5QYXNzd29yZCA8aW5wdXQgdHlwZT0icGFzc3dvcmQ
iIHNpemU9IjIwIiBtYXhsZW5ndGg9IjM2IiBuYW1lPSJwYXNzd29yZCIgLz48L3A+PHA+PGl
ucHV0IHR5cGU9ImltYWdlIiBzcmM9IndlYnNpdGVfY29kZS9pbWFnZXMvQnR0bl9Mb2dpbk9
mZi5naWYiIG9ubW91c2VvdmVyPSJ0aGlzLnNyYz0nd2Vic2l0ZV9jb2RlL2ltYWdlcy9CdHR
uX0xvZ2luT24uZ2lmJyIgb25tb3VzZWRvd249InRoaXMuc3JjPSd3ZWJzaXRlX2NvZGUvaW1
hZ2VzL0J0dG5fTG9naW5DbGljay5naWYnIiBvbm1vdXNlb3V0PSJ0aGlzLnNyYz0nd2Vic2l
0ZV9jb2RlL2ltYWdlcy9CdHRuX0xvZ2luT2ZmLmdpZiciIC8+PC9wPg==',
'PGh0bWw+PGJvZHk+PGNlbnRlcj48cD48Zm9ybSBtZXRob2Q9InBvc3QiIGFjdGlvbj0iIj4
8cD5QYXNzd29yZCA8aW5wdXQgdHlwZT0icGFzc3dvcmQiIHNpemU9IjIwIiBtYXhsZW5ndGg
9IjM2IiBuYW1lPSJwYXNzd29yZCIgLz48L3A+PHA+PGlucHV0IHR5cGU9ImltYWdlIiBzcmM
9IndlYnNpdGVfY29kZS9pbWFnZXMvQnR0bl9Mb2dpbk9mZi5naWYiIG9ubW91c2VvdmVyPSJ
0aGlzLnNyYz0nd2Vic2l0ZV9jb2RlL2ltYWdlcy9CdHRuX0xvZ2luT24uZ2lmJyIgb25tb3V
zZWRvd249InRoaXMuc3JjPSd3ZWJzaXRlX2NvZGUvaW1hZ2VzL0J0dG5fTG9naW5DbGljay5
naWYnIiBvbm1vdXNlb3V0PSJ0aGlzLnNyYz0nd2Vic2l0ZV9jb2RlL2ltYWdlcy9CdHRuX0x
vZ2luT2ZmLmdpZiciIC8+PC9wPg==', 'modules/', 'website_code/',
'USER-FILES/', 'website_code/php/',
'c:/inetpub/wwwroot/xertetoolkits/import/',
'c:\inetpub\wwwroot\xertetoolkits\',
'c2VsZWN0ICIgLiAkeGVydGVfdG9vbGtpdHNfc2l0ZS0+ZGF0YWJhc2VfdGFibGVfcHJlZml
4IC4gIm9yaWdpbmFsdGVtcGxhdGVzZGV0YWlscy50ZW1wbGF0ZV9uYW1lLCAiIC4gJHhlcnR
lX3Rvb2xraXRzX3NpdGUtPmRhdGFiYXNlX3RhYmxlX3ByZWZpeCAuICJsb2dpbmRldGFpbHM
udXNlcm5hbWUsICIgLiAkeGVydGVfdG9vbGtpdHNfc2l0ZS0+ZGF0YWJhc2VfdGFibGVfcHJ
lZml4IC4gIm9yaWdpbmFsdGVtcGxhdGVzZGV0YWlscy50ZW1wbGF0ZV9mcmFtZXdvcmssICI
gLiAkeGVydGVfdG9vbGtpdHNfc2l0ZS0+ZGF0YWJhc2VfdGFibGVfcHJlZml4IC4gInRlbXB
sYXRlcmlnaHRzLnVzZXJfaWQsICIgLiAkeGVydGVfdG9vbGtpdHNfc2l0ZS0+ZGF0YWJhc2V
fdGFibGVfcHJlZml4IC4gInRlbXBsYXRlcmlnaHRzLmZvbGRlciwgIiAuICR4ZXJ0ZV90b29
sa2l0c19zaXRlLT5kYXRhYmFzZV90YWJsZV9wcmVmaXggLiAidGVtcGxhdGVyaWdodHMudGV
tcGxhdGVfaWQsICIgLiAkeGVydGVfdG9vbGtpdHNfc2l0ZS0+ZGF0YWJhc2VfdGFibGVfcHJ
lZml4IC4gInRlbXBsYXRlZGV0YWlscy5hY2Nlc3NfdG9fd2hvbSBmcm9tICIgLiAkeGVydGV
fdG9vbGtpdHNfc2l0ZS0+ZGF0YWJhc2VfdGFibGVfcHJlZml4IC4gIm9yaWdpbmFsdGVtcGx
hdGVzZGV0YWlscywgIiAuICR4ZXJ0ZV90b29sa2l0c19zaXRlLT5kYXRhYmFzZV90YWJsZV9
wcmVmaXggLiAidGVtcGxhdGVyaWdodHMsICIgLiAkeGVydGVfdG9vbGtpdHNfc2l0ZS0+ZGF
0YWJhc2VfdGFibGVfcHJlZml4IC4gInRlbXBsYXRlZGV0YWlscywgIiAuICR4ZXJ0ZV90b29
sa2l0c19zaXRlLT5kYXRhYmFzZV90YWJsZV9wcmVmaXggLiAibG9naW5kZXRhaWxzIHdoZXJ
lICIgLiAkeGVydGVfdG9vbGtpdHNfc2l0ZS0+ZGF0YWJhc2VfdGFibGVfcHJlZml4IC4gInR
lbXBsYXRlZGV0YWlscy50ZW1wbGF0ZV90eXBlX2lkID0gIiAuICR4ZXJ0ZV90b29sa2l0c19
zaXRlLT5kYXRhYmFzZV90YWJsZV9wcmVmaXggLiAib3JpZ2luYWx0ZW1wbGF0ZXNkZXRhaWx
zLnRlbXBsYXRlX3R5cGVfaWQgYW5kICIgLiAkeGVydGVfdG9vbGtpdHNfc2l0ZS0+ZGF0YWJ
hc2VfdGFibGVfcHJlZml4IC4gInRlbXBsYXRlZGV0YWlscy5jcmVhdG9yX2lkID0gIiAuICR
4ZXJ0ZV90b29sa2l0c19zaXRlLT5kYXRhYmFzZV90YWJsZV9wcmVmaXggLiAibG9naW5kZXR
haWxzLmxvZ2luX2lkIGFuZCAiIC4gJHhlcnRlX3Rvb2xraXRzX3NpdGUtPmRhdGFiYXNlX3R
hYmxlX3ByZWZpeCAuICJ0ZW1wbGF0ZXJpZ2h0cy50ZW1wbGF0ZV9pZCA9ICIgLiAkeGVydGV
fdG9vbGtpdHNfc2l0ZS0+ZGF0YWJhc2VfdGFibGVfcHJlZml4IC4gInRlbXBsYXRlZGV0YWl
scy50ZW1wbGF0ZV9pZCBhbmQgIiAuICR4ZXJ0ZV90b29sa2l0c19zaXRlLT5kYXRhYmFzZV9
0YWJsZV9wcmVmaXggLiAidGVtcGxhdGVyaWdodHMudGVtcGxhdGVfaWQ9IlRFTVBMQVRFX0l
EX1RPX1JFUExBQ0UiIGFuZCByb2xlPSJjcmVhdG9yIg==', '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.ph
p on line 49

sr

From: Steve Ricketts <mailto:velocedge at hotmail.com>  

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

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

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.ph
p on line 49
Notice:  Undefined index:  toolkits_logon_username in
<b>C:\Inetpub\wwwroot\XerteToolkits\website_code\php\database_library.ph
p 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.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/>  

________________________________

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

________________________________

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

________________________________

Hotmail: Powerful Free email with security by Microsoft. Get it now.
<http://clk.atdmt.com/GBL/go/201469230/direct/01/>  

________________________________

Hotmail: Powerful Free email with security by Microsoft. Get it now.
<http://clk.atdmt.com/GBL/go/201469230/direct/01/> 

________________________________

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

________________________________

Hotmail: Free, trusted and rich email service. Get it now.
<http://clk.atdmt.com/GBL/go/201469228/direct/01/> 

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