#1351: Fixtures for Searchable on I18n with MySQL InnoDB cause MySQL error
----------------------------+-----------------------------------------------
Reporter: eXtreme | Owner: jwage
Type: defect | Status: new
Priority: blocker | Milestone: 1.0.1
Component: Data Fixtures | Version: 1.0
Resolution: | Keywords: searchable, i18n, fixtures
Has_test: 0 | Mystatus: Pending Core Response
Has_patch: 0 |
----------------------------+-----------------------------------------------
Comment (by eXtreme):
I have this problem in stable 0.11, 1.0 betas and SVN 1.0 branch.
"The issue is that since the parent object to the translations doesn't
have any columns set on it, it is not saved and the child translations
fail because the parent object doesn't exist."
In this example - propably yes, but I have the same problem with larger
parent table, with fields which are not I18nzed, with nestedset enabled
etc.
"This should be working in 1.0 branch"
The same code as presented in ticket and the newest SVN version - problem
still exists.
{{{
F:\downloads\scripts\doctrine\dev>php test.php build-all-reload
build-all-reload - Are you sure you wish to drop your databases? (y/n)
y
build-all-reload - Successfully dropped database for connection "0" named
"test_doctrine"
build-all-reload - Generated models successfully from YAML schema
build-all-reload - Successfully created database for connection "0" named
"test_doctrine"
build-all-reload - Created tables successfully
SQLSTATE[HY000]: General error: 1452 Cannot add or update a child row: a
foreign key constraint fails (`test_doctrine/table3_translation`,
CONSTRAINT `table3_translation_ibfk_1` FOREIGN KEY (`id`, `lang`)
REFERENCES `table3_translation_index` (`id`, `lang`))
}}}
--
Ticket URL: <http://trac.phpdoctrine.org/ticket/1351#comment:6>
Doctrine <http://www.phpdoctrine.org>
PHP Doctrine Object Relational Mapper
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"doctrine-svn" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.co.uk/group/doctrine-svn?hl=en-GB
-~----------~----~----~----~------~----~------~--~---
