Removed all countries except uk, gc doesnt work!!

[Xbox Memberships]

great stuff good to know it will work. im having trouble using my ftp. i use filezilla and even the pre saved quick connect settings or importing settings from cpanel dont work? closest i can get is a folder that contains nothing named "import" and a file named ftp.quota??

[stevesh]

No, you don't use FTP for this. Under 'databases' in your hosting control panel should be a selection called 'phpMyAdmin', which is a database tool.

[Xbox Memberships]

i need to use ftp to install zen to a subdomain so i can pinch the database from it dont i?

[Xbox Memberships]

might help to mention ive already accessed the php myadmin area and backed up the zen_countries file

[stevesh]

Sorry, I misunderstood. That's right. You might check post #7 here for a little easier installation method.

http://www.zen-cart.com/forum/showthread.php?t=190947

[frank18]

@Xbox Memberships

Emailed the countries table as requested.

If you are using a prefix in your DB then you need to open the countries.sql file with your editor and add the prefix asf:

If your prefix is zen_ then change the line

CREATE TABLE IF NOT EXISTS `countries` (

to

CREATE TABLE IF NOT EXISTS `zen_countries` (

and change the line

INSERT INTO `countries` (`countries_id`, `countries_name`, `countries_iso_code_2`, `countries_iso_code_3`, `address_format_id`) VALUES

to

INSERT INTO `zen_countries` (`countries_id`, `countries_name`, `countries_iso_code_2`, `countries_iso_code_3`, `address_format_id`) VALUES

Save the changed file and then import the sql patch into your DB

Make sure you backup your live DB before doing this.

Best to set your store to Maintenance mode.

[Xbox Memberships]

thanks frank worked a treat i did email you back not long ago, i now have all countries active once again, now my only 2 problems i can see are

1. admin home displays 10 rows of visitors data all as today with todays figures?

2. google checkout still wont work as it should, i have the express checkout button working but if google checkout is selected as payment option during normal checkout process i get an error on the integration console of google saying "you tried to post a none valid us address" the order processes as if payment has been made in zencart admin ui and delivers emails. but instead of being sent to the google checkout payment gateway page they are displayed with a warning about a .php error which i have placed below...

Warning: Invalid argument supplied for foreach() in /home/xboxmemb/public_html/includes/classes/order.php on line 778

Warning: Cannot modify header information - headers already sent by (output started at /home/xboxmemb/public_html/includes/classes/order.php:778) in /home/xboxmemb/public_html/includes/functions/functions_general.php on line 44