Zen Cart Logo
Forums / Installing on a Linux/Unix Server / Installer stalls at creating Database

Installer stalls at creating Database

Views: 17,359

Results 1 to 20 of 23
4 Jul 2016, 1:09 PM
#1
bscho avatar

bscho

Zen Follower

Join Date:
Jul 2016
Location:
London
Posts:
259
Plugin Contributions:
0

Installer stalls at creating Database

I am trying to install the latest version of Zen cart.
It stalls when creating Database at 82%.
I am using a remote mysql Database server with database name of
zencart

Any ideas or can I use an older version of Zen-cart?

4 Jul 2016, 3:34 PM
#2
lat9 avatar

lat9

Administrator

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

Re: Installer stalls at creating Database

Are there any zcInstall*.log files present in your /logs folder?

4 Jul 2016, 4:03 PM
#3
bscho avatar

bscho

Zen Follower

Join Date:
Jul 2016
Location:
London
Posts:
259
Plugin Contributions:
0

Re: Installer stalls at creating Database

Yes two after a new attempt
one says
Jul 04 2016 15:49 -- checkNewDBConnection
PASSED

Jul 04 2016 15:49 -- General
processing file /home/linnas01/w/webhouses.co.uk/user/htdocs/store/zc_install/sql/install/mysql_zencart.sql

This time it was frozen at 94%

4 Jul 2016, 4:25 PM
#4
lat9 avatar

lat9

Administrator

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

Re: Installer stalls at creating Database

How much of the database was actually installed?

You can use your hosting company's phpMyAdmin to see which tables have been installed in the database; what's the last one that was created?

4 Jul 2016, 4:28 PM
#5
bscho avatar

bscho

Zen Follower

Join Date:
Jul 2016
Location:
London
Posts:
259
Plugin Contributions:
0

Re: Installer stalls at creating Database

zones_to_geo_zones is the last table

96 rows in the set

4 Jul 2016, 6:26 PM
#6
lat9 avatar

lat9

Administrator

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

Re: Installer stalls at creating Database

