There is this error and can’t find a fix for this issue?
php -f bin/ubdatamigration run --step=7
[Processing][run] in step #7: ………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………
Status: fail
Message: CDbCommand failed to execute the SQL statement: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column ‘items_count’ at row 1. The SQL statement executed was: INSERT INTO `quote` (`store_id`, `is_active`, `is_virtual`, `is_multi_shipping`, `items_count`, `items_qty`, `orig_order_id`, `store_to_base_rate`, `store_to_quote_rate`, `grand_total`, `base_grand_total`, `customer_group_id`, `customer_note_notify`, `customer_is_guest`, `trigger_recollect`, `is_persistent`, `entity_id`, `created_at`, `updated_at`, `base_currency_code`, `store_currency_code`, `quote_currency_code`, `customer_tax_class_id`, `remote_ip`, `global_currency_code`, `base_to_global_rate`, `base_to_quote_rate`, `subtotal`, `base_subtotal`, `subtotal_with_discount`, `base_subtotal_with_discount`, `is_changed`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7, :yp8, :yp9, :yp10, :yp11, :yp12, :yp13, :yp14, :yp15, :yp16, :yp17, :yp18, :yp19, :yp20, :yp21, :yp22, :yp23, :yp24, :yp25, :yp26, :yp27, :yp28, :yp29, :yp30, :yp31)
You have new mail in /var/mail/www-data
1 answer
Hi there,
I am sorry for replying to you this late as our team has just been back from our weekend.
: 1264 Out of range value for column ‘items_count’ at row 1. The SQL statement executed was: INSERT INTO `quote` (`store_id`, `is_active`, `is_virtual`,
That issue occurred because your M1 database had at least one data record which had a very big value on the sales_flat_quote.items_count field.
That relates to the MySQL settings and data in your M1 database. You can take a look at a similar issue here.
You can consider updating the MySQL settings in your M2 server to handle for that case.
Or you can look at the data records in the ‘sales_flat_quote‘ table which has a very big value of ‘items_count’ field. And you can re-update the value of this field on found data records.
Then, you can continue with data migration in step #7 by running the CLI command:
php -f bin/ubdatamigration run --step=7;
Regards,
Mall.
