Troubleshooting Code That Works on Windows Locally but Fails on Linux

1. Troubleshooting analysis: the same piece of code works locally on Windows but fails in the Linux environment. The code is as follows

PHP

    /**
     * 设置页面元素的排序
     */
    public function actionSetSortNumber()
    {
        $id = $this->request->post('id');
        if (empty($id)) {
            return [
                'code' => 10001,
                'message' => '参数 id 不能为空',
            ];
        }

        /* @var $element PageElement */
        $element = PageElement::find()->where(['id' => $id])->limit(1)->one();
        if (!$element) {
            return [
                'code' => 10404,
                'message' => '该页面元素不存在',
            ];
        }

        $current = $element->order_number;
        $number = $this->request->post('number');

        // 判断是否超出范围
        $max = PageElement::find()
            ->select('MAX(`order_number`)')
            ->where(['page_id' => $element->page_id])
            ->scalar();

        if ($number < 1 || $number > $max) {  // 这里改成1开始
            return [
                'code' => 10405,
                'message' => '设置失败，请输入正确的数字',
            ];
        }

        if ($number === $current) {
            return [
                'code' => 10406,
                'message' => '排序号不能与原排序号相同',
            ];
        }

        $transaction = \Yii::$app->db->beginTransaction();
        try {
            if ($number < $current) {
                PageElement::updateAllCounters([
                    'order_number' => 1,
                ], 'page_id = :pageId AND device_type = :deviceType AND order_number >= :min AND order_number < :max', [
                    ':pageId' => $element->page_id,
                    ':deviceType' => $element->device_type,
                    ':min' => $number,
                    ':max' => $current,
                ]);
            } else {
                PageElement::updateAllCounters([
                    'order_number' => -1,
                ], 'page_id = :pageId AND device_type = :deviceType AND order_number > :min AND order_number <= :max', [
                    ':pageId' => $element->page_id,
                    ':deviceType' => $element->device_type,
                    ':min' => $current,
                    ':max' => $number,
                ]);
            }

            $element->order_number = $number;
            $element->updated_at = date('Y-m-d H:i:s');
            if (!$element->save(false, ['order_number', 'updated_at'])) {
                $transaction->rollBack();
                return [
                    'code' => 10002,
                    'message' => '数据库操作失败，请联系管理员',
                ];
            }

            // 统一重新排序，从1开始
            $elements = PageElement::find()
                ->where([
                    'page_id' => $element->page_id,
                    'device_type' => $element->device_type,
                ])
                ->orderBy(['order_number' => SORT_ASC])
                ->all();

            Yii::info(
                [
                    $elements
                ]
            );

            foreach ($elements as $index => $item) {

                $newOrderNumber = $index + 1; // 从1开始排序
                Yii::info(
                    [
                        $item->order_number,
                        $newOrderNumber
                    ]
                );
                if ($item->order_number != $newOrderNumber) {
                    $item->order_number = $newOrderNumber;
                    $item->updated_at = date('Y-m-d H:i:s');
                    if (!$item->save(false, ['order_number', 'updated_at'])) {
                        $transaction->rollBack();
                        return [
                            'code' => 10002,
                            'message' => '数据库操作失败，请联系管理员',
                        ];
                    }
                }
            }

            $transaction->commit();

            return [
                'code' => 10000,
                'message' => '设置页面元素的排序成功',
                'data' => $element,
            ];
        } catch (\Exception $e) {
            $transaction->rollBack();
            return [
                'code' => 10003,
                'message' => '操作异常：' . $e->getMessage(),
            ];
        }
    }


    /**
     * 设置页面元素的排序
     */
    public function actionSetSortNumber()
    {
        $id = $this->request->post('id');
        if (empty($id)) {
            return [
                'code' => 10001,
                'message' => '参数 id 不能为空',
            ];
        }

        /* @var $element PageElement */
        $element = PageElement::find()->where(['id' => $id])->limit(1)->one();
        if (!$element) {
            return [
                'code' => 10404,
                'message' => '该页面元素不存在',
            ];
        }

        $current = $element->order_number;
        $number = $this->request->post('number');

        // 判断是否超出范围
        $max = PageElement::find()
            ->select('MAX(`order_number`)')
            ->where(['page_id' => $element->page_id])
            ->scalar();

        if ($number < 1 || $number > $max) {  // 这里改成1开始
            return [
                'code' => 10405,
                'message' => '设置失败，请输入正确的数字',
            ];
        }

        if ($number === $current) {
            return [
                'code' => 10406,
                'message' => '排序号不能与原排序号相同',
            ];
        }

        $transaction = \Yii::$app->db->beginTransaction();
        try {
            if ($number < $current) {
                PageElement::updateAllCounters([
                    'order_number' => 1,
                ], 'page_id = :pageId AND device_type = :deviceType AND order_number >= :min AND order_number < :max', [
                    ':pageId' => $element->page_id,
                    ':deviceType' => $element->device_type,
                    ':min' => $number,
                    ':max' => $current,
                ]);
            } else {
                PageElement::updateAllCounters([
                    'order_number' => -1,
                ], 'page_id = :pageId AND device_type = :deviceType AND order_number > :min AND order_number <= :max', [
                    ':pageId' => $element->page_id,
                    ':deviceType' => $element->device_type,
                    ':min' => $current,
                    ':max' => $number,
                ]);
            }

            $element->order_number = $number;
            $element->updated_at = date('Y-m-d H:i:s');
            if (!$element->save(false, ['order_number', 'updated_at'])) {
                $transaction->rollBack();
                return [
                    'code' => 10002,
                    'message' => '数据库操作失败，请联系管理员',
                ];
            }

            // 统一重新排序，从1开始
            $elements = PageElement::find()
                ->where([
                    'page_id' => $element->page_id,
                    'device_type' => $element->device_type,
                ])
                ->orderBy(['order_number' => SORT_ASC])
                ->all();

            Yii::info(
                [
                    $elements
                ]
            );

            foreach ($elements as $index => $item) {

                $newOrderNumber = $index + 1; // 从1开始排序
                Yii::info(
                    [
                        $item->order_number,
                        $newOrderNumber
                    ]
                );
                if ($item->order_number != $newOrderNumber) {
                    $item->order_number = $newOrderNumber;
                    $item->updated_at = date('Y-m-d H:i:s');
                    if (!$item->save(false, ['order_number', 'updated_at'])) {
                        $transaction->rollBack();
                        return [
                            'code' => 10002,
                            'message' => '数据库操作失败，请联系管理员',
                        ];
                    }
                }
            }

            $transaction->commit();

            return [
                'code' => 10000,
                'message' => '设置页面元素的排序成功',
                'data' => $element,
            ];
        } catch (\Exception $e) {
            $transaction->rollBack();
            return [
                'code' => 10003,
                'message' => '操作异常：' . $e->getMessage(),
            ];
        }
    }

