SpirtouliS Posted March 27, 2008 Posted March 27, 2008 Hello, I'm new to OSC and to php and unfortunately to MySQL as well :blush: nevertheless i am trying by making a lot of backups to built an eshop for my friend the adress is http://www.hpbs.gr/index.php (for whom would like to see howi'm doing) i have encounder a problem which is as follows : 1054 - Unknown column 's.public_flag' in 'where clause' select count(*) as total from orders o, orders_status s where o.customers_id = '5' and o.orders_status = s.orders_status_id and s.language_id = '4' and s.public_flag = '1' [TEP STOP] I think that a column in the database is missing but i haven't made any changes to the database for that matter everything is working ok except when a customer is logged in and is trying to view the account info and history and then the above error is **** my day :( thank you in advance for your help
SpirtouliS Posted March 27, 2008 Author Posted March 27, 2008 SORRY I SEARCHED THE FORUM AND FOUND THE SOLUTION :-) ADMIN PLEASE ADD A BUTTON IN THE FORUM SO THE OWNER OFTHE POST CAN DELETE IT THANKYOU Hello,I'm new to OSC and to php and unfortunately to MySQL as well :blush: nevertheless i am trying by making a lot of backups to built an eshop for my friend the adress is http://www.hpbs.gr/index.php (for whom would like to see howi'm doing) i have encounder a problem which is as follows : 1054 - Unknown column 's.public_flag' in 'where clause' select count(*) as total from orders o, orders_status s where o.customers_id = '5' and o.orders_status = s.orders_status_id and s.language_id = '4' and s.public_flag = '1' [TEP STOP] I think that a column in the database is missing but i haven't made any changes to the database for that matter everything is working ok except when a customer is logged in and is trying to view the account info and history and then the above error is **** my day :( thank you in advance for your help
Recommended Posts
Archived
This topic is now archived and is closed to further replies.