[Tickets #10027] Re: ingo-convert-prefs-to-sql fails

[bugs at horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/10027
------------------------------------------------------------------------------
  Ticket             | 10027
  Updated By         | neil.fagan at wenn.com
  Summary            | ingo-convert-prefs-to-sql fails
  Queue              | Ingo
  Version            | 2.0.1
  Type               | Bug
  State              | Resolved
  Priority           | 3. High
  Milestone          |
  Patch              |
  Owners             | Michael Slusarz
------------------------------------------------------------------------------


neil.fagan at wenn.com (2011-05-03 10:06) wrote:

> Changes have been made in Git for this ticket:
>
> Bug #10027: Fix call to setAuth()
>
>  14 files changed, 25 insertions(+), 20 deletions(-)
> http://git.horde.org/horde-git/-/commit/3abbb978412cf263e57ab50fdd0cfa7f35760997

applied change, however script still fails to update prefs into sql.
get the following output when script is executed
Converting filters for user: accounts.....
[ ERROR! ] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate
            entry 'accounts' for key 1

[ ERROR! ] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate
            entry 'accounts' for key 1
done
Converting filters for user: joe.bloggs.....
[ ERROR! ] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate
            entry 'accounts' for key 1

[ ERROR! ] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate
            entry 'accounts' for key 1
done

This is repeated for every user in the list.
Upon examining the mysql ingo_rules table, every row is assigned  
(column rule_owner) to the initial user in the list and all the  
rule_conditions couumns are blank (text - a:0:{} ).