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
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
Try creating a file like phpinfo.php in your root directory, and place this code inside :
Then show the link here, so we can check what's going on.
Code: Select all
<?php phpinfo();
Opencart Developer - My Extension Showcase
Contact me at aeon.yoda@gmail.com
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 :
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
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!
file updated - thanks!
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 :
to
edit install/controller/install/step_3.php, line 230 :
Code: Select all
$data['mysqli'] = extension_loaded('mysqli');
Code: Select all
$data['mysqli'] = true;
Opencart Developer - My Extension Showcase
Contact me at aeon.yoda@gmail.com
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
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
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
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.
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.
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
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.
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
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 erroryodapt wrote: ↑Sun Oct 08, 2017 2:51 amLooks 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 :
toCode: Select all
$data['mysqli'] = extension_loaded('mysqli');
Code: Select all
$data['mysqli'] = true;
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']);
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
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
Who is online
Users browsing this forum: No registered users and 23 guests