Non-expiring indivudal subscriptions: No access to PDFs (OJS

We have a problem with non-expiring individual (login-based) subscriptions. When you add a user to a non-expiring subscription, the user can’t access the PDFs. May be that’s because you can’t enter a start date for a non-ending-subscription? There’s no problem, when you add a user to a subscription type, which is 1-year based.

Here are some screenshots

User with 1-year-subscription


User can access PDF


User with non-ending subscription


User can’t access PDF


We are encountering this issue as well with

When I change the digits to true or false in this literal sql statement, the bug is resolved.

OS platform Linux
PHP version 7.3.20
Apache version Apache/2.4.37 (Oracle Linux) mod_fcgid/2.3.9
Database driver mysqli
Database server version 10.3.28-MariaDB

driver mysqli
port 3306
persistent Off
debug Off


I should clarify that the true and false values are quoted:

AND ((st.non_expiring = "true") OR (st.non_expiring = "false" AND (' . $dateSql . ')))

Cross-filed: No access granted for non-expiring subscription · Issue #7596 · pkp/pkp-lib · GitHub

@crowesn, thanks for tracking this down; it’s best to just post an issue in one place, or if posting in multiple places, to cross-link them to keep organized. I’ll close this in favour of the github issue.

Alec Smecher
Public Knowledge Project Team

1 Like

This topic was automatically closed after 19 hours. New replies are no longer allowed.