2. In the production Linux environment, execution never reaches the code block if ($item->order_number != $newOrderNumber) { }. order_number=17, but the expected value is order_number=16. See Figure 1

In the production Linux environment, execution never reaches the code block if ($item->order_number != $newOrderNumber) { }. order_number=17, but the expected value is order_number=16 — Figure 1

3. Printing $elements yields the following data, which ultimately confirms that there is no issue with this sorting method.

Plaintext

4. Therefore, the problem lies in the interface method used to fetch the field list of page elements.

PHP

    /**
     * 获取页面元素的字段列表
     *
     * @return array
     */
    public function actionGetElementsByPageId(): array
    {
        $pageId = $this->request->post('page_id');
        if (empty($pageId)) {
            return [
                'code' => 10001,
                'message' => '参数 page_id 不能为空',
            ];
        }

        $deviceType = $this->request->post('device_type', PageElementType::DEVICE_TYPE_PC);

        /* @var $page Page */
        $page = Page::find()
            ->where([
                'id' => $pageId,
                'status' => [
                    Page::STATUS_NORMAL,
                    Page::STATUS_HIDDEN,
                ],
            ])
            ->limit(1)->one();
        if (empty($page)) {
            return [
                'code' => 10001,
                'message' => '该页面不存在',
            ];
        }

        $pageElements = PageElement::find()
            ->joinWith(['element_type'])
            ->with(['element_type.fields'])
            ->where([
                'page_elements.page_id' => $pageId,
                'page_element_types.device_type' => $deviceType
            ])->orderBy('page_elements.order_number ASC, page_elements.id ASC')->asArray()->all();

        $elementIds = array_map(fn($el) => $el['id'], $pageElements);

        $inputs = PageElementInput::find()
            ->where(['element_id' => $elementIds])
            ->asArray()
            ->all();

        // 构建以 element_id 和 field_id 为索引的值集合
        $inputMap = [];
        foreach ($inputs as $input) {
            $inputMap[$input['element_id']][$input['field_id']] = $input;
        }


        // 给每个字段加上 input
        foreach ($pageElements as &$element) {

            $element['style'] = StringHelper::parseIfJson($element['style']);
            $element['inputs'] = [];
            $element['slots'] = [];
            foreach ($element['element_type']['fields'] as &$field) {

                $fieldId = $field['id'];
                $fieldName = $field['name'];
                $fieldType = $field['field_type'];
                $elementId = $element['id'];

                $input = $inputMap[$elementId][$fieldId] ?? null;
                $value = isset($input['value']) ? StringHelper::parseIfJson($input['value']) : null;
                $style = isset($input['style']) ? StringHelper::parseIfJson($input['style']) : null;

                if ($fieldType == PageElementFieldType::TYPE_DATA_SOURCE) {
                    // 数据源字段
                    if (is_array($value) && ($value['type'] ?? '') === 'recommendation_slot') {
                        $alias = $value['value'] ?? '';
                        if ($alias) {
                            $element['slots'][$fieldName] = RecommendationSlot::getSlotWithContentsByAlias($alias);
                        }
                    }
                }
                // 普通字段
                $element['inputs'][$fieldName]['value'] = $value;
                $element['inputs'][$fieldName]['style'] = $style;
            }

            $element['inputs'] = !empty($element['inputs']) ? $element['inputs'] : null;
            $element['slots'] = !empty($element['slots']) ? $element['slots'] : null;
        }


        return [
            'code' => 10000,
            'message' => '获取页面元素列表成功',
            'data' => $pageElements
        ];
    }


    /**
     * 获取页面元素的字段列表
     *
     * @return array
     */
    public function actionGetElementsByPageId(): array
    {
        $pageId = $this->request->post('page_id');
        if (empty($pageId)) {
            return [
                'code' => 10001,
                'message' => '参数 page_id 不能为空',
            ];
        }

        $deviceType = $this->request->post('device_type', PageElementType::DEVICE_TYPE_PC);

        /* @var $page Page */
        $page = Page::find()
            ->where([
                'id' => $pageId,
                'status' => [
                    Page::STATUS_NORMAL,
                    Page::STATUS_HIDDEN,
                ],
            ])
            ->limit(1)->one();
        if (empty($page)) {
            return [
                'code' => 10001,
                'message' => '该页面不存在',
            ];
        }

        $pageElements = PageElement::find()
            ->joinWith(['element_type'])
            ->with(['element_type.fields'])
            ->where([
                'page_elements.page_id' => $pageId,
                'page_element_types.device_type' => $deviceType
            ])->orderBy('page_elements.order_number ASC, page_elements.id ASC')->asArray()->all();

        $elementIds = array_map(fn($el) => $el['id'], $pageElements);

        $inputs = PageElementInput::find()
            ->where(['element_id' => $elementIds])
            ->asArray()
            ->all();

        // 构建以 element_id 和 field_id 为索引的值集合
        $inputMap = [];
        foreach ($inputs as $input) {
            $inputMap[$input['element_id']][$input['field_id']] = $input;
        }


        // 给每个字段加上 input
        foreach ($pageElements as &$element) {

            $element['style'] = StringHelper::parseIfJson($element['style']);
            $element['inputs'] = [];
            $element['slots'] = [];
            foreach ($element['element_type']['fields'] as &$field) {

                $fieldId = $field['id'];
                $fieldName = $field['name'];
                $fieldType = $field['field_type'];
                $elementId = $element['id'];

                $input = $inputMap[$elementId][$fieldId] ?? null;
                $value = isset($input['value']) ? StringHelper::parseIfJson($input['value']) : null;
                $style = isset($input['style']) ? StringHelper::parseIfJson($input['style']) : null;

                if ($fieldType == PageElementFieldType::TYPE_DATA_SOURCE) {
                    // 数据源字段
                    if (is_array($value) && ($value['type'] ?? '') === 'recommendation_slot') {
                        $alias = $value['value'] ?? '';
                        if ($alias) {
                            $element['slots'][$fieldName] = RecommendationSlot::getSlotWithContentsByAlias($alias);
                        }
                    }
                }
                // 普通字段
                $element['inputs'][$fieldName]['value'] = $value;
                $element['inputs'][$fieldName]['style'] = $style;
            }

            $element['inputs'] = !empty($element['inputs']) ? $element['inputs'] : null;
            $element['slots'] = !empty($element['slots']) ? $element['slots'] : null;
        }


        return [
            'code' => 10000,
            'message' => '获取页面元素列表成功',
            'data' => $pageElements
        ];
    }

