PKP Bugzilla – Bug 6597
Comments table should have an index on parent_id
Last modified: 2011-04-14 12:00:56 PDT
We are moving to Git Issues for bug tracking in future releases. During transition, content will be in both tools. If you'd like to file a new bug, please create an issue.
Comments table should have an index on parent_id.
Created attachment 3482 [details]
Patch against OJS 2.3.4
Created attachment 3483 [details]
Patch against OCS 2.3.3-1
NOTE: These patches will only affect your installation if they are applied *before* the installation or upgrade scripts are run. To add the missing index to an existing installation without running an upgrade, execute the following SQL:
CREATE INDEX comments_parent_comment_id ON comments (parent_comment_id);