Probs with MY ACCOUNT details

[Guest]

I am in the middle of setting up a new site - with little knowledge!, however proud of the results so far:

i have managed to modify the site for UK use and i am happy with overall look

The problem is that when a logged in customer tries to view their account via the 'My Account' link the following appears:

 

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

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

[TEP STOP]

 

Also - is it possible to get the Counties drop down box to appear on sign up as standard, as opposed to it just appearing when they make a typo?

 

many thanks in advance

Gavin

[steve_s]

I am in the middle of setting up a new site - with little knowledge!, however proud of the results so far:

i have managed to modify the site for UK use and i am happy with overall look

The problem is that when a logged in customer tries to view their account via the 'My Account' link the following appears:

 

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

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

[TEP STOP]

 

Also - is it possible to get the Counties drop down box to appear on sign up as standard, as opposed to it just appearing when they make a typo?

 

many thanks in advance

Gavin

Have you added a contribution that needs to alter order_status table and you forgot to run the sql ?

state countries drop down contribution http://addons.oscommerce.com/info/2028

[steve_s]

Have you added a contribution that needs to alter order_status table and you forgot to run the sql ?

state countries drop down contribution http://addons.oscommerce.com/info/2028

Can you paste structure of your order_status table here or post a screen-shot

Edited May 26, 2009 by steve_s

[Guest]

Can you paste structure of your order_status table here or post a screen-shot

please pardon my complete lack of understanding, where do i get the part of table or info that you wish to see

 

By the Way: That country selector thing works great!! All i have to do now is re-format the layout for british address order

Thanks for you you help so far - much appreciated

 

Gav