Helpdesk (forum)

#133 Field List error

Posted in ‘NorrCompetition’

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

PHP version

ea-php82

bizguy

When I attempt to delete or Unpublish a Field I get the following error and the item remain in a published state.

Unknown column 'published' in 'field list'

Please advise.

b2z

Hi Ed!

I can confirm the bug. Interesting that it was hidden for so long time. Anyway here is the easy fix:

1. Open file /administrator/components/com_competition/tables/field.php

2. Find this peace of code (line 55-60):

public function __construct(&$db)
{
    parent::__construct('#__competition_fields', 'id', $db);
}

3. Change it to:

public function __construct(&$db)
{
    $this->setColumnAlias('published', 'state');

    parent::__construct('#__competition_fields', 'id', $db);
}

Please let me know did it help or not.

Kind regards,

Dmitrijs

bizguy

Hi Dmitrijs,

Yes, the fix provided allowed me to Unpublish and Trash a Field.

Thanks for the quick reply and fix!

b2z

Great! We will include this fix in the next release.

Kind regards,

Dmitrijs