That's the "right" last table and the "right" number of rows. I'm out of additional options.:(

4 Jul 2016, 11:56 PM
#7
bscho avatar

bscho

Zen Follower

Join Date:
Jul 2016
Location:
London
Posts:
259
Plugin Contributions:
0

Re: Installer stalls at creating Database

  • want to bypass this and jump to the next page and need to amend the configure page*

/**

  • This is the complete physical path to your store's files. eg: /var/www/vhost/accountname/public_html/store/
  • Should have a closing / on it.
    */
    define('DIR_FS_CATALOG', '/htdocs/vhost/accountname/public_html/store/');

where are the stores files? in a normal include configure file?

5 Jul 2016, 2:26 AM
#8
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
177

Re: Installer stalls at creating Database

bscho:

/**

  • This is the complete physical path to your store's files. eg: /var/www/vhost/accountname/public_html/store/
  • Should have a closing / on it.
    */
    define('DIR_FS_CATALOG', '/htdocs/vhost/accountname/public_html/store/');

where are the stores files? in a normal include configure file?
They are in whatever directory you uploaded the files to. So, if that's /home/yourname/public_html/ ... then ... that's what DIR_FS_CATALOG will be automatically set to by zc_install

5 Jul 2016, 10:14 AM
#9
bscho avatar

bscho

Zen Follower

Join Date:
Jul 2016
Location:
London
Posts:
259
Plugin Contributions:
0

Re: Installer stalls at creating Database

I can now get to the cart when I use
define('DIR_FS_CATALOG', '/home/linnas01/w/webhouses.co.uk/user/htdocs/store/');
Can't get to the admin though as it says
Not found
The requested URL /store/admin/alert_page.php was not found on this server.
How do I get to the admin now?

5 Jul 2016, 11:26 AM
#10
lat9 avatar

lat9

Administrator

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

Re: Installer stalls at creating Database

Use the value defined for DIR_FS_CATALOG in /YOUR_ADMIN/includes/configure.php file, too!

If you post the contents of your /includes/configure.php file (without the database settings) and the contents of your /YOUR_ADMIN/includes/configure.php file, someone might see what needs to be changed.

When/if you post a file's contents, use the **# **button in the menu-bar to wrap "code" tags around that code, making it easier to read!

6 Jul 2016, 12:30 AM
#11
bscho avatar

bscho

Zen Follower

Join Date:
Jul 2016
Location:
London
Posts:
259
Plugin Contributions:
0

Re: Installer stalls at creating Database

Thanks I found that helpful.

I have successfully loaded v1.5.3 and the cart works fine.

I have loaded again v1.5.5a using a new database the problem at the stage of creating a database still stalls at 86%.

Anyone, has experienced this before?

Anyone with a fresh idea please?

6 Jul 2016, 1:22 PM
#12
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
177

Re: Installer stalls at creating Database

I encountered that once way back in the early days of developing the new installer. IIRC it was caused by a permissions issue with writing the progress-meter file, which seemed odd. I was certain we'd fixed that though. So your case might be caused by something different.
Another thing which I'm sure was fixed was that the progress-bar is a modal which originally could be "canceled" by clicking anywhere else on the page to close the modal ... and of course then the installation would halt. But that was fixed, and besides, if it was still happening then you wouldn't be telling us a percentage because it would have disappeared from the screen.

Another former observation is that the percentage bar doesn't always get to 100% because it's being read from disk and sometimes things complete before it can read that final 100 value, and so it jumps to the next screen without showing 100%. But that's not quite what you're experiencing either.

Usually when zc_install encounters a "fatal" problem, it will log into the /logs/ folder with a different kind of filename: zcInstall-DEBUG-xxxxx.log (note the word DEBUG), in which you'll find the details of a PHP or MySQL error that's caused problems.
I'm puzzled by yours isn't triggering the debug file if it's failing to complete normally.

I realize this post doesn't give a concrete solution to your situation, but perhaps helps inform you more.

6 Jul 2016, 2:40 PM
#13
wilt avatar

wilt

Oji-san

Join Date:
Jun 2003
Location:
Newcastle UK
Posts:
1,844
Plugin Contributions:
3

Re: Installer stalls at creating Database

Another thing to check, which will give some indication of how far the install progress got, is to check the contents of the
products table (assuming you asked for demo data to be installed)
Are there any entries there?

6 Jul 2016, 4:48 PM
#14
bscho avatar

bscho

Zen Follower

Join Date:
Jul 2016
Location:
London
Posts:
259
Plugin Contributions:
0

Re: Installer stalls at creating Database

All the 96 tables are listed the last in the table is
zones_to_geo_zones

6 Jul 2016, 4:52 PM
#15
bscho avatar

bscho

Zen Follower

Join Date:
Jul 2016
Location:
London
Posts:
259
Plugin Contributions:
0

Re: Installer stalls at creating Database

When is the next version out?

6 Jul 2016, 5:16 PM
#16
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
177

Re: Installer stalls at creating Database

bscho:

When is the next version out?
Lol. You are certainly welcome to try out the v160 installation. Go to github.com/zencart and click the Clone Or Download button, and grab the zip.
It's nowhere ready for release, but it'd be interesting to know whether your system has the same problems with the newer version.

What other servers have you tried it on?

6 Jul 2016, 5:19 PM
#17
wilt avatar

wilt

Oji-san

Join Date:
Jun 2003
Location:
Newcastle UK
Posts:
1,844
Plugin Contributions:
3

Re: Installer stalls at creating Database

This wasn't what I asked :)

What I asked is whether demo data had been loaded.

e.g whether products table had been populated

bscho:

All the 96 tables are listed the last in the table is
zones_to_geo_zones

6 Jul 2016, 8:16 PM
#18
bscho avatar

bscho

Zen Follower

Join Date:
Jul 2016
Location:
London
Posts:
259
Plugin Contributions:
0

Re: Installer stalls at creating Database

I'll try that v160 version

Only one server at the moment to try it on.

I'am thinking it is my php which is 5.4.45 on the server could this be the problem?

7 Jul 2016, 3:42 AM
#19
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
177

Re: Installer stalls at creating Database

bscho:

I'll try that v160 version

Only one server at the moment to try it on.

I'am thinking it is my php which is 5.4.45 on the server could this be the problem?
See: Server Requirements for Zen Cart®

7 Jul 2016, 10:24 AM
#20
bscho avatar

bscho

Zen Follower

Join Date:
Jul 2016
Location:
London
Posts:
259
Plugin Contributions:
0

Re: Installer stalls at creating Database

I have now php version 5.6.20 on my server.

No luck though as both v160 and v155a still stall on create a Database.

I have the option to move to a cloud server to run php7.0 Do you think this is worth trying?

Or before I move do you have anything else I can try?