search

TromsFylkestrafikk / ragnarok-ruter

Ruter sink for Ragnarok
GNU General Public License v3.0
0 stars 0 forks source link

Too short string column in ruter_transactions.cs_comment #7

Closed tfk-kaare closed 1 year ago

tfk-kaare commented 1 year ago

Problem / Motivation

String data, right truncated: 1406 Data too long for column 'cs_comment' at row 1 (Connection: mysql, SQL: insert into `ruter_transactions` (`order_id`, `order_date`, `order_time`, `order_status`, `payer_app_id`, `payer_platform`, `payer_version`, `payer_phone_type`, `app_id`, `app_instance_id`, `payer_id`, `payment_id`, `payment_method`, `payment_status`, `amount`, `vat`, `vat_percentage`, `credit_amount`, `transaction_type`, `ticket_number`, `ticket_type`, `ticket_type_id`, `ticket_status`, `owner`, `valid_from`, `valid_to`, `stop_from`, `stop_to`, `zone_from`, `zone_to`, `zones`, `zones_all`, `event_time`, `distribution_type`, `cs_ordered_by`, `cs_comment`, `cs_invoice_ref`, `platform_version`)

A comment column should not be varchar, and certainly not only 45 characters wide.

Suggested resolution

Change the column type of cs_column to ->text()