Post by DMBurns » Sat Dec 01, 2018 2:56 am

OpenCart Versions: 3.0.2.0 (downloaded from site and also using the Master Branch from Github)
MYSQL version: 5.7.24-0ubuntu0.18.04.1
OS: Ubuntu 18.04.1
Apache2
PHP7.2

Doing a fresh install and the install scripts report a duplicate field name in the table.

Error from log:

Code: Select all

2018-11-30 18:08:01 - Exception:  Error: Duplicate column name 'status'<br />Error No: 1060<br />CREATE TABLE `oc_gdpr` (
  `gdpr_id` int(11) NOT NULL,
  `email` varchar(96) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `date_added` datetime NOT NULL,
  PRIMARY KEY (`gdpr_id`)
) ENGINE=MyISAM CHARSET=utf8 COLLATE=utf8_general_ci;
 in /var/www/html/system/library/db/mysqli.php on line 43
The installation scripts end at that point. I have looked for where the gdpr tables are created from to see if I could fix the double entry of the 'status' field, but can not seem to find it and, quite possibly, I am trying to fix it in the wrong way.

Newbie

Posts

Joined
Sat Dec 01, 2018 2:16 am

Post by IP_CAM » Sun Dec 02, 2018 5:40 am

oc_gdpr or gdpr in general is no default OC v.3.0.2.x Table Name,
it does not even exist as Variable somewhere. ::)
So, it's not really a clean install, as your comment above seems to tell us.
Ernie

For Sale: Top URL's, including an OpenCart V-Pro Shop!
A wide range of matching Designs can be seen here: http://www.opencart.li
For Information on URL's offered, please contact me at: jti@jacob.ch
Hundreds of Mods in 380+ Repositories for OC v.1.5.x - v.2.3.x
to be found on my Github Site: https://github.com/IP-CAM
Image


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by victorj » Sun Dec 02, 2018 5:29 pm

Latest version from github will show that error on a clean install.
Its not in database file, so expect is a module adding those database entrys.

Koeltechnische deurrubbers eenvoudig online op maat bestellen.
Alle niet stekplichtige onderdelen zoals scharnieren, sloten, randverwarming en verlichting voor alle typen koelingen en vriezers.
https://koelcel-onderdelen.com

Koeltechnische deurrubbers eenvoudig online op maat bestellen.
Eigen productie en snelle levering.
https://123-deurrubbers.com


User avatar
Expert Member

Posts

Joined
Sat Jun 25, 2011 4:09 am
Location - Alkmaar Holland

Post by DMBurns » Wed Dec 05, 2018 4:38 pm

I found the problem was in the /system/helper/db_schema.php and had been marked by a DEV and has now been fixed in the code.

Problem solved - carry on. :o

Newbie

Posts

Joined
Sat Dec 01, 2018 2:16 am
Who is online

Users browsing this forum: No registered users and 3 guests