EMB01
asked on
DB Error: Constraint Violation (After Overwriting Files in Horde)
My host suggested I copy and the files that contained my old data from the old directory:
/old/var/lib/mysql/horde/m nemo_memos .MYD
/old/var/lib/mysql/horde/m nemo_memos .MYI
/old/var/lib/mysql/horde/m nemo_memos .frm
To the new files in the new directory:
/var/lib/mysql/horde/mnemo _memos.MYD
/var/lib/mysql/horde/mnemo _memos.MYI
/var/lib/mysql/horde/mnemo _memos.frm
I overwrite these without making a backup and now I need help.
When I overwrote mnemo_memos.MYD I could still add notes via Horde webmail. Then, I overwrote mnemo_memos.MYI and mnemo_memos.frm and I get the following error when I try to add a note in Horde:
There was an error saving the note: DB Error: constraint violation
Can someone please help me just to get this working again. It would be a plus if I could also get my old data saved, too. Thank you.
/old/var/lib/mysql/horde/m
/old/var/lib/mysql/horde/m
/old/var/lib/mysql/horde/m
To the new files in the new directory:
/var/lib/mysql/horde/mnemo
/var/lib/mysql/horde/mnemo
/var/lib/mysql/horde/mnemo
I overwrite these without making a backup and now I need help.
When I overwrote mnemo_memos.MYD I could still add notes via Horde webmail. Then, I overwrote mnemo_memos.MYI and mnemo_memos.frm and I get the following error when I try to add a note in Horde:
There was an error saving the note: DB Error: constraint violation
Can someone please help me just to get this working again. It would be a plus if I could also get my old data saved, too. Thank you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER