Not connecting to database during setup

Open to all! Ask other shopowners for help.
Post Reply
Berry
Member
Posts: 6
Joined: Mon Apr 08, 2024 5:55 pm
Phoenix Version:
Has thanked: 4 times

Not connecting to database during setup

Post by Berry »

Hello Everyone,

I hope someone can help. I'm trying to install the newest version. When I get to the database setup it tries and fails. the error There was a problem importing the database. The following error had occured:
Please verify the connection parameters and try again.

I've tried deleting and redoing the database several times. Tried pasting in the database info. As well as typing it same result. Also have tried the version next to the newest release same result have changed the php version. I have in motion hosting and their tech staff have looked deeply into. They say there is no reason why it shouldn't work however they did discover this error

PHP Warning: Undefined property: sql_file::$errno in /home/berryb12/store.quiltersplayhouse.com/includes/system/versioned/1.0.8.9/sql_file.php on line 92
[19-Apr-2024 03:59:03 UTC] PHP Warning: Undefined property: sql_file::$error in /home/berryb12/store.quiltersplayhouse.com/includes/system/versioned/1.0.8.9/sql_file.php on line 92
[19-Apr-2024 03:59:03 UTC] PHP Warning: DB: [] from </home/berryb12/store.quiltersplayhouse.com/install/phoenix.sql> in /home/berryb12/store.quiltersplayhouse.com/includes/system/versioned/1.0.8.9/sql_file.php on line 93
[19-Apr-2024 03:59:03 UTC] PHP Warning: Undefined variable $db_error in /home/berryb12/store.quiltersplayhouse.com/install/rpc.php on line 89

Tags:


Join The Code Co-op to get access to your library in the Code Co-op Forum
ecartz
Core Team
Posts: 3084
Joined: Tue Nov 05, 2019 6:02 pm
Phoenix Version:
Has thanked: 4 times
Been thanked: 208 times

Re: Not connecting to database during setup

Post by ecartz »

TY. https://github.com/CE-PhoenixCart/Phoen ... 45f0bcde2c

Note: it probably still won't work afterwards, but the first, second, and fourth messages should go away. The third log message should show an actual DB error. That error is likely to be the real problem.
Berry
Member
Posts: 6
Joined: Mon Apr 08, 2024 5:55 pm
Phoenix Version:
Has thanked: 4 times

Re: Not connecting to database during setup

Post by Berry »

thank you for the reply. The fixes you outlined did get rid of the error. However now hanging on testing database connection
heatherbell
Senior Contributor
Posts: 2540
Joined: Mon Oct 07, 2019 4:39 am
Phoenix Version:
Has thanked: 35 times
Been thanked: 243 times

Re: Not connecting to database during setup

Post by heatherbell »

It might be the same issue as this:
https://github.com/CE-PhoenixCart/PhoenixCart/issues/38
Change from MyIsam to InnoDB - internet search that phrase leads to instructions on how to do that.

It might be the same issue as this:
viewtopic.php?f=10&t=1937
Berry
Member
Posts: 6
Joined: Mon Apr 08, 2024 5:55 pm
Phoenix Version:
Has thanked: 4 times

Re: Not connecting to database during setup

Post by Berry »

I just want to Thank BrockleyJohn for going above and beyond to help me sort this out and get it working on my server. Can't say Thanks enough my man!


Join The Code Co-op to get access to your library in the Code Co-op Forum
Post Reply