Home› General support

Duplicate Administrator

Photoashes Member
in General support
Dear All,

I have copied data from one instance of Zenphoto to another. I copied across Albums, Cache and Backup.

I am trying to run the old backup in the new installation of Zenphoto but I get the following error:

INSERT INTO `zp_administrators` (`id`,`user`,`pass`,`name`,`email`,`rights`,`custom_data`,`valid`,`group`,`quota`) VALUES ("10","administrators",NULL,NULL,NULL,"0",NULL,"1",NULL,NULL) ) failed. Error: Duplicate entry 'administrators' for key 'user'

Is there anything I can do? I really want to restore all the comments and ratings that were attached to each image.

Thanks in advance,

Alex

Comments

  • sbillard Member
    Short answer is insatll the nightly build. If you do not want to do that, search the forum on this topic. There have been some work-arounds posted.

    BTW, this error is caused by upgrading from a much older version of Zenphoto. Depending on how old that version was, you may get some exceptions when you run the backup restore.
  • Photoashes Member
    Many thanks, I'll give the nb a crack. Previous version was 1.2.8.

    Just to confirm, install the nightly build on my new installation and then try to restore my old backup file?
  • sbillard Member
    No, restoring the database will just put the bad entries back. Just install the nightly build.
Sign In or Register to comment.