MySQL Errcode 17??

dnathan

Hi ZP Gurus,

I have installed successfully, and when I do the setup.php, I get this error:

zenphoto setup
Creating tables...
MySQL Query ( ALTER TABLE `comments` ADD CONSTRAINT `comments_ibfk_1` FOREIGN KEY (`imageid`) REFERENCES `images` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; ) Failed. Error: Error on rename of '.\wordpress\#sql-1138_9.MYI' to '.\wordpress\comments.MYI' (Errcode: 17)

not sure what it's about so any help would be greatly appreciated.

Thanks,
DAN

trisweb

Wow, that's very strange... Are you installing in the same database as Wordpress? If so, are the table names conflicting? Just to be sure, in config.php mysql section, set a table_prefix value that's not blank.

Let me know if that doesn't work

dnathan

Hi trisweb,

Many thanks for your response - yes I am using a prefix and it's set to "zp_" so I am pretty sure it's not conflicting names. Any other thoughts on this?

Cheers again,
DAN