Add standard/default fields to list view tries to duplicate field #318

New Issue

Closed

opened 2018-07-12 16:16:34 +00:00 by cpaschen · 0 comments

cpaschen commented

2018-07-12 16:16:34 +00:00

(Migrated from github.com)

Steps to reproduce the issue

Following the video tutorial here:
https://www.youtube.com/watch?v=FHQfIhWHYyQ&feature=youtu.be&list=PLQRGFI8XZ_wtGvPQZWBfDzzlERLQgpMRE&t=5m45s

Add a field element for an existing default field (like 'created_by').
Add to admin view with display/filter/etc as desired

Expected result

Should add to the list view (and filters, and to different tab than publishing if desired) WITHOUT trying to add a duplicate field to the table.

Actual result

Gives error: "Duplicate column name 'created_by' " and an error installing component.

System information (as much as possible)

OS Name & Version: WAMP
MySql Version: 5.5.56
Apache Version: 2.4.27
PHP Version: 7.1.9
Joomla Version: 3.8.8
JCB Version: 2.8.0
Browser: multiple

Additional comments

Work-around per forum does resolve the issue.

(remove the SQL string in the component updates that is trying to create the field AND remove the /administrator/COMPONENT/sql/updates/mysql/x.x.x.sql file where that update is being added as well, then compile install)

### Steps to reproduce the issue Following the video tutorial here: https://www.youtube.com/watch?v=FHQfIhWHYyQ&feature=youtu.be&list=PLQRGFI8XZ_wtGvPQZWBfDzzlERLQgpMRE&t=5m45s Add a field element for an existing default field (like 'created_by'). Add to admin view with display/filter/etc as desired ### Expected result Should add to the list view (and filters, and to different tab than publishing if desired) WITHOUT trying to add a duplicate field to the table. ### Actual result Gives error: "Duplicate column name 'created_by' " and an error installing component. ### System information (as much as possible) - OS Name & Version: WAMP - MySql Version: 5.5.56 - Apache Version: 2.4.27 - PHP Version: 7.1.9 - Joomla Version: 3.8.8 - JCB Version: 2.8.0 - Browser: multiple ### Additional comments Work-around per forum does resolve the issue. (remove the SQL string in the component updates that is trying to create the field AND remove the /administrator/COMPONENT/sql/updates/mysql/x.x.x.sql file where that update is being added as well, then compile install)