08 February 2010, 4:48

While trying to backing up the database Table in phpmyadmin we receive the following error #1062 - Duplicate entry '1' for key 1

for the table mahusr

 Any solutions are apprecited.

It is possible to remove the autoincrement and than you can copy the table but it is NOT possible to put the autoincrement in id back >> this results in the above error to!

 Thanks Andi 

15 March 2010, 16:02

Hi

Are you trying to backup and then restore back into your same Mahara database that already has data in it?

25 March 2010, 8:42

Hi,

 I have exactly the same problem. I just tried to copy my mahara database into a completely new and empty backup database and then this error according to the users table comes up:

'#1062 - Duplicate entry '1' for key 1'

The database is empty, so I don't really understand how this error can occur. I'd appreciate every help, because otherwise I can't upgrade my Mahara without losing the data of the users table.

 Greets

Sebastian