Originally Posted by
ChrisYoung
Another way to add the countries to your website is to first is to backup your database and check your database to add a new column if needed. This way literally takes less than a minute to do and is simple. But always, always, backup your database before making any changes.
Firstly, you need to check and see if the countries have been installed into the database correctly with all the necessary columns.
Goto phpMyAdmin, click on the correct database, click on zc_countries (which ever zc_ is yours) which needs to have 6 columns, which are...
countries_id, countries_name, countries_iso_code_2, countries_iso_code_3, address_format_id, status.
If you are missing countries on your website, more than likely you are missing the last column which is status.
If you don't want to do an update or a new install, another way is to add the missing column in your database.
Adding a new column is quick and easy, and it is really easy to do.
After you have clicked on zc_countries which now should be showing a list of your countries.
BACKUP YOUR DATABASE!
If the last column is missing, the "status" column, you need to add the column.
Near the top of the page look for structure and click it, this is usually next to browse.
This will bring up the names of all the columns in the zc_countries table. 5 columns again, look for the status column (if the status column is there STOP something else is wrong and you may not need to add the extra column).
Next, look to about the middle of the page under a big black line for the word "Add" next to it will be a box with the number 1 in it, and then a checked "At End of Table" text, meaning the new column will appear at the end of the table, which is where it needs to be.
At the end of this line will be a button that says "GO". Before clicking that, make sure that the drop down box next to it says countries_id and the previously mentioned "1" and "At End of Table" are correct.
Click on "GO".
After clicking you will see some boxes with headings that need to be filled in.
Name: status (type this in lower case)
Type: tinyint (from the drop down box list)
Length/Values: Leave blank.
Default: Click drop down box. Click on "As Defined:" Then type "1" in the text box that appears.
Collation: Leave blank.
Attributes: Leave blank.
Null: Check the box (make sure there is a tick in the box)
Index: Leave blank.
A_I: Leave blank.
Comments: Leave blank.
Click on the save button.
Check to make sure that you have a new column with status on the top and all other values are "1".
Check your admin for your website.
Hope this helps.
Cheers,
Chris.
Bookmarks