<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>
<div><br></div><div><span style="font-size: 10pt; ">database_library</span> itself fails (no echo from line 1) if I include this function:</div><div><br></div><div>function db_query($sql, $params = array()) {</div><div><br></div><div>If I take it out, the page returns various echos, including the call to db_query_one()</div><div><br></div><div>If I put <span style="font-size: 10pt; ">db_query function back in, the page blows up.</span></div><div><span style="font-size: 10pt; "><br></span></div><div><span style="font-size: 10pt; "><br></span></div><div><br></div><br><div><div id="SkyDrivePlaceholder"></div>> Date: Sun, 29 Apr 2012 15:15:29 +0100<br>> From: patrick.lockley@googlemail.com<br>> To: xerte@lists.nottingham.ac.uk<br>> Subject: [Xerte] Re: database.php<br>> <br>> sorry, being blind<br>> <br>> i'd look in database_library for the actual mysql_query line, and add<br>> it under that<br>> <br>> On Sun, Apr 29, 2012 at 3:11 PM, Dave Burnett <d_b_burnett@hotmail.com> wrote:<br>> > ??<br>> ><br>> > Isn't that where I have it? Following the db_query?<br>> ><br>> ><br>> ><br>> >> Date: Sun, 29 Apr 2012 15:08:22 +0100<br>> ><br>> >> From: patrick.lockley@googlemail.com<br>> >> To: xerte@lists.nottingham.ac.uk<br>> >> Subject: [Xerte] Re: database.php<br>> >><br>> >> ok, so put the mysql_error in<br>> >><br>> >> echo ("five config page"); //get this far<br>> >> $row = db_query_one("SELECT * FROM<br>> >> {$xerte_toolkits_site->database_table_prefix}sitedetails");<br>> >> echo mysql_error() . " <---- ERROR <br />";<br>> >><br>> >> On Sun, Apr 29, 2012 at 3:04 PM, Dave Burnett <d_b_burnett@hotmail.com><br>> >> wrote:<br>> >> > in config<br>> >> ><br>> >> > echo ("five config page"); //get this far<br>> >> > $row = db_query_one("SELECT * FROM<br>> >> > {$xerte_toolkits_site->database_table_prefix}sitedetails");<br>> >> > echo mysql_error(); //nope<br>> >> > echo ("six config page"); //nope<br>> >> ><br>> >> ><br>> >> ><br>> >> >> Date: Sun, 29 Apr 2012 14:30:14 +0100<br>> >> >> From: patrick.lockley@googlemail.com<br>> >> >> To: xerte@lists.nottingham.ac.uk<br>> >> >> Subject: [Xerte] Re: database.php<br>> >> >><br>> >> >> You don't have to close php tags at the end<br>> >> >><br>> >> >> put the mysql_error into config.php after the mysql_query or db_query<br>> >> >> statement?<br>> >> >><br>> >> >> On Sun, Apr 29, 2012 at 1:30 PM, Dave Burnett <d_b_burnett@hotmail.com><br>> >> >> wrote:<br>> >> >> > Nothing at the bottom.<br>> >> >> ><br>> >> >> > Here at the top I get dave, but no dave 1<br>> >> >> > So, issue in config<br>> >> >> ><br>> >> >> > config has opening <?php but no close. Issue?<br>> >> >> ><br>> >> >> ><br>> >> >> ><br>> >> >> > <?php<br>> >> >> > echo ("dave");<br>> >> >> > // This file could be used instead of index.php to perform<br>> >> >> > authentication.<br>> >> >> > // The list of usernames/passwords are hard coded below. (search for<br>> >> >> > 'sarah')<br>> >> >> ><br>> >> >> > require("config.php");<br>> >> >> > echo ("dave1");<br>> >> >> ><br>> >> >> ><br>> >> >> ><br>> >> >> ><br>> >> >> > ________________________________<br>> >> >> > From: patrick.lockley@googlemail.com<br>> >> >> > Date: Sun, 29 Apr 2012 12:30:11 +0100<br>> >> >> ><br>> >> >> > To: xerte@lists.nottingham.ac.uk<br>> >> >> > Subject: [Xerte] Re: database.php<br>> >> >> ><br>> >> >> > Ok.<br>> >> >> ><br>> >> >> > At the end of switch put echo mysql_error();<br>> >> >> ><br>> >> >> > On 29 Apr 2012, at 12:25, Dave Burnett <d_b_burnett@hotmail.com><br>> >> >> > wrote:<br>> >> >> ><br>> >> >> ><br>> >> >> > I've always used renamed switch<br>> >> >> ><br>> >> >> ><br>> >> >> > ________________________________<br>> >> >> > From: patrick.lockley@googlemail.com<br>> >> >> > Date: Sun, 29 Apr 2012 10:31:48 +0100<br>> >> >> > To: xerte@lists.nottingham.ac.uk<br>> >> >> > Subject: [Xerte] Re: database.php<br>> >> >> ><br>> >> >> > Do you have ldap installed?<br>> >> >> ><br>> >> >> > On 29 Apr 2012, at 02:40, Dave Burnett <d_b_burnett@hotmail.com><br>> >> >> > wrote:<br>> >> >> ><br>> >> >> ><br>> >> >> > OK. New install, same result.<br>> >> >> ><br>> >> >> > index.php = blank page.<br>> >> >> ><br>> >> >> ><br>> >> >> ><br>> >> >> ><br>> >> >> ><br>> >> >> > ________________________________<br>> >> >> > From: knowledgeware@kccsoft.com<br>> >> >> > To: xerte@lists.nottingham.ac.uk<br>> >> >> > Date: Sat, 28 Apr 2012 12:42:30 -0700<br>> >> >> > Subject: [Xerte] Re: database.php<br>> >> >> ><br>> >> >> > The ODBC connection has not fixed the problem, unless I have the<br>> >> >> > wrong<br>> >> >> > DSN<br>> >> >> > name which I’m trying to confirm. Vince sees a PHP error, tracking<br>> >> >> > that<br>> >> >> > down<br>> >> >> > next…however the PHP all looks OK to me.<br>> >> >> ><br>> >> >> ><br>> >> >> ><br>> >> >> > RonM2<br>> >> >> ><br>> >> >> ><br>> >> >> > This message and any attachment are intended solely for the addressee<br>> >> >> > and<br>> >> >> > may contain confidential information. If you have received this<br>> >> >> > message<br>> >> >> > in<br>> >> >> > error, please send it back to me, and immediately delete it. Please<br>> >> >> > do<br>> >> >> > not<br>> >> >> > use, copy or disclose the information contained in this message or in<br>> >> >> > any<br>> >> >> > attachment. Any views or opinions expressed by the author of this<br>> >> >> > email<br>> >> >> > do<br>> >> >> > not necessarily reflect the views of the University of Nottingham.<br>> >> >> > This message has been checked for viruses but the contents of an<br>> >> >> > attachment<br>> >> >> > may still contain software viruses which could damage your computer<br>> >> >> > system:<br>> >> >> > you are advised to perform your own checks. Email communications with<br>> >> >> > the<br>> >> >> > University of Nottingham may be monitored as permitted by UK<br>> >> >> > legislation.<br>> >> >> ><br>> >> >> > _______________________________________________<br>> >> >> > Xerte mailing list<br>> >> >> > Xerte@lists.nottingham.ac.uk<br>> >> >> > http://lists.nottingham.ac.uk/mailman/listinfo/xerte<br>> >> >> ><br>> >> >> > This message and any attachment are intended solely for the addressee<br>> >> >> > and<br>> >> >> > may contain confidential information. If you have received this<br>> >> >> > message<br>> >> >> > in<br>> >> >> > error, please send it back to me, and immediately delete it. Please<br>> >> >> > do<br>> >> >> > not<br>> >> >> > use, copy or disclose the information contained in this message or in<br>> >> >> > any<br>> >> >> > attachment. Any views or opinions expressed by the author of this<br>> >> >> > email<br>> >> >> > do<br>> >> >> > not necessarily reflect the views of the University of Nottingham.<br>> >> >> ><br>> >> >> > This message has been checked for viruses but the contents of an<br>> >> >> > attachment<br>> >> >> > may still contain software viruses which could damage your computer<br>> >> >> > system:<br>> >> >> > you are advised to perform your own checks. Email communications with<br>> >> >> > the<br>> >> >> > University of Nottingham may be monitored as permitted by UK<br>> >> >> > legislation.<br>> >> >> ><br>> >> >> ><br>> >> >> > _______________________________________________ Xerte mailing list<br>> >> >> > Xerte@lists.nottingham.ac.uk<br>> >> >> > http://lists.nottingham.ac.uk/mailman/listinfo/xerte This message and<br>> >> >> > any<br>> >> >> > attachment are intended solely for the addressee and may contain<br>> >> >> > confidential information. If you have received this message in error,<br>> >> >> > please<br>> >> >> > send it back to me, and immediately delete it. Please do not use,<br>> >> >> > copy<br>> >> >> > or<br>> >> >> > disclose the information contained in this message or in any<br>> >> >> > attachment.<br>> >> >> > Any<br>> >> >> > views or opinions expressed by the author of this email do not<br>> >> >> > necessarily<br>> >> >> > reflect the views of the University of Nottingham. This message has<br>> >> >> > been<br>> >> >> > checked for viruses but the contents of an attachment may still<br>> >> >> > contain<br>> >> >> > software viruses which could damage your computer system: you are<br>> >> >> > advised to<br>> >> >> > perform your own checks. Email communications with the University of<br>> >> >> > Nottingham may be monitored as permitted by UK legislation.<br>> >> >> ><br>> >> >> > _______________________________________________<br>> >> >> > Xerte mailing list<br>> >> >> > Xerte@lists.nottingham.ac.uk<br>> >> >> > http://lists.nottingham.ac.uk/mailman/listinfo/xerte<br>> >> >> ><br>> >> >> > This message and any attachment are intended solely for the addressee<br>> >> >> > and<br>> >> >> > may contain confidential information. If you have received this<br>> >> >> > message<br>> >> >> > in<br>> >> >> > error, please send it back to me, and immediately delete it. Please<br>> >> >> > do<br>> >> >> > not<br>> >> >> > use, copy or disclose the information contained in this message or in<br>> >> >> > any<br>> >> >> > attachment. Any views or opinions expressed by the author of this<br>> >> >> > email<br>> >> >> > do<br>> >> >> > not necessarily reflect the views of the University of Nottingham.<br>> >> >> ><br>> >> >> > This message has been checked for viruses but the contents of an<br>> >> >> > attachment<br>> >> >> > may still contain software viruses which could damage your computer<br>> >> >> > system:<br>> >> >> > you are advised to perform your own checks. Email communications with<br>> >> >> > the<br>> >> >> > University of Nottingham may be monitored as permitted by UK<br>> >> >> > legislation.<br>> >> >> ><br>> >> >> ><br>> >> >> > _______________________________________________ Xerte mailing list<br>> >> >> > Xerte@lists.nottingham.ac.uk<br>> >> >> > http://lists.nottingham.ac.uk/mailman/listinfo/xerte This message and<br>> >> >> > any<br>> >> >> > attachment are intended solely for the addressee and may contain<br>> >> >> > confidential information. If you have received this message in error,<br>> >> >> > please<br>> >> >> > send it back to me, and immediately delete it. Please do not use,<br>> >> >> > copy<br>> >> >> > or<br>> >> >> > disclose the information contained in this message or in any<br>> >> >> > attachment.<br>> >> >> > Any<br>> >> >> > views or opinions expressed by the author of this email do not<br>> >> >> > necessarily<br>> >> >> > reflect the views of the University of Nottingham. This message has<br>> >> >> > been<br>> >> >> > checked for viruses but the contents of an attachment may still<br>> >> >> > contain<br>> >> >> > software viruses which could damage your computer system: you are<br>> >> >> > advised to<br>> >> >> > perform your own checks. Email communications with the University of<br>> >> >> > Nottingham may be monitored as permitted by UK legislation.<br>> >> >> ><br>> >> >> > _______________________________________________<br>> >> >> > Xerte mailing list<br>> >> >> > Xerte@lists.nottingham.ac.uk<br>> >> >> > http://lists.nottingham.ac.uk/mailman/listinfo/xerte<br>> >> >> ><br>> >> >> > This message and any attachment are intended solely for the addressee<br>> >> >> > and<br>> >> >> > may contain confidential information. If you have received this<br>> >> >> > message<br>> >> >> > in<br>> >> >> > error, please send it back to me, and immediately delete it. Please<br>> >> >> > do<br>> >> >> > not<br>> >> >> > use, copy or disclose the information contained in this message or in<br>> >> >> > any<br>> >> >> > attachment. Any views or opinions expressed by the author of this<br>> >> >> > email<br>> >> >> > do<br>> >> >> > not necessarily reflect the views of the University of Nottingham.<br>> >> >> ><br>> >> >> > This message has been checked for viruses but the contents of an<br>> >> >> > attachment<br>> >> >> > may still contain software viruses which could damage your computer<br>> >> >> > system:<br>> >> >> > you are advised to perform your own checks. Email communications with<br>> >> >> > the<br>> >> >> > University of Nottingham may be monitored as permitted by UK<br>> >> >> > legislation.<br>> >> >> ><br>> >> >> ><br>> >> >><br>> >> >> _______________________________________________<br>> >> >> Xerte mailing list<br>> >> >> Xerte@lists.nottingham.ac.uk<br>> >> >> http://lists.nottingham.ac.uk/mailman/listinfo/xerte<br>> >> ><br>> >> > This message and any attachment are intended solely for the addressee<br>> >> > and<br>> >> > may contain confidential information. If you have received this message<br>> >> > in<br>> >> > error, please send it back to me, and immediately delete it. Please do<br>> >> > not<br>> >> > use, copy or disclose the information contained in this message or in<br>> >> > any<br>> >> > attachment. Any views or opinions expressed by the author of this email<br>> >> > do<br>> >> > not necessarily reflect the views of the University of Nottingham.<br>> >> ><br>> >> > This message has been checked for viruses but the contents of an<br>> >> > attachment<br>> >> > may still contain software viruses which could damage your computer<br>> >> > system:<br>> >> > you are advised to perform your own checks. Email communications with<br>> >> > the<br>> >> > University of Nottingham may be monitored as permitted by UK<br>> >> > legislation.<br>> >> ><br>> >> ><br>> >> > _______________________________________________<br>> >> > Xerte mailing list<br>> >> > Xerte@lists.nottingham.ac.uk<br>> >> > http://lists.nottingham.ac.uk/mailman/listinfo/xerte<br>> >> ><br>> >> > This message and any attachment are intended solely for the addressee<br>> >> > and<br>> >> > may contain confidential information. If you have received this message<br>> >> > in<br>> >> > error, please send it back to me, and immediately delete it. Please do<br>> >> > not<br>> >> > use, copy or disclose the information contained in this message or in<br>> >> > any<br>> >> > attachment. Any views or opinions expressed by the author of this email<br>> >> > do<br>> >> > not necessarily reflect the views of the University of Nottingham.<br>> >> ><br>> >> > This message has been checked for viruses but the contents of an<br>> >> > attachment<br>> >> > may still contain software viruses which could damage your computer<br>> >> > system:<br>> >> > you are advised to perform your own checks. Email communications with<br>> >> > the<br>> >> > University of Nottingham may be monitored as permitted by UK<br>> >> > legislation.<br>> >> ><br>> >> ><br>> >><br>> >> _______________________________________________<br>> >> Xerte mailing list<br>> >> Xerte@lists.nottingham.ac.uk<br>> >> http://lists.nottingham.ac.uk/mailman/listinfo/xerte<br>> ><br>> > This message and any attachment are intended solely for the addressee and<br>> > may contain confidential information. If you have received this message in<br>> > error, please send it back to me, and immediately delete it. Please do not<br>> > use, copy or disclose the information contained in this message or in any<br>> > attachment. Any views or opinions expressed by the author of this email do<br>> > not necessarily reflect the views of the University of Nottingham.<br>> ><br>> > This message has been checked for viruses but the contents of an attachment<br>> > may still contain software viruses which could damage your computer system:<br>> > you are advised to perform your own checks. Email communications with the<br>> > University of Nottingham may be monitored as permitted by UK legislation.<br>> ><br>> ><br>> > _______________________________________________<br>> > Xerte mailing list<br>> > Xerte@lists.nottingham.ac.uk<br>> > http://lists.nottingham.ac.uk/mailman/listinfo/xerte<br>> ><br>> > This message and any attachment are intended solely for the addressee and<br>> > may contain confidential information. If you have received this message in<br>> > error, please send it back to me, and immediately delete it. Please do not<br>> > use, copy or disclose the information contained in this message or in any<br>> > attachment. Any views or opinions expressed by the author of this email do<br>> > not necessarily reflect the views of the University of Nottingham.<br>> ><br>> > This message has been checked for viruses but the contents of an attachment<br>> > may still contain software viruses which could damage your computer system:<br>> > you are advised to perform your own checks. Email communications with the<br>> > University of Nottingham may be monitored as permitted by UK legislation.<br>> ><br>> ><br>> <br>> _______________________________________________<br>> Xerte mailing list<br>> Xerte@lists.nottingham.ac.uk<br>> http://lists.nottingham.ac.uk/mailman/listinfo/xerte<br></div> </div></body>
</html>