chrisbeau Posted June 13, 2011 Share Posted June 13, 2011 1054 - Unknown column 's.public_flag' in 'where clause' select o.orders_id, o.date_purchased, o.delivery_name, o.delivery_country, o.billing_name, o.billing_country, ot.text as order_total, s.orders_status_name from orders o, orders_total ot, orders_status s where o.customers_id = '2' and o.orders_id = ot.orders_id and ot.class = 'ot_total' and o.orders_status = s.orders_status_id and s.language_id = '1' and s.public_flag = '1' order by orders_id desc limit 3 [TEP STOP] If customers click "my account" (account.php) while they have an order placed, the above error is given. Any help appriciated ! Link to comment Share on other sites More sharing options...
germ Posted June 13, 2011 Share Posted June 13, 2011 Read this If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you. "Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice." - Me - "Headers already sent" - The definitive help "Cannot redeclare ..." - How to find/fix it SSL Implementation Help Like this post? "Like" it again over there > Link to comment Share on other sites More sharing options...
chrisbeau Posted June 13, 2011 Author Share Posted June 13, 2011 1054 - Unknown column 's.public_flag' in 'where clause' select count(*) as total from orders o, orders_total ot, orders_status s where o.customers_id = '2' and o.orders_id = ot.orders_id and ot.class = 'ot_total' and o.orders_status = s.orders_status_id and s.language_id = '1' and s.public_flag = '1' Clicking view all orders gives a similar error. Link to comment Share on other sites More sharing options...
chrisbeau Posted June 13, 2011 Author Share Posted June 13, 2011 Read this Thank you very much. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.