PKP Bugzilla – Bug 3219
Blank public IDs saved as empty strings rather than NULLs
Last modified: 2008-07-14 09:47:35 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.
Blank public IDs are saved as empty strings rather than NULL values; this causes indexing to run into duplicates. Should check for this in:
- Public article IDs
- Public issue IDs
- Public supp file IDs
Should also ensure that blanks are turned into nulls as part of the upgrade process.
To work around this for OJS 2.2, run the following queries before upgrading:
UPDATE issues SET public_issue_id = NULL WHERE public_issue_id = '';
UPDATE published_articles SET public_article_id = NULL WHERE public_article_id = '';
UPDATE article_supplementary_files SET public_supp_file_id = NULL WHERE public_supp_file_id = '';
Created attachment 459 [details]
Patch against pre-2.2.1 CVS