Hi,
I have just completed a long overdue upgrade from 1.3 to 1.5.7 c. Naturally there have been some teething issues. I am getting a couple of errors noted in the logs:
i) On completing a payment (I use the paypal express checkout module) there is fatal SQL error in the logs:
Unknown column 'language_code' in 'field list' :: INSERT INTO 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, language_code, order_weight) VALUES ('1', 'rez khan', '', '306 starkweather drive', '', 'beaver dam', '53916', 'Wisconsin', 'United States', '2066966606', 'r1234######################', '2', 'John Smith', '', '1234 New Drive', '', 'New Town', '12345', 'TX', 'United States', '2', 'John Smith', '', 123 New drive', '', 'New Town', '12345', 'TX', 'United States', '2', 'Credit Card', 'paypaldp', 'Store Pickup (Walk In)', 'storepickup', '', 'Visa', 'John Smith, 'XXXXXX', '', now(), '2', '0.01055', '0.00055', 'USD', '1.000000', '99.91.162.121 - 99.91.162.121', 'en', '0') ==> (as called by)
/home3/genesbea/public_html/genesweddingflorals/includes/functions/database.php
ii) On clicking on the orders link in the admin area I get the following error which prevents orders from being displayed:
Unknown column 'o.language_code' in 'field list' :: SELECT o.orders_id, o.customers_id, o.customers_name, o.payment_method, o.shipping_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, o.order_total, o.customers_company, o.customers_email_address, o.customers_street_address, o.delivery_company, o.delivery_name, o.delivery_street_address, o.billing_company, o.billing_name, o.billing_street_address, o.payment_module_code, o.shipping_module_code, o.orders_status, o.ip_address, o.language_code
FROM (orders o )
LEFT JOIN orders_status s ON (o.orders_status = s.orders_status_id AND s.language_id = 1) ORDER BY o.orders_id DESC ==> (as called by) /home3/genesbea/public_html/genesweddingflorals/GARDENIA/orders.php on line 1204 <== in /home3/genesbea/public_html/genesweddingflorals/includes/classes/db/mysql/query_factory.php on line 170.
The URL of the shopping cart is https://genesweddingflorals.com/index.php.
PHP version is 7.2
Plugins : Zipship/Paypal Express
Bookmarks