Paypal payments standard not recording orders in admin.

[DrByte]

[10-May-2016 10:22:13 America/Los_Angeles] PHP Fatal error: 1054:Unknown column 'o.shipping_method' 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, ot.text as 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.ip_address from (orders_status s, orders o ) left join orders_total ot on (o.orders_id = ot.orders_id and ot.class = 'ot_total') where (o.orders_status = s.orders_status_id and s.language_id = '1') order by o.orders_id DESC limit 0, 1 ==> (as called by) /home/bestfa7/public_html/newzen/zcadmin/orders.php on line 871 <== in /home/bestfa7/public_html/newzen/includes/classes/db/mysql/query_factory.php on line 155

The "unknown column" error means that your database query is looking for data from the mentioned field name (o.shipping_method refers to a field called "shipping_method" on the "orders" table) but the field is missing from that table in your database.

So, you'll need to put that field back (it's normally there in a fresh install of v1.5.4). Not sure how you ended up deleting it from your database table. It's pretty important.

Now, while this particular example of the error is showing up when using the Admin orders screen, the same problem will definitely affect checkouts, meaning you'll not have any sales recorded until you fix your database.