[Xerte] Re: database.php

[Pat Lockley]

did you put the error reporting line in?

On Sun, Apr 29, 2012 at 3:32 PM, Dave Burnett <d_b_burnett at hotmail.com> wrote:
>
> 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
>
> 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.
>
>