Country list not showing up in admin or at account creation

[wooden words]

I have just installed new clean zen cart in the admin area under countries it is all blank, also when I went to create a test account there were no countries and this error message. although it says version 1.5.5b I installed the newest 1.5.5c. my php version is 5.6.28. this is brand new site with no plugins , products ect

website is http://dllaserdesigns.com.au

can someone please advise. Thank you

[DrByte]

I just did a fresh install on a new server, and all the countries seem to show up fine here.

To do the install of countries it requires a few dependencies:
- database character set is utf8
- server properly supports utf8
- you chose utf8 during zc_install execution
- when you uploaded the zc_install/sql/ directory to your server, it needs all the files; if some failed to upload, you'd end up with incomplete data.

Further, you'll find more specific info about the problem in your /logs folder, as explained in this FAQ, which matches the message in your screenshot: WARNING: An Error occurred, please refresh the page and try again.

[wooden words]

Hi DrByte,
I have checked my database character set and it is set to utf8_general_ci and my database is running •Database client version: libmysql - 5.1.73.

Have tried a fresh install and still getting the same thing. I am not totally computer savvy with databases ect so not sure how to fix my problem, so might have to go back to zencart 5.4 as I know everything works for me on that version.

Have attached a screen shot of my php myadmin, not sure if tells you anything that may help.

Thanks for your help.

[mc12345678]

ZC 1.5.5 fileset was obtained from?

You're in the process of an upgrade it would seem, is the intention to start with a clean slate version of ZC and then manually enter product/store information or are you going to follow one of the upgrade processes?

The times seen when the country data is not present has been when someone tries to use one of the host's auto-installer/auto-upgrade programs.

[DrByte]

1. In phpMyAdmin, click on the zc_countries table. What's in it?

2. What's in the /logs/MyDebug-xxxxxxxxxx.log files on your server?


It really feels like your PHP file set isn't "only" original ZC code. But, without seeing what's in the table, and what PHP/MySQL errors are occurring in the background, we can't help you much.

[wooden words]

Hi mc123456787 DrByte
yes it is a clean fresh zen cart not upgrade. and yes I did use my hosts auto installer of 1.5.5, so should I delete that and install via ftp with download from Zen Cart. have attached country database & an error log the latest one from the 28-12 they seem to be all the same.

Thank you for your help on this.

[mc12345678]

Yes, ideally should use the ZC provided version instead of a host's provided/modified version. It is unfortunate that various hosts continue to provide an altered, non-functional version of the store software which puts the general software in poor light.

That said, it is possible to use/re-use the database information that was initiated by the auto-installer which can be found in the includes/configure.php file. The reason I say that is because at least a database (storage location) has been established. Suggest dropping all of the tables in it before using it, but if the host did anything useful it was to setup that database.

Of course to maximize learning and understanding would suggest creating your own.

Is there a reason your not doing an upgrade? Or is this being installed/started up for someone else? Ask because upgrading an existing store following the process outlined here: http://www.zen-cart.com/entry.php?3-...d-of-upgrading

This way urls are maintained from old version to new version which supports continuity of your site.

[wooden words]

doing a new install as this is a new website.

[mc12345678]

doing a new install as this is a new website.

Okay, good. :)

BTW, didn't say it in my last message, but you might do others at your host a favor if you also report the issue to your host. Unfortunately, they are likely to blaim ZC in some way or deny any type of responsibility, but perhaps it could get solved for others so that they don't experience the same issue.

[wooden words]

Yes I will do.
Thank you for your help on this, will go try what you have suggested, Yes I agree I'm sure they will blame zc but have been using zc for a while now and wouldn't change, it works perfectly for my business.

Once again thanks you for your assistance. will let you know how it goes.