Hi!
After an entire day trying to fix the issue, I give up leaving the thing to experts.
The relation between Jdownloads and joomla tags is almost unusable, let me explain (I'm sorry for my terrible english):
- I'm using Joomla 3.5.0
- I'm using Jdownloads 3.2.44
- In Jdownloads I have multiple categories, but I have a second level of organization based on tags
In frontend users can choose to display files in single Jdownloads category and it works brillantly. The issue begins when I use a list of tagged elements. I correcty see the list of my tagged downloads, but dates are wrong. I've investigated a lot and the issue is this: when you create or modify publication date using Jdownloads the value is updated in the
#####_jdownloads_files table in database, while tags date is taken from
#####_ucm_content table (
core_created_time).
A second effect of this issue is that if you remove an element from Jdownloads it will still appear in the tag.
I know that my explanation is terrible, but if you need further informations I'll try to help as much as I can.
Thank you very much!
Hi
I have looked at the first case and there does seem to be a problem
The table below shows information taken from the 3 Downloads from jD backend and for an Article
Title Created Modified Published Type
Audit Letter-As Sent 2015-07-12 Never 2015-11-04 Download
decorative-products For Uploaders 2015-07-12 2016-04-11 2015-08-31 Download
service sheet 2015-07-12 2016-05-10 2015-08-31 Download
Test Article- Content Plugin 2015-10-08 2016-05-09 2015-10-08 Article
If these are compared to the attached images (shown with Compact Tag Display) then there are obvious discrepancies
For Reference the Tag Creation Date was 2015-08-18 and Tag Modified Date was 2016-05-02
Colin
[gelöscht durch Administrator]
Thank you very much for your interest! If I can help with other informations let me know!
Thanks for the hints. I will try to fix it soon.
After the first checks i have this results:
1) the Modified date is always updated in ucm_content when you change a Download with a tag in jDownloads (see first pic).
2) when i delete an article in Joomla (empty trash) it still exists the early used tag for him in the _tags table (not used in any other content)
3) the same in ucm_content
So i am not sure where shall be here a bug. As we have (nearly) the same behaviors in jDownloads as in Joomla.
Or i need maybe more details?
[gelöscht durch Administrator]
@Arno
l will try to do some more tests.
@Serg
Could you also test more please.
Colin
@Arno
Think I have found the situation.
First if I checked the dates shown in ---ucm-content and as shown on tags display were consistent. They were, see pics.
I then opened a Download in backend and saved it. Both ucm_content and tag display showed today's date. So good.
Went to Download again in backend and changed modified date to a few days earlier by using the calendar function. Saved and closed. Verified that download modified date saved in jdownloads_files was the correctly changed one.
But the ucm_content table entry had not been change to the selected modified date. It still had today's date. So problem seems to be when uses the Calendar function to set a modified date. Probably applies to created date as well but I did not try.
Colin
[gelöscht durch Administrator]
QuoteSo problem seems to be when uses the Calendar function to set a modified date. Probably applies to created date as well but I did not try.
Thanks Colin. I will check it.