[Xerte] Re: database.php

[Dave Burnett]

database_library itself fails (no echo from line 1) if I include this function:
function db_query($sql, $params = array()) {
If I take it out, the page returns various echos, including the call to db_query_one()
If I put db_query function back in, the page blows up.



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