There was query related issues when comes empty or null value in here
JROOT/components/com_sppagebuilder/helpers/articles.php:407
Fixed Code:
public static function getCategories($parent_id = [1], $include_subcategories = true, $child = false, $cats = array()) {
$app = Factory::getApplication();
$db = Factory::getDbo();
$query = $db->getQuery(true);
$query
->select('*')
->from($db->quoteName('#__categories'))
->where($db->quoteName('extension') . ' = ' . $db->quote('com_content'))
->where($db->quoteName('published') . ' = ' . $db->quote(1))
->where($db->quoteName('access') . " IN (" . implode(',', Factory::getUser()->getAuthorisedViewLevels()) . ")")
->where($db->quoteName('language') . " IN (" . $db->Quote(Factory::getLanguage()->getTag()) . ", " . $db->Quote('*') . ")");
// Sanitize and check parent IDs
$filteredIds = array_filter(array_map('intval', $parent_id));
if (!empty($filteredIds)) {
$query->where($db->quoteName('parent_id') . " IN (" . implode(',', $filteredIds) . ")");
}
$query->order($db->quoteName('lft') . ' ASC');
$db->setQuery($query);
$rows = $db->loadObjectList();
foreach ($rows as $row) {
if ($include_subcategories) {
$cats[] = $row->id;
if (self::hasChildren($row->id)) {
$cats = self::getCategories([$row->id], $include_subcategories, true, $cats);
}
}
}
return $cats;
}