Dear jDownloads users, There is currently no Joomla 6 compatible version available. However, we are working on it and hope to release it shortly.
SELECT name, COUNT(*) AS cnt
FROM #__assets
WHERE name = 'com_jdownloads'
OR name LIKE 'com_jdownloads.category.%'
OR name LIKE 'com_jdownloads.download.%'
GROUP BY name
HAVING COUNT(*) > 1
ORDER BY cnt DESC, name ASC;
SELECT id, parent_id, lft, rgt, level, name, title, rules
FROM #__assets
WHERE name = 'com_jdownloads'
ORDER BY id;SELECT 'category' AS row_type, c.id, c.asset_id
FROM #__jdownloads_categories c
LEFT JOIN #__assets a ON a.id = c.asset_id
WHERE c.asset_id IS NULL OR c.asset_id = 0 OR a.id IS NULL
UNION ALL
SELECT 'download' AS row_type, d.id, d.asset_id
FROM #__jdownloads_files d
LEFT JOIN #__assets a2 ON a2.id = d.asset_id
WHERE d.asset_id IS NULL OR d.asset_id = 0 OR a2.id IS NULL
ORDER BY row_type, id;SELECT d.id, d.catid, d.access, v.title AS access_level_title, d.user_access, d.created_by
FROM #__jdownloads_files d
LEFT JOIN #__viewlevels v ON v.id = d.access
WHERE d.id IN (701, 663, 4636)
ORDER BY d.id;
SELECT id, title, rules
FROM #__viewlevels
WHERE id = 7;
DELETE a
FROM #__assets a
JOIN (
SELECT name, MIN(id) AS keep_id
FROM #__assets
WHERE name = 'com_jdownloads'
OR name LIKE 'com_jdownloads.category.%'
OR name LIKE 'com_jdownloads.download.%'
GROUP BY name
HAVING COUNT(*) > 1
) k ON k.name = a.name
WHERE a.id <> k.keep_id;