Increasing character limit for futures

Store Builder Questions
1

I am using the features section to list ingredients however it seems that after a certian lenght of text it is trunicated. Is there anyway to make the maximum text lenght longer?



Thanks,

2

Edit the character limit in the database.

3

Another possibility if you do not want to mess with the database is to create a Recipes block in Design->Blocks with ‘Block content’ set to “Unique HTML block”. You could then enter your recipes with whatever formatting you like.



If you are intent on putting your recipes into the feature tab, you will ned to change the ‘value’ field in cscart_product_features_values from varchar(255) to text. Make sure to backup the table before you start changing things.



Bob

4

thanks jobosales, I had to remove a few indexes of the ‘value’ field to allow the convert to type ‘text’ . My understanding is that indexes help to speed up the parsing and finding of field data correct? So other then a slow down in performance if I get a large number of enteries I should be fine right? I have done a fair bit of testing and can’t see any change in performace or function. If I am out to lunch and really need to put the indexes back in please let me know.



Thanks,

5

I would be very reluctant to remove an index - they exist as a means to lookup information. If a key is constructed programmatically and returns an empty result, your record is unavailable. Even if it works today, there is no assurance that future code changes might not rely on this index existing.



I see only one index where ‘value’ is used: the ‘fl’ key. I would add it back. If it is not currently used, there should be no implications; if it is used somewhere, those searches might take a bit longer with TEXT instead of VARCHAR(255).



You can get some insight into the performance issues here:

[url]MySQL :: MySQL Forums :: Performance



Bob

6

Thanks,



with ‘fl’ being a key I can’t add an index of ‘value’ in the TEXT format because there is no specified lenght. I get the error "#1170 - BLOB/TEXT column ‘value’ used in key specification without a key length ". So to have an index of ‘value’ in the ‘fl’ key the longest it can be is VARCHAR(328 ) which is not long enough. I would need around VARCHAR(1000). So with adding the ingredients via the features tab out I tryed your other sugestion of adding a custom block (which would work fine, thank you i never thought of that). However when I go to Design ->Blocks->Add a block I don’t find an HTML or Unique HTML Block option in the block content pull down. do I need to turn on a setting somwhere? Thanks,

7

What version are you running? HTML blocks were added in 2.0.9.



Bob

8

Thanks, I updated to 2.0.12 from 2.0.8 (I was dreading this as I have made quite a few custom mods, but the update process went really smooth) and now have all i need. Thanks again.