jDownloads Support Forum

jDownloads for Joomla 4.x and 5.x => jDownloads 4.0 => General => Topic started by: danieledel on 19.03.2023 08:33:55

Title: Problem after update Joomla 3.9 for Joomla 4.2.
Post by: danieledel on 19.03.2023 08:33:55
Good morning,
I have some difficult question about Jdownloads.

I have a popular site based on Joomla 3.10 http://www.ansuitalia.it/Portale/ thanks to Jdownloads (in Italian language) I have uploaded many gigabytes of files to share them. I couldn't get it to joomla 4.2, resorted to server backup put everything back after the failures. So I made a copy of the site (except the heavy Jdownloads files, everything else had been copied to the new web portal) at http://www.ansuitalia.it/Portale_nuovo/ , the one gigabyte Mysql xxxxxxxx_1 database was copied in database xxxxxxxx_2, disabling various systems and plugins I was able to switch to Joomla 4.2 (even if the old original site remains on Joomla 3.10) which uses only the database xxxxxxxx_2, so for now the old site works too, waiting to use the new site when it will be completed.

The new site updated to Joomla 4.2 couldn't use the old Jdownloads, so I uninstalled it and installed the new Jdownloads (4.0.20 beta) for Joomla 4, but it had many strange problems, it didn't work. I uninstalled it again by also deleting the Jdownloads data inside the Mysql xxxxxxxx_2 database and when I reinstalled it everything seemed to work, I also started some test folders and everything seems ok. My problem? In the old Jdownloads I have many files (maybe 20 gigabytes) with their various description texts, some preview images of the contents, already split folders and subfolders. Instead of redoing all the super work from scratch I would like to be able to "import" the "old" Jdownloads into the new one, including the database data, texts, files and so with a few clicks everything is back in place, without many hours of effort. Is there a method? Is there any software that does this? Can I make a backup of the "old" Jdownloads content to "import" everything into the "new" one, even writing to the Mysql _2 database?

I await your kind directions, good evening.
Title: Re: Problem after update Joomla 3.9 for Joomla 4.2. - [Not a Bug!]
Post by: Arno on 20.03.2023 12:09:26
Hi daniel,
QuoteThe new site updated to Joomla 4.2 couldn't use the old Jdownloads, so I uninstalled it and installed the new Jdownloads (4.0.20 beta) for Joomla 4, but it had many strange problems, it didn't work.
It's a pity you didn't share your problems with the newly installed jDownloads 4 here!
You are the only one who has made such a statement so far. And in the meantime, several hundred users have installed the new version. I have received almost no error messages recently, but minor problems are bound to crop up here and there.

QuoteInstead of redoing all the super work from scratch I would like to be able to "import" the "old" Jdownloads into the new one, including the database data, texts, files and so with a few clicks everything is back in place, without many hours of effort. Is there a method? Is there any software that does this? Can I make a backup of the "old" Jdownloads content to "import" everything into the "new" one, even writing to the Mysql _2 database?
The database structure has changed somewhat in version 4. Therefore, you cannot simply take over the DB tables of the old 3.x version. However, there are only a few changes. I think I had already described the necessary changes somewhere. I'll have to check to see if I can find it again.

But the easiest way would have been to install the jDownloads 4 update. And that worked well for almost all users. Maybe you should try this again and tell me beforehand what problems you had before.

Since your post is not an bug report, I'm moving it. 

Title: Re: Problem after update Joomla 3.9 for Joomla 4.2.
Post by: danieledel on 20.03.2023 14:49:20
So to make all of Jdownloads work on Joomla 4 it was enough that I installed the new Jdownloads without removing the old Jdownloads (used by Joomla 3.10) and everything was already fine? I feel stupid, my problem is that the system showed me errors as soon as I enabled even one "previous" Jdownload element, and installing the new one it gave me errors, only by deleting the old one I was able to install the new one. I do not know what happened.

