How to to increase text limit in Seller/Buyer Feedback

[Marshal Halloway]

It seems to be a limited space for feedback in Classifieds. Is there a way to increase this limit?

Since a user can only give one feedback to a seller/buyer and edit or update for later transactions, there should be more space for text.

I realized this today after giving a seller a feedback. When saving, it cut my feedback in half and also in a middle of a word.

There should also be a way to tell the person that there is a limit as well.

[Chuck S]

Okay using phpmyadmin you can do this as it is currently a 255character varchar field and thats the max for that field

ALTER TABLE class_feedback CHANGE comment comment TEXT

change the prefix to your table prefix

[Marshal Halloway]

Guess I am a little lost here.

I opened pp_feedback and tried to change 255 to 600, but MySql gives me a error message

MySQL said: Documentation
#1074 - Too big column length for column 'comment' (max = 255). Use BLOB instead.

That probably means that I don't do this right and misunderstood your advise.

[Chuck S]

You need to use the query I posted to alter the table. a varchar field only goes to 255 so you can not make it 600. You need to alter that field to a text field which has no length. If your using the default prefix try this

ALTER TABLE pp_feedback CHANGE comment comment TEXT

[Marshal Halloway]

Got it fixed. Thanks.