RP 4.1: Maximum number of letter in extra fields and line break

[snoopy5]

Hi

RP 4.1

When I enter a lot of text into an extra field of RP, it does not show every letter later on (see attachment the red circles)

a) How do I increase the number of letters allowed in the extra fields?


The extra fields have very early a line-break. The column for the predefinded text within the extra field is very small (see attachment the red arrow).

b) How do I enlarge this columns/ let the line break later happen in the text?

Thanks in advance

[Chuck S]

What is missing? There is no ine break there the description is limited to like 10% or something in the showproduct tempate leaving room for the data

I am not sure what your trying to show in your example as there is no max length field to my knowledge here other than possibly 255 characters on a varchar field in the database.

[snoopy5]

Originally Posted by Chuck S

What is missing? There is no ine break there the description is limited to like 10% or something in the showproduct tempate leaving room for the data
...

Where is this 10% defined (in which file and with which code). I would then change it i.e. to 50%..

Originally Posted by Chuck S

....
I am not sure what your trying to show in your example as there is no max length field to my knowledge here other than possibly 255 characters on a varchar field in the database.

mmmhhh

But there must be a reason why it does not show the whole text. The 2 fields I have market in red have bot below 60 letters (incl. blank spaces). So what could be then the reason that it is deleting text of those fields. Maybe the number of lines?

[Chuck S]

The extra fields all have 10% defined in the showproduct template which you can change. There is no size restriction on the additional extras we print the title and then the data

Content visible to verified customers only.

[snoopy5]

o.k., I got it with the change of the 10%. Looks better now.

But there is still the problem with the deleted text of the extra fields. Even now, when I add a few words in the fields and save it, the new words added do neither appear on the front end, nor when I go back in ACP in the category field itself. It is as I would have never entered them.

It is never above 100 letters incl. blank spaces. There is now also enough space to display within the template.

What could be the reason for this?

[Chuck S]

test - Omegatron.net Reviews

There are no limits I am seeing?

Post descriptions I posted are longer than yours the field is a varchar field limited in mysql to 255 characters.

[snoopy5]

Originally Posted by Chuck S

test - Omegatron.net Reviews

There are no limits I am seeing?

Post descriptions I posted are longer than yours the field is a varchar field limited in mysql to 255 characters.

mmmmhhh

are these the normal extra fields 1-6 or the additional fields?

When I made the same test, the normal extra fields seem to have a restriction, the additional fields not. See my screenshots.

Could be the reason for the normal extra fields, that in the upload window is not more space without a linebreak? See screenshot

[Chuck S]

The regular extra fields are VARCHAR 64 character fields. You would need to modify those to be bigger like this

ALTER TABLE rp_products CHANGE extra1 extra1 VARCHAR(255) DEFAULT NULL;
ALTER TABLE rp_products CHANGE extra2 extra2 VARCHAR(255) DEFAULT NULL;
ALTER TABLE rp_products CHANGE extra3 extra3 VARCHAR(255) DEFAULT NULL;
ALTER TABLE rp_products CHANGE extra4 extra4 VARCHAR(255) DEFAULT NULL;
ALTER TABLE rp_products CHANGE extra5 extra5 VARCHAR(255) DEFAULT NULL;
ALTER TABLE rp_products CHANGE extra6 extra6 VARCHAR(255) DEFAULT NULL;

[snoopy5]

Originally Posted by Chuck S

The regular extra fields are VARCHAR 64 character fields. You would need to modify those to be bigger like this

ALTER TABLE rp_products CHANGE extra1 extra1 VARCHAR(255) DEFAULT NULL;
ALTER TABLE rp_products CHANGE extra2 extra2 VARCHAR(255) DEFAULT NULL;
ALTER TABLE rp_products CHANGE extra3 extra3 VARCHAR(255) DEFAULT NULL;
ALTER TABLE rp_products CHANGE extra4 extra4 VARCHAR(255) DEFAULT NULL;
ALTER TABLE rp_products CHANGE extra5 extra5 VARCHAR(255) DEFAULT NULL;
ALTER TABLE rp_products CHANGE extra6 extra6 VARCHAR(255) DEFAULT NULL;

o.k., thanks.

If I would change this and next year a new RP version comes out, would this then give problems with the upgarde to the new version?

[snoopy5]

update:

I made a backup and then did this mysql query successfully. Now the appearance in the uplaod screen is better (see screenshot the added space A.).

But the field is still limited to 64 letters.

What else could be responsible for the 64 restriction? Is there anywhere in the code something hidden that limits the regular extra fields to 64 letters?

[Chuck S]

The 64 limit is not going to change old entered data

You need to edit those to what you wish after changing the database fields.

[snoopy5]

Originally Posted by Chuck S

...

You need to edit those to what you wish after changing the database fields.

I did that, but it still does not show the added words

[Chuck S]

ALTER TABLE rp_categories CHANGE extra1 extra1 VARCHAR(255) DEFAULT NULL;
ALTER TABLE rp_categories CHANGE extra2 extra2 VARCHAR(255) DEFAULT NULL;
ALTER TABLE rp_categories CHANGE extra3 extra3 VARCHAR(255) DEFAULT NULL;
ALTER TABLE rp_categories CHANGE extra4 extra4 VARCHAR(255) DEFAULT NULL;
ALTER TABLE rp_categories CHANGE extra5 extra5 VARCHAR(255) DEFAULT NULL;
ALTER TABLE rp_categories CHANGE extra6 extra6 VARCHAR(255) DEFAULT NULL;

[snoopy5]

Originally Posted by Chuck S

ALTER TABLE rp_categories CHANGE extra1 extra1 VARCHAR(255) DEFAULT NULL;
ALTER TABLE rp_categories CHANGE extra2 extra2 VARCHAR(255) DEFAULT NULL;
ALTER TABLE rp_categories CHANGE extra3 extra3 VARCHAR(255) DEFAULT NULL;
ALTER TABLE rp_categories CHANGE extra4 extra4 VARCHAR(255) DEFAULT NULL;
ALTER TABLE rp_categories CHANGE extra5 extra5 VARCHAR(255) DEFAULT NULL;
ALTER TABLE rp_categories CHANGE extra6 extra6 VARCHAR(255) DEFAULT NULL;

Yeeeeeeeeeeeeeeeeeeeeeeeeeesssssss!

That did the trick.

Thank you very much!

[Chuck S]

have a good weekend

[snoopy5]

Originally Posted by Chuck S

have a good weekend

thanks. you too.

I will testdrive & modify RP 4.1 the whole week-end...

[Chuck S]

Hopefully I will be relaxing the whole weekend