Code:
[11-Oct-2021 15:21:23 UTC] PHP Fatal error: 1406:Data too long for column 'shipping_method' at row 1 :: INSERT INTO zen_orders (customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, payment_module_code, shipping_method, shipping_module_code, coupon_code, cc_type, cc_owner, cc_number, cc_expires, date_purchased, orders_status, order_total, order_tax, currency, currency_value, ip_address) VALUES ('15', 'Jonathan Crossley', '', '2 Harrisons Farm', '', 'Oby', 'NR29 3BW', 'Norfolk', 'United Kingdom', '01493 369317', '[email protected]', '6', 'Jonathan Crossley', '', '2 Harrisons Farm', '', 'Oby', 'NR29 3BW', 'Norfolk', 'United Kingdom', '6', 'Jonathan Crossley', '', '2 Harrisons Farm', '', 'Oby', 'NR29 3BW', 'Norfolk', 'United Kingdom', '6', 'Cheque/Money Order', 'moneyorder', 'Royal Mail 1<sup>st</sup> Class <span style=\"font-weight: normal; font-style: italic\">"Large Letter"</span> (Great Britain and Northern Ireland only)', 'rm1stlargeletter', '', '', '', '', '', now(), '1', '2.45', '0', 'GBP', '1.00000000', '213.205.240.5 - 213.205.240.5') in /home/tuskerfu/public_html/atomicws/catalog/includes/classes/db/mysql/query_factory.php on line 101
I then decided to clean out the admin activity log (taking a backup of the database first). This had the unfortunate result of then preventing me from logging in to the admin site - took a snapshot of the log after the login attempt:
Bookmarks