Hello,
I'm having a strange issue with duplicate jDownloads tables that I can't resolve. It seems like there are two instances of jDownloads installed. When I look at the extensions list, I see this:
(https://www.catholicsforisrael.com/images/temp/jdownloads1.png)
But then Joomla Extensions: Discover "discovers" these parts of jDownloads that are "waiting" to be installed:
(https://www.catholicsforisrael.com/images/temp/jdownloads2.png)
When I check the Database, I see that indeed several of the jDownloads tables are duplicated:
(https://www.catholicsforisrael.com/images/temp/jdownloads3.png)
I have tried uninstalling jDownloads (without deleting the tables and data) and then reinstalling it, but the extra tables are still there and Joomla still "Discovers" the jDownloads component and some of its plugins. I have also tried manually deleting the extra tables from phpMyAdmin, but then they recreate themselves automatically (with the extension_id number that keeps increasing)!
How can I get rid of those extra tables and stop Joomla from constantly "discovering" jDownloads?
Thank you, and happy new year!
Also, is it normal that every time I install jDownloads it recreates all the layouts? I ended up with dozens of duplicate layouts that I had to delete manually. All the licenses are also recreated at each install, so I now have 70 licenses!
If I'm dealing with a conflict between two versions of the extension, I'm wondering if I should uninstall jDownloads again (without deleting the jDownloads tables and data, and of course the downloadable files in the jdownloads folder), then delete all the jDownloads rows in the _extensions table, then reinstall it?
Does that sound like a good idea or would that be dangerous?
Hi
This does sound challenging, something I have not seen before.
I will bring it to Arno's attention.
Possibly the database does not have delete permission so it keeps adding tables
For reference it should not keep replicating the existing Layouts and licenses
Also could you advise Joomla version, jD version, PHP and what database and version
Colin
Sure. It's Joomla 4.4.1, jD 4.0.38, PHP 8.1, mysql 8.0.28
Update: I tried my idea above. I uninstalled jDownloads. After the uninstall, much of jDownloads still appeared under System/Manage/Extensions/. I tried uninstalling it a second time. This produced an error. Finally, I tried deleting the jDownloads rows in the _extension table. This was a disaster and completely crashed the website.
So after restoring a site backup, I am back at square one. All the jDownloads tables are duplicated in the DB, and Joomla Discover now identifies 14 different jDownloads extensions waiting to be installed!
(https://www.catholicsforisrael.com/images/temp/jdownloads4.png)
Any advice would be appreciated!
Hi jazzbird,
I have never observed such behaviour before. But I must also admit that I have never used the 'Discover' function before.
It could possibly be the result of an incorrect previous installation or update? ::)
Maybe can I try to check this more in detail tomorrow.
Okay Arno, thanks, I appreciate it.
I think the Discover function just indicates that Joomla sees the extra (duplicate) records in the DB and so it thinks that the extension is available but not properly installed. Basically I think I'm dealing with two instances of jDownloads on my site that clash with one another.
Hi jazzbird,
normaly two instances of jDownloads on the same Joomla installation are not possible.
If only because each table can only exist once with this name.
I would try the following:
- Create a backup
- Uninstall jDownloads (without deleting the files and DB tables!)
- Now check the Extensions Manager to see if an installation of jDownloads is still listed.
- If so, try to repeat the uninstallation process, even if an error message would certainly appear.
- Alternatively, manually delete the jDownloads entries in the 'extensions' table.
- Check whether jDownloads subdirectories from previous installation attempts still exist in the /temp folder. If so, delete them.
- Now check which DB tables of jDownloads exist in the database. Only 7 tables should exist here.
- If this has been done successfully, create a new backup of this clean version.
- Now reinstall jDownloads.
;)
Quote from: Arno on 03.01.2024 09:54:54
I would try the following:
1- Create a backup
2- Uninstall jDownloads (without deleting the files and DB tables!)
3- Now check the Extensions Manager to see if an installation of jDownloads is still listed.
4- If so, try to repeat the uninstallation process, even if an error message would certainly appear.
5- Alternatively, manually delete the jDownloads entries in the 'extensions' table.
6- Check whether jDownloads subdirectories from previous installation attempts still exist in the /temp folder. If so, delete them.
7- Now check which DB tables of jDownloads exist in the database. Only 7 tables should exist here.
8- If this has been done successfully, create a new backup of this clean version.
9- Now reinstall jDownloads.
Thank you for the suggestion! I believe I tried something very similar a few days ago. If I recall correctly, item 5 (manually deleting the jD entries) completely crashed my site.
As you can see in the tables screenshot above, all the jD tables definitely exist twice with the same name on my site.
I will try a few more things and get back to you.
When I uninstall jD, do I select only the component, or all the plugins and modules as well? Currently I have 19 jDownloads installed! The component, 6 plugins, and 12 modules.
By the way, the uninstall instructions on this page are very confusing:
https://www.jdownloads.net/documentation/getting-started-v3-9/how-to-uninstall-all-of-jdownloads-jd39
The instructions say to select all items, then deselect the component, then uninstall (everything except the component?).
But the image shows the opposite: only the component is selected. So just uninstall the component?
So which one is it? Just uninstall the component, or uninstall everything else except the component?
Item 2: I uninstalled just the component.
Item 3: After the uninstall, I still have 13 jDownloads extensions that are apparently still installed.
(https://www.catholicsforisrael.com/images/temp/jdownloads5.png)
Item 4: I tried to repeat the uninstallation process. An error did indeed appear, and no change.
Still 13 jD extensions appear in the list:
(https://www.catholicsforisrael.com/images/temp/jdownloads6.png)
I now managed to uninstall the two plugins at the bottom of the list. If I try to uninstall any of the modules, I get the error:
An error has occurred.
0 Call to a member function children() on null
So Joomla still lists the component and 10 modules, but won't let me uninstall them.
This is what's left in my _extensions table:
This is where last time I tried to delete all the jDownloads rows and it crashed the website. So I'm hesitant to do it again. Please advise!
(https://www.catholicsforisrael.com/images/temp/jdownloads7.png)
Okay, it looks like I was able to delete all the tables this time and the website is still working. Will now try to reinstall.
Update: I reinstalled jDownloads. The installation seems to have worked normally. After the installation, Joomla still 'discovered' one of the smart search plugins. I went ahead and installed it.
The new install did duplicate again all the licenses and layouts, so I will have to delete these manually.
But with all this my download buttons now don't appear! Instead of the buttons, I now get the message: "Cannot find the layout Standard Files Layout"
So I still need help. Please advise.
Okay. I have deleted the duplicate licenses and layouts.
I have also resolved the previous error "Cannot find the layout Standard Files Layout" and the download links now appear..
I think I'm getting close. The only thing is that clicking on the buttons opens a new "download details" page. I don't want that but just want the download to begin immediately. I must have lost that setting when I reinstalled. How do I get the jDownloads buttons to activate the download right away without opening the "download details" page?
Never mind. I found it. It looks like I've finally resolved the issue!
Hi,
okay, that sounds much better. ;)
But I still don't understand all these problems.
Neither do I! It's been an ordeal. But I'm glad it seems to be resolved. Thanks!
Now if you could just help me with my much smaller CSS question:
https://www.jdownloads.com/forum/index.php?topic=14171.0
Unfortunately I was not able to reply to your postings so quickly. :(
QuoteUpdate: I reinstalled jDownloads. The installation seems to have worked normally. After the installation, Joomla still 'discovered' one of the smart search plugins. I went ahead and installed it.
The new install did duplicate again all the licenses and layouts, so I will have to delete these manually.
But with all this my download buttons now don't appear! Instead of the buttons, I now get the message: "Cannot find the layout Standard Files Layout"
So I still need help. Please advise.
I think that something was wrong here. Because both smart search plugins should already be installed at the time.
QuoteBy the way, the uninstall instructions on this page are very confusing:
https://www.jdownloads.net/documentation/getting-started-v3-9/how-to-uninstall-all-of-jdownloads-jd39
Only the component needs to be marked.
I have contacted Colin (the author) so that he can correct this. Thanks for the hint.
jazzbird,
sorry about the confusion. There was was one erroneous statemnt - I have modified the text to make it clearer.
It is only the Component that needs uninstalling.
Have also tested in Joomla 5
Colin
Jazzbird,
The normal method of uninstalling jD is to just uninstall the component, It then uninstalls evrything else.
See
https://www.jdownloads.net/documentation/getting-started-v3-9/how-to-uninstall-all-of-jdownloads-jd39Colin