ThirtyBeesDatabaseException

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND `nright` < )' at line 3

in file classes/Category.php at line 2616

SQL

SELECT `id_category`
FROM `tb_marineudcategory`
WHERE (`nleft` >  AND `nright` < )

Source file: classes/Category.php

2597:            $this->recursiveDelete($toDelete, (int) $row['id_category']);
2598:        }
2599:    }
2600:
2601:    /**
2602:     * Get all ids of all subcategories of the current category
2603:     *
2604:     * @since   1.0.0
2605:     * @version 1.0.0 Initial version
2606:     * @return array list of ids of the subcategories
2607:     * @throws PrestaShopDatabaseException
2608:     * @throws PrestaShopException
2609:     */
2610:    public function getAllSubcategories()
2611:    {
2612:        return Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS(
2613:            (new DbQuery())
2614:                ->select('`id_category`')
2615:                ->from('category')
2616:                ->where('`nleft` > '.$this->nleft.' AND `nright` < '.$this->nright)
2617:        );
2618:    }
2619:
2620:    /**
2621:     * @param $table \CoreUpdater\TableSchema
2622:     */
2623:    public static function processTableSchema($table)
2624:    {
2625:        if ($table->getNameWithoutPrefix() === 'category_lang') {
2626:            $table->reorderColumns(['id_category', 'id_shop', 'id_lang']);

Stack trace