Page 1 of 2

Installation stuck on database import

Posted: Sat May 14, 2022 7:31 pm
by oldcelt
The message "The database structure is now being imported. Please be patient during this procedure." appeared and the processing wheel has been turning for half an hour.

Been out for a meal. Still stuck in the same place.

Any idea why it's failing to complete installation please?

Re: Installation stuck on database import

Posted: Sat May 14, 2022 9:19 pm
by Kofod95
Sorry, no solution from me.
Usually this step takes a couple of seconds only. If you have softaculous on your host, it may be worth installing through that?

//Daniel

Re: Installation stuck on database import

Posted: Sun May 15, 2022 5:22 am
by heatherbell
oldcelt wrote: Sat May 14, 2022 7:31 pm Any idea why it's failing to complete installation please?
Impossible to say without more details but guess there is something not configured correctly on your server.
https://github.com/CE-PhoenixCart/Phoen ... quirements

Re: Installation stuck on database import

Posted: Sun May 15, 2022 11:39 am
by oldcelt
Checked the requirements and changed from MySQL to MariaDB.

I'm trying to set up on my dev machine using Wampserver - details:-
PHP settings and PHP extension checked as specified.
Apache: 2.4.51
PHP: 7.4.26
MariaDB: 10.6.5
MySQL: 5.7.36

All indicators on the installation show green thumbs up but it's still hanging!

Can someone suggest where the problem may lie please?

Re: Installation stuck on database import

Posted: Sun May 15, 2022 2:12 pm
by burt
oldcelt wrote: Sun May 15, 2022 11:39 am Wampserver
Try a different localhost server. I use "uniform server" for offline hosting.

Re: Installation stuck on database import

Posted: Sun May 15, 2022 4:25 pm
by tedukes
Port 3306 open on your firewall for MySQL/MariaDB?

Re: Installation stuck on database import

Posted: Sun May 15, 2022 4:34 pm
by oldcelt
burt wrote: Sun May 15, 2022 2:12 pm
oldcelt wrote: Sun May 15, 2022 11:39 am Wampserver
Try a different localhost server. I use "uniform server" for offline hosting.
I've used Wampserver for 20 years with no problems. I've had hundreds of templates including ecommerce programs install and run without error, including oscommerce.
I doubt this is a server problem but thanks for your input.

Re: Installation stuck on database import

Posted: Sun May 15, 2022 4:44 pm
by oldcelt
tedukes wrote: Sun May 15, 2022 4:25 pm Port 3306 open on your firewall for MySQL/MariaDB?
Checked port 3306 is open ok. However, Wampserver reports that MySQL uses port 3308. Is that a problem?

Re: Installation stuck on database import

Posted: Mon May 16, 2022 5:12 am
by heatherbell
oldcelt wrote: Sun May 15, 2022 4:44 pm MySQL uses port 3308. Is that a problem?
I think this is answered in User Guide here: https://phoenixcart.org/phoenixcartwiki ... to_Install

Re: Installation stuck on database import

Posted: Mon May 16, 2022 11:45 am
by oldcelt
heatherbell wrote: Mon May 16, 2022 5:12 am
oldcelt wrote: Sun May 15, 2022 4:44 pm MySQL uses port 3308. Is that a problem?
I think this is answered in User Guide here: https://phoenixcart.org/phoenixcartwiki ... to_Install
Sorry, I should have said MariaDB uses port 3308 NOT MySQL. MySQL uses 3306.

I've tried both databases with exactly the same result (specifying the port for MariaDB).

I've tested several shopping carts on this machine and all installed without a hitch until now!
I have been able to install Phoenix on my website but that's not a good place to be making changes and testing.

I've written a small PHP test to make sure I'm getting a connection to the database using the same parameters I used for Phoenix installation. The connection works perfectly.