Applied a fix for mysql now, and released MojoMojo-0.999006.tar.gz to CPAN. Please test it and give me feedback. (Note,still dont have a working solution for Pg)
Marcus On 9/22/07, Marcus Ramberg <[EMAIL PROTECTED]> wrote: > Thanks for the report. I've been able to reproduce it on Postgresql as > well The problem is there's a circular dependency between page, > content and versions. I'll work on it tomorrow and try to get a > working version out to cpan. Will reply here when I do. > > Marcus > > On 9/19/07, Matthias Zeichmann <[EMAIL PROTECTED]> wrote: > > On 9/18/07, Josef Chladek <[EMAIL PROTECTED]> 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--------------------------------------- > > [EMAIL PROTECTED]: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 > > [EMAIL PROTECTED]:script$ > > ----------->8--------------------------------------- > > -- > > siggen.pl: Segmentation Fault > > > > _______________________________________________ > > List: Catalyst@lists.rawmode.org > > Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst > > Searchable archive: http://www.mail-archive.com/catalyst@lists.rawmode.org/ > > Dev site: http://dev.catalyst.perl.org/ > > > > > -- > With regards > Marcus Ramberg > -- With regards Marcus Ramberg _______________________________________________ List: Catalyst@lists.rawmode.org Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/catalyst@lists.rawmode.org/ Dev site: http://dev.catalyst.perl.org/