<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=text/html;charset=Windows-1252 http-equiv=Content-Type>
<STYLE><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
--></STYLE>
<META name=GENERATOR content="MSHTML 8.00.6001.18882"></HEAD>
<BODY style="PADDING-LEFT: 10px; PADDING-RIGHT: 10px; PADDING-TOP: 15px"
id=MailContainerBody class=hmmessage leftMargin=0 topMargin=0
CanvasTabStop="true" name="Compose message area">
<DIV><FONT size=3 face=Calibri>SYSTEM 2 - Windows Server 2003, IIS
6</FONT></DIV>
<DIV><FONT size=3 face=Calibri></FONT> </DIV>
<DIV><FONT size=3 face=Calibri>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.</FONT></DIV>
<DIV><FONT size=3 face=Calibri></FONT> </DIV>
<DIV>
<DIV><FONT face=Calibri>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");</FONT></DIV>
<DIV><FONT face=Calibri></FONT> </DIV>
<DIV><FONT face=Calibri>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</FONT></DIV>
<DIV><FONT face=Calibri></FONT> </DIV>
<DIV><FONT face=Calibri>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<BR></FONT></DIV>
<DIV><FONT face=Calibri>sr</DIV></FONT>
<DIV><FONT face=Calibri></FONT> </DIV>
<DIV><FONT face=Calibri></FONT> </DIV></DIV>
<DIV style="FONT: 10pt Tahoma">
<DIV><FONT size=3 face=Calibri></FONT><FONT size=3
face=Calibri></FONT><BR></DIV>
<DIV style="BACKGROUND: #f5f5f5">
<DIV style="font-color: black"><B>From:</B> <A
title="mailto:velocedge@hotmail.com CTRL + Click to follow link"
href="mailto:velocedge@hotmail.com">Steve Ricketts</A> </DIV>
<DIV><B>Sent:</B> Sunday, March 07, 2010 4:57 PM</DIV>
<DIV><B>To:</B> <A
title="mailto:xerte@lists.nottingham.ac.uk CTRL + Click to follow link"
href="mailto:xerte@lists.nottingham.ac.uk">Xerte discussion list</A> </DIV>
<DIV><B>Subject:</B> RE: [Xerte] Full install failing on page 4: No database
selected</DIV></DIV></DIV>
<DIV><BR></DIV>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).<BR> <BR> <BR>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<BR>The sitedetails
site ID query succeeded <BR>The sitedetails site url query succeeded <BR>The
sitedetails apache query succeeded <BR>The sitedetails apache query succeeded
<BR>The sitedetails mimetypes query succeeded <BR>The sitedetails LDAP
preference query succeeded <BR>The sitedetails LDAP preference query succeeded
<BR>The sitedetails LDAP_filter query succeeded <BR>The sitedetails
integration_config_path query succeeded <BR>The sitedetails admin_username query
succeeded <BR>The sitedetails admin_password query succeeded <BR>The sitedetails
site_session_name query succeeded <BR>The sitedetails site_title query succeeded
<BR>The sitedetails site_name query succeeded <BR>The sitedetails site_logo
query succeeded <BR>The sitedetails organisational_logo query succeeded <BR>The
sitedetails welcome_message query succeeded <BR>The sitedetails site_text query
succeeded <BR>The sitedetails news_text query succeeded <BR>The sitedetails
pod_one query succeeded <BR>The sitedetails pod_two query succeeded <BR>The
sitedetails copyright query succeeded <BR>The sitedetails rss_title query
succeeded <BR>The sitedetails synd_publisher query succeeded <BR>The sitedetails
synd_rights query succeeded <BR>The sitedetails synd_license query succeeded
<BR>The sitedetails demonstration_page query succeeded <BR>The sitedetails
form_string query succeeded <BR>The sitedetails peer_form_string query succeeded
<BR>The sitedetails module_path query succeeded <BR>The sitedetails
website_code_path query succeeded <BR>The sitedetails users_file_area_short
query succeeded <BR>The sitedetails php_library_path query succeeded <BR>The
sitedetails import_path query succeeded <BR>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<BR>The
sitedetails play_edit_preview_queryquery succeeded <BR>The sitedetails
error_log_path query succeeded <BR>The sitedetails email_error_list query
succeeded <BR>The sitedetails error_log_message query succeeded <BR>Notice:
Undefined index: max_error_size in
C:\Inetpub\wwwroot\XerteToolkits\setup\page4.php on line 587<BR>The sitedetails
max_error_size query succeeded <BR>The sitedetails error_email_message query
succeeded <BR>The sitedetails ldap_host query succeeded <BR>The sitedetails
ldap_port query succeeded <BR>The sitedetails bind_pwd query succeeded <BR>The
sitedetails basedn query succeeded <BR>The sitedetails bind_dn query succeeded
<BR>The sitedetails flash_save_path query succeeded <BR>The sitedetails
flash_upload_path query succeeded <BR>The sitedetails flash_preview_check_path
query succeeded <BR>The sitedetails flash_flv_skin query succeeded <BR>The
sitedetails site_email_account query succeeded <BR>The sitedetails headers query
succeeded <BR>The sitedetails email_to_add_to_username query succeeded <BR>The
sitedetails proxy1 query succeeded <BR>The sitedetails port1 query succeeded
<BR>The sitedetails feedback_list query succeeded <BR>Install complete <BR>Your
site URL is <A
href="http://www.svr.com/xertetoolkits/">www.svr.com/xertetoolkits/</A> <BR>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. <BR>Please see the Xerte site at <A
href="http://www.nottingham.ac.uk/xerte">http://www.nottingham.ac.uk/xerte</A>
and please consider joining the mailing list. <BR> <BR>[INDEX.PHP
(original)]<BR>Notice: Undefined variable: form_string in
C:\Inetpub\wwwroot\XerteToolkits\index.php on line 39<BR><BR>[Demo changed to
index.php]<BR>Notice: Undefined variable: database_fail in
<b>C:\Inetpub\wwwroot\XerteToolkits\website_code\php\database_library.php
on line 49<BR>Notice: Undefined index: toolkits_logon_username in
<b>C:\Inetpub\wwwroot\XerteToolkits\website_code\php\database_library.php
on line 57<BR><BR>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.<BR> <BR>sr<BR>
<HR id=stopSpelling>
From: velocedge@hotmail.com<BR>To: xerte@lists.nottingham.ac.uk<BR>Subject: RE:
[Xerte] Full install failing on page 4: No database selected<BR>Date: Sun, 7 Mar
2010 16:51:30 -0500<BR><BR>
<STYLE>
.ExternalClass .ecxhmmessage P
{padding:0px;}
.ExternalClass body.ecxhmmessage
{font-size:10pt;font-family:Verdana;}
</STYLE>
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.<BR> <BR>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:<BR> <BR><A
href="http://learnnet/xertetoolkits/USER-FILES/1-guest-Nottingham/preview.xml?myvar=1267992069172"><font color="red"><b>MailScanner has detected a possible fraud attempt from "learnnet" claiming to be</b></font> http://learnnet:80/xertetoolkits/USER-FILES/1-guest-Nottingham/preview.xml?myvar=1267992069172</A>
<BR> <BR>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.<BR> <BR>sr<BR> <BR>
<HR id=ecxstopSpelling>
Subject: RE: [Xerte] Full install failing on page 4: No database
selected<BR>Date: Sun, 7 Mar 2010 19:10:17 +0000<BR>From:
Patrick.Lockley@nottingham.ac.uk<BR>To: xerte@lists.nottingham.ac.uk<BR><BR>
<STYLE>
.ExternalClass .ecxhmmessage P
{padding:0px;}
.ExternalClass body.ecxhmmessage
{font-size:10pt;font-family:Verdana;}
</STYLE>
<DIV dir=ltr id=ecxecxidOWAReplyText1410>
<DIV dir=ltr><FONT size=2 face=Arial>Your later paragraphs may well reflect the
fact your sitedetails table is basically empty, as your setup
failed.</FONT></DIV></DIV>
<DIV>
<DIV dir=ltr id=ecxecxecxidOWAReplyText32610>
<DIV dir=ltr><FONT face=Arial>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.</FONT></DIV>
<DIV dir=ltr><FONT size=2 face=Arial></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial>Well, all page 4 of the installer does is populate
this table. So to get errors - the table wouldn't be populated?</FONT></DIV>
<DIV dir=ltr><FONT face=Arial></FONT> </DIV>
<DIV dir=ltr><FONT size=2 face=Arial>Switching from index to demo will not
really achieve anything other than removing the requirement for
LDAP.</FONT></DIV>
<DIV dir=ltr><FONT face=Arial>SR: Yep, that's what I was going for. The
developers will enter through our LMS and as such will have already been
authenticated.</FONT></DIV>
<DIV dir=ltr><FONT face=Arial></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial>Then ignore demo, and use
integration.txt</FONT></DIV></DIV>
<DIV dir=ltr> </DIV>
<DIV dir=ltr>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.</DIV>
<DIV dir=ltr> </DIV>
<DIV dir=ltr><BR>
<HR>
<FONT size=2 face=Tahoma><B>From:</B> xerte-bounces@lists.nottingham.ac.uk on
behalf of Steve Ricketts<BR><B>Sent:</B> Sun 07/03/2010 16:35<BR><B>To:</B>
Xerte discussion list<BR><B>Subject:</B> Re: [Xerte] Full install failing on
page 4: No database selected<BR></FONT><BR></DIV>
<DIV>
<DIV><FONT face=Calibri>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. <IMG
style="FLOAT: none" title="Sad smile emoticon" alt="Sad smile emoticon"
src="http:///"></FONT></DIV>
<DIV><FONT face=Calibri></FONT> </DIV>
<DIV><FONT face=Calibri>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)</FONT></DIV>
<DIV><FONT face=Calibri></FONT> </DIV>
<DIV><FONT face=Calibri>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. </FONT></DIV>
<DIV><FONT face=Calibri></FONT> </DIV>
<DIV><FONT face=Calibri>sr</FONT></DIV>
<DIV><FONT face=Calibri></FONT> </DIV>
<DIV><FONT face=Calibri>PS. php_library_path returned to
normal.</FONT></DIV>
<DIV><BR></DIV>
<DIV style="FONT: 10pt Tahoma">
<DIV style="BACKGROUND: #f5f5f5">
<DIV><B>From:</B> <A title=ronm@mitchellmedia.co.uk
href="mailto:ronm@mitchellmedia.co.uk">RonM</A> </DIV>
<DIV><B>Sent:</B> Sunday, March 07, 2010 10:12 AM</DIV>
<DIV><B>To:</B> <A title=xerte@lists.nottingham.ac.uk
href="mailto:xerte@lists.nottingham.ac.uk">'Xerte discussion list'</A> </DIV>
<DIV><B>Subject:</B> RE: [Xerte] Full install failing on page 4: No database
selected</DIV></DIV></DIV>
<DIV><BR></DIV>
<DIV class=ecxecxecxSection1>
<P class=ecxecxecxMsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">Hi
Steve</SPAN></P>
<P class=ecxecxecxMsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">I’ve
had this kind of problem on windows/IIS installations too. So a couple of
suggestions but from memory...</SPAN></P>
<P class=ecxecxecxMsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"></SPAN> </P>
<P style="TEXT-INDENT: -18pt" class=ecxecxecxMsoListParagraph><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"><SPAN>1.<SPAN
style="FONT: 7pt 'Times New Roman'">
</SPAN></SPAN></SPAN><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">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.</SPAN></P>
<P style="TEXT-INDENT: -18pt" class=ecxecxecxMsoListParagraph><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"><SPAN>2.<SPAN
style="FONT: 7pt 'Times New Roman'">
</SPAN></SPAN></SPAN><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">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</SPAN></P>
<P style="TEXT-INDENT: -18pt" class=ecxecxecxMsoListParagraph><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"><SPAN>3.<SPAN
style="FONT: 7pt 'Times New Roman'">
</SPAN></SPAN></SPAN><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">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.</SPAN></P>
<P class=ecxecxecxMsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"></SPAN> </P>
<P class=ecxecxecxMsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">Pat
may have other suggestions but try this and post back to the list.</SPAN></P>
<P class=ecxecxecxMsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">HTH</SPAN></P>
<P class=ecxecxecxMsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">Ron</SPAN></P>
<P class=ecxecxecxMsoNormal><A name=_MailEndCompose></SPAN><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"></A> </P>
<DIV>
<DIV
style="BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0cm; PADDING-RIGHT: 0cm; BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT: medium none; PADDING-TOP: 3pt">
<P class=ecxecxecxMsoNormal><B><SPAN
style="FONT-FAMILY: 'Tahoma','sans-serif'; FONT-SIZE: 10pt"
lang=EN-US>From:</SPAN></B><SPAN
style="FONT-FAMILY: 'Tahoma','sans-serif'; FONT-SIZE: 10pt" lang=EN-US>
xerte-bounces@lists.nottingham.ac.uk
[mailto:xerte-bounces@lists.nottingham.ac.uk] <B>On Behalf Of </B>Steve
Ricketts<BR><B>Sent:</B> 07 March 2010 14:41<BR><B>To:</B> Xerte discussion
list<BR><B>Subject:</B> [Xerte] Full install failing on page 4: No database
selected</SPAN></P></DIV></DIV>
<P class=ecxecxecxMsoNormal> </P>
<DIV>
<P class=ecxecxecxMsoNormal><SPAN style="FONT-FAMILY: 'Calibri','sans-serif'"
lang=EN-US>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?</SPAN><SPAN lang=EN-US></SPAN></P></DIV>
<DIV>
<P class=ecxecxecxMsoNormal><SPAN style="FONT-FAMILY: 'Calibri','sans-serif'"
lang=EN-US><BR>Thanks,</SPAN></P></DIV>
<DIV>
<P class=ecxecxecxMsoNormal><SPAN style="FONT-FAMILY: 'Calibri','sans-serif'"
lang=EN-US></SPAN> </P></DIV>
<DIV>
<P class=ecxecxecxMsoNormal><SPAN style="FONT-FAMILY: 'Calibri','sans-serif'"
lang=EN-US>sr</SPAN><SPAN lang=EN-US></SPAN></P></DIV>
<DIV>
<P class=ecxecxecxMsoNormal><SPAN
style="FONT-FAMILY: 'Tahoma','sans-serif'; FONT-SIZE: 10pt"
lang=EN-US></SPAN> </P></DIV>
<DIV>
<P class=ecxecxecxMsoNormal><SPAN style="FONT-FAMILY: 'Calibri','sans-serif'"
lang=EN-US>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.</SPAN><SPAN
style="FONT-FAMILY: 'Tahoma','sans-serif'; FONT-SIZE: 10pt"
lang=EN-US></SPAN></P></DIV>
<DIV>
<P class=ecxecxecxMsoNormal><SPAN
style="FONT-FAMILY: 'Tahoma','sans-serif'; FONT-SIZE: 10pt"
lang=EN-US></SPAN> </P></DIV>
<DIV>
<P class=ecxecxecxMsoNormal><SPAN style="FONT-FAMILY: 'Calibri','sans-serif'"
lang=EN-US>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.</SPAN><SPAN
style="FONT-FAMILY: 'Tahoma','sans-serif'; FONT-SIZE: 10pt"
lang=EN-US></SPAN></P></DIV></DIV>
<HR>
<BR>_______________________________________________<BR>Xerte mailing
list<BR>Xerte@lists.nottingham.ac.uk<BR>http://lists.nottingham.ac.uk/mailman/listinfo/xerte<BR><BR></DIV><BR>
<HR>
Hotmail: Trusted email with powerful SPAM protection. <A
href="http://clk.atdmt.com/GBL/go/201469227/direct/01/">Sign up now.</A>
</DIV><BR>
<HR>
Hotmail: Trusted email with Microsoft’s powerful SPAM protection. <A
href="http://clk.atdmt.com/GBL/go/201469226/direct/01/">Sign up now.</A> <BR>
<HR>
Hotmail: Trusted email with Microsoft’s powerful SPAM protection. <A
href="http://clk.atdmt.com/GBL/go/201469226/direct/01/" target=_new>Sign up
now.</A> </BODY></HTML>