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

OpenCart Versions: (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

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.



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.

I am no longer active around here, to reach me, contact:
My latest Freeware Opencart LIGHT Testsite, available on demand:
My 888 FREE OC Extension-Repositories - from OC v.1.5.x up,
on the largest OC Extension Github Site:

User avatar
Legendary Member


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.

Koeltechnische deurrubbers eenvoudig online op maat bestellen.
Eigen productie en snelle levering.

User avatar
Expert Member


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



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

Users browsing this forum: No registered users and 6 guests