[horde] Error when updating DB scheme for kronolith

[LALOT Dominique]

Hello Ronan,

Thanks a lot it solved also my problem.

Dom

2011/4/11 MarkatOSI <buy at mark.net>

>
> Problem solved. I found a similar situation described in another posting
>
> "I'm having the same issue :
> SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry
> 'Nmaurice' for key 'rampage_users_user_name'
>
> But over here nmaurice is a user and in our case, I'm guessing that
> this user usually logs in as 'nmaurice', and logged in at least once
> as 'Nmaurice'.
>
> After running the following query, the migrate script was happy.
> mysql> update kronolith_events set
> event_creator_id=lower(event_creator_id);
>
> Hope this helps,
> Ronan. "
>
>
> I had to run similar commands over all of the kronolith tables and columns
> which contained user ids. After that the schema updated correctly
> --
> View this message in context:
> http://old.nabble.com/Error-when-updating-DB-scheme-for-kronolith-tp31360171p31366218.html
> Sent from the Horde - General mailing list archive at Nabble.com.
>
> --
> Horde mailing list
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
>



-- 
Dominique LALOT
Ingénieur Systèmes et Réseaux
http://annuaire.univmed.fr/showuser.php?uid=lalot