You are viewing the PKP Support Forum | PKP Home Wiki

ojs 2.0.1 /sectionEditor

Are you an Editor, Author, or Journal Manager in need of help? Want to talk to us about workflow issues? This is your forum.

Moderators: jmacgreg, michael, vgabler, John

Forum rules
The Public Knowledge Project Support Forum is moving to http://forum.pkp.sfu.ca

This forum will be maintained permanently as an archived historical resource, but all new questions should be added to the new forum. Questions will no longer be monitored on this old forum after March 30, 2015.

ojs 2.0.1 /sectionEditor

Postby ctineo » Thu Jul 14, 2005 12:24 pm

I work with postgres 7.4.2 and ojs 2.0.1 when I log in with editor rol in the section "section editor" happens an error:
"ERROR: relation "a" does not exist"
I put debug = on config.inc.php and obtain the SQL that this giving to the error
the problem me is that I do not see where fails to correct it.
SELECT DISTINCT a.*, s.abbrev as section_abbrev, s.title as section_title, c.copyed_id, c.copyeditor_id, c.copyedit_revision, c.date_notified AS copyeditor_date_notified, c.date_underway AS copyeditor_date_underway, c.date_completed AS copyeditor_date_completed, c.date_acknowledged AS copyeditor_date_acknowledged, c.date_author_notified AS copyeditor_date_author_notified, c.date_author_underway AS copyeditor_date_author_underway, c.date_author_completed AS copyeditor_date_author_completed, c.date_author_acknowledged AS copyeditor_date_author_acknowledged, c.date_final_notified AS copyeditor_date_final_notified, c.date_final_underway AS copyeditor_date_final_underway, c.date_final_completed AS copyeditor_date_final_completed, c.date_final_acknowledged AS copyeditor_date_final_acknowledged, c.initial_revision AS copyeditor_initial_revision, c.editor_author_revision AS copyeditor_editor_author_revision, c.final_revision AS copyeditor_final_revision, r2.review_revision FROM articles a, article_authors aa LEFT JOIN edit_assignments e ON (e.article_id = a.article_id) LEFT JOIN users ed ON (e.editor_id = ed.user_id) LEFT JOIN sections s ON (s.section_id = a.section_id) LEFT JOIN copyed_assignments c ON (a.article_id = c.article_id) LEFT JOIN users ce ON (c.copyeditor_id = ce.user_id) LEFT JOIN proof_assignments p ON (p.article_id = a.article_id) LEFT JOIN users pe ON (pe.user_id = p.proofreader_id) LEFT JOIN review_rounds r2 ON (a.article_id = r2.article_id and a.current_round = r2.round) LEFT JOIN layouted_assignments l ON (l.article_id = a.article_id) LEFT JOIN users le ON (le.user_id = l.editor_id) WHERE a.journal_id = '1' AND e.editor_id = '5' AND aa.article_id = a.article_id AND a.status = 1 ORDER BY article_id ASC
Posts: 2
Joined: Wed Jul 13, 2005 9:19 am

Postby kevin » Thu Jul 14, 2005 8:26 pm

Posts: 338
Joined: Tue Oct 14, 2003 8:23 pm

Return to OJS Editorial Support and Discussion

Who is online

Users browsing this forum: No registered users and 3 guests