+- ZenphotoCMS Forum (https://forum.zenphoto.org)
+-- Forum: Support (https://forum.zenphoto.org/forum-1.html)
+--- Forum: General support (https://forum.zenphoto.org/forum-4.html)
+--- Thread: MySQL Errcode 17?? (/thread-606.html)
MySQL Errcode 17?? - dnathan - 2006-06-19
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
MySQL Errcode 17?? - trisweb - 2006-06-20
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
MySQL Errcode 17?? - dnathan - 2006-06-22
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