Project

General

Profile

Bug #234

can not delete users in prewikka

Added by prmarino1-gmail-com - almost 16 years ago. Updated about 14 years ago.

Status:
Closed
Priority:
High
Assignee:
Yoann VANDOORSELAERE
Target version:
0.9.12
Start date:
Due date:
% Done:

0%

Resolution:
fixed

Description

when trying to delete a user prewikka using postgresql returned this error

Traceback (most recent call last):
  File "/usr/lib/python2.4/site-packages/prewikka/Core.py", line 304, in process
    getattr(view_object, view[[handler]])()
  File "/usr/lib/python2.4/site-packages/prewikka/views/usermanagement.py", line 115, in render
    self.env.db.deleteUser(user)
  File "/usr/lib64/python2.4/site-packages/prewikka/Database.py", line 165, in deleteUser
    self.query("DELETE FROM Prewikka_Filter_Criterion USING Prewikka_Filter, Prewikka_Filter_Criterion " 
  File "/usr/lib64/python2.4/site-packages/prewikka/Database.py", line 131, in query
    raise [[PreludeDBError]](e.errno)
[[PreludeDBError]]: ERROR:  table name "prewikka_filter_criterion" specified more than once

the error is in Database.py in the deleteUser sub routine

attached is a patch built against prewikka 0.9.10

Database.py.diff View - postgresql delete user patch (779 Bytes) prmarino1-gmail-com -, 06/07/2007 05:41 AM

History

#1 Updated by Yoann VANDOORSELAERE almost 16 years ago

  • Status changed from New to Closed
  • Resolution set to fixed

(In r9564) Handle user deletion in a portable SQL way. Fix #234.

#2 Updated by Yoann VANDOORSELAERE almost 16 years ago

Thanks for reporting this!
The issue has been fixed using a different workaround that should work with any database backend. You can check r9564 for details.

Regards,

#3 Updated by Yoann VANDOORSELAERE about 14 years ago

  • Project changed from PRELUDE SIEM to Prewikka
  • Category deleted (5)
  • Target version deleted (0.9.12)

Also available in: Atom PDF