install freezes at "Loading Character Set specific data 59%"

[earmsby]

Doing a fresh install of v1.5.5 (in process of upgrade) and the install process froze on the screen where it is "loading character set specific data". Should I simply refresh the page, delete everything and start over or ??

Have done many installs but this new version is not as familiar as the old install.

Help!

[DrByte]

It's rare for that to happen, but if it does I'd first just reload the page and fill in the DB info again, and let it do its install over. Or go back one page and go from there.

If it's halting due to some sort of error, it's most likely logged in the /logs/ folder in zcInstall-DEBUG-xxxxxx.log files.

It might be a result of incomplete files from a bad FTP upload, too.

[earmsby]

Well, I tried starting over with the install and running it again. This time it froze on the same screen but at 64%. Maybe if I try it a few more times, it will finish that step! :)

[earmsby]

Ok, I'm at a total loss here. Third time running the install and it freezes now at 58%. I can see no data has been added to the database and there is no DEBUG log file (there are other log files that don't say DEBUG, though).

Guess the next step will be to completely delete all the ZC files and the database and start over.

[DrByte]

By the time it's at the stage of loading "character set specific data", it's already built all the tables, and is starting to fill some of them with basic data such as country names etc.

So, if your database is truly still empty at that point, then that suggests to me you're checking the wrong database when trying to debug it.

[earmsby]

Hmmm... maybe I just didn't look in enough tables, but I'm very sure I was looking at the correct database in phpMyAdmin. I will have to come back to this tomorrow as I ran out of time to troubleshoot this install. Thought it would just take a few minutes but an hour later, I am out of time.

[earmsby]

Ok, I restarted this project today. I completely deleted the previous test store directory (in Filezilla) and I completely deleted the database I created yesterday. I even redownloaded the 1.5.5 zip file from SourceForge. Unfortunately, I'm still stalling out in "loading character set specific data." Comparing the database data to the mysql_utf8.sql file in the install folder, I can see that the countries were added except the last one and no zones have been added. Unlike yesterday, this time a DEBUG log file was generated and it has 14 lines that all say:

[13-Apr-2016 10:45:59 America/New_York] PHP Warning:  mysqli_connect(): (HY000/2002): No such file or directory in /homepages/PATH_TO_STORE/includes/classes/db/mysql/query_factory.php on line 102

In case any of this is pertinent to the problem, here is as much information as I can collect about the server and site:

Host: 1&1
PHP version: 5.5.34
MYSQL version: 5.5

Thanks, DrByte for your previous assistance on this. Is there anything else that would shed light on this issue?

[kobra]

If you install/upgrade at another host (Bluehost) then you should be able to move this fileset and DB to 1&1 for your client
Basically follow this FAQ
https://www.zen-cart.com/content.php...fferent-server

[earmsby]

If you install/upgrade at another host (Bluehost) then you should be able to move this fileset and DB to 1&1 for your client
Basically follow this FAQ
https://www.zen-cart.com/content.php...fferent-server

Perhaps, but 1&1 locks down their database servers pretty tightly and I've had a hard time doing dumps and restores. I'm almost ready to insist the client move to a new host or else find a new web developer. [exasperated...] Of course the client doesn't want to pay much to do "routine" things. ;)

[DrByte]

The backup_mysql plugin will export a copy of the database. Almost same as using phpMyAdmin and choosing Export. Both are ideal options for when you're changing hosts.