An unexpected error occurred.

mysql error: [1242: Subquery returns more than 1 row] in EXECUTE(" SELECT h.http_host AS host, ( SELECT pp.cPath FROM PagePaths AS pp WHERE pp.cID = ( SELECT c.cID FROM Pages AS p INNER JOIN CollectionVersions AS c ON ( p.cID = c.cID ) WHERE c.cvIsApproved = 1 AND p.cParentID = i.instance_id ORDER BY p.cDisplayOrder ASC LIMIT 1 ) ) AS home, ( SELECT MD5(c2.cID) AS itb FROM Pages AS p2 INNER JOIN CollectionVersions AS c2 ON ( p2.cID = c2.cID ) WHERE c2.cvIsApproved = 1 AND p2.cParentID = i.instance_id ORDER BY p2.cDisplayOrder ASC LIMIT 1 ) AS itb FROM bbcms_instances AS i LEFT JOIN bbcms_http_hosts AS h ON ( i.http_host_id = h.http_host_id ) WHERE i.instance_id = '9040' ")

< Back to Home