I'm ready to copy parts of the "old" (1) MySql database into the "new" (2) one, and to copy all the file folders calmly from the old site to the new one. I really want to fix the problem, and a lot of gratitude to whoever invented Jdownloads which is so awesome, I've been using it well for many years. Thanks a lot for Jdownload which is reliable and well thought out.
Good evening.
Title: Re: Problem after update Joomla 3.9 for Joomla 4.2.
Post by: Arno on 20.03.2023 15:34:31
Hi,
I suspect that you did not follow the described procedure for the update.

All the necessary information, instructions etc. can be found in the description for downloading the new version 4 here:
https://www.jdownloads.com/index.php/downloads/download/6-jdownloads/70-jdownloads-4.html

However, you should not try to increase the confusion.

I would therefore advise you to set up a new test site with completely the same content as your current Joomla 3.10 and jDownloads 3.9 version.

On this test site, then carry out the update to Joomla 4 and jDownloads 4 as described. Of course, you must deactivate all other extensions that are not compatible with Joomla 4. It is up to you to decide whether you want to use this new test site for your rebuild after the update, or whether you only want to use the current DB tables on the test site you created first.
Title: Re: Problem after update Joomla 3.9 for Joomla 4.2.
Post by: danieledel on 21.03.2023 17:53:34
Here's an update on my problem, without previous Jdownloads data in the MySql database, Jdownload 4_0_20_beta installs without problems inside Joomla 4, but so I NOT recover descriptions, folder tree, files, permissions and the rest. Yesterday I then had Jdownload data of database _1 copied to database _2 , as pictured below. All folders and subfolders are also copied to the component directory, in the right location.

