+- 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: Creating tables mysql error (/thread-913.html)
Creating tables mysql error - katie - 2006-11-26
The message I get when I hit go is:
MySQL Query ( ALTER TABLE comments ADD CONSTRAINT comments_ibfk_1 FOREIGN KEY (imageid) REFERENCES images (id) ON DELETE CASCADE ON UPDATE CASCADE; ) Failed. Error: Key column 'imageid' doesn't exist in table
I don't know whats wrong. Please help?
Creating tables mysql error - ed2 - 2006-11-26
If you are on the "go" page, this is an install, right? Hate to be pedantic, but did you create an MySQL table on your server and update the zp_config file with the table name, MySQL server URL, username and password?
Creating tables mysql error - katie - 2006-11-26
Yeah I did. I actually have a hosted site, not a domain, so I don't know if thats part of the problem. But yeah, I got the person who own the website to set one up for me.
Creating tables mysql error - ed2 - 2006-11-27
Mine's hosted as well, although my host gives me the ability to create my own tables... In my install, the SQL server URL was not the same (not even close) to my URL. Are you sure the SQL server URL works? Does your host have any facilities for looking at the table and verifying the table name, password, etc?
Creating tables mysql error - trisweb - 2006-11-28
That message means that the communication to the MySQL server is indeed working, so that's not the problem.
It sounds like the 'comments' table did not get created correctly... is there a way you can look at the database, through PhpMyAdmin for example?