zero price after add to cart,

[able morphius]

Hello I am new to the forum although i have had some experience with oscommerce and php before to a limited degree. my problem is that when i add a product to the shopping cart it displays with 0.00 dollars value, black numerals not red

I am aware of usual tricks of default currency mod problems and have made alteration from USD to AUD, in includes/languages/english.php

oanda updated aud and usd values okay, set defualt currency in admin etc.

Also Customer Orders page in Admin displays,

 

1054 - Unknown column 'o.orders_stores_id' in 'where clause'

 

select count(*) as total from orders o left join orders_total ot on (o.orders_id = ot.orders_id), stores st, orders_status s where o.orders_status = s.orders_status_id and s.language_id = '1' and ot.class = 'ot_total' and o.orders_stores_id = st.stores_id

 

[TEP STOP]

 

Which i think is another matter, but maybe related

= first dummy order i made didn't seem to be logged by system

also Seem to have problem with auspost parcel, more due to total lack of knowing what settings are required by it.

i have them as

AusPOST Parcel Post

 

Enable auspost

True

 

Insurance

 

 

Dispatch Postcode

3779

 

Handling Fee

$4.40

 

Parcel Height

2800

 

Parcel Width

800

 

Parcel Depth

600

 

Shipping Zone

Australian Zones

 

Tax Class

--none--

 

Sort order of display.

1

 

my url is https://gdcoffee.com/osCommerce/catalog/index.php,

Please if anyone can help It would be really Great as i am working against a dead line for having this up and running, (i need sleep )

Yours sincerely

Morphius