[Catalyst] MojoMojo-0.999005 and mysql

[Marcus Ramberg]

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 <marcus.ramberg at gmail.com> 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 <matthias at volltext.net> wrote:
> > 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
> >
> > _______________________________________________
> > List: Catalyst at 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