Member
Member
katie   2006-11-26, 03:20
#1

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?

Member
Member
ed2   2006-11-26, 15:07
#2

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?

Member
Member
katie   2006-11-26, 21:50
#3

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.

Member
Member
ed2   2006-11-27, 23:00
#4

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?

Developer
Developer
trisweb   2006-11-28, 08:24
#5

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?

  
Powered By MyBB, © 2002-2026 MyBB Group.
Made with by Curves UI.