MojoMojo-0.999005 and mysql

[Josef Chladek-2]

hello,

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?

thanks
josef



_______________________________________________
List: Catalyst@...
Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst@.../
Dev site: http://dev.catalyst.perl.org/

[Matthias Zeichmann]

On 9/18/07, Josef Chladek <josef.chladek@...> 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@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@wrk:script$
----------->8---------------------------------------
--
siggen.pl: Segmentation Fault

_______________________________________________
List: Catalyst@...
Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst@.../
Dev site: http://dev.catalyst.perl.org/

[Marcus Ramberg-3]

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@...> wrote:

> On 9/18/07, Josef Chladek <josef.chladek@...> 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@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@wrk:script$
> ----------->8---------------------------------------
> --
> siggen.pl: Segmentation Fault
>
> _______________________________________________
> List: Catalyst@...
> Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst
> Searchable archive: http://www.mail-archive.com/catalyst@.../
> Dev site: http://dev.catalyst.perl.org/
>

--
With regards
Marcus Ramberg

_______________________________________________
List: Catalyst@...
Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst@.../
Dev site: http://dev.catalyst.perl.org/

[Marcus Ramberg-3]

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@...> 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@...> wrote:
> > On 9/18/07, Josef Chladek <josef.chladek@...> 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@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@wrk:script$
> > ----------->8---------------------------------------
> > --
> > siggen.pl: Segmentation Fault
> >
> > _______________________________________________
> > List: Catalyst@...
> > Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst
> > Searchable archive: http://www.mail-archive.com/catalyst@.../
> > Dev site: http://dev.catalyst.perl.org/
> >
>
>
> --
> With regards
> Marcus Ramberg
>

--
With regards
Marcus Ramberg

_______________________________________________
List: Catalyst@...
Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst@.../
Dev site: http://dev.catalyst.perl.org/

[Josef Chladek-2]

Am 23.09.2007 um 13:17 schrieb 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

hello marcus,

sorry, but does not work on this end...

josef

mysql> create database mojomojo;
Query OK, 1 row affected (0.00 sec)

mysql> quit
Bye
home:/Users/josef/.cpan/build/MojoMojo-0.999006 root# /usr/bin/
perl5.8.6 script/mojomojo_spawn_db.pl
Deploying schema to dbi:mysql:database=mojomojo;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 (`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 script/
mojomojo_spawn_db.pl line 51
home:/Users/josef/.cpan/build/MojoMojo-0.999006 root#

_______________________________________________
List: Catalyst@...
Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst@.../
Dev site: http://dev.catalyst.perl.org/

[Marcus Ramberg-3]

On 9/23/07, Josef Chladek <josef.chladek@...> wrote:
> Am 23.09.2007 um 13:17 schrieb 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)
> sorry, but does not work on this end...

It worked on my end :( Anyways, I have now found a proper fix, which
does not depend on any deferring of reference checks, and works on
both mysql and Pg.  MojoMojo-0.999007.tar.gz  is now on it's way to
CPAN. Please test it and tell me everything is ok ;-)

--
With regards
Marcus Ramberg

_______________________________________________
List: Catalyst@...
Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst@.../
Dev site: http://dev.catalyst.perl.org/

[Josef Chladek-2]

Am 24.09.2007 um 01:37 schrieb Marcus Ramberg:

> On 9/23/07, Josef Chladek <josef.chladek@...> wrote:
>> Am 23.09.2007 um 13:17 schrieb 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)
>> sorry, but does not work on this end...
>
> It worked on my end :( Anyways, I have now found a proper fix, which
> does not depend on any deferring of reference checks, and works on
> both mysql and Pg.  MojoMojo-0.999007.tar.gz  is now on it's way to
> CPAN. Please test it and tell me everything is ok ;-)

yup, works now!

fyi, make test fails (not only in the newest version), any hints on  
that?
thanks
josef

t/c/page....................NOK 16#   Failed test 'Can show search page'
#   at t/c/page.t line 19.
     mojomojo.conf is the main configuration file and is in  
Config::General
[error] Caught exception in MojoMojo::Controller::Page->search "Can't  
use an undefined value as an ARRAY reference at /Library/Perl/5.8.6/
Plucene/Search/BooleanQuery.pm line 122."

#   Failed test 'can show inline search'
#   at t/c/page.t line 20.
# Looks like you failed 2 tests of 17.
t/c/page....................dubious
         Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 16-17
     mojomojo.conf is the main configuration file and is in  
Config::General
         Failed 2/17 tests, 88.24% okay

t/schema_DBIC_Attachment....Can't use an undefined value as a symbol  
reference at /Library/Perl/5.8.6/File/MMagic.pm line 576.
# Looks like your test died before it could output anything.
t/schema_DBIC_Attachment....dubious
         Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-12
         Failed 12/12 tests, 0.00% okay




_______________________________________________
List: Catalyst@...
Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst@.../
Dev site: http://dev.catalyst.perl.org/

[Marcus Ramberg-3]

On 9/24/07, Josef Chladek <josef.chladek@...> wrote:
>
> yup, works now!
>
> fyi, make test fails (not only in the newest version), any hints on
> that?

I assume that means something is wrong with your plucene installation.
Can you search from the web interface?

Marcus

>
> t/c/page....................NOK 16#   Failed test 'Can show search page'
> #   at t/c/page.t line 19.
>      mojomojo.conf is the main configuration file and is in
> Config::General
> [error] Caught exception in MojoMojo::Controller::Page->search "Can't
> use an undefined value as an ARRAY reference at /Library/Perl/5.8.6/
> Plucene/Search/BooleanQuery.pm line 122."
>
> #   Failed test 'can show inline search'
> #   at t/c/page.t line 20.
> # Looks like you failed 2 tests of 17.
> t/c/page....................dubious
>          Test returned status 2 (wstat 512, 0x200)
> DIED. FAILED tests 16-17
>      mojomojo.conf is the main configuration file and is in
> Config::General
>          Failed 2/17 tests, 88.24% okay
>
> t/schema_DBIC_Attachment....Can't use an undefined value as a symbol
> reference at /Library/Perl/5.8.6/File/MMagic.pm line 576.
> # Looks like your test died before it could output anything.
> t/schema_DBIC_Attachment....dubious
>          Test returned status 255 (wstat 65280, 0xff00)
> DIED. FAILED tests 1-12
>          Failed 12/12 tests, 0.00% okay
>
>
>
>
> _______________________________________________
> List: Catalyst@...
> Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst
> Searchable archive: http://www.mail-archive.com/catalyst@.../
> Dev site: http://dev.catalyst.perl.org/
>

--
With regards
Marcus Ramberg

_______________________________________________
List: Catalyst@...
Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst@.../
Dev site: http://dev.catalyst.perl.org/