Error 500 after uploading firsrt Public files

[tredelijkheid]

Hi,

I have been running JD for months without any issues. Until now I have only been using Registered files and not Public downloads. I have now added 5 files and now get an error 500 on every click on a "Download". This is what it looks like:



   





Duplicate column name 'uploads_default_access_level' SQL=ALTER TABLE `nen9v_jdownloads_usergroups_limits` ADD `uploads_default_access_level` INT( 10 ) NOT NULL DEFAULT '0' AFTER `uploads_can_change_category`;

An error has occurred.

    500 Unknown column 'a.featured' in 'where clause' SQL=SELECT COUNT(*) FROM `nen9v_jdownloads_files` AS a LEFT JOIN nen9v_users AS uc ON uc.id=a.checked_out LEFT JOIN `nen9v_jdownloads_files` AS f ON f.file_id = a.other_file_id LEFT JOIN `nen9v_languages` AS l ON l.lang_code = a.language LEFT JOIN nen9v_viewlevels AS ag ON ag.id = a.access LEFT JOIN nen9v_jdownloads_categories AS c ON c.id = a.cat_id LEFT JOIN nen9v_jdownloads_categories AS cc ON cc.id = c.parent_id WHERE (a.published = 0 OR a.published = 1) AND (a.featured = 0 OR a.featured = 1) Unknown column 'a.featured' in 'field list' SQL=SELECT a.file_id, a.file_title, a.file_alias, a.description, a.file_pic, a.price, a.release, a.cat_id, a.size, a.date_added, a.publish_from, a.publish_to, a.use_timeframe, a.url_download, a.other_file_id, a.extern_file, a.downloads, a.extern_site, a.notes, a.access, a.language, a.checked_out, a.checked_out_time, a.ordering, a.featured, a.published, a.asset_id,uc.name AS editor,f.url_download AS other_file_name, f.file_title AS other_download_title,l.title AS language_title,ag.title AS access_level,c.title AS category_title, c.parent_id AS category_parent_id,cc.title AS category_title_parent FROM `nen9v_jdownloads_files` AS a LEFT JOIN nen9v_users AS uc ON uc.id=a.checked_out LEFT JOIN `nen9v_jdownloads_files` AS f ON f.file_id = a.other_file_id LEFT JOIN `nen9v_languages` AS l ON l.lang_code = a.language LEFT JOIN nen9v_viewlevels AS ag ON ag.id = a.access LEFT JOIN nen9v_jdownloads_categories AS c ON c.id = a.cat_id LEFT JOIN nen9v_jdownloads_categories AS cc ON cc.id = c.parent_id WHERE (a.published = 0 OR a.published = 1) AND (a.featured = 0 OR a.featured = 1) ORDER BY a.file_title asc LIMIT 0, 20 Unknown column 'a.featured' in 'where clause' SQL=SELECT COUNT(*) FROM `nen9v_jdownloads_files` AS a LEFT JOIN nen9v_users AS uc ON uc.id=a.checked_out LEFT JOIN `nen9v_jdownloads_files` AS f ON f.file_id = a.other_file_id LEFT JOIN `nen9v_languages` AS l ON l.lang_code = a.language LEFT JOIN nen9v_viewlevels AS ag ON ag.id = a.access LEFT JOIN nen9v_jdownloads_categories AS c ON c.id = a.cat_id LEFT JOIN nen9v_jdownloads_categories AS cc ON cc.id = c.parent_id WHERE (a.published = 0 OR a.published = 1) AND (a.featured = 0 OR a.featured = 1)

Call stack   
#      Function      Location   
1      JApplicationCms->execute()      /volume1/web/administrator/index.php:47   
2      JApplicationAdministrator->doExecute()      /volume1/web/libraries/cms/application/cms.php:252   
3      JApplicationAdministrator->dispatch()      /volume1/web/libraries/cms/application/administrator.php:152   
4      JComponentHelper::renderComponent()      /volume1/web/libraries/cms/application/administrator.php:98   
5      JComponentHelper::executeComponent()      /volume1/web/libraries/cms/component/helper.php:372   
6      require_once()      /volume1/web/libraries/cms/component/helper.php:392   
7      JControllerLegacy->execute()      /volume1/web/administrator/components/com_jdownloads/jdownloads.php:39   
8      jdownloadsController->display()      /volume1/web/libraries/legacy/controller/legacy.php:728   
9      JControllerLegacy->display()      /volume1/web/administrator/components/com_jdownloads/controller.php:46   
10      jdownloadsViewdownloads->display()      /volume1/web/libraries/legacy/controller/legacy.php:690   
11      JError::raiseError()      /volume1/web/administrator/components/com_jdownloads/views/downloads/view.html.php:59   
12      JError::raise()      /volume1/web/libraries/legacy/error/error.php:254
And by the way, i am running on jDownloads Version 3.2.24 beta. I cannot seem to upgrade it via the web interface.... Many thanks for your help!

[Arno]

And by the way, i am running on jDownloads Version 3.2.24 beta. I cannot seem to upgrade it via the web interface.... Many thanks for your help!

This can not really be. We have first in the last release added the 'featured' functionality. So please check again the used jD version.

To solve your 'featured' error, you can use this hints:
http://www.jdownloads.com/forum/index.php?topic=8641.msg35224#msg35224

[tredelijkheid]

Arno, thanks!


The adding of the Featured field worked!

Will check the version issue but atleast the downloading works again.