Post by dmbrownfield » Thu Nov 13, 2008 11:16 am

I changed postcode to zipcode in every file in these folders:
language/english/controller 
store/catalog/controller 
template/default/content

and when I try to create an account in my store am getting this:  error:  Unknown column 'zipcode' in
'field list' 
error no: 1054
then it prints out everything I entered including the zipcode.

what did I forget to change? 

New member

Posts

Joined
Fri May 09, 2008 12:37 am

Post by Qphoria » Thu Nov 13, 2008 11:30 am

you can't change the variable name as that is what the code uses to reference it. You must only change the value name

For example:

$_text_post_code  = "Post Code"
can change to:
$_text_post_code  = "Zip Code"
but NOT:
$_text_zip_code  = "Zip Code"

Image
Donate!|OpenCart Basics|GeoZones
Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by jty » Thu Nov 13, 2008 11:37 am

dmbrownfield wrote: I changed postcode to zipcode in every file in these folders:
language/english/controller 
store/catalog/controller 
template/default/content
Undo your changes in
store/catalog/controller 
template/default/content

Only change the language file

jty
Active Member

Posts

Joined
Sat Aug 30, 2008 8:19 am

Post by fido-x » Thu Nov 13, 2008 5:27 pm

dmbrownfield wrote: and when I try to create an account in my store am getting this:  error:  Unknown column 'zipcode' in
'field list' 
error no: 1054
then it prints out everything I entered including the zipcode.

what did I forget to change? 
This error is caused because there is to field in the "address" table in the database for "zipcode" (it is called "postcode"). BTW, what is a zipcode?
jty wrote: Only change the language file
Exactly!
Qphoria wrote: $_text_post_code  = "Post Code"
can change to:
$_text_post_code  = "Zip Code"
That's ALL you need to do to achieve your desired outcome!

Fido-X.

Image
Modules for OpenCart 2.3.0.2
Homepage Module [Free - since OpenCart 0.7.7]
Multistore Extensions
Store Manager Multi-Vendor/Multi-Store management tool

If you're not living on the edge ... you're taking up too much space!


User avatar
Expert Member

Posts

Joined
Sat Jun 28, 2008 1:09 am
Location - Tasmania, Australia

Post by jty » Thu Nov 13, 2008 6:54 pm

fido-x wrote: BTW, what is a zipcode?
A zipcode to a postcode is like a wrench to a spanner
Maybe we need an American language pack  ;D

jty
Active Member

Posts

Joined
Sat Aug 30, 2008 8:19 am

Post by Qphoria » Thu Nov 13, 2008 8:57 pm

jty wrote:
fido-x wrote: BTW, what is a zipcode?
A zipcode to a postcode is like a wrench to a spanner
Maybe we need an American language pack   ;D
That is exactly right and we will have en_US and en_GB in 0.8 :)

Image
Donate!|OpenCart Basics|GeoZones
Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by jty » Thu Nov 13, 2008 9:27 pm

Why do Americans ship by United States Postal Services to a zip code?
We post via Australia Post to a post code

jty
Active Member

Posts

Joined
Sat Aug 30, 2008 8:19 am

Post by dmbrownfield » Tue Nov 18, 2008 9:16 am

Because we Americans can't stand anything being simple !!!!!

New member

Posts

Joined
Fri May 09, 2008 12:37 am

Post by fido-x » Tue Nov 18, 2008 5:01 pm

jty wrote: Why do Americans ship by United States Postal Services to a zip code?
We post via Australia Post to a post code
dmbrownfield wrote: Because we Americans can't stand anything being simple !!!!!
It's not an issue of "simplicity" versus "complexity" (or over-engineering), it's more logical to use a postal service to post to a postcode.
Qphoria wrote: That is exactly right and we will have en_US and en_GB in 0.8 :)
How about an en_AU?

Image
Modules for OpenCart 2.3.0.2
Homepage Module [Free - since OpenCart 0.7.7]
Multistore Extensions
Store Manager Multi-Vendor/Multi-Store management tool

If you're not living on the edge ... you're taking up too much space!


User avatar
Expert Member

Posts

Joined
Sat Jun 28, 2008 1:09 am
Location - Tasmania, Australia

Post by jty » Tue Nov 18, 2008 6:46 pm

fido-x wrote:
Qphoria wrote: That is exactly right and we will have en_US and en_GB in 0.8 :)
How about an en_AU?
Aussie's don't need a language pack
Aussies are bi-lingual. Aussies speak ((en_GB + en_US) / 2)

jty
Active Member

Posts

Joined
Sat Aug 30, 2008 8:19 am

Post by Qphoria » Tue Nov 18, 2008 7:36 pm

jty wrote: Aussie's don't need a language pack
Aussies are bi-lingual. Aussies speak ((en_GB + en_US) / 2)
I havent heard any one post any authorised en_US out of you colour-lovin, humour-less, spanner-wielding localised freaks!  ;D

Image
Donate!|OpenCart Basics|GeoZones
Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am
Who is online

Users browsing this forum: No registered users and 3 guests