X-Cart forums

[MsBecky]

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]

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]

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