Problem joing tables

[deanplayer]

Hello guys,

 

I have purchased some code to integreate PayPal Pro with my online shop (software: http://www.zenatdesign.com/PaypalProDemo/) and it is all installed and working correctly until the page it submits to PayPal. This is the error message I am receiving:

 

The query failed

· errorno=1054

· error=Unknown column 'shipping_address' in 'on clause'

 

SELECT

order_detail.id as order_id,

user_name,

item_total,

tax_total,

order_total,

shipping_total,

handling_total,

payer_id,

order_desc,

shipping_address,

billing_address,

status,

date_placed,

first_name,

last_name,

company,

email,

address.name as shipping_name,

address.street_1 as shipping_street_1,

address.street_2 as shipping_street_2,

address.city as shipping_city,

address.state as shipping_state,

address.zip as shipping_zip,

address.country as shipping_country,

billing.name as billing_name,

billing.street_1 as billing_street_1,

billing.street_2 as billing_street_2,

billing.city as billing_city,

billing.state as billing_state,

billing.zip as billing_zip,

billing.country as billing_country,

order_item.quantity as item_quantity,

item.id as item_id,

item.name as item_name,

item.desc as item_desc,

item.amount as item_amount,

item.tax as item_tax,

item.weight as item_weight

FROM

order_detail,

order_item

INNER JOIN address ON address.id=shipping_address

INNER JOIN address AS billing ON billing.id=billing_address

INNER JOIN item ON order_item.order_id=order_detail.id AND item.id=order_item.item_id

WHERE

user_name='ophuy7bd887qp7m'

 

I have checked the database and shipping_address exists in the order_detail table. I have also tried INNER JOIN address ON address.id=order_detail.shipping_address but still no luck.

 

Can anyone see anything wrong with this query?

 

Thanks - this is sending me nuts!