Post by robhert » Sat Jun 30, 2007 11:53 pm

As you see

http://img502.imageshack.us/img502/9359/nonhm8.th.gif[/img]

Shipping and Payment Addresses are currently not showing and I don't Know WHY???

I hope you can help me.

Thanks in advance.

Newbie

Posts

Joined
Sat Jun 30, 2007 11:02 pm

Post by robhert » Sun Jul 01, 2007 12:22 am

I have tested it and ...

When somebody register by a country, by example, Peru, my country. Its address is not showing, but when I register with US country, the address IS SHOWING!!!

I don't know, at this moment, what makes this... Hope you can help me

Thanks.
PD Again, sorry for my poor english...


Here's a little more explained:

http://img75.imageshack.us/img75/1283/explaingl2.th.gif[/img]

Hope you can help me...
Last edited by robhert on Sun Jul 01, 2007 4:10 am, edited 1 time in total.

Newbie

Posts

Joined
Sat Jun 30, 2007 11:02 pm

Post by dmit » Tue Jul 10, 2007 11:05 pm

Sorry robhert, this is not a solution, just want to confirm that the bug really exists!

Any help from community?.. Daniel?..

OpenCart ver. 0.6.5

Newbie

Posts

Joined
Thu Apr 05, 2007 5:45 pm

Post by scandic » Wed Jul 11, 2007 3:46 am

Same with german adresses. There is a problem with country specific information stored in database. For the street adress many countries got "street_address" in the format string. Maybe something from older releases, but 0.6.5 uses "address_1" instead.
This won't fix the problem but I'm looking forward to the bug.

New member

Posts

Joined
Sun Jul 08, 2007 2:48 am
Location - Frankfurt, Germany

Post by byronrode » Wed Jul 25, 2007 2:17 am

It seems that this is a bug with regards to the upgrade...
There is only really 2 ways to change this! It seems that when the upgrade was done some countries stored in the Database had the address details stored as

street_address
suburb
...

and other were stored like

address_1
address_2

THE PROBLEM

if you view the table "address" in MySQL (phpMyAdmin or similiar) you will see that the column names are called address_1 and address_2 and that is where the problem is coming from as the first option is looking for columns called street_address and suburb and cant find them, so it merely prints the column_name.

Both fixes will take quite a bit of time, however Fix 1 will take a little quicker IMO.

FIX 1

1) Go into phpMyAdmin or similiar and search the countries table for street_name.
2) Change all the instances of street_name to address_1
3) Then do the same steps above for suburb, and replace with address_2

FIX 2

1) Open up your Open Cart admin panel, and go into the localization -> countries section and click on each affected country and update the address details to reflect address_1 and address_2.

I hope this helps you guys. I was fortunate enough to only need one country for my store, but i reinstalled a fresh copy of the store and tested the above, and it worked perfectly for me.

OTHER POSSIBILITIES

it is possible to edit the class that reads the column names for the addresses to allow for either street_name or address_1 and so on, but I think that for future releases the database values should be standardized and that will stop the problem.

Happy Shopping!

Newbie

Posts

Joined
Wed Jul 25, 2007 2:07 am

Post by deejunit » Sat Aug 18, 2007 6:22 pm

This bug is still present in v. 0.7.2 and so you saved my day byronrode!  ;D

As I only need to use 1 country I applied your fix no. 2 and changed the address format to:

firstname lastname
address_1
postcode city
country

Thnx!

New member

Posts

Joined
Sat Jul 21, 2007 5:40 am
Who is online

Users browsing this forum: No registered users and 4 guests