(http://ansunet.altervista.org/_altervista_ht/Jdown/1.jpg)

However, after the MySql database has the data from the previous Jdownloads, installing Jdownload 4_0_20_beta gives an error message (picture below), but so I can't recover the data if I first delete the database data.

(http://ansunet.altervista.org/_altervista_ht/Jdown/3.jpg)

Even more strange is that, although the installation fails and Jdownload 4_0_20_beta does not appear in the list of components, the plugins and modules typical of Jdownload 4_0_20_beta appear in the list of extensions ... Let's say I'm going crazy? Obviously the method described above is not feasible, I can't start a third site based on Joomla 3.9 after all the work I've done, I'll have to invent some method that works.

(http://ansunet.altervista.org/_altervista_ht/Jdown/5.jpg)

I think a lot to find a problem, are there any ideas?
Good evening.
Title: Re: Problem after update Joomla 3.9 for Joomla 4.2.
Post by: Arno on 21.03.2023 22:22:27
Hi,
your jDownloads DB tables seems to be incorrect.

But I have to admit that her explanations confuse me a bit.  ::)
I'm not quite clear what they actually did and in what order. I'm afraid we won't be able to solve the problem that way.

There are two possibilities now:
1. you go back to the time before you tried the update process the first time. Then you try the update with the new version 4.0.21 which was released today. This version tries to correct the incorrect DB tables. You should then receive an information about invalid DB tables at the first start. Then start the update process a second time. The update should then complete successfully.

2. you send me a backup of the Joomla 3.10 database including the original 3.9.x jDownloads DB tables and I try to perform the update for you. If necessary with the necessary manual changes. Afterwards, I will send you the new database to import into your website.

Title: Re: Problem after update Joomla 3.9 for Joomla 4.2.
Post by: danieledel on 22.03.2023 08:56:15
Thank you very much for your kind resolution of the problem, you are a true expert and have a big heart. I emailed her how to download my database file.
Good day.
Title: Why was my post closed?
Post by: danieledel on 30.03.2023 10:00:45
I apologize but my post: https://www.jdownloads.com/forum/index.php?topic=13912.0 it was closed because it is said that I would not have sent anything, yet I have sent 3 different private emails from the site form: https://www.jdownloads.com/index.php/contact.html
I put the downloadable database .sql file with a link, inside my site, to allow for analysis once it was downloaded, all data was sent via email. I am willing to pay a cash reward to fix this.
Good day.
Title: Re: Why was my post closed?
Post by: Arno on 30.03.2023 13:43:39
Hi Daniel,
in this case seems something went wrong.  ::)

I have not received any PM or e-mail.  :-\

But I have open the original topic again. So I will move later the new posts to this topic.

I will send you a PM.
Title: Re: Problem after update Joomla 3.9 for Joomla 4.2.
Post by: danieledel on 30.03.2023 15:18:06
I sent the data to my database again, I used 2 emails that have the same name as the holder: danieledel@inxxxx.xx and danielozma@gxxxx.xxx . Thank you and good day.
Title: Re: Problem after update Joomla 3.9 for Joomla 4.2.
Post by: Arno on 30.03.2023 15:37:35
Hi Daniele,
I have now received your e-mail and also your PM.
I will try to check your DB tables tonight or tomorrow.
Title: Re: Problem after update Joomla 3.9 for Joomla 4.2.
Post by: Arno on 01.04.2023 22:54:53
Hi,
I have now checked out your jDownloads DB tables.

The problem is that this tables are from the very old version 3.2.x !
But it is not possible to update from this version directly to jDownloads 4.

So you must first try to run the update to the latest version 3.9.8.x.
You can find what you need for this here:
https://www.jdownloads.com/forum/index.php?topic=13923.msg49537#msg49537
Title: Re: Problem after update Joomla 3.9 for Joomla 4.2.
Post by: danieledel on 02.04.2023 09:25:54
As you know I have online both the "old site" (with Joomla 3.10) and the "new site" (Joomla 4) hidden in a secret folder. I installed Jdownloads 3.9 on the "old site" (double installation, as in the instructions) and everything seems to have gone well, the messages say that everything went well, the files are downloaded from the site. Thank you for all the help received so far.

(http://ansunet.altervista.org/_altervista_ht/Jdown/7.jpg)

But if I access the Mysql database of the "old site" I DON'T see titles of tables headed to Jdownloads 3.9 (for backup, like in the picture above taken a few minutes ago), so I wonder if I did it right or not. In fact, if everything is ok, I copy the new piece of Jdownloads database into the database of the "new site", and from there I start the installation of Jdownloads for Joomla 4. How do I check that the database is updated correctly? I await your kind directions, and have a good day. Thank you.
Title: Re: Problem after update Joomla 3.9 for Joomla 4.2.
Post by: ColinM on 02.04.2023 11:41:29
Hi,
From what you write I suggest that you abandon your 'new site'.  Think it is a 'complication' that is not needed. :)

Just do some test that your 'old site' is working OK.  For example can you create a new category in the backend,can you edit a download from the front end and so on. 
When you are happy that the old site is working then make an akeeba backup so you can restore it elsewhere if you should need it.
Ensure you are at latest version of Joomla 3.10

Then to upgrade the site from Joomla 3 to Joomla 4 by following the instructions in
https://www.jdownloads.net/documentation/getting-started-v3-9/upgrading-from-jd3-9-to-jd4-%7Bv4%7D

Also check you are at PHP8
  Colin
Title: Re: Problem after update Joomla 3.9 for Joomla 4.2.
Post by: danieledel on 02.04.2023 13:13:28
Thanks for the suggestion but by now the "new site" is ready while the gigantic "old site" should cost many hours of work to be adapted, when everything is ready I rename the online folder that contains one site and replace it with the other. Also having "new sites" has already helped me defend myself against mistakes I made while upgrading, like a lightning rod. Good day.
Title: Re: Problem after update Joomla 3.9 for Joomla 4.2.
Post by: ColinM on 02.04.2023 13:33:13

Hi,
From what you say your 'new site' is working.  Did you mananage to transfer your Categories and Dopwnloads from your 'old site' to the 'new site'?

One way to do this is to use an an FTP like FileZilla to copy the contents of the 'old site' jdownloads Directory (folder). Then copy them to the 'new site' jdownloads directory.  Next use the Check Downloads Area in the jD Control Panel (first I also change Option - Monitoring - Automatically publish new found Items to Yes) then use the check downloads button.

If you already have some Categories and Downloads in the new site it is then best done by each category/subcat to avoid overwriting existing items
Colin
Title: Re: Problem after update Joomla 3.9 for Joomla 4.2.
Post by: danieledel on 02.04.2023 17:26:55
Thanks for your advice but I don't think you read everything about this problem, I already copied from the old site to the new site everything I could, the problems are only in the database compatibility. Good evening.
Title: Re: Problem after update Joomla 3.9 for Joomla 4.2.
Post by: danieledel on 03.04.2023 10:17:41
Good news, I managed to upgrade to Jdownloads 3.9 on the "old site", then I copied the Mysql database piece to the "new site" and thanks to the data from it, when I installed the Jdownload 4.0.21 I managed to restore everything on the "new site", now I have to slowly reinsert all the modules and all the services in the various positions of the new graphic template, and change some settings. Thank you all and Jdownloads will always remain in my heart, a mythical and fantastic and unrivaled file management system for Joomla. Good day.
Title: Re: Problem after update Joomla 3.9 for Joomla 4.2.
Post by: Arno on 03.04.2023 13:56:17
Hi Daniele,
thank you very much for your praise and your good assessment. 

But I am afraid that they might still have problems with this kind of update.

Or have you also adapted the old table structure to the new version?

For example, try creating new downloads and categories in the backend to see if you get any error messages.
Title: Re: Problem after update Joomla 3.9 for Joomla 4.2.
Post by: danieledel on 06.04.2023 21:37:37
I tried to start a new category inside Jdownloads on Joomla 4.2 and it fails, it says "Save failed with the following error: Invalid Parent ID."

It didn't let me upload an .mp4 video to Jdownload's upload directory, so I compressed it in "zip" mode, and with the .zip extension it uploaded perfectly from the site without Ftp. When I clicked on the uploaded file to make it downloadable, going to the File section of Jdownloads, the error message "The selected file from the files list will be assigned to this new Download" appeared at the top, but I continued anyway. It seemed to be fine and that it was publishing the .zip file, but I went to the public directory where I had the file available, clicked to download it and it gave me this error: "info
The requested file was not found. Please inform the webmaster.: Vessare_gli_sfigati.zip" so I went to Jdownloads download list and deleted it.

Bottom line: I have Jdownloads blocked, I sang happiness and victory too soon. Good evening.
Title: Re: Problem after update Joomla 3.9 for Joomla 4.2.
Post by: Arno on 06.04.2023 23:05:33
Hi Daniele,
when you can send me a complete Akeeba backup from your Joomla installation AFTER you have updated to Joomla 4 but BEFORE you have tried the update to jDownloads 4, I will do the job for you!
Title: Re: Problem after update Joomla 3.9 for Joomla 4.2.
Post by: danieledel on 07.04.2023 08:52:47
Maybe I can privately give all the data to access my site? I mean both Ftp, and admin account? It would be better and more effective or faster. I await your kind directions, have a nice day.
Title: Re: Problem after update Joomla 3.9 for Joomla 4.2.
Post by: Arno on 07.04.2023 10:20:20
No this is more complicated for me as I need also access to the DB and so on.

Install the free akeeba backup extension and create a full backup: https://www.akeeba.com/download/akeeba-backup/9-5-1/pkg-akeebabackup-9-5-1-core-zip.raw
Afterwards download it and send it to my e-mail address info@jdownloads.com.

When the file should be to big, use a free hoster like https://wetransfer.com/
Here it is easy to send big files with only a few clicks.
Title: Re: Problem after update Joomla 3.9 for Joomla 4.2.
Post by: danieledel on 07.04.2023 17:13:50
I just finished backing up the site using Akeeba, it produced a 16.24 gigabyte file. I'm also willing to give online access to the Mysql database and to the Joomla site, giving the access data to everything via email, otherwise I'll try to put that gigantic file online. I await your kind directions, good evening and thanks for everything.
Title: Re: Problem after update Joomla 3.9 for Joomla 4.2.
Post by: Arno on 08.04.2023 09:24:54
I think 16 GB is to big.  :o

Maybe you could deselect the /jdownloads folder from the backup list?

QuoteI'm also willing to give online access to the Mysql database and to the Joomla site, giving the access data to everything via email,
Okay, let's try this.
Title: Re: Problem after update Joomla 3.9 for Joomla 4.2.
Post by: danieledel on 08.04.2023 16:38:09
Done, I have emailed my site login details, thank you for Jdownloads fixes, database access is also available. Good evening and thank you.
Title: Re: Problem after update Joomla 3.9 for Joomla 4.2.
Post by: danieledel on 11.04.2023 15:12:01
Could it be useful if I start the Ftp program called FileZilla, and change all the folders and subfolders and files related to Jdownloads to 755? I await your kind directions, good evening and thank you.
Title: Re: Problem after update Joomla 3.9 for Joomla 4.2.
Post by: danieledel on 14.04.2023 15:18:37
There are updates? Thank you and good day.
Title: Re: Problem after update Joomla 3.9 for Joomla 4.2.
Post by: danieledel on 17.04.2023 15:45:04
What happen? I can also pay some money, but I need the site to work, I've already sent all the access data via email. Good evening.
Title: Re: Problem after update Joomla 3.9 for Joomla 4.2.
Post by: Arno on 18.04.2023 21:17:04
Hi Daniele,
I am since a few days in my holidays in italy.
So i need a little more time to check your request again. Sorry.
Title: Re: Problem after update Joomla 3.9 for Joomla 4.2.
Post by: danieledel on 18.04.2023 22:49:42
Ok, let's wait for other days, I live in Lombardy. Good evening.
Title: Re: Problem after update Joomla 3.9 for Joomla 4.2.
Post by: danieledel on 21.04.2023 16:22:15
A mystery, strangely the files present in the Jdownloads folders have permissions set to 600, and in fact they are not downloaded. Shouldn't they be set to 755 or 644? In a post I read that this problem appears after installing Akeba (the one for backups). Now I try to change some permission from the server. Good day.

Here's what I found, in my site with Joomla 3.9 the "old" Jdownloads has all folders set to 775, and single downloadable files are set to 664 in permissions. In the "new site" instead the folders are always set to 775, but all the downloadable files are set to 600, practically impossible to work on them. Did I find the fault? Good evening.
Title: Re: Problem after update Joomla 3.9 for Joomla 4.2.
Post by: danieledel on 24.04.2023 16:14:00
Strangely the files were set to 600, with the help of the server I temporarily set all the files and folders to 755, so at least all site visitors are able to download all the files that Jdownloads has made available for years, I fixed it for "old files". So I tried to upload a file from the Joomla administration and it was added to the list of "creatable downloads", I tried to make it available but I couldn't. I then went to the management of the single "download", I deleted the file and AFTER the cancellation occurred I activated to upload it to upload it again, this error message appeared to me "danger Save failed with the following error: File could not be uploaded. Check the rights on your server (FTP: set to CHMOD 0755). See FAQ on setting file access rights." I'll stop for now, it's enough for me that at least we can download the hundreds of other files that have been present for years from our site, I delete the new "download" from the list of downloadable files.

I discovered another strange problem, the "Jdownloads Latest" module present here: http://www.ansuitalia.it/Portale/ultime-notizie.html
if you click a file link, a "404" error page opens.

Good evening.
Title: Re: Problem after update Joomla 3.9 for Joomla 4.2.
Post by: danieledel on 26.04.2023 10:07:51
I contacted the server that hosts the site, for strange incomprehensible reasons you could change file permissions only from their "root" administration side, this morning I was finally able to change Jdownloads file and folder permissions using Ftp. By copying the various positions of the permissions from another site with Jdownloads that I manage, I put the permissions 777, 755 and 644 wherever they are needed, now Jdownloads allows you to publish new download files, I have published a new one download: http://www.ansuitalia.it/Portale/download-ansu/download/54-informatica/413-alcune-guide-per-arch-linux.html
So this problem is solved.

The mystery remains why the "Jdownloads Latest" module present here does NOT work: http://www.ansuitalia.it/Portale/ultime-notizie.html
Good day.
Title: Re: Problem after update Joomla 3.9 for Joomla 4.2.
Post by: ColinM on 26.04.2023 22:42:14
Hi
Could you please start another querry about the Latest Module and describe the problem
Thanks
Colin
Title: Re: Problem after update Joomla 3.9 for Joomla 4.2.
Post by: danieledel on 27.04.2023 16:51:03
Ok, so I start a new thread here in the forum. Good evening.