[Erp5-dev] Path length

Romain Courteaud romain at nexedi.com
Mon Jul 4 16:14:19 CEST 2005


Hi all,

I'm currently playing with a high simulation depth, and I'm encountering 
problem with the catalog.
Some of my objects in my test can have a path up to 443 characters, but 
type of columns relative_url and path in the table catalog are VARCHAR(255).
So, portal catalog does not work very well in this case.

Example:
/erp5/portal_simulation/37/1_movement_1_2_0/default_transformation_sourcing_rule/transformation_source/default_transformation_rule/modified_resource_piquage/default_transformation_sourcing_rule/transformation_source/default_transformation_rule/modified_resource_coupage/default_transformation_sourcing_rule/transformation_source/default_transformation_rule/consumed_resource_copy_of_2/default_transformation_sourcing_rule/transformation_source

What must I do in this situation ?
Change the type of the columns to TEXT ?
Cut the ID of my objects ?

Romain



More information about the Erp5-dev mailing list