[Devel] [ openser-Bugs-1529368 ] avp_db_query() errors in the log

SourceForge.net noreply at sourceforge.net
Fri Jul 28 16:43:16 CEST 2006


Bugs item #1529368, was opened at 2006-07-26 20:37
Message generated for change (Comment added) made by goestelecom
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=743020&aid=1529368&group_id=139143

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: modules
Group: ver devel
Status: Open
Resolution: None
Priority: 5
Submitted By: Norman Brandinger (goestelecom)
Assigned to: Nobody/Anonymous (nobody)
Summary: avp_db_query() errors in the log

Initial Comment:
I am executing the following avp_db_query() and the
database is successfully updated.  This is a very good
thing.

avp_db_query("UPDATE mytable SET mycolumn = '$ru' WHERE
uuid = '$fU'");

However, a review of the log shows the following error
messages are produced:

openser[13427]: get_columns(): No columns
openser[13427]: convert_result(): Error getting column
names
openser[13427]: get_result(): Error while converting result
openser[13427]: avpops:db_query_avp: error - cannot do
the query

It appears that the "error" messages really aren't
errors at all.  Should avp_db_query() be modified to
take into account situations where no columns are being
returned (for example, in an UPDATE query)?  In such
situations, the log messages could be supressed.

Regards,
Norm

----------------------------------------------------------------------

>Comment By: Norman Brandinger (goestelecom)
Date: 2006-07-28 10:43

Message:
Logged In: YES 
user_id=1372252

Attached is a patch to modules/postgres/dbase.c that avoids
the errors in the log when there is no data returned from a
query such as (INSERT or UPDATE).

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=743020&aid=1529368&group_id=139143



More information about the Devel mailing list