id	summary	reporter	owner	description	type	status	priority	milestone	component	version	resolution	keywords	cc	blockedby	blocking
2358	Magnalister SQL-Syntax-Fehler unter PHP 8.1	Karsta	somebody	"Nach Umstellung auf PHP 8.1 kommt im Magnalister folgende Fehlermeldung beim Vorbereiten der Artikel.

{{{
 SELECT SQL_CALC_FOUND_ROWS DISTINCT CategoryID, SiteID, CategoryName,
		           CategoryLevel, ParentID, LeafCategory
		      FROM magnalister_ebay_categories
		     WHERE CategoryID != ParentID AND ParentID = 
		           AND StoreCategory = '0'
                   AND SiteID = 77
		           AND InsertTimestamp > UNIX_TIMESTAMP() - 86400
		  ORDER BY CategoryName ASC
}}}

Und hier Auszug aus dem log:
{{{
[error] [modified] [pid:14679] mysqli object is already closed in File: /xxx/includes/external/magnalister/php/lib/MagnaDB.php on Line: 140 {} {}
}}}

"	Bug/Fehler	closed	normal	modified-shop-2.0.8.0	Module	2.0.7.2	fixed