X-Cart: shopping cart software

X-Cart forums (https://forum.x-cart.com/index.php)
-   Changing design (https://forum.x-cart.com/forumdisplay.php?f=51)
-   -   Increase Character Limit In Product Review Field (https://forum.x-cart.com/showthread.php?t=53644)

MsBecky 05-07-2010 02:11 PM

Increase Character Limit In Product Review Box
 
Hello Fellow X-Cart Members,

We have BCS Advanced Product Ratings and Reviews installed.

Can someone please tell me where to go, so that I can increase the character limit for the text field box, for customer reviews.
Each time someone leaves a review, it gets cut off.

Thanks in advance for your help :-)

- Becky -

Asiaplay 05-08-2010 01:29 AM

Re: Increase Character Limit In Product Review Field
 
Hi Becky,

I don't have this mod (and I guess not too many people do)- so ultimately BCS could answer the exact location.

However, you could try the following:-
Background: Generally a field's text length is controlled by, what a field's "type" is set to within your SQL table - so you will need to use PHPMyAdmin or similar to log-in and browse your SQL tables to change the field "type".

I would look in the "xcart_product_reviews" SQL table to make sure that when viewing structure, the field "type" for that field you want longer text for, is set to "text" (if you want a lot of text) or "varchar(255}" if you only want 255 letters.

This should fix this problem... unless BCS have added a "truncate" setting in the template. so that when you import reviews data, it cuts the amount of text imported (but I doubt there will be).
Note: if the first step doesn't fix it - then look in the template file for the truncate code and remove it.

Hope this helps - cheers, Asiaplay

MsBecky 05-20-2010 10:33 AM

Re: Increase Character Limit In Product Review Field
 
Quote:

Originally Posted by Asiaplay
Hi Becky,

I don't have this mod (and I guess not too many people do)- so ultimately BCS could answer the exact location.

However, you could try the following:-
Background: Generally a field's text length is controlled by, what a field's "type" is set to within your SQL table - so you will need to use PHPMyAdmin or similar to log-in and browse your SQL tables to change the field "type".

I would look in the "xcart_product_reviews" SQL table to make sure that when viewing structure, the field "type" for that field you want longer text for, is set to "text" (if you want a lot of text) or "varchar(255}" if you only want 255 letters.

This should fix this problem... unless BCS have added a "truncate" setting in the template. so that when you import reviews data, it cuts the amount of text imported (but I doubt there will be).
Note: if the first step doesn't fix it - then look in the template file for the truncate code and remove it.

Hope this helps - cheers, Asiaplay


Hi Asiaplay,

Thank you very much for taking the time to reply :)
I received the following reply from Carrie @BCSE

The mod uses a "text" field which should be very large and should not run out. The actual size is dependent on the server and server settings within mysql. You could ask your host what the "max_allowed_packet" size is for the mysql client and server.

I hope this helps!

Carrie

---
So, I asked our host and received the info. Now just waiting for Carrie's reply. I'll keep ya posted!

Thanks Again - Becky


All times are GMT -8. The time now is 03:50 PM.

Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.