#1603: Can't make rootColumnName within NestedSet a reference to id of another
table
--------------------------+-------------------------------------------------
Reporter: dream0r | Owner: jwage
Type: enhancement | Status: closed
Priority: minor | Milestone: 1.1.0
Component: Behaviors | Version: 1.0.3
Resolution: fixed | Keywords:
Has_test: 0 | Mystatus: Pending Core Response
Has_patch: 0 |
--------------------------+-------------------------------------------------
Changes (by jwage):
* status: new => closed
* resolution: => fixed
Old description:
> I would like to use a NestedSet table together with another table. I
> tried to create a reference on menu_id (the rootColumnName) to the Menu
> table. This table allows me to save different trees as different 'menus'.
> YAML:
>
> ----
>
> {{{
> detect_relations: true
>
> Menu:
> columns:
> title:
> type: string(255)
> MenuItem:
> actAs:
> NestedSet:
> hasManyRoots: true
> rootColumnName: menu_id
> columns:
> title:
> type: string(255)
> menu_id:
> }}}
>
> ----
>
> Above fails because NestedSet template creates a int root column with 4
> bytes size instead of 8 bytes. The columns don't match cause of their
> length.
>
> '''Solution: let the nestedset template create a root column with a 8
> bytes size.'''
New description:
I would like to use a NestedSet table together with another table. I tried
to create a reference on menu_id (the rootColumnName) to the Menu table.
This table allows me to save different trees as different 'menus'. YAML:
----
{{{
detect_relations: true
Menu:
columns:
title:
type: string(255)
MenuItem:
actAs:
NestedSet:
hasManyRoots: true
rootColumnName: menu_id
columns:
title:
type: string(255)
menu_id:
}}}
----
Above fails because NestedSet template creates a int root column with 4
bytes size instead of 8 bytes. The columns don't match cause of their
length.
'''Solution: let the nestedset template create a root column with a 8
bytes size.'''
--
Comment:
In r5227 this was fixed.
--
Ticket URL: <http://trac.doctrine-project.org/ticket/1603#comment:2>
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
-~----------~----~----~----~------~----~------~--~---
