RECENT UPGRADE PROBLEMS

[not me]

I've recently added some upgrades that were contained in osCommerce Online Merchant v2.2 RC1 Upgrade Notes.

 

Since then everytime a customer trys to log back into their account the following is displayed,

 

1054 - Unknown column 's.public_flag' in 'where clause'

 

select count(*) as total from orders o, orders_status s where o.customers_id = '22' and o.orders_status = s.orders_status_id and s.language_id = '1' and s.public_flag = '1'

 

[TEP STOP]

 

A new account can be created fine and orders placed. Just happens when logging back in!!!!

 

Any help would be great.

 

Many thanks for reading

 

m0jon

[Eitan]

I've recently added some upgrades that were contained in osCommerce Online Merchant v2.2 RC1 Upgrade Notes.

 

Since then everytime a customer trys to log back into their account the following is displayed,

 

1054 - Unknown column 's.public_flag' in 'where clause'

 

select count(*) as total from orders o, orders_status s where o.customers_id = '22' and o.orders_status = s.orders_status_id and s.language_id = '1' and s.public_flag = '1'

 

[TEP STOP]

 

A new account can be created fine and orders placed. Just happens when logging back in!!!!

 

Any help would be great.

 

Many thanks for reading

 

m0jon

funny, my post above yours is the exact same problem... hahaha

[MJP]

funny, my post above yours is the exact same problem... hahaha

funny, both your posts have been answered today too.

[Eitan]

funny, both your posts have been answered today too.

 

im retarded

 

http://www.oscommerce.com/forums/index.php?sho...045&hl=1054

 

 

check that out m0jon....

[not me]

I've recently added some upgrades that were contained in osCommerce Online Merchant v2.2 RC1 Upgrade Notes.

 

Since then everytime a customer trys to log back into their account the following is displayed,

 

1054 - Unknown column 's.public_flag' in 'where clause'

 

select count(*) as total from orders o, orders_status s where o.customers_id = '22' and o.orders_status = s.orders_status_id and s.language_id = '1' and s.public_flag = '1'

 

[TEP STOP]

 

A new account can be created fine and orders placed. Just happens when logging back in!!!!

 

Any help would be great.

 

Many thanks for reading

 

m0jon

 

solution as follows

 

if you are able to access your DB is to run the sql statement:

 

CODE

 

alter table orders_status add public_flag int DEFAULT '1';