openhands
cea88eaa57
The Arcturus errors "page hierarchy contains a cycle page 354 and 357" and "sibling order 1 is used more than once (111 problems)" come from catalog_pages, not catalog_items: pages 354/357 point at themselves, and many parents have child pages sharing the same order_num. Extend the emulator catalog scan + fix to detect both: pages whose parent chain loops back get detached (parent_id = 0 on the highest cycle member) and every affected parent's children are renumbered sequentially, preserving their current relative order. Add scripts/diag-emulator.ts to inspect the live catalog state.
33 lines
1.2 KiB
TypeScript
33 lines
1.2 KiB
TypeScript
import "./load-env";
|
|
import { sql } from "drizzle-orm";
|
|
import { db } from "@/lib/db";
|
|
|
|
async function main() {
|
|
const [dp] = (await db.execute(sql`
|
|
SELECT CAST(parent_id AS CHAR) parentId, CAST(order_num AS CHAR) orderNum, COUNT(*) c, GROUP_CONCAT(id) ids
|
|
FROM catalog_pages
|
|
GROUP BY parent_id, order_num
|
|
HAVING COUNT(*) > 1
|
|
`)) as unknown as [Array<Record<string, unknown>>, unknown];
|
|
console.log("=== catalog_pages duplicate (parent, order_num) groups ===");
|
|
console.log(JSON.stringify(dp));
|
|
|
|
const [children] = (await db.execute(sql`
|
|
SELECT CAST(parent_id AS CHAR) parentId, COUNT(*) c
|
|
FROM catalog_pages
|
|
WHERE parent_id <> 0
|
|
GROUP BY parent_id ORDER BY c DESC LIMIT 8
|
|
`)) as unknown as [Array<Record<string, unknown>>, unknown];
|
|
console.log("=== most children per parent ===");
|
|
console.log(JSON.stringify(children));
|
|
|
|
const [pages] = (await db.execute(sql`
|
|
SELECT CAST(id AS CHAR) id, CAST(parent_id AS CHAR) parentId, CAST(order_num AS CHAR) orderNum, caption_save caption, enabled
|
|
FROM catalog_pages WHERE id IN (353,354,355,356,357,358)
|
|
`)) as unknown as [Array<Record<string, unknown>>, unknown];
|
|
console.log("=== pages 353-358 ===");
|
|
console.log(JSON.stringify(pages, null, 1));
|
|
await db.$client?.end?.();
|
|
}
|
|
void main();
|