How do I Increase the max allowable character length

[MarlboroMan]

Good Day

 

How do I Increase the max allowable characters for the below fields 

 

Reference length limit to more than 32 Characters

Description limit to more than 6000 Characters

Product Name limit to more than 128 Characters

[vekia]

 

 

Reference length limit to more than 32 Characters

open classes/Product.php and change line:

'reference' =>                    array('type' => self::TYPE_STRING, 'validate' => 'isReference', 'size' => 32), 

to:

'reference' =>                    array('type' => self::TYPE_STRING, 'validate' => 'isReference', 'size' => 64),

then in shop database you have to change the definition of "reference" column from VARCHAR(32) to VARCHAR(64)

 

 

 

you can follow the same steps for other fields (btw. description does not have any limit)

[MarlboroMan]

Thank you.

Where do I find the reference column?

Will these settings change back with the next update?

I'm using PS V1.7.2.0

Edited July 29, 2017 by MarlboroMan (see edit history)

[MarlboroMan]

Hi

 

Where do I find the reference column mentioned at the start of this post?

Will these settings change back with the next update?

I'm using PS V1.7.2.0

[Scully]

When you edit products. Reference is the field for a product number.

Changes are overwritten by updates if you don't use the override directories.

[MarlboroMan]

Hi Scully

 

I'm trying to Increase Product Name limit to more than 128 Characters like mentioned above.

 

How do I do this so that it will not change back after an update? "Not sure how to use override directories in presta 1.7"

[Scully]

Read this:

 

http://doc.prestashop.com/display/PS16/Overriding+default+behaviors

 

and this...

 

http://developers.prestashop.com/themes/modules/overriding.html

 

Plenty of documentatino for overriding. It doesn't make sence to duplicate all the content from the refered pages.

[MarlboroMan]

open classes/Product.php and change line:

'reference' =>                    array('type' => self::TYPE_STRING, 'validate' => 'isReference', 'size' => 32), 

to:

'reference' =>                    array('type' => self::TYPE_STRING, 'validate' => 'isReference', 'size' => 64),

then in shop database you have to change the definition of "reference" column from VARCHAR(32) to VARCHAR(64)

 

 

 

you can follow the same steps for other fields (btw. description does not have any limit)

Hi Vekia

 

Where in the database do I find the "reference" column to change VARCHAR(32) to VARCHAR(64)? 

Edited October 7, 2017 by MarlboroMan (see edit history)

[Scully]

Sometimes I wonder about questions. To what kind of data does reference belong to?

If you can answer this question, you'll easily find the table related.

[jul57]

Have the same problem

 

Has anyone found a solution for this?

Edited November 8, 2017 by jul57 (see edit history)

[Amin Vatandoust]

To change the VARCHAR(32) in database, just follow these steps on phpMyAdmin:

1. Find "ps_product" table (or your custom prefix).

2. Click on + to open it.

3. Click on "Columns" and scroll down to find "reference" then click on it.

 

4. Now you can change Length to your custom character length.

That's all.

[stdeykun]

The reference field can be found in ps_product_attribute ( for combinations ) too.

[burakpresta3]

Hi @vekia, @Amin Vatandoust and all others, 

i dont want open a new topic,

i need to change the lenght of the customer service message (contact us), they are sending spams. if i make the "char size" smaller it is going to be better. 

under 

classes/customermessege .php 

            'message' => array('type' => self::TYPE_STRING, 'validate' => 'isCleanHtml', 'required' => true, 'size' => 16777216),
but it gives 500error, if char size bigger then this value, will you please help ? 

 

version 1.7.6.4

thank you very much. 

[burakpresta3]

any idea about changing customer message size ?  for 1.7.6.4

[Amin Vatandoust]

@burakpresta3 I have no idea about it. you may need to turn on debug and check what is the error. But, if you want to avoid spams, why you are not trying google reCAPTCHA?