? ? Pending

User tests: Successful: Unsuccessful:

avatar Bakual
Bakual
17 Jan 2017

Pull Request for Issue #12733.

Summary of Changes

  • Removes image and image alternate text fields from the field definition. Those aren't used anywhere and would only confuse users.
  • Removes options, attributes, created_by_alias, publish_up and publish_down columns from the #__fields table. They are not used at all and make no sense in the context of a field.

Testing Instructions

  • Test that creating, editing and general use of fields work as before. There should be no difference except that the two "image" and "image alternate text" fields are no longer part of the edit form.
  • To test the database changes, you need to either install a fresh installation or update from a 3.6.5 installation to this branch. So this may be a bit tricky. You can however also manually delete the columns and test or just create a few fields and verify there is no data stored into those columns.

Documentation Changes Required

None

avatar Bakual Bakual - open - 17 Jan 2017
avatar Bakual Bakual - change - 17 Jan 2017
Status New Pending
avatar Bakual Bakual - edited - 17 Jan 2017
avatar joomla-cms-bot joomla-cms-bot - change - 17 Jan 2017
Category SQL Administration com_admin Postgresql MS SQL com_fields
avatar Bakual Bakual - change - 17 Jan 2017
Title
Remove unneeded fields from com_fields
[com_fields] Remove unneeded fields from com_fields
Labels Added: ?
avatar Bakual Bakual - edited - 17 Jan 2017
avatar joomla-cms-bot joomla-cms-bot - change - 17 Jan 2017
Category SQL Administration com_admin Postgresql MS SQL com_fields SQL Administration com_admin Postgresql MS SQL com_fields Installation
avatar laoneo
laoneo - comment - 17 Jan 2017

The update scripts are missing.

avatar zero-24
zero-24 - comment - 17 Jan 2017

The update scripts are missing.

@laoneo There are no update needed as it was not in any stable release. ;)

avatar Bakual
Bakual - comment - 17 Jan 2017

The update scripts are missing.

Look again. The update scripts are there. I adjusted the existing ones so we don't add the fields and remove them again.

avatar laoneo
laoneo - comment - 17 Jan 2017

Was a mistake on my side. Sorry for the confusion, too long day.

avatar franz-wohlkoenig
franz-wohlkoenig - comment - 19 Jan 2017

I have tested this item ? unsuccessfully on 5fd022a

Tested 2 Fields in Field Group "Details":

  • Field "Colour" is shown correct below "Details"
  • Field "Editor" is shown at "Basic Settings".
    bildschirmfoto 2017-01-19 um 20 59 00

This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/13621.
avatar franz-wohlkoenig franz-wohlkoenig - test_item - 19 Jan 2017 - Tested unsuccessfully
avatar Bakual
Bakual - comment - 19 Jan 2017

@franz-wohlkoenig That's an interesting bug you found there, but not related to this PR.
I actually suspected that this behavior could be possible but haven't got the time to try to produce it. What happens here is that if you name the field alias the same as an existing regular formfield, the custom one will overwrite the existing one. There are two reasons for that: First we allow the admin to name the field the way he wants, which means it can take the name of an existing one. Second we're using the "params" form group to store our fields. That group often is already used by the original form. So it clashes there.

There are already PRs open which would solve that issue:

  • Don't store in params group: #13353
  • Remove the alias field: #13182
avatar franz-wohlkoenig
franz-wohlkoenig - comment - 19 Jan 2017

@Bakual Changing Fieldname from Editor to Editor1 solved Problem:
bildschirmfoto 2017-01-19 um 21 57 35

avatar franz-wohlkoenig
franz-wohlkoenig - comment - 21 Jan 2017

Tested Field-type Gallery on Article got on different Paths in Front- and Backend:

  • Warning: JFolder: :files: Path is not a folder. Path: __/images/images/sampledata/fruitshop
  • and Picture-Gallery: Warning: Invalid argument supplied for foreach() in /plugins/fields/gallery/tmpl/gallery.php on line 50
avatar Bakual
Bakual - comment - 21 Jan 2017

@franz-wohlkoenig Is that on a Windows machine?

It isn't an issue of this PR, but may be a bug related to the different directory separators.

avatar franz-wohlkoenig
franz-wohlkoenig - comment - 21 Jan 2017

Test on:
Joomla! 3.7.0-beta1-nightly
macOS Sierra, 10.12.2
Firefox 50.1.0
PHP 7.0.4
MySQLi 5.5.53-0

avatar laoneo
laoneo - comment - 22 Jan 2017

I have tested this item successfully on 5fd022a


This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/13621.

avatar laoneo laoneo - test_item - 22 Jan 2017 - Tested successfully
avatar chmst
chmst - comment - 23 Jan 2017

I have tested this item successfully on 5fd022a


This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/13621.

avatar chmst chmst - test_item - 23 Jan 2017 - Tested successfully
avatar astridx
astridx - comment - 23 Jan 2017

I have tested this item successfully on 5fd022a

1. I pull the current version of joomla-cms
2. I made a new installation without testdata
3. I installed Patch tester but I get the message
1146 Table 'joomla-cms.#__patchtester_pulls' doesn't exist
I solved this problem by creating the database tables manually. I had this problem earlier, that is why I tell it. Perhaps someone has a hint for me.
4. I applied the patch
5. I deleted the configuration.php and copied a installation folder and made new installation.
6. I created a lot of field and everything worked well.


This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/13621.
avatar astridx
astridx - comment - 23 Jan 2017

I have tested this item successfully on 5fd022a

1. I pull the current version of joomla-cms
2. I made a new installation without testdata
3. I installed Patch tester but I get the message
1146 Table 'joomla-cms.#__patchtester_pulls' doesn't exist
I solved this problem by creating the database tables manually. I had this problem earlier, that is why I tell it. Perhaps someone has a hint for me.
4. I applied the patch
5. I deleted the configuration.php and copied a installation folder and made new installation.
6. I created a lot of field and everything worked well.


This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/13621.
avatar astridx astridx - test_item - 23 Jan 2017 - Tested successfully
avatar astridx astridx - test_item - 23 Jan 2017 - Tested successfully
avatar rdeutz rdeutz - change - 23 Jan 2017
The description was changed
Status Pending Fixed in Code Base
Closed_Date 0000-00-00 00:00:00 2017-01-23 18:57:18
Closed_By rdeutz
Labels Added: ?
avatar rdeutz rdeutz - close - 23 Jan 2017
avatar rdeutz rdeutz - merge - 23 Jan 2017

Add a Comment

Login with GitHub to post a comment