Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Problem 1054 Please help me


SpirtouliS

Recommended Posts

Posted

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

Posted

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...