New Shipping Address Error.. Plz Help

[Guest]

We are getting the below error and we have looked thru the php files and db and can't seem to find where the problem is coming from. We double checked the country and the zones and tax zones.

 

Any suggestions?

 

thanks,

 

***

New Shipping Address

 

Please use the following form to create a new shipping address to use for this order.

Gender: Male Female *

First Name: *

Last Name: *

Website URL:

Street Address: *

Suburb:

Post Code: *

City: *

State/Province: 1054 - Unknown column 'Australia' in 'where clause'

 

select zone_name from zones where zone_country_id = Australia order by zone_name

 

[TEP STOP]

[Guest]

when do u get this error? creating a new account? or?

[Guest]

only when I go to change the shipping address.