Post by timnilimaa » Wed Dec 30, 2020 4:36 am

Everything shows up green on step 2, I configure my remote mysql server where I've already created a database, dedicated user/password (granted access too) but I've also tried with db root account.

I get to an http 500 and in the logs I can see

Code: Select all

2020-12-29T19:51:37.258334515Z [Tue Dec 29 19:51:37.258022 2020] [php7:error] [pid 43] [client <<<removed>>>:43007] PHP Fatal error:  Uncaught Exception: Error: Got error 1 from storage engine<br />Error No: 1030<br />CREATE TABLE `oc_address` (\n  `address_id` int(11) NOT NULL AUTO_INCREMENT,\n  `customer_id` int(11) NOT NULL,\n  `firstname` varchar(32) NOT NULL,\n  `lastname` varchar(32) NOT NULL,\n  `company` varchar(40) NOT NULL,\n  `address_1` varchar(128) NOT NULL,\n  `address_2` varchar(128) NOT NULL,\n  `city` varchar(128) NOT NULL,\n  `postcode` varchar(10) NOT NULL,\n  `country_id` int(11) NOT NULL DEFAULT '0',\n  `zone_id` int(11) NOT NULL DEFAULT '0',\n  `custom_field` text NOT NULL,\n  PRIMARY KEY (`address_id`),\n  KEY `customer_id` (`customer_id`)\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;\n in /home/site/wwwroot/system/library/db/mysqli.php:40\nStack trace:\n#0 /home/site/wwwroot/system/library/db.php(45): DB\\MySQLi->query('CREATE TABLE `o...')\n#1 /home/site/wwwroot/install/model/install/install.php(26): DB->query('CREATE TABLE `o...')\n#2 /home/site/wwwroot/system/engine/loader.php(248): ModelInstallInstall->database(Array in /home/site/wwwroot/system/library/db/mysqli.php on line 40, referer: <<<removed>>>/install/index.php?route=install/step_3
I run php 7.4.9, mysql 5.7.29. I am perfectly able to connect to the database from the server so there is not an issue with username/password/firewalls between the web server and the database server.

Anyone with any pointers?

Newbie

Posts

Joined
Wed Dec 30, 2020 4:24 am

Post by straightlight » Wed Dec 30, 2020 7:04 am

PHP and mySQL versions are too high.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by litextension » Fri Jan 29, 2021 12:11 pm

Hi,
You should downgrade to PHP version 7.3, and mysql 5.6

Have a nice day!

LitExtension - Shopping Cart Migration Expert
Visit us at: https://litextension.com


User avatar
New member

Posts

Joined
Wed Aug 03, 2016 4:22 pm

Post by straightlight » Fri Jan 29, 2021 9:17 pm

litextension wrote:
Fri Jan 29, 2021 12:11 pm
Hi,
You should downgrade to PHP version 7.3, and mysql 5.6

Have a nice day!
mySQL v5.7 also works.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON
Who is online

Users browsing this forum: No registered users and 3 guests