Hello

I am using CBsubs for a congress registration, with sometimes A LOT of plans taken at the same time by a user (conferences, meals options, and so on).
I met an error when registering : "1406 - Data too long for column 'item_number' at row 1.
After a while I understood that the list of plans is too long for the 'item_number' in three tables
- item_number in _cbsubs_payment_baskets
- item_number in _cbsubs_payments
- item_number in _cbsubs_notifications

Thi column is a varchar of maxsize 255. In phpmyadmin I changed manually the maxsize to 1000 and it fixed it.
I don't think this is a problembut I prefer to have your opinion : do you see a flag ??

Best regards
Antoine

Thanks for your quick answer.But I'm not sure to follow you :- Here is me setting (CBSubs / Configuration / Display/ Invoices) :  

Here is what is stored in database  :


As you can see, the item_number contains a long list of artnum taken by the user.

Where am I wrong ?

---

Furthermore, can you confirm that the fact that I changed the maxsize of item_nuber column is not a big deal ?

Thanks a lot by advance !
Best regards !

Antoine

 

That item_number doesn't look correct. It shouldn't be a list of item numbers.

There may be something misconigurated, but I have no idea what or where. Does it come from my [INVOICENUMBER] set in CBSubs invoice configuration ? (see image in my second post)

Is that the only row that's invalid like that? What table specifically is that in?
 

this lont 'item_number' is exactly the same in three tables (and it seems logical)
- item_number in _cbsubs_payment_baskets
- item_number in _cbsubs_payments
- item_number in _cbsubs_notifications

Best regards
Antoine