5. Printing $pageElements reveals that the element 1833011727103953 no longer exists in $pageElements. See Figure 2

Plaintext

    [2] => common\models\PageElement Object
        (
            [_attributes:yii\db\BaseActiveRecord:private] => Array
                (
                    [id] => 1833011727103953
                    [element_type_id] => 1833011727099549
                    [page_id] => 1833011727101232
                    [device_type] => 1
                    [style] => 
                    [order_number] => 3
                    [created_at] => 2025-05-29 15:55:59
                    [updated_at] => 2025-05-29 15:55:59
                )

            [_oldAttributes:yii\db\BaseActiveRecord:private] => Array
                (
                    [id] => 1833011727103953
                    [element_type_id] => 1833011727099549
                    [page_id] => 1833011727101232
                    [device_type] => 1
                    [style] => 
                    [order_number] => 3
                    [created_at] => 2025-05-29 15:55:59
                    [updated_at] => 2025-05-29 15:55:59
                )

            [_related:yii\db\BaseActiveRecord:private] => Array
                (
                )

            [_relationsDependencies:yii\db\BaseActiveRecord:private] => Array
                (
                )

            [_errors:yii\base\Model:private] => 
            [_validators:yii\base\Model:private] => 
            [_scenario:yii\base\Model:private] => default
            [_events:yii\base\Component:private] => Array
                (
                )

            [_eventWildcards:yii\base\Component:private] => Array
                (
                )

            [_behaviors:yii\base\Component:private] => Array
                (
                )

        )


    [2] => common\models\PageElement Object
        (
            [_attributes:yii\db\BaseActiveRecord:private] => Array
                (
                    [id] => 1833011727103953
                    [element_type_id] => 1833011727099549
                    [page_id] => 1833011727101232
                    [device_type] => 1
                    [style] => 
                    [order_number] => 3
                    [created_at] => 2025-05-29 15:55:59
                    [updated_at] => 2025-05-29 15:55:59
                )

            [_oldAttributes:yii\db\BaseActiveRecord:private] => Array
                (
                    [id] => 1833011727103953
                    [element_type_id] => 1833011727099549
                    [page_id] => 1833011727101232
                    [device_type] => 1
                    [style] => 
                    [order_number] => 3
                    [created_at] => 2025-05-29 15:55:59
                    [updated_at] => 2025-05-29 15:55:59
                )

            [_related:yii\db\BaseActiveRecord:private] => Array
                (
                )

            [_relationsDependencies:yii\db\BaseActiveRecord:private] => Array
                (
                )

            [_errors:yii\base\Model:private] => 
            [_validators:yii\base\Model:private] => 
            [_scenario:yii\base\Model:private] => default
            [_events:yii\base\Component:private] => Array
                (
                )

            [_eventWildcards:yii\base\Component:private] => Array
                (
                )

            [_behaviors:yii\base\Component:private] => Array
                (
                )

        )

