Ticket #52 (closed Bug report: Fixed)

Opened 13 years ago

Last modified 12 years ago

Problem when User and Owner are same for more than one node

Reported by: infil00p Owned by: fproulx
Priority: normal Milestone: WifiDog Auth Server 1.0
Component: Auth server, Content Management Version: Auth Server SVN
Keywords: Cc:

Description (last modified by max-horvath) (diff)

When managing nodes, we managed to get this error out
of our devauth server.

ExecSqlUniqueRes() : An error occured while executing
the following SQL
query :
SELECT * FROM node_stakeholders WHERE is_owner = true AND
user_id='d84568f58b31a4b9571803049844ded0'

The query returned 2 results, although there should
have been only one.

ExecSqlUniqueRes(): The query returned 2 result(s) :
node_id user_id is_owner is_tech_officer
amherst d84568f58b31a4b9571803049844ded0 t t
MadisonJean d84568f58b31a4b9571803049844ded0 t t

Basically, on the dev-auth server amherst and
MadisonJean are two different networks both owned by
the same person and both maintained by the same person.
 However, for some reason this appeared.  It make sense
for the query to produce this result, but for some
reason it's not supported.  Pretty sure that this is a bug.

Change History

Changed 13 years ago by fproulx

Logged In: YES 
user_id=1245118

It appears it's simply because it should not use ExecSqlUniqueRes, but ExecSql 
instead, as this is totally normal to have many references.... Although I will add 
uniqueness referential integrity on the database to ensure we don't get duplicate 
on primary key (node_id, user_id)

Changed 13 years ago by fproulx

Logged In: YES 
user_id=1245118

It should be fixed in CVS.

Changed 13 years ago by fproulx

  • status changed from assigned to closed

Changed 13 years ago by anonymous

  • version changed from None to For 1.0
  • milestone set to WifiDog Auth Server 1.0

Changed 13 years ago by max-horvath

  • version changed from For 1.0 to Auth Server SVN
  • description modified (diff)
Note: See TracTickets for help on using tickets.