MHL3060 / bentux

Automatically exported from code.google.com/p/bentux
0 stars 0 forks source link

can't update the description box with a longer input in productform. #79

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
[tux] ERROR [btpool0-22] ProductFormController.onSubmit(172) | 
org.springframework.dao.DataIntegrityViolationException: Hibernate flushing: 
Could not execute JDBC batch update; SQL [update product set availability=?, 
barcode=?, brand_name_id=?, day_life=?, description=?, discount_price=?, 
multiple_special_count=?, name=?, price=?, rating=?, sku=?, special_end=?, 
special_start=? where id=?]; Data truncation: Data too long for column 
'description' at row 1; nested exception is java.sql.BatchUpdateException: Data 
truncation: Data too long for column 'description' at row 1

To reproduce:
1. go to productform either add/edit an existing
2. write a longer string or something in the box.
3. save button.
4. get a error msg " object.exists" 

Original issue reported on code.google.com by lhkh...@gmail.com on 3 Oct 2010 at 9:00

GoogleCodeExporter commented 9 years ago
fixed.
now the description is limited to 2000 characters. If you enter more than 2000 
characters, it will failed the validation and prompt for correction.

Original comment by benli3...@gmail.com on 6 Oct 2010 at 2:31

GoogleCodeExporter commented 9 years ago
It takes more words more now but definitely far less than 2000 characters. I 
tired putting your statement above and it complaints and already complaining.

Original comment by lhkh...@gmail.com on 7 Oct 2010 at 4:20

GoogleCodeExporter commented 9 years ago
an exception stack would be helpful.

I am sure I have fixed the description issue.

Original comment by benli3...@gmail.com on 7 Oct 2010 at 4:30