[OJS 3.2.1-1]: OAI earliestDatestamp problem

Software Support
,
4

Hi @Antonio_Fracasso,

  • What DBMS are you using (PostgreSQL or MySQL)?
  • Can you run the following queries for an article ID that’s showing a changing datestamp?
    SELECT s.* FROM submissions s WHERE s.submission_id=123;
SELECT p.* FROM submissions s JOIN publications p ON (s.current_publication_id = p.publication_id) WHERE s.submission_id=123;
SELECT i.* FROM submissions s JOIN publications p ON (s.current_publication_id = p.publication_id) JOIN publication_settings ps ON (ps.publication_id = p.publication_id AND ps.setting_name='issueId') JOIN issues i ON (i.issue_id = ps.setting_value) WHERE s.submission_id=123;

…with the article ID in place of 123 for each?

Regards,
Alec Smecher
Public Knowledge Project Team