Installation stuck on database import

Ask the community for help and support.
oldcelt
Posts: 9
Joined: Sat May 14, 2022 5:42 pm

Installation stuck on database import

Post 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?

Tags:
User avatar
Kofod95
VIP Member
VIP Member
Posts: 262
Joined: Sat Feb 06, 2021 7:38 pm
Has thanked: 48 times
Been thanked: 67 times

Re: Installation stuck on database import

Post 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
I'm not smart, but sometimes even a blind chicken can find a corn.
Here are a lot of corns: Phoenix user guide
heatherbell
VIP Member
VIP Member
Posts: 1222
Joined: Mon Oct 07, 2019 4:39 am
Has thanked: 12 times
Been thanked: 118 times

Re: Installation stuck on database import

Post 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
oldcelt
Posts: 9
Joined: Sat May 14, 2022 5:42 pm

Re: Installation stuck on database import

Post 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?
burt
Lead Developer
Lead Developer
Posts: 1337
Joined: Tue Oct 29, 2019 9:37 am
Has thanked: 21 times
Been thanked: 42 times

Re: Installation stuck on database import

Post by burt »

oldcelt wrote: Sun May 15, 2022 11:39 am Wampserver
Try a different localhost server. I use "uniform server" for offline hosting.
Back in the saddle, one day a week, February 2022...
tedukes
Posts: 87
Joined: Wed Oct 27, 2021 11:27 pm
Has thanked: 17 times
Been thanked: 1 time

Re: Installation stuck on database import

Post by tedukes »

Port 3306 open on your firewall for MySQL/MariaDB?
oldcelt
Posts: 9
Joined: Sat May 14, 2022 5:42 pm

Re: Installation stuck on database import

Post 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.
oldcelt
Posts: 9
Joined: Sat May 14, 2022 5:42 pm

Re: Installation stuck on database import

Post 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?
heatherbell
VIP Member
VIP Member
Posts: 1222
Joined: Mon Oct 07, 2019 4:39 am
Has thanked: 12 times
Been thanked: 118 times

Re: Installation stuck on database import

Post 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
oldcelt
Posts: 9
Joined: Sat May 14, 2022 5:42 pm

Re: Installation stuck on database import

Post 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.
Post Reply