6. Adjust the list query method so that it matches the query conditions used when setting the sort order. The results now meet expectations: sorting starts at 1, and each subsequent element’s order number increments by 1. See Figure 3

Adjust the list query method so that it matches the query conditions used when setting the sort order. The results now meet expectations: sorting starts at 1, and each subsequent element's order number increments by 1 — Figure 3

PHP

        $pageElements = PageElement::find()
            ->joinWith(['element_type'])
            ->with(['element_type.fields'])
            ->where([
                'page_elements.page_id' => $pageId,
                'page_element_types.device_type' => $deviceType
            ])->orderBy('page_elements.order_number ASC, page_elements.id ASC')->asArray()->all();


        $pageElements = PageElement::find()
            ->with(['element_type.fields'])
            ->where([
                'page_id' => $pageId,
                'device_type' => $deviceType
            ])->orderBy('order_number ASC, id ASC')->asArray()->all();

        $pageElements = PageElement::find()
            ->joinWith(['element_type'])
            ->with(['element_type.fields'])
            ->where([
                'page_elements.page_id' => $pageId,
                'page_element_types.device_type' => $deviceType
            ])->orderBy('page_elements.order_number ASC, page_elements.id ASC')->asArray()->all();


        $pageElements = PageElement::find()
            ->with(['element_type.fields'])
            ->where([
                'page_id' => $pageId,
                'device_type' => $deviceType
            ])->orderBy('order_number ASC, id ASC')->asArray()->all();

关于作者 · 持续学习与技术实践

我是一名拥有 15 年以上开发经验的技术从业者，自 2013 年起持续运营个人技术博客，记录工作与个人项目中遇到的真实问题，以及解决问题过程中的探索、实践和思考。

除了技术写作，我也在持续开发和维护自己的独立项目，探索新技术和新工具在实际场景中的应用。我始终相信，没有不值得去解决的问题，也没有不值得去学习的技术。

如果这篇文章对你有所帮助，欢迎浏览博客中的其他文章，也欢迎交流技术经验与想法。

关于我 · GitHub · 邮件联系

Troubleshooting Code That Works on Windows Locally but Fails on Linux

更多文章

保护机制也会保护错东西：为什么一个 Documentation 能阻塞整页修订？

页面明明是我自己的，为什么不能直接重写？从 /translation/ 改版看 immutable source 与 replacement successor

为什么修完 Reviewer 指出的所有例子，下一轮还是会失败？从 B→revision→B 看同类问题完整性

为下一次 PHP 8.5 升级做准备：从两次验证失败到自动回滚工具完成