SOLVED Downloads disappeared after upgrade to 3.2.21b

[gebeer]

Hello,

after an upgrade from 3.2.20b to 3.2.21b on a J! 3.3.6 install, the downloads in the categories are not visible anymore on the frontend.

I searched the forum and found some posts about permission issues. Even after reapplying permissions, I get empty category listings.

My categories and downloads all show access level public. In Options I set Public download to allowed. I went to tools and reset the permissions for categories and downloads. Now they are all inherited and still show public.

I don't get a message that access is not allowed, just a blank listing. I also tried setting the Layout to one of the standard layouts. That also didn't help.

Now I have no idea what could be wrong. Did I miss anything after the upgrade?

[ColinM]

Hmm, strange. Not heard this problem before. Maybe the update did not complete properly.  Do you have say an Akeeba backup?  Do not use jDownloads backup as it would seem your site may have a 'challenge'.  Are all the categories and downloads present?

Colin

[gebeer]

This time I didn't make a backup before updating JDownloads :-(

The site is still in development and has no other challenges besides this one.

Fortunately I have only 8 categories and like 10 downloads and the site is not life yet. So I will try and uninstall/reinstall JDownloads and hope that this will solve the problem. I'll report back here.

[gebeer]

I switched on debugging and get the following in section database queries which may be related to the problem.

Maybe you can see from the output what the problem might be?

Code Select Expand

Abfragezeit: 2.05 ms Nach letzter Abfrage: 26.86 ms
Doppelte Abfragen: #9  #52

SHOW TABLES

Erklären
?EXPLAIN? unmöglich für Abfrage: SHOW TABLES
Profil (Profile)
Kein ?SHOW PROFILE? (vielleicht weil es mehr als 100 Abfragen gab)
Aufrufstapel (Call Stack)
JROOT/plugins/system/jdownloads/jdownloads.php:76
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:583
JROOT/libraries/cms/application/site.php:649
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Die ?xdebug.file_link_format?-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]
Abfragezeit: 0.72 ms Nach letzter Abfrage: 2.29 ms

SELECT file_id
  from nljrh_jdownloads_files
  WHERE published = 1
  AND use_timeframe = 1
  AND publish_to != '0000-00-00 00:00:00'
  AND publish_to <= '2015-01-15 02:03:54'

Erklären
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE nljrh_jdownloads_files ALL idx_published ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 11 Using where
Profil (Profile)
Kein ?SHOW PROFILE? (vielleicht weil es mehr als 100 Abfragen gab)
Aufrufstapel (Call Stack)
JROOT/plugins/system/jdownloads/jdownloads.php:104
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:583
JROOT/libraries/cms/application/site.php:649
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Die ?xdebug.file_link_format?-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]
Abfragezeit: 0.60 ms Nach letzter Abfrage: 0.39 ms

SELECT file_id
  from nljrh_jdownloads_files
  WHERE published = 0
  AND use_timeframe = 1
  AND publish_from != '0000-00-00 00:00:00'
  AND publish_from <= '2015-01-15 02:03:54'

Erklären
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE nljrh_jdownloads_files ref idx_published idx_published 1 const 1 Using where
Profil (Profile)
Kein ?SHOW PROFILE? (vielleicht weil es mehr als 100 Abfragen gab)
Aufrufstapel (Call Stack)
JROOT/plugins/system/jdownloads/jdownloads.php:112
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:583
JROOT/libraries/cms/application/site.php:649
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Die ?xdebug.file_link_format?-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]


[gebeer]

I found the problem. I had layout overrides in place for category and download default.php. Some code in there daesn't work anymore with the latest version.

Sorry for all the trouble to those of you who read through this.

And thank you, devs, for your great component