heavendragon / zfsecurity

Automatically exported from code.google.com/p/zfsecurity
Other
0 stars 0 forks source link

Unable to populate dummy data #23

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago
What steps will reproduce the problem?
1. getting files from repository
2. pointing url to
http://localhost/blog/zfsecurity/demo/public/setup/do/populate
3.

What is the expected output? What do you see instead?
Expected output, acording to video tutorial should be successufuly created
dummy data. I am getting this error: SQLSTATE[HY000]: General error: 1452
Cannot add or update a child row: a foreign key constraint fails
(`blog/post`, CONSTRAINT `post_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES
`user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)

What version of the product are you using? On what operating system?
I am using last files from repository on windows xp, MySQL Version 5.0.51b  

Please provide any additional information below.

Original issue reported on code.google.com by nezabor...@gmail.com on 25 Nov 2008 at 8:13

GoogleCodeExporter commented 8 years ago
I receive the same error when attempting to import dummy data:

   SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a 
child row: a foreign key constraint fails (`jeremyTest/post`, CONSTRAINT 
`post_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE 
CASCADE ON 
UPDATE CASCADE)

Database server info:

   Server version: 5.0.51a FreeBSD port: mysql-server-5.0.51a

Code version:

   r138 - http://code.google.com/p/zfsecurity/source/detail?r=138

Please let me know if there is anything I can do to help facilitate the testing 
of 
this problem, and if I come across the solution I will let you know.

Original comment by notmesse...@gmail.com on 6 Jan 2009 at 8:15