Why won't Proxmox install from a flash drive?

Question

Proxmox

I burned the ISO version using Etcher to a USB flash drive and when I try to install, I always get a black screen and reboot. screenshot before reboot

Answer 1

Not all images are suitable for a flash drive. Try to use ventoy, there is a chance that he can handle it.

Answer 2

Firstly, what kind of iso, 7.1 has been released for a long time ( PVE 7.1-2 )
Secondly, use Unetboot

Answer 3

SELECT DISTINCT `t`.`id`, `i`.`id` 
    FROM `cats` AS `c`
    JOIN `cats` AS `t` ON `t`.`NSLeft` >= `c`.`NSLeft` 
                       AND `t`.`NSRight` <= `c`.`NSRight`
    LEFT JOIN `cats_bind` AS `cb` ON `cb`.`cat_id` = `t`.`id`
    LEFT JOIN `items` AS `i` ON `i`.`category_id` = `t`.`id` 
                             OR `i`.`id` = `cb`.`item_id`
    WHERE `c`.`id` = :root_category
    ORDER BY `t`.`title`, `i`.`title`

Answer 4

Let's say SELECT_CATS is a query to get the id of all subcategories recursively.

SELECT * FROM items WHERE category_id IN (SELECT_CATS)
UNION
SELECT * FROM items WHERE item_id = (SELECT item_id FROM cats_bind WHERE cat_id IN (SELECT_CATS))