Wizbits Posted January 31, 2010 Share Posted January 31, 2010 At present I have tried everything on this RMA 2.6 install. I even started again 4 times..., each time it improves slightly. However I am getting SQL issues arrising and I know damn well I have done everything correctly... I am puzzled. My latest problem is:- 1054 - Unknown column 'o.contact_user_name' in 'field list' select o.returns_id, o.returns_status, o.customers_name, o.contact_user_name, o.rma_value, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.return_reason_name, op.final_price, o.returns_date_finished, rs.returns_status_name from returned_products o left join returns_products_data op on (o.returns_id = op.returns_id), return_reasons s , returns_status rs where o.returns_reason = s.return_reason_id and s.language_id = '1' and o.returns_status = rs.returns_status_id order by o.returns_id DESC limit 0, 20 [TEP STOP] I keep clearing up as I go but...... Help with thanks Quote Link to comment Share on other sites More sharing options...
Jan Zonjee Posted January 31, 2010 Share Posted January 31, 2010 However I am getting SQL issues arrising and I know damn well I have done everything correctly... Why do you get an error then that a column named contact_user_name is missing in the table orders? 1054 - Unknown column 'o.contact_user_name' in 'field list' Quote Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.