[Catalyst] MojoMojo-0.999005 and mysql

[Matthias Zeichmann]

On 9/18/07, Josef Chladek <josef.chladek at gmail.com> wrote:
> hello,

hi,

> running mojomojo from the mojomojo.db file works, but if I setup a
> mysql-db and try to populate the db, it hangs with the following error:
>
> DBI Exception: DBD::mysql::st execute_array failed: Cannot add or
> update a child row: a foreign key constraint fails
> (`mojomojo`.`page_version`, CONSTRAINT `page_version_fk_page` FOREIGN
> KEY (`page`) REFERENCES `page` (`id`)) [err was 1452 now 1]
> executing 3 generated 3 errors [for Statement "INSERT INTO
> page_version (comments, content_version_first, content_version_last,
> created, creator, depth, name, name_orig, page, parent,
> parent_version, release_date, remove_date, status, version) VALUES
> (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"] at /Library/Perl/
> 5.8.6/DBIx/Class/Schema.pm line 940
>
> mysql is 5.1.15-beta on OS X 10.4.10
> anyone else seeing this?

yes, i am getting the same on mysql 5.0.38 and ubuntu feisty :
----------->8---------------------------------------
mz at wrk:script$ ./mojomojo_spawn_db.pl
Deploying schema to dbi:mysql:database=mojo;host=localhost
Creating initial data
DBIx::Class::Schema::populate(): DBI Exception: DBD::mysql::st
execute_array failed: Cannot add or update a child row: a foreign key
constraint fails (`mojo/page_version`, CONSTRAINT
`page_version_fk_page` FOREIGN KEY (`page`) REFERENCES `page` (`id`))
[err was 1452 now 1]
executing 3 generated 3 errors [for Statement "INSERT INTO
page_version (comments, content_version_first, content_version_last,
created, creator, depth, name, name_orig, page, parent,
parent_version, release_date, remove_date, status, version) VALUES (?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"] at ./mojomojo_spawn_db.pl
line 51
mz at wrk:script$
----------->8---------------------------------------
--
siggen.pl: Segmentation Fault