2.4.8.1 To 3.0.2

Software Support
1

Is it possible to update directly from OJS 2.4.8.1 to 3.0.2?

2.4.8.1 upgrade goes well

php tools/upgrade.php upgrade
[pre-install]
[load: upgrade.xml]
[version: 2.4.8.1]
[schema: lib/pkp/xml/schema/signoff.xml]
[schema: lib/pkp/xml/schema/common.xml]
[schema: lib/pkp/xml/schema/groups.xml]
[schema: lib/pkp/xml/schema/log.xml]
[schema: lib/pkp/xml/schema/announcements.xml]
[schema: lib/pkp/xml/schema/scheduledTasks.xml]
[schema: lib/pkp/xml/schema/temporaryFiles.xml]
[schema: lib/pkp/xml/schema/metadata.xml]
[schema: lib/pkp/xml/schema/reviews.xml]
[schema: lib/pkp/xml/schema/reviewForms.xml]
[schema: lib/pkp/xml/schema/controlledVocab.xml]
[schema: lib/pkp/xml/schema/submissions.xml]
[schema: lib/pkp/xml/schema/comments.xml]
[schema: lib/pkp/xml/schema/notes.xml]
[schema: lib/pkp/xml/schema/gifts.xml]
[schema: lib/pkp/xml/schema/mutex.xml]
[schema: lib/pkp/xml/schema/tombstone.xml]
[schema: lib/pkp/xml/schema/metrics.xml]
[schema: dbscripts/xml/ojs_schema.xml]
[data: dbscripts/xml/indexes.xml]

[code: Installer Installer::addPluginVersions]
[post-install]
Successfully upgraded to version 2.4.8.1

But the 3.0.2 upgrade succeeds but results in

DB Error: Unknown column ‘journal_id’ in 'on clause
on all pages

MYSQL Update cmd

php tools/upgrade.php upgrade
[pre-install]
[load: upgrade.xml]
[version: 3.0.2.0]

[code: Installer Installer::syncSeriesAssocType]
[data: dbscripts/xml/upgrade/2.4.0_preupdate_usageStatistics.xml (skipped)]
[data: dbscripts/xml/upgrade/2.4.0_preupdate_usageStatistics2.xml]
[data: dbscripts/xml/upgrade/3.0.0_preupdate.xml]
[data: dbscripts/xml/upgrade/3.0.0_adaptTimedViews.xml (skipped)]
[data: dbscripts/xml/upgrade/3.0.0_adaptReferrals.xml]
[data: dbscripts/xml/upgrade/3.0.0_adaptBooksForReview.xml]
[data: dbscripts/xml/upgrade/remove_timed_views_bots.xml (skipped)]

[code: Installer Installer::migrateCounterPluginUsageStatistics (skipped)]

[code: Installer Installer::migrateTimedViewsUsageStatistics (skipped)]

[code: Installer Installer::migrateDefaultUsageStatistics (skipped)]
[data: dbscripts/xml/upgrade/2.4.0_postUsageStatsMigration.xml (skipped)]
[data: dbscripts/xml/upgrade/2.4.0_postUsageStatsMigration2.xml]
[data: dbscripts/xml/upgrade/2.4.0_postCounterMigration.xml (skipped)]
[data: dbscripts/xml/upgrade/2.4.0_postTimedViewsMigration.xml (skipped)]
[data: dbscripts/xml/upgrade/3.0.0_preupdate_commentsToEditor.xml]
[schema: lib/pkp/xml/schema/common.xml]
[schema: lib/pkp/xml/schema/log.xml]
[schema: lib/pkp/xml/schema/announcements.xml]
[schema: lib/pkp/xml/schema/scheduledTasks.xml]
[schema: lib/pkp/xml/schema/temporaryFiles.xml]
[schema: lib/pkp/xml/schema/metadata.xml]
[schema: lib/pkp/xml/schema/reviews.xml]
[schema: lib/pkp/xml/schema/reviewForms.xml]
[schema: lib/pkp/xml/schema/controlledVocab.xml]
[schema: lib/pkp/xml/schema/submissions.xml]
[schema: lib/pkp/xml/schema/submissionFiles.xml]
[schema: lib/pkp/xml/schema/notes.xml]
[schema: lib/pkp/xml/schema/views.xml]
[schema: lib/pkp/xml/schema/genres.xml]
[schema: lib/pkp/xml/schema/gifts.xml]
[schema: lib/pkp/xml/schema/mutex.xml]
[schema: lib/pkp/xml/schema/tombstone.xml]
[schema: lib/pkp/xml/schema/rolesAndUserGroups.xml]
[schema: lib/pkp/xml/schema/metrics.xml]
[schema: lib/pkp/xml/schema/views.xml]
[schema: lib/pkp/xml/schema/libraryFiles.xml]
[schema: dbscripts/xml/ojs_schema.xml]
[data: dbscripts/xml/indexes.xml]
[data: dbscripts/xml/upgrade/3.0.0_change_assoc_type.xml]
[data: dbscripts/xml/upgrade/3.0.0_change_assoc_type_metrics.xml]
[data: dbscripts/xml/upgrade/3.0.0_settings.xml]

