Hello Brian,

I will share the code when this last bit of issues are cleared so everything is clear.

I’ve attached the screencast. Please let me know if it’s not clear.

Comment has been marked private.

Hello Brian,

Sorry for the late reply. Can you please let me know what this code block is doing?

// Controllers/Manage/Categories.php line ~ 389
$categoryTranslation
    ->setCatId($categoryId)
    ->setGroupId($category->getGroupId())
    ->setLangId($languageId)
    ->setStatus($status)
    ->setEditDate(ee()->localize->now)
    ->setEditBy(ee()->session->userdata('member_id'))
    ->setIsAuto(null)
    ->save();

$category->Translations->add($categoryTranslation);
$category->save();

If I comment out the last 2 lines, the translations are saved correctly and no Null rows are created. If those 2 lines are necessary, can you please let me know which files I can investigate the issues further?

Your CP access should be restored.

So

$categoryTranslation
    ->setCatId($categoryId)
    ->setGroupId($category->getGroupId())
    ->setLangId($languageId)
    ->setStatus($status)
    ->setEditDate(ee()->localize->now)
    ->setEditBy(ee()->session->userdata('member_id'))
    ->setIsAuto(null)
    ->save();

Insert/Update records in exp_publisher_categories?

What table do these lines insert to?

$category->Translations->add($categoryTranslation);
$category->save();

What files are involved here? I think it’s probably with the site’s setup but it’d be easier to debug this way.

I put an echo after the $category->save(); and saw 16 rows of output (which is correct as we have 8 languages x 2 statuses). However, exp_publisher_categories got 32 rows inserted.

Actually the opposite.

When I commented out the last 3 rows. I get 16 rows inserted into exp_publisher_categories. When the lines are not commented out, I get 32 rows. The duplicated ones just have NULL for all field values.

It is when you create a new category, following the steps: 1. Create a new category custom field 2. Create a new category with some data entered for the custom field 3. Go to publisher categories and edit the category 4. Hit save and observer the database rows

You are right Brian. I stop focusing on the code but rather the server setup and I found that the staging site wasn’t using the latest version of PHP. After upgrading the PHP version to 7.2, no duplicated rows are generated.

The modifications that I made for the translation statuses are in Model/Category.php

public function getTranslationStatus()
    {
        $status = [];
        $translations = $this->getTranslations();
        $customFields = count($this->CategoryGroup->getCategoryFields());

        /** @var \EllisLab\ExpressionEngine\Model\Category\Category $defaultCategory */
        $defaultCategory = ee('Model')->get('Category')
            ->filter('cat_id', $this->getCatId())
            ->first();

        $categoryFields = ee('Model')->get('CategoryField')->all();
        $requiredFields = [];
        /** @var NativeCategoryField $field */
        foreach ($categoryFields as $field) {
            if ($this->getGroupId() == $field->getProperty('group_id')) {
                $requiredFields['field_id_'.$field->getProperty('field_id')] = $field->getProperty('field_required');
            }
        }
        /** @var CategoryTranslation $translation */
        foreach ($translations as $translation) {
            /** @var FieldFacade $customFieldTranslations */
            $customFieldTranslations = $translation->getCustomFields();
            $status[$translation->getLangId()] = 'complete';

            if ($customFields && !$customFieldTranslations) {
                $status[$translation->getLangId()] = 'incomplete';
            } elseif ($customFieldTranslations) {
                $checkEmpty = true;
                foreach ($customFieldTranslations as $name => $value) {
                    // e.g. $category->field_id_N Is the custom field property something that
                    if ($value === '' && isset($defaultCategory->$name) && $defaultCategory->$name === '' && $requiredFields[$name]) {
                        $status[$translation->getLangId()] = 'incomplete';
                    } elseif (!empty($value)) {
                        $checkEmpty = false;
                    }
                }
                if ($checkEmpty) {
                    $status[$translation->getLangId()] = 'incomplete';
                }
            }

            if ($translation->getCatName() === '' && $defaultCategory->cat_name !== '') {
                $status[$translation->getLangId()] = 'incomplete';
            }
            if ($translation->getDescription() === '' && $defaultCategory->cat_description !== '') {
                $status[$translation->getLangId()] = 'incomplete';
            }
            if ($translation->getImage() === '' && $defaultCategory->cat_image !== '') {
                $status[$translation->getLangId()] = 'incomplete';
            }
            if ($translation->getUrlTitle() === '' && $defaultCategory->cat_url_title !== '') {
                $status[$translation->getLangId()] = 'incomplete';
            }
        }

        return $status;
    }

Basically I’m checking if the custom fields are required. The status will be lit if 1. There is at least 1 field that is not empty 2. All required fields are not empty

Is {publisher:current_language_prefix} returning empty because the segments doesn’t take the language prefix into account? If this is the intended behaviour, when do we use {publisher:current_language_prefix}?

Comment has been marked private.