dreamsfloat Posted February 13, 2010 Share Posted February 13, 2010 I have had a few people write a comment in the comment box during checkout and I only get half of what they write. The weird thing is it is not the same amount of characters every time. I looked all through the admin area and I didn't see where to change this. I don't know if I have to go into the code to change it or what. If you have any ideas, please let me know. Thanks! Link to comment Share on other sites More sharing options...
johnnybebad Posted February 13, 2010 Share Posted February 13, 2010 I have had a few people write a comment in the comment box during checkout and I only get half of what they write. The weird thing is it is not the same amount of characters every time. I looked all through the admin area and I didn't see where to change this. I don't know if I have to go into the code to change it or what. If you have any ideas, please let me know. Thanks! You need to check your database table orders_status_history to see how many characters the comments field accepts and increase it, if there is no limit then it must be a setting elsewhere I guess, let us know how you get on. Getting better with mods but no programmer am I. Link to comment Share on other sites More sharing options...
dreamsfloat Posted February 22, 2010 Author Share Posted February 22, 2010 You need to check your database table orders_status_history to see how many characters the comments field accepts and increase it, if there is no limit then it must be a setting elsewhere I guess, let us know how you get on. I went into MySQL and found the orders_status_history table. I found the comment column, but I can't figure out how to increase it. I don't know databases really well. It says Null - yes and under the column Default it says NULL. The Cardinality is None. I don't know what to change. Thanks for your help! Link to comment Share on other sites More sharing options...
Guest Posted February 22, 2010 Share Posted February 22, 2010 Brooke, There doesn't seem to be a limitation in the SQL table for the comment box. However, the text box itself may be the restriction. In catalog>checkout_payment.php you will see this line. <td><?php echo tep_draw_textarea_field('comments', 'soft', '60', '5'); ?></td> Try increasing the comment box parameters (columns 60, rows 5). I am not sure this will work as I have never had this issue come up before, this is all I can think of at the moment. Chris Link to comment Share on other sites More sharing options...
dreamsfloat Posted February 23, 2010 Author Share Posted February 23, 2010 I changed the column to 100 and the row to 50 and it didn't change it. I have added some contributions maybe that messed it up. Link to comment Share on other sites More sharing options...
dreamsfloat Posted February 23, 2010 Author Share Posted February 23, 2010 I went into all the product tables and order tables and changed every row that had something to do with options and it worked! Thanks for the idea. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.