[code: Installer Installer::migrateArticleMetadata]
[data: dbscripts/xml/upgrade/3.0.0_update.xml]

[code: Installer Installer::clearDataCache]

[code: Installer Installer::migrateUserRoles]

[code: Installer Installer::installDefaultGenres]

[code: Installer Installer::fixReviewForms]

[code: Installer Installer::htmlifyEmailTemplates]
[note: docs/release-notes/README-BEACON]

[code: Installer Installer::installEmailTemplate]

[code: Installer Installer::installEmailTemplate]

[code: Installer Installer::installEmailTemplate]

[code: Installer Installer::installEmailTemplate]

[code: Installer Installer::installEmailTemplate]

[code: Installer Installer::installEmailTemplate]
[data: dbscripts/xml/upgrade/3.0.0_scheduledTasks.xml]

[code: Installer Installer::localizeCustomBlockSettings]

[code: Installer Installer::convertEditorDecisionNotes]

[code: Installer Installer::convertQueries]

[code: Installer Installer::migrateFiles]
WARNING:
Unable to find a match for “68-231-1-CE.pdf” in
“/opt/ojs/afl-journal/files/journals/8//articles/68/”. Skipping this
file.

  • lots of the same
    WARNING: Unable to find a match for “31-56-1-RV.docx” in
    “/opt/ojs/afl-journal/files/journals/5//articles/31/”. Skipping this
    file.

