View Issue Details

WikiJump to Notes
IDProjectCategoryView StatusDate SubmittedLast Update
0015549Plugin - LinkedCustomFieldsGeneralpublic2013-02-27 09:292017-04-01 00:14
Reportervovella Assigned Torombert  
PriorityurgentSeverityblockReproducibilityalways
Status closedResolutionfixed 
Target Version1.0.1 
Summary0015549: Characters on target values is limited
Description

Can't use plugin with fields values more than 255 characters. How I can make more?

MySql talk that database.

TagsNo tags attached.
Attached Files
LinkedCustomField - prepare.png (102,370 bytes)   
LinkedCustomField - prepare.png (102,370 bytes)   
LinkedCustomField - result.png (87,757 bytes)   
LinkedCustomField - result.png (87,757 bytes)   
LinkedCustomField - mantis_plugin_LinkedCustomFields_data_table - doesnt exist.png (119,039 bytes)   
LinkedCustomField - mantis_plugin_LinkedCustomFields_data_table - doesnt exist.png (119,039 bytes)   
LinkedCustomField - mantis_plugin_LinkedCustomFields_data_table - cant change paramentr.png (122,531 bytes)   
LinkedCustomField - mantis_plugin_LinkedCustomFields_data_table - cant change paramentr.png (122,531 bytes)   

Relationships

Relationship GraphDependency Graph
has duplicate 0019375 closedrombert Link Custom fields doesnt work when its linked to more than 3 values for a option 
has duplicate 0019677 closedrombert Limitation du nombre de valeurs à fitrer 

Activities

vovella

vovella

2013-03-01 06:00

reporter   ~0035337

Resolved!

In file LinkedCustomField.php need to change valuo of paraments varchar from default 255 to more, for example 2255.

        array( 'CreateTableSQL',
            array( plugin_table( 'data' ), "
                custom_field_id    I NOTNULL,
                custom_field_value_order    I NOTNULL,
                custom_field_value C(2255) NOTNULL DEFAULT \" '' \",
                target_field_id    I NOTNULL,
                target_field_values    C(2255) NOTNULL DEFAULT \" '' \"
            ")
        )
cdijoux

cdijoux

2015-07-17 05:55

reporter   ~0051087

In our case, the limit "2255" was also a problem.
I suggest to put "X" instead of "C(2255)". Mysql will put the column "target_field_values" as a text, with a higher limit.

For the column "custom_field_value", i don't think it's usefull to change his limit, because it refer to only ONE value of a custom_field (in mantis_custom_field_string_table.value), which is limited to 255, so if you don't upgrade this limit, it's not possible to have a value higher than 255 in the "custom_field_value".

Changes tested and working on our instance :
array( 'CreateTableSQL',
array( plugin_table( 'data' ), "
custom_field_id I NOTNULL,
custom_field_value_order I NOTNULL,
custom_field_value C(255) NOTNULL DEFAULT \" '' \",
target_field_id I NOTNULL,
target_field_values X NOTNULL DEFAULT \" '' \"
")
)
rombert

rombert

2015-07-17 06:46

manager   ~0051089

I actually put XL in the fields, should be more than enough :-)