I think we are at par now with late replys.
I made two new upload tests: The upload of a .zip version of LV's Cheatpackage worked
. The upload of the XTM Patch.exe 0.75 was still somewhat problematic though. The initial upload itself worked fine too and the download entry showed up correctly on the overview page (under X3: Reunion -> Total Conversions). However, clicking on it would always bring up a 404 page not found error. The edit button worked fine though and brought me to the normal Edit Download page of the file, where I could make and save changes. I then deleted the file from xdownloads and received these two messages:
Error
The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay SQL=SELECT a.file_id, a.file_title, a.file_alias, a.description, a.description_long, a.file_pic, a.images, a.price, a.release, a.file_language, a.system, a.license, a.url_license, a.license_agree, a.size, a.date_added, a.file_date, a.publish_from, a.publish_to, a.use_timeframe, a.url_download, a.preview_filename, a.other_file_id, a.md5_value, a.sha1_value, a.extern_file, a.extern_site, a.mirror_1, a.mirror_2, a.extern_site_mirror_1, a.extern_site_mirror_2, a.url_home, a.author, a.url_author, a.created_id, a.created_mail, a.modified_id, a.modified_date, a.submitted_by, a.set_aup_points, a.downloads, a.cat_id, a.changelog, a.password, a.password_md5, a.views, a.metakey, a.metadesc, a.robots, a.update_active, a.custom_field_1, a.custom_field_2, a.custom_field_3, a.custom_field_4, a.custom_field_5, a.custom_field_6, a.custom_field_7, a.custom_field_8, a.custom_field_9, a.custom_field_10, a.custom_field_11, a.custom_field_12, a.custom_field_13, a.custom_field_14, a.access, a.language, a.ordering, a.featured, a.published, a.checked_out, a.checked_out_time, a.modified_date as modified, a.modified_id,CASE WHEN a.publish_from = 0 THEN a.date_added ELSE a.publish_from END as publish_from,a.publish_to, a.images, a.metakey, a.metadesc, a.access, a.downloads, LENGTH(a.description_long) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.published END AS state,aa.url_download AS filename_from_other_download,c.title AS category_title, c.access AS category_access, c.alias AS category_alias, c.cat_dir AS category_cat_dir, c.cat_dir_parent AS category_cat_dir_parent,u.name AS creator,u2.name AS modifier,u2.name AS modifier,l.title AS license_title, l.url AS license_url, l.description AS license_text, l.id as lid,ROUND(r.rating_sum / r.rating_count, 0) AS rating, r.rating_count as rating_count, r.rating_sum as rating_sum,parent.title as parent_title, parent.id as parent_id, parent.alias as parent_alias,menuf.id AS menuf_itemid,menuc.id AS menuc_cat_itemid,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM #__jdownloads_files AS a LEFT JOIN #__jdownloads_files AS aa on aa.file_id = a.other_file_id LEFT JOIN #__jdownloads_categories AS c ON c.id = a.cat_id LEFT JOIN #__users AS ua ON ua.id = a.created_id LEFT JOIN #__users AS uam ON uam.id = a.modified_id LEFT JOIN #__users AS u on u.id = a.created_id LEFT JOIN #__users AS u2 on u2.id = a.modified_id LEFT JOIN #__jdownloads_licenses AS l on l.id = a.license LEFT JOIN #__jdownloads_ratings AS r on r.file_id = a.file_id LEFT JOIN #__jdownloads_categories as parent ON parent.id = c.parent_id LEFT JOIN (SELECT id, link, access, published from #__menu GROUP BY link) AS menuf on menuf.link LIKE CONCAT('index.php?option=com_jdownloads&view=download&id=',a.file_id) AND menuf.published = 1 AND menuf.access IN (1,1,2,3,6) LEFT JOIN (SELECT id, link, access, published from #__menu GROUP BY link) AS menuc on menuc.link LIKE CONCAT('index.php?option=com_jdownloads&view=category&catid=',a.cat_id) AND menuc.published = 1 AND menuc.access IN (1,1,2,3,6) LEFT OUTER JOIN (SELECT cat.id as id FROM #__jdownloads_categories AS cat JOIN #__jdownloads_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id WHERE a.access IN (1,1,2,3,6) AND c.access IN (1,1,2,3,6) AND CASE WHEN badcats.id is null THEN a.published ELSE 0 END IN (0,1,2) AND (a.publish_from = '0000-00-00 00:00:00' OR a.publish_from <= '2016-09-09 09:43:53') AND (a.publish_to = '0000-00-00 00:00:00' OR a.publish_to >= '2016-09-09 09:43:53') ORDER BY a.downloads DESC LIMIT 1000 The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay SQL=SELECT COUNT(*) FROM #__jdownloads_files AS a LEFT JOIN #__jdownloads_files AS aa on aa.file_id = a.other_file_id LEFT JOIN #__jdownloads_categories AS c ON c.id = a.cat_id LEFT JOIN #__users AS ua ON ua.id = a.created_id LEFT JOIN #__users AS uam ON uam.id = a.modified_id LEFT JOIN #__users AS u on u.id = a.created_id LEFT JOIN #__users AS u2 on u2.id = a.modified_id LEFT JOIN #__jdownloads_licenses AS l on l.id = a.license LEFT JOIN #__jdownloads_ratings AS r on r.file_id = a.file_id LEFT JOIN #__jdownloads_categories as parent ON parent.id = c.parent_id LEFT JOIN (SELECT id, link, access, published from #__menu GROUP BY link) AS menuf on menuf.link LIKE CONCAT('index.php?option=com_jdownloads&view=download&id=',a.file_id) AND menuf.published = 1 AND menuf.access IN (1,1,2,3,6) LEFT JOIN (SELECT id, link, access, published from #__menu GROUP BY link) AS menuc on menuc.link LIKE CONCAT('index.php?option=com_jdownloads&view=category&catid=',a.cat_id) AND menuc.published = 1 AND menuc.access IN (1,1,2,3,6) LEFT OUTER JOIN (SELECT cat.id as id FROM #__jdownloads_categories AS cat JOIN #__jdownloads_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id WHERE a.access IN (1,1,2,3,6) AND c.access IN (1,1,2,3,6) AND CASE WHEN badcats.id is null THEN a.published ELSE 0 END IN (0,1,2) AND (a.publish_from = '0000-00-00 00:00:00' OR a.publish_from <= '2016-09-09 09:43:53') AND (a.publish_to = '0000-00-00 00:00:00' OR a.publish_to >= '2016-09-09 09:43:53')
and now everything seems to work as it should.