A permission issue or something else?

[danieledel]

I have a Joomla-based site that has shared over 400 files with thousands of people for years:
http://www.ansuitalia.it/Portale/download-ansu.html
After updating to Jdownloads 4.0.47, "public" and "guest" users are NOT able to download files. However, for Joomla administrators, everything seems normal (pictured below), and the files download without problems.



I tried changing the permissions for individual files offered for download, because downloads for all files were blocked for "public" and "guest" users. However, even doing so file by file did not resolve the problem. What can I do? I made a donation in euros to Jdownloads, and there may be another one.
Have a good day.

[ColinM]

Hi
This is most likely be to do with the User Group Settings for Public and for Guest

The standard ranking level for Public is 1 and for Guest it is 0.  Zero ranking means in effect no access so I suggest changing ranking of Public to say 5 and Guest to say 4.

Look at the User Group settings settings for Administrator that is Group Settings, GroupCreation/Editing Settings and Limits. Change the settings in Public and Guest to match those in Registered.  There are some items in Group Settings, such as "Display add/upload icon" that are not appropriate for public or gueest.
Colin

[danieledel]

Thanks for the advice, but I'm browsing Joomla and can't figure out exactly where I should change the permissions. Which section within the administration are we talking about? Sorry, but I don't understand. Have a good evening.

[ColinM]

Hi  There is a whole section on Access & User Group Settings in the Documentation.

Access is from the backend Click on Components, then on jDownloads and next on UserGroups.

Colin

[danieledel]

Thank you, I discovered a problem, now I'm off to work on the database.
Have a nice day.

[danieledel]

After careful research, I discovered that the "form_fieldset" value is missing from the MySQL database. I'm concerned that some values ��or entire sections may be missing from the database. Below is a photo of the various database sections where everything related to Jdownloads should be located. Do you think I'm missing something? Thanks for any help.
Have a nice day.

[ColinM]

Hi
Good work! Yes "form_fieldset" is in the usergroups part of the database.
See in the documentation the entire strucure of the database
https://www.jdownloads.net/documentation?view=article&id=320&catid=28

Do you have Akeeba backups or similar?  First I would suggest you make a backup of the present site. Then restore an earliere backup but note that any recently added Dowloads, Categories and so on will be lost so yo need to note the changes. You might consider setting up a second site and working on that site.
Also check with your hosting service as they may have site backups.
Best wishes
Colin

[danieledel]

I figured out what's wrong: that table has the wrong data in the database, so much so that it hangs when copying it from one database to another. I don't have any backups that don't have the problem. I need a ready-made table from that Jdownloads database as a file, a file I would import into my database after deleting the corrupted table. It would contain a working configuration that I would then modify to adapt it. Can you provide me with a working one so I could download it and insert it into my database? Thanks and have a good day.

[ColinM]

Hi
My suggestion is that you first check that all the downloadable files exist OK.
On the site check that in Directory jDownloads there are directories that correspond to your categores, and that the categories contain the actual downloadable files.
Please see the article https://www.jdownloads.net/documentation?view=article&id=253&catid=26 which describes how to uninstall jD.

All users details are in the Joomla database. However check the jD usergroup settings for each user type, that is super users, administrators and so on. when you have those details then you can go to the uninstall stage as noted below.

In the Uminstall ensure you KEEP the Images and the Files but select to delete the database. After the Uninstall completes then re-install the latest jD. This will create a new database table. You will have to restore any usergroup settings.
At each stage check
Best wishes
Colin
This will recreate the database to match the items. but you will have to

[danieledel]

I managed to fix the Jdownload UserGroup system by deleting a group that I had added after the Joomla installation, the supporters group, and now I have managed to change the "public" ranking to 5 and the "guest" one to 4 as indicated above, but the problem continues as before: http://www.ansuitalia.it/Portale/download-ansu.html?view=category&catid=52

Will this method cause the descriptions of over 400 files to disappear, and will I have to rewrite them one by one? How can I recover the descriptions and images that were included in the descriptions of each file offered for download?
Thanks and have a nice day.

[ColinM]

Hi
Yes the method described would loose the Descriptions and similar.  Regreatably I am not a database expert!! So I am not sure of the way to save a table and later restore it.  Maybe your hosting service might be able to help.
Colin

[danieledel]

Should Jdownloads files be set to 644 or 755 in FTP permissions? And what FTP permissions should its folders have?

A strange thing about the Jdownloads installed on my site is that every attempt I make to install the Italian language version fails, but on other websites I've created with Joomla, I can easily install Jdownloads in Italian. I'm worried there's some kind of corruption in Joomla that I've never noticed. I checked the Jdownloads installation log, and it says there were no errors.

I've carefully examined the database tables with the Joomla "FF Explorer" component, and the permissions for the "jdownloads usergroups limits" table appear to be fine (as noted above). Examining the "jdownloads file" table, it appears all the files offered for download are fine (all at level 1 with the "access" value). I'm looking at other tables, but it's possible the problem isn't in the database, where everything works fine, but rather within Joomla or the Jdownloads component. I tried accessing my site with a browser set to English (without logging in), but even that didn't show the files in the various folders. It's a real mystery, I'll sleep on it. Thanks for any help, and good night.

[ColinM]

Hi
Files should be set to 644, folders to 755
Colin

[danieledel]

Thanks, I fixed all the file permissions via FTP. Unfortunately, the problem hasn't been resolved. I'm open to anyone's ideas.
Thanks and have a good day.