<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
--></style>
</head>
<body class='hmmessage'>
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>