[code: Installer Installer::convertSupplementaryFiles]
PHP
Warning:
copy(/opt/ojs/afl-journal/files/journals/7//articles/49/attachment/49-1-157-2-13-20161129.jpg):
failed to open stream: No such file or directory in
/usr/local/apps/ojs/afl-journal/htdocs/lib/pkp/classes/file/FileManager.inc.php
on line 159
PHP Warning: assert(): Assertion failed in
/usr/local/apps/ojs/afl-journal/htdocs/lib/pkp/classes/submission/SubmissionFileDAODelegate.inc.php
on line 132
PHP Warning:
copy(/opt/ojs/afl-journal/files/journals/7//articles/49/attachment/49-1-158-1-13-20161129.jpg):
failed to open stream: No such file or directory in
/usr/local/apps/ojs/afl-journal/htdocs/lib/pkp/classes/file/FileManager.inc.php
on line 159
PHP Warning: assert(): Assertion failed in
/usr/local/apps/ojs/afl-journal/htdocs/lib/pkp/classes/submission/SubmissionFileDAODelegate.inc.php
on line 132
PHP Warning:
copy(/opt/ojs/afl-journal/files/journals/7//articles/49/attachment/49-1-165-1-13-20161129.jpg):
failed to open stream: No such file or directory in
/usr/local/apps/ojs/afl-journal/htdocs/lib/pkp/classes/file/FileManager.inc.php
on line 159
PHP Warning: assert(): Assertion failed in
/usr/local/apps/ojs/afl-journal/htdocs/lib/pkp/classes/submission/SubmissionFileDAODelegate.inc.php
on line 132
PHP Warning:
copy(/opt/ojs/afl-journal/files/journals/7//articles/49/attachment/49-1-166-1-13-20161129.jpeg):
failed to open stream: No such file or directory in
/usr/local/apps/ojs/afl-journal/htdocs/lib/pkp/classes/file/FileManager.inc.php
on line 159
PHP Warning: assert(): Assertion failed in
/usr/local/apps/ojs/afl-journal/htdocs/lib/pkp/classes/submission/SubmissionFileDAODelegate.inc.php
on line 132
PHP Warning:
copy(/opt/ojs/afl-journal/files/journals/7//articles/51/attachment/51-1-173-1-13-20161129.pdf):
failed to open stream: No such file or directory in
/usr/local/apps/ojs/afl-journal/htdocs/lib/pkp/classes/file/FileManager.inc.php
on line 159
PHP Warning: assert(): Assertion failed in
/usr/local/apps/ojs/afl-journal/htdocs/lib/pkp/classes/submission/SubmissionFileDAODelegate.inc.php
on line 132
PHP Warning:
copy(/opt/ojs/afl-journal/files/journals/6//articles/60/attachment/60-1-214-1-13-20161205.png):
failed to open stream: No such file or directory in
/usr/local/apps/ojs/afl-journal/htdocs/lib/pkp/classes/file/FileManager.inc.php
on line 159
PHP Warning: assert(): Assertion failed in
/usr/local/apps/ojs/afl-journal/htdocs/lib/pkp/classes/submission/SubmissionFileDAODelegate.inc.php
on line 132
PHP Warning:
copy(/opt/ojs/afl-journal/files/journals/7//articles/57/attachment/57-1-216-1-13-20161205.png):
failed to open stream: No such file or directory in
/usr/local/apps/ojs/afl-journal/htdocs/lib/pkp/classes/file/FileManager.inc.php
on line 159
PHP Warning: assert(): Assertion failed in
/usr/local/apps/ojs/afl-journal/htdocs/lib/pkp/classes/submission/SubmissionFileDAODelegate.inc.php
on line 132
PHP Warning:
copy(/opt/ojs/afl-journal/files/journals/7//articles/74/attachment/74-1-242-1-13-20170127.jpg):
failed to open stream: No such file or directory in
/usr/local/apps/ojs/afl-journal/htdocs/lib/pkp/classes/file/FileManager.inc.php
on line 159
PHP Warning: assert(): Assertion failed in
/usr/local/apps/ojs/afl-journal/htdocs/lib/pkp/classes/submission/SubmissionFileDAODelegate.inc.php
on line 132

[code: Installer Installer::setFileUploader]

[code: Installer Installer::setFileName]
[data: dbscripts/xml/upgrade/3.0.0_postupdate.xml]
[data: dbscripts/xml/upgrade/3.0.0_pubId_settings.xml]
[data: dbscripts/xml/upgrade/3.0.0_postupgrade_galley_files.xml]
[data: dbscripts/xml/upgrade/3.0.0_postupgrade_metrics.xml]
[data: dbscripts/xml/upgrade/3.0.0_issue_settings.xml]
[data: dbscripts/xml/upgrade/3.0.0_submission_settings.xml]
[data: dbscripts/xml/upgrade/3.0.0_review_method.xml]
[data: dbscripts/xml/upgrade/3.0.0_edit_decisions.xml]

[code: Installer Installer::convertCommentsToEditor]
[note: docs/release-notes/README-3.0]
[note: docs/release-notes/README-3.0.1]
[data: dbscripts/xml/upgrade/3.0.2_update.xml]
[note: docs/release-notes/README-3.0.2]

[code: Installer Installer::addPluginVersions]
[post-install]

PHP 5.6.29 (cli) (built: Dec 12 2016 11:49:59)
Copyright (c) 1997-2016 The PHP Group
Zend Engine v2.6.0, Copyright (c) 1998-2016 Zend Technologies
with Zend OPcache v7.0.6-dev, Copyright (c) 1999-2016, by Zend Technologies

And

Server version: 5.5.54-MariaDB MariaDB Server

2

Hi @tijones,

Yes, you can upgrade from OJS 2.4.8-1 to 3.0.2 directly.

Do you get the DB Error: Unknown column 'journal_id' in 'on clause warning before running the upgrade script? If so, that’s expected – you need to run the database upgrade. See docs/UPGRADE for details.

Regards,
Alec Smecher
Public Knowledge Project Team

1 Like
3

No I get that error from the site after running the update, like as if it doesn’t complete ,

4

Hi @tijones,

Agreed, it looks as though the upgrade didn’t complete. Try reloading from backup so that your database is in a consistent state (a failed upgrade will leave it orphaned between the two versions), and running the upgrade again. Check your error logs to see if something relevant appears there.

Regards,
Alec Smecher
Public Knowledge Project Team

5 
Hello!
I'm getting the same error. I updated ojs from 2.4.2.0 to 2.4.8-2 and works fine.
then upgrade 2.4.8-2 to 3.0.2 and I got the error

DB Error: Unknown column 'journal_id' in 'on clause'
the log is OK.

php tools/upgrade.php upgrade
[pre-install]
[load: upgrade.xml]
[version: 3.0.2.0]
[code: Installer Installer::syncSeriesAssocType]
[data: dbscripts/xml/upgrade/2.4.0_preupdate_usageStatistics.xml (skipped)]
[data: dbscripts/xml/upgrade/2.4.0_preupdate_usageStatistics2.xml]
[data: dbscripts/xml/upgrade/3.0.0_preupdate.xml]
[data: dbscripts/xml/upgrade/3.0.0_adaptTimedViews.xml (skipped)]
[data: dbscripts/xml/upgrade/3.0.0_adaptReferrals.xml]
[data: dbscripts/xml/upgrade/3.0.0_adaptBooksForReview.xml]
[data: dbscripts/xml/upgrade/remove_timed_views_bots.xml (skipped)]
[code: Installer Installer::migrateCounterPluginUsageStatistics (skipped)]
[code: Installer Installer::migrateTimedViewsUsageStatistics (skipped)]
[code: Installer Installer::migrateDefaultUsageStatistics (skipped)]
[data: dbscripts/xml/upgrade/2.4.0_postUsageStatsMigration.xml (skipped)]
[data: dbscripts/xml/upgrade/2.4.0_postUsageStatsMigration2.xml]
[data: dbscripts/xml/upgrade/2.4.0_postCounterMigration.xml (skipped)]
[data: dbscripts/xml/upgrade/2.4.0_postTimedViewsMigration.xml (skipped)]
[data: dbscripts/xml/upgrade/3.0.0_preupdate_commentsToEditor.xml]
[schema: lib/pkp/xml/schema/common.xml]
[schema: lib/pkp/xml/schema/log.xml]
[schema: lib/pkp/xml/schema/announcements.xml]
[schema: lib/pkp/xml/schema/scheduledTasks.xml]
[schema: lib/pkp/xml/schema/temporaryFiles.xml]
[schema: lib/pkp/xml/schema/metadata.xml]
[schema: lib/pkp/xml/schema/reviews.xml]
[schema: lib/pkp/xml/schema/reviewForms.xml]
[schema: lib/pkp/xml/schema/controlledVocab.xml]
[schema: lib/pkp/xml/schema/submissions.xml]
[schema: lib/pkp/xml/schema/submissionFiles.xml]
[schema: lib/pkp/xml/schema/notes.xml]
[schema: lib/pkp/xml/schema/views.xml]
[schema: lib/pkp/xml/schema/genres.xml]
[schema: lib/pkp/xml/schema/gifts.xml]
[schema: lib/pkp/xml/schema/mutex.xml]
[schema: lib/pkp/xml/schema/tombstone.xml]
[schema: lib/pkp/xml/schema/rolesAndUserGroups.xml]
[schema: lib/pkp/xml/schema/metrics.xml]
[schema: lib/pkp/xml/schema/views.xml]
[schema: lib/pkp/xml/schema/libraryFiles.xml]
[schema: dbscripts/xml/ojs_schema.xml]
[data: dbscripts/xml/indexes.xml]
[data: dbscripts/xml/upgrade/3.0.0_change_assoc_type.xml]
[data: dbscripts/xml/upgrade/3.0.0_change_assoc_type_metrics.xml]
[data: dbscripts/xml/upgrade/3.0.0_settings.xml]
[code: Installer Installer::migrateArticleMetadata]
[data: dbscripts/xml/upgrade/3.0.0_update.xml]
[code: Installer Installer::clearDataCache]
[code: Installer Installer::migrateUserRoles]
[code: Installer Installer::installDefaultGenres]
[code: Installer Installer::fixReviewForms]
[code: Installer Installer::htmlifyEmailTemplates]
[note: docs/release-notes/README-BEACON]
[code: Installer Installer::installEmailTemplate]
[code: Installer Installer::installEmailTemplate]
[code: Installer Installer::installEmailTemplate]
[code: Installer Installer::installEmailTemplate]
[code: Installer Installer::installEmailTemplate]
[code: Installer Installer::installEmailTemplate]
[data: dbscripts/xml/upgrade/3.0.0_scheduledTasks.xml]
[code: Installer Installer::localizeCustomBlockSettings]
[code: Installer Installer::convertEditorDecisionNotes]
[code: Installer Installer::convertQueries]
[code: Installer Installer::migrateFiles]
WARNING: Unable to find a match for "19-60-1-SM.rtf" in "files/journals/1//articles/19/". Skipping this file.
WARNING: Unable to find a match for "19-61-1-RV.rtf" in "files/journals/1//articles/19/". Skipping this file.
[code: Installer Installer::convertSupplementaryFiles]
[code: Installer Installer::setFileUploader]
[code: Installer Installer::setFileName]
[data: dbscripts/xml/upgrade/3.0.0_postupdate.xml]
[data: dbscripts/xml/upgrade/3.0.0_pubId_settings.xml]
[data: dbscripts/xml/upgrade/3.0.0_postupgrade_galley_files.xml]
[data: dbscripts/xml/upgrade/3.0.0_postupgrade_metrics.xml]
[data: dbscripts/xml/upgrade/3.0.0_issue_settings.xml]
[data: dbscripts/xml/upgrade/3.0.0_submission_settings.xml]
[data: dbscripts/xml/upgrade/3.0.0_review_method.xml]
[data: dbscripts/xml/upgrade/3.0.0_edit_decisions.xml]
[code: Installer Installer::convertCommentsToEditor]
[note: docs/release-notes/README-3.0]
[note: docs/release-notes/README-3.0.1]
[data: dbscripts/xml/upgrade/3.0.2_update.xml]
[note: docs/release-notes/README-3.0.2]
[code: Installer Installer::addPluginVersions]
[post-install]

Release Notes
----------------------------------------
This software will optionally provide PKP with a unique identifier for the
installation and the OAI base URL. These are to be used for statistics and
security alert purposes only.

This feature is optional. If you do not wish to participate, you may either
uncheck the "beacon" option in the installation form, or for existing installs,
edit your config.inc.php configuration file and set "enable_beacon" to Off.


OJS 3.0 Release Notes
CVS tag: ojs-3_0_0-0

Release date: August 31, 2016
=============================

Welcome to OJS 3.0!


OJS 3.0.1 Release Notes
CVS tag: ojs-3_0_1-0

Release date: November 25, 2016
===============================


Configuration Changes
---------------------

See config.TEMPLATE.inc.php for a description and examples of all supported
configuration parameters.

New config.inc.php parameters:
        - files:filename_revision_match - The filename similarity (in percent) that
                must be met for a possible revision to be detected.


New Features
------------
        #1565# Add visual cue when a field is missing a translation (multi-lingual inputs)
        #1601# Implement CLI for import/export plugins
        #1762# Add skip-to links for content in default frontend templates
        #1825# Resolve HTML publishing issues
        #1859# Add Sidebar Management to site settings for multi-journal installs
        #1934# Localize issue and article cover images
        #1951# Add support for custom issue ordering
        #1981# Make filename similarity requirement configurable


Bug Fixes
---------
        #592# Fix behavior when journal not publicly enabled
        #1469# "Forgot password" doesn't deliver reset password
        #1594# acron plugin (pkp-lib) has app-specific language
        #1599# Replace minifiedScripts.tpl with some other mechanism
        #1628# Length of the rights statement
        #1683# Implement OJS 2.4.x to 3.0 upgrade
        #1709# Native Import Issues for OJS and OMP
        #1740# Select window opens twice
        #1747# Action "copy review form" inactive
        #1765# Sidebar Management Wording
        #1787# Tab-specific primary nav menu items don't work when already on page
        #1788# Incorrect datetime value
        #1793# Test/fix PostgreSQL upgrades
        #1795# Spectrum colour picker not loaded in journal settings wizard
        #1800# UserGroupDAO insertObject returns wrong value
        #1801# Fix text paths for issue galleys
        #1803# Fix attempt to connect to "ojs" database before installation
        #1804# Fix function declaration variations for PHP7
        #1805# Can't Export Issues
        #1809# Fix listbuilder conventions for PHP7
        #1810# Undefined constant in site settings
        #1812# Remove Citation Assistant leftovers
        #1815# Move metadata (DC/GS) meta tags into HTML head
        #1820# Title parameter in multiple locale.xml files is $param instead of $title
        #1821# When creating users, usernames are silently converted to lowercase
        #1834# PHP Warning: end() expects parameter 1 to be array in search.tpl
        #1838# Automatic emails for open access/subscription triggered post-install in OJS 3.0
        #1840# Metrics migration from 2.4.x to 3.0
        #1843# Permit all file stages in galleys grid
        #1846# Ensure XML-imported content is indexed
        #1847# Ensure closed registrations works properly
        #1862# Ensure unique template files are compiled for each journal
        #1868# Make datepicker respect date formats
        #1872# UI plugin upgrade
        #1877# DataCite export's "publisher" should be clarified
        #1885# Fix MySQL test race condition
        #1891# Make dependent files application closer-scoped
        #1893# Fix MIME type detection problems for CSS
        #1905# Acron really, really wants to run...
        #1907# Show volume info only when checkbox selected
        #1909# Fix APA/CBE/RefWorks author initial
        #1910# Crossref plugin doesn’t use test API for status query
        #1925# PKPString::mime_content_type() should fall back on mime_content_type when fileinfo is unavailable
        #1927# Fix keyword input attempted autosuggest
        #1930# Include article prefix on article details page
        #1937# Resequence the category items
        #1946# {$abstractTermIfEnabled} is not rendering in the emails for review request to a reviewer
        #1948# {$journalTitle} not rendering in a decision email
        #1956# 3.0.0 XML export validation message encoding
        #1958# Use modern constructor syntax
        #1966# Correct and Clean Up EndNote Citation Export
        #1967# keywords not saved
        #1973# PKPComponentRouter documentation misidentifies the path/to/component mapping
        #1976# Smarty typos in tab/settings/appearance/form/ templates
        #1989# Some notification emails sent out with empty recipient list
        #2018# Section and published article ordering
        #2028# Make review forms import nicely into email
        #2032# Revise wording in Workflow Settings
        #2034# Disable "Type" metadata by default


OJS 3.0.2 Release Notes
CVS tag: ojs-3_0_2-0

Release date: February 1, 2017
==============================


New Features
------------
        #850# Implement CRUD API for DOAJ
        #1726# Permit submission locale changes
        #1808# Display article references metadata on article details page
        #1859# Add Sidebar Management to site settings for multi-journal installs
        #1906# enable RTL orientation in OJS 3
        #2022# Add section to the submission filter form in the editorial back-end
        #2174# Display author biographical information in OJS


Bug Fixes
---------
        #1426# $_SERVER[HOSTNAME] should not be used for host identification
        #1772# Consider adding aria-required to required fields
        #1856# getByControlledVocabId() SQL does not work with PostgreSQL
        #1867# Check box on the logging page of OJS 3.0
        #1873# Display comments for editor
        #1901# Update Crossref DOI display according to their new guidelines
        #1924# Upgrade to 3.0.0: Filename migration
        #1934# Localize issue and article cover images
        #1996# [OJS3] Flaws in registration
        #2039# Role selection in other journals on user profile page broken
        #2042# Add theme api methods for manipulating parent scripts, styles and options
        #2044# Article cover images don't appear in search results
        #2045# Review form elements are brought into email draft despite inclusion flag status
        #2046# Fix tool constructor syntax
        #2047# [OJS] Submission notes visible for authors in OJS 3.0
        #2049# Respect "editor only" section flag on submission process
        #2052# Permit new decisions to restore archived submissions to active queue
        #2053# Editor assign email template not available on Submission stage
        #2062# Problems upgrading from OJS 3.0 to 3.0.1 with PostgreSQL
        #2068# DOI Export Plugin assertion "register" is noisy
        #2069# Article cover images in portrait dimensions can cause extra gaps
        #2074# DOMDocument::createElementNS() is being used without consideration for escaping
        #2075# Review first_page / last_page parsing
        #2076# Review page counting code: MEDRA and EndNote
        #2079# Full-text indexing not working
        #2083# [OJS] Author View Metadata modal javascript error
        #2085# Improve touch controls of frontend about nav dropdown
        #2087# Wrong usage event object when accessing article page
        #2089# List incomplete submissions in the managers active submissions lists
        #2091# "Omit this section from About the Journal" in Section Settings is not used
        #2092# [OJS] Reviewer doesn't have adequate permission to download review file
        #2097# [OJS] Updating to OJS3 - revision files and initial copyedit files missing
        #2098# [OJS3] Only tiny area clickable for tick boxes in tasks popup
        #2100# [OJS3] Default Theme. Review interests on registration not visible
        #2109# Section editors can access submission and data only if they are assigned to that submission
        #2111# Guest Editor role is inoperative
        #2112# Related Items plugin needs rewrite for OJS 3.x
        #2115# Configured date formats need to be respected in front end
        #2117# Display native export validation errors
        #2118# [OJS] Enable journal to appear publicly on the site when path written with capital letters leads to an error
        #2129# Proxy settings are not considered when fetching plugins.xml from PKP
        #2131# OJS3: Errors on installation page are unobtrusive
        #2134# OJS 3.0.1: Statistics plugin needs additional testing
        #2136# [OJS] Empty sidebar breaks javascript in front end
        #2138# Use %Y-%m-%d in strftime function
        #2143# Remove restriction on email length
        #2144# REVIEW_ACCEPT should be REVIEW_CONFIRM in upgrade script
        #2154# fix hard coded current year in the usage stats JS
        #2156# OJS install/upgrade documentation is slightly inaccurate
        #2158# Press/journal assistants cannot delete their own placeholder queries
        #2159# [OJS] upgrading to OJS3: Revisions and Reviewer's Attachments panels not visible in Review tab for authors
        #2162# ru_RU locale update
        #2167# fix getViews
        #2176# No Reviewers after upgrading from 2.4.8 to 3.0.1
        #2182# CSRF check prevents notes from being deleted
        #2184# User group settings only installed for primary locale upon context creation
        #2185# Make stage/review assignment joins in SubmissionDAO more selective
        #2187# [OJS] Upgrading to OJS3: authors can not download the revisions they have uploaded
        #2195# [OJS] Upgrading to OJS3: reviewers can see the names of the authors
        #2201# [OJS 3.0.1] A reviewer has commented on "title" notifications should not go to other reviewers
        #2208# PostgreSQL Update Statements
        #2211# OJS 3: Remove site wide harvester registration section
        #2212# Editorial actions do not appear when an editor assigns themselves
        #2215# Dropdown controls in review forms present the wrong options
        #2218# OJS3: 'Phone' field 24-character limit
        #2223# Work around `false` returns from `glob` on some platforms during upgrade


Successfully upgraded to version 3.0.2.0
6

Hi @ojsfder,

That log looks like a successful upgrade to OJS 3.0.2. Where do you get the SQL error about the missing journal_id column?

Regards,
Alec Smecher
Public Knowledge Project Team

7

In the site itself, I can’t see nothing but the error :frowning:
apache’s access log:

"GET / HTTP/1.1" 200 61 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Firefox/52.0"

apache’s error log:

ojs2: DB Error: Unknown column 'journal_id' in 'on clause'

I also tried other URIs like /index.php but I got the same error.

Is anything I can do to help you helping me?

8

Hi @ojsfder,

Can you try turning on show_stacktrace in config.inc.php? I wonder if you have an incompatible plugin or something similar that’s causing problems, or perhaps some old OJS 2.x code that’s still in your 3.x installation.

Regards,
Alec Smecher
Public Knowledge Project Team

9

I am sorry to inform you that it was my mistake, I didn’t realised that after update I forgot to change apache’s Root Directory (it was pointing to old 2.4.8-2 instalation).
I’m sorry to make you waste your time.

It’s seems ok now (after I make things right) :slight_smile:

10

Hi @ojsfder,

Not a problem, thanks for following up!

Regards,
Alec Smecher
Public Knowledge Project Team

11

Hello, I’m back again.
“seems right” but just before logging in :-/

(I’m not the site Administrator, so I had to wait for Admins to validate, and they didn’t :frowning:
I had to clone the virtual machine and now I have a testing server


the upgrade seems ok, but when I log in as admin I see somethings doesn’t seem right.

I explain myself:

after loggin in, I go to control pannel, or user profile and:

I see a loading label at the top of the site (in the blue top header) and doesn’t stop ever, is loading forever.

if I choose any of the options in the left menu, the red color don’t change, I mean, it stays at the first option and loading labels stays “loading”. (next picture)

OJS-error

if I click some of the link loaded I get an error

{"status":true,"content":"\n\n\t\t\tAyuda\n\t<\/a>\n\n

And the source code of the error is

{"status":true,"content":"\n<a href=\"#\" class=\"requestHelpPanel pkp_help_link pkp_help_tab\" data-topic=\"user-profile.md\">\n\t\t\tAyuda\n\t<\/a>\n\n<script type=\"text\/javascript\">\n\t$(function() {\n\t\t\/\/ Attach the form handler.\n\t\t$('#identityForm').pkpHandler('$.pkp.controllers.form.AjaxFormHandler');\n\t});\n<\/script>\n\n<form class=\"pkp_form\" id=\"identityForm\" method=\"post\" action=\"http:\/\/revitest.fder.edu.uy\/index.php\/rfd\/$$$call$$$\/tab\/user\/profile-tab\/save-identity\" enctype=\"multipart\/form-data\">\n\t<input type=\"hidden\" name=\"csrfToken\" value=\"d1f2071b888f7040fdd43bb260f92893\">\n\n\t\n<script>\n\t$(function() {\n\t\t\/\/ Attach the form handler.\n\t\t$('#identityFormNotification').pkpHandler('$.pkp.controllers.NotificationHandler',\n\t\t{\n\t\t\t\nfetchNotificationUrl: \"http:\\\/\\\/revitest.fder.edu.uy\\\/index.php\\\/rfd\\\/notification\\\/fetchNotification\",\nhasSystemNotifications: null\n\t\t});\n\t});\n<\/script>\n<div id=\"identityFormNotification\" class=\"pkp_notification \"><\/div>\n\t\n<fieldset  id=\"userNameInfo\">\n\t\t\t\t\n\n<div class=\"section  \">\n\t\t\t\t\t<label >Nombre usuario<\/label>\t\t\t\n\t\t\t\t\t\tojsAdmin\n\t\t\n\t<\/div>\t\n<\/fieldset>\n\t\n<fieldset  id=\"userFormCompactLeft\">\n\t\t\t\t\n\n<div class=\"section  \">\n\t\t\t\t\t<label >Nombre<\/label>\t\t\t\n\t\t\t\t\t\t\n<div class=\"inline pkp_helpers_quarter\">\n\t\t<input\ttype=\"text\"\n\t\tmaxlength=\"40\" validation=\"required\" \n\t\tclass=\"field text required\"\n\t\t\t\t\t\tname=\"firstName\"\n\t\tvalue=\"ojsAdmin\"\n\t\tid=\"firstName-59a5aa070bcf8\"\n\t\t\t\t required aria-required=\"true\"\t\/>\n\n\t\n\t<span>\n\t\t\t\t<label class=\"sub_label\"  for=\"firstName-59a5aa070bcf8\">\n\tNombre<span class=\"req\">*<\/span><\/label><\/span>\n<\/div>\n\t\t\t\n<div class=\"inline pkp_helpers_quarter\">\n\t\t<input\ttype=\"text\"\n\t\tmaxlength=\"40\" \n\t\tclass=\"field text\"\n\t\t\t\t\t\tname=\"middleName\"\n\t\tvalue=\"\"\n\t\tid=\"middleName-59a5aa070c20d\"\n\t\t\t\t\t\/>\n\n\t\n\t<span>\n\t\t\t\t<label class=\"sub_label\"  for=\"middleName-59a5aa070c20d\">\n\tSegundo Nombre<\/label><\/span>\n<\/div>\n\t\t\t\n<div class=\"inline pkp_helpers_quarter\">\n\t\t<input\ttype=\"text\"\n\t\tmaxlength=\"40\" validation=\"required\" \n\t\tclass=\"field text required\"\n\t\t\t\t\t\tname=\"lastName\"\n\t\tvalue=\"ojs\"\n\t\tid=\"lastName-59a5aa070c674\"\n\t\t\t\t required aria-required=\"true\"\t\/>\n\n\t\n\t<span>\n\t\t\t\t<label class=\"sub_label\"  for=\"lastName-59a5aa070c674\">\n\tApellidos<span class=\"req\">*<\/span><\/label><\/span>\n<\/div>\n\t\t\n\t<\/div>\t\t\n\n<div class=\"section  \">\n\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\n<div class=\"inline pkp_helpers_quarter\">\n\t\t<input\ttype=\"text\"\n\t\tmaxlength=\"40\" \n\t\tclass=\"field text\"\n\t\t\t\t\t\tname=\"salutation\"\n\t\tvalue=\"\"\n\t\tid=\"salutation-59a5aa070ce1d\"\n\t\t\t\t\t\/>\n\n\t\n\t<span>\n\t\t\t\t<label class=\"sub_label\"  for=\"salutation-59a5aa070ce1d\">\n\tTratamiento<\/label><\/span>\n<\/div>\n\t\t\t\n<div class=\"inline pkp_helpers_quarter\">\n\t\t<input\ttype=\"text\"\n\t\tmaxlength=\"5\" \n\t\tclass=\"field text\"\n\t\t\t\t\t\tname=\"initials\"\n\t\tvalue=\"oo\"\n\t\tid=\"initials-59a5aa070d3b5\"\n\t\t\t\t\t\/>\n\n\t\n\t<span>\n\t\t\t\t<label class=\"sub_label\"  for=\"initials-59a5aa070d3b5\">\n\tIniciales<\/label><\/span>\n<\/div>\n\t\t\t\n<div class=\"inline pkp_helpers_quarter\">\n\t\t<input\ttype=\"text\"\n\t\t\n\t\tclass=\"field text\"\n\t\t\t\t\t\tname=\"suffix\"\n\t\tvalue=\"\"\n\t\tid=\"suffix-59a5aa070d938\"\n\t\t\t\t\t\/>\n\n\t\n\t<span>\n\t\t\t\t<label class=\"sub_label\"  for=\"suffix-59a5aa070d938\">\n\tSufijo<\/label><\/span>\n<\/div>\n\t\t\n\t<\/div>\t\t\n\n<div class=\"section  \">\n\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\n<div class=\"pkp_helpers_quarter\">\n<select name=\"gender\" id=\"gender\" >\n\t\t<option label=\"\" value=\"\"><\/option>\n<option label=\"M\" value=\"M\">M<\/option>\n<option label=\"F\" value=\"F\" selected=\"selected\">F<\/option>\n<option label=\"Otro\" value=\"O\">Otro<\/option>\n<\/select>\n\n\t<span>\n\t<label class=\"sub_label\"  for=\"gender\">\n\tSexo<\/label><\/span>\n<\/div>\n\t\t\n\t<\/div>\t\n<\/fieldset>\n\t\n\n\n<div class=\"section formButtons form_buttons \">\n\t\t\t\t\t\t\t\t\n\t\t\t\n\t\t\n\t\t\n\t<button class=\"pkp_button submitFormButton\" type=\"submit\"  id=\"submitFormButton-59a5aa070eeda\" >Guardar<\/button>\n\n\t\t<span class=\"pkp_spinner\"><\/span>\n\n\t\t\n\t<\/div>\n\n\t<p><span class=\"formRequired\">* Campos obligatorios<\/span><\/p>\n<\/form>","elementId":"0"}

No errors logged in apache, nor ojs, I enable all debug vars and I can’t see error logged


I can ask permission to give you Admin credentials for the test if you need it.

thanks you,

sds, NicolĂĄs.

12

Hi @ojsfder,

Your post got a little garbled above – can you try using the quoting tools this forum tool supports (e.g. the “preformatted text” button at the top of the toolbar)? The forum software supports Markdown syntax, if you’re familiar.

Regards,
Alec Smecher
Public Knowledge Project Team