Post by engagelondon » Sun Oct 08, 2017 1:48 am

Hi
Am attempting a 100% fresh install of ver 2.3.0.2

After uploading the files and starting the config - I get to page 3/4

the DB Driver dropdown offers me mPDO - and nothing else ( I was expecting to see MySQL or similar)

Using the mPDO option results in error message " Failed to connect to database. Reason: 'could not find driver' "

my ISP tells me I'm running MySQLi - so a bit stuck

Any suggestions gratefully received

Newbie

Posts

Joined
Tue May 10, 2016 4:28 pm

Post by yodapt » Sun Oct 08, 2017 1:51 am

Try creating a file like phpinfo.php in your root directory, and place this code inside :

Code: Select all

<?php phpinfo(); 
Then show the link here, so we can check what's going on.

Opencart Developer - My Extension Showcase
Contact me at aeon.yoda@gmail.com


User avatar
Active Member

Posts

Joined
Fri Jun 17, 2011 6:39 pm


Newbie

Posts

Joined
Tue May 10, 2016 4:28 pm

Post by yodapt » Sun Oct 08, 2017 2:21 am

Seems like mysqli is installed, it's strange that it doesn show up.

Try this, inside that file you just created, replace the code with this one :

Code: Select all

<?php
print_r(get_loaded_extensions());
?>

Opencart Developer - My Extension Showcase
Contact me at aeon.yoda@gmail.com


User avatar
Active Member

Posts

Joined
Fri Jun 17, 2011 6:39 pm


Post by engagelondon » Sun Oct 08, 2017 2:26 am

Indeed - I've wasted a day with this - last time I installed OC was around version 1.5 and it was really easy

file updated - thanks!

Newbie

Posts

Joined
Tue May 10, 2016 4:28 pm

Post by yodapt » Sun Oct 08, 2017 2:51 am

Looks like mysqlnd is installed instead of mysql, which is the same. For some reason mysqli isnt listed, but I assume it is there, so try this :

edit install/controller/install/step_3.php, line 230 :

Code: Select all

$data['mysqli'] = extension_loaded('mysqli');
to

Code: Select all

$data['mysqli'] = true;

Opencart Developer - My Extension Showcase
Contact me at aeon.yoda@gmail.com


User avatar
Active Member

Posts

Joined
Fri Jun 17, 2011 6:39 pm


Post by engagelondon » Sun Oct 08, 2017 2:57 am

Now - thats better!

Before I go too far down this road - as its a fresh install - should i stay with this version or go to 3.0.2.0?

I tried installing ver 3 earlier but was having the same issue.

I ask as your obviously an expert - and I REALLY appreciate your help on this

Newbie

Posts

Joined
Tue May 10, 2016 4:28 pm

Post by yodapt » Sun Oct 08, 2017 3:14 am

Version 3.x is recent, there arent as much modules / extensions for it yet, and there are several bugs (too many) yet officially unsolved. I dont see any reason to recommend it, I guess it's a matter of choice, maybe it has a couple features out of the box that you really need, but probably you dont.

Opencart Developer - My Extension Showcase
Contact me at aeon.yoda@gmail.com


User avatar
Active Member

Posts

Joined
Fri Jun 17, 2011 6:39 pm


Post by engagelondon » Sun Oct 08, 2017 3:49 am

I hear you

The install continues to fall over - I get to stage 3, give it my details and it then falls over to a white screen.

I may well suggest my client looks elsewhere, an installer that falls over hardly inspires confidence

Thanks for your help however.

Newbie

Posts

Joined
Tue May 10, 2016 4:28 pm

Post by yodapt » Sun Oct 08, 2017 5:14 am

I would suggest you talk with the hosting company about it, it's the first time I encounter such issue in 8 years.

Opencart Developer - My Extension Showcase
Contact me at aeon.yoda@gmail.com


User avatar
Active Member

Posts

Joined
Fri Jun 17, 2011 6:39 pm


Post by engagelondon » Sun Oct 08, 2017 5:46 am

:) If i could describe the problem I would :)

Newbie

Posts

Joined
Tue May 10, 2016 4:28 pm

Post by yodapt » Sun Oct 08, 2017 6:35 am

The problem is that your PHP version doesnt show mysqli installed in it's environment, and thus you are unable to use it in your applications.

Alternatively, if you want I can assist you directly if you give me access, to see if I can work around the problem. Drop me an email if you want.

Opencart Developer - My Extension Showcase
Contact me at aeon.yoda@gmail.com


User avatar
Active Member

Posts

Joined
Fri Jun 17, 2011 6:39 pm


Post by engagelondon » Sun Oct 08, 2017 7:05 pm

Hi - Thanks for the offer

I've had a moan with my server people - let them do some work!

Newbie

Posts

Joined
Tue May 10, 2016 4:28 pm

Post by tonkp » Mon Oct 09, 2017 12:47 pm

Thanks for the info



sbobet

Newbie

Posts

Joined
Fri Sep 08, 2017 3:41 pm

Post by ideep13 » Tue Dec 29, 2020 4:42 am

yodapt wrote:
Sun Oct 08, 2017 2:51 am
Looks like mysqlnd is installed instead of mysql, which is the same. For some reason mysqli isnt listed, but I assume it is there, so try this :

edit install/controller/install/step_3.php, line 230 :

Code: Select all

$data['mysqli'] = extension_loaded('mysqli');
to

Code: Select all

$data['mysqli'] = true;
I made a fresh install of 2.3.0.2.. had the exact same error.. changed the line you suggested and than I changed the DB driver from mPDO to Msqli and receieved a fatal error


Fatal error: Uncaught Error: Class 'MySQLi' not found in /home/ZZ/XX/install/controller/install/step_3.php:266 Stack trace: #0 /home/ZZ/XX/install/controller/install/step_3.php(8): ControllerInstallStep3->validate() #1 /home/ZZ/XX/system/engine/action.php(51): ControllerInstallStep3->index() #2 /home/ZZ/XX/system/engine/front.php(34): Action->execute(Object(Registry)) #3 /home/ZZ/XX/system/engine/front.php(29): Front->execute(Object(Action)) #4 /home/ZZ/XX/system/framework.php(103): Front->dispatch(Object(Action), Object(Action)) #5 /home/ZZ/XX/system/startup.php(124): require_once('/home/ZZ/...') #6 /home/ZZ/XX/install/index.php(31): start('install') #7 {main} thrown in /home/ZZ/XX/install/controller/install/step_3.php on line 266


created the phpinfo.php file and this is inside -
<?php phpinfo();

on line 266 is this:

Code: Select all

	$mysql = @new MySQLi($this->request->post['db_hostname'], $this->request->post['db_username'], html_entity_decode($this->request->post['db_password'], ENT_QUOTES, 'UTF-8'), $this->request->post['db_database'], $this->request->post['db_port']);

User avatar
Active Member

Posts

Joined
Mon Jun 18, 2012 2:47 am

Post by ideep13 » Tue Dec 29, 2020 6:09 am

nevermind.. I had to check the mysqli under php version

User avatar
Active Member

Posts

Joined
Mon Jun 18, 2012 2:47 am

Post by ideep13 » Tue Dec 29, 2020 6:18 am

I ma trying to upload previous database from 2.1.0.1. to 2.3.0.1

I created a fresh install of 2.3.0.2 with new database.. so I have a site.. I would like to import products from previous shop 2.1.0.1 through database now but I received this errors in phpmyadmin



--
-- Database: `xx`
--

-- --------------------------------------------------------

--
-- Table structure for table `oc_address`
--

CREATE TABLE `oc_address` (
`address_id` int(11) NOT NULL,
`customer_id` int(11) NOT NULL,
`firstname` varchar(32) NOT NULL,
`lastname` varchar(32) NOT NULL,
`company` varchar(40) NOT NULL,
`address_1` varchar(128) NOT NULL,
`address_2` varchar(128) NOT NULL,
`city` varchar(128) NOT NULL,
`postcode` varchar(10) NOT NULL,
`country_id` int(11) NOT NULL,
`zone_id` int(11) NOT NULL,
`custom_field` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8
MySQL said: Documentation

#1050 - Table 'oc_address' already exists

User avatar
Active Member

Posts

Joined
Mon Jun 18, 2012 2:47 am
Who is online

Users browsing this forum: No registered users and 7 guests