[horde] Error when updating DB scheme for kronolith

MarkatOSI buy at mark.net
Sun Apr 10 22:50:49 UTC 2011

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.

More information about the horde mailing list