Forums / Installing on a Linux/Unix Server / Setup Freezes at Database Setup

Setup Freezes at Database Setup

Views: 8,026

Results 1 to 9 of 9
22 Jul 2023, 12:20 AM
#1
pixodaros avatar

pixodaros

New Zenner

Join Date:
May 2023
Location:
Canada
Posts:
56
Plugin Contributions:
0

Setup Freezes at Database Setup

I am creating a test install on a Linux web server which also has Wordpress on it. My interface is through cPanel.

I can reach the home page for the installation and start the setup process, but when I get to Database Setup, fill in the details of the new database and user for ZenCart, and click "Continue" the setup freezes with the progress bar between 25% and 90% complete. The message above the progress bar is something like "Loading Character Set Specific data 99%" or "Loading Demo Data 100%," Refreshing the page just brings me back to the Database Setup screen.

The new database for Zen Cart is still only 4 KB so nothing is being added during the incomplete install.

MySQL is version 10.5.21-MariaDB, I am pretty sure PHP is version 7.4

22 Jul 2023, 1:17 AM
#2
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: Setup Freezes at Database Setup

What logs are generated in the logs folder? Would expect some helpful information to exist, provided haven't tried to access the admin folder yet through your browser.

Also, what is the origin of your fileset? Ver 1.5.8? Ver 1.5.8a or the latest on github?

ZC Installation/Maintenance Support <- Site
Contribution for contributions welcome...

22 Jul 2023, 1:41 AM
#3
pixodaros avatar

pixodaros

New Zenner

Join Date:
May 2023
Location:
Canada
Posts:
56
Plugin Contributions:
0

Re: Setup Freezes at Database Setup

The version is 1.5.8a (the latest version linked from the ZenCart homepage).

At my first look the logs at /home/mysite/public_html/zencart-1.5.8a-test/logs say something like this:

PHP Fatal error:  Uncaught Error: Class 'ZipArchive' not found in /home/mysite/public_html/zencart-1.5.8a-test/zc_install/ajaxLoadMainSql.php:57
Stack trace:
#0 {main}
  thrown in /home/mysite/public_html/zencart-1.5.8a-test/zc_install/ajaxLoadMainSql.php on line 57

(There are also log files for the times I entered the wrong password, but those were easy to solve)

22 Jul 2023, 2:37 AM
#4
pixodaros avatar

pixodaros

New Zenner

Join Date:
May 2023
Location:
Canada
Posts:
56
Plugin Contributions:
0

Re: Setup Freezes at Database Setup

Here is a thread with a similar error. It looks like the poster talked to their web host ("Dreamhost support was finally able to figure this out - they didn't tell me how they fixed it, but it's all set, thanks!"), I may try that in a few days.

https://www.zen-cart.com/showthread.php?226218-Database-creation-hangs-at-85

22 Jul 2023, 11:01 AM
#5
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,119
Plugin Contributions:
56

Re: Setup Freezes at Database Setup

FWIW, it's ***never ***a good idea to use a webhost's 1-click install as those have been problematic for years.

Copying the files to the web-hosted file-system via FTP or pulling a zip-file via cPanel's File Manager and extracting prior to running the zc_install process is much more reliable.

22 Jul 2023, 12:52 PM
#6
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: Setup Freezes at Database Setup

Did an internet search on the issue which didn't target a specific host, but that either the installation of a needed server package was missed or possibly the call in the code is not quite right or could be made slightly different.

My guess though is that it is more likely that either the software is not available for access or the php.ini for your php 7.4 instance isn't invoking it.

Reason why not using php 8.x?

ZC Installation/Maintenance Support <- Site
Contribution for contributions welcome...

22 Jul 2023, 4:51 PM
#7
pixodaros avatar

pixodaros

New Zenner

Join Date:
May 2023
Location:
Canada
Posts:
56
Plugin Contributions:
0

Re: Setup Freezes at Database Setup

lat9:

FWIW, it's ***never ***a good idea to use a webhost's 1-click install as those have been problematic for years.
Yes, I used the "copy the Zip file onto the web server with File Manager then extract it, load the URL, and install through the web interface" method because that is what the Zen Cart installation instructions recommend.

mc12345678:

Did an internet search on the issue which didn't target a specific host, but that either the installation of a needed server package was missed or possibly the call in the code is not quite right or could be made slightly different.
Did you mean results like https://stackoverflow.com/questions/48255921/php-fatal-error-uncaught-error-class-ziparchive-not-found-in Knowing whether the problem is with Zen Cart or with the server's configuration would help.

mc12345678:

My guess though is that it is more likely that either the software is not available for access or the php.ini for your php 7.4 instance isn't invoking it.

Reason why not using php 8.x?
The web server seems to have PHP 8.0 installed but 7.4 is active. Because this is a working server not a pure test environment, I would want to ask the server provider why they set it up like that so I don't break something else. They support 25 databases so having both Wordpress and a test install of Zen cart should not be a problem but we live in Romulus' dump not Plato's republic.

22 Jul 2023, 6:03 PM
#8
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: Setup Freezes at Database Setup

pixodaros:

The version is 1.5.8a (the latest version linked from the ZenCart homepage).

At my first look the logs at /home/mysite/public_html/zencart-1.5.8a-test/logs say something like this:

PHP Fatal error: Uncaught Error: Class 'ZipArchive' not found in /home/mysite/public_html/zencart-1.5.8a-test/zc_install/ajaxLoadMainSql.php:57
Stack trace:
#0 {main}
thrown in /home/mysite/public_html/zencart-1.5.8a-test/zc_install/ajaxLoadMainSql.php on line 57

> 
> (There are also log files for the times I entered the wrong password, but those were easy to solve)

> **pixodaros:**
>
> Yes, I used the "copy the Zip file onto the web server with File Manager then extract it, load the URL, and install through the web interface" method because that is what the Zen Cart installation instructions recommend.
> 
> 
> Did you mean results like <https://stackoverflow.com/questions/48255921/php-fatal-error-uncaught-error-class-ziparchive-not-found-in>  Knowing whether the problem is with Zen Cart or with the server's configuration would help.
> 
> 
> The web server seems to have PHP 8.0 installed but 7.4 is active.  Because this is a working server not a pure test environment, I would want to ask the server provider why they set it up like that so I don't break something else.  They support 25 databases so having both Wordpress and a test install of Zen cart should not be a problem but we live in Romulus' dump not Plato's republic.

The error called out above in this post is attempting to access a class that is only used in core code this one time. 

As to the issue being specifically something wrong with the overall software, it's not specifically an issue with overall zen cart otherwise there would be far more posts at this point about it. For a little background though, the primary developers have determined that installation of the demo data is "best" through this unzip process, even though that software or class is only managed this one time. 

A solution can be offered if your interested in continuing down a path of not getting the host to support. Basically it would be to offer direction of how to unzip the necessary files and as part of the code to skip the unzip process and search for the necessary upon which to take the next action. 

As to impact on other software, hopefully you are seeking upgrading that software to start using a current version of php. Php 7.4 is already outdated, unfortunately.

ZC Installation/Maintenance Support <- Site
Contribution for contributions welcome...

24 Jul 2023, 5:58 AM
#9
pixodaros avatar

pixodaros

New Zenner

Join Date:
May 2023
Location:
Canada
Posts:
56
Plugin Contributions:
0

Re: Setup Freezes at Database Setup

Activating PHP 8.0 and turning on some more PHP packages appears to have solved this problem. Now I have a test install with test data.