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.

Bug 6817

Summary: Check and fix missing controlled vocab data for citation assistant
Product: OJS Reporter: Alec Smecher <alec>
Component: GeneralAssignee: PKP Support <pkp-support>
Status: RESOLVED FIXED    
Severity: normal CC: axfelix
Priority: P3    
Version: 2.3.7   
Hardware: All   
OS: All   
Version Reported In: Also Affects:
Attachments: Calls the DB update script from pkp-lib to add controlled vocabulary entries for citation assistant on OJS install
DB update script for pkp-lib to add controlled vocabulary entries for citation assistant on OJS install

Description Alec Smecher 2011-08-10 09:39:30 PDT
See http://pkp.sfu.ca/support/forum/viewtopic.php?f=8&t=7814 for details.
Comment 1 Alex Garnett 2011-09-02 17:49:57 PDT
Created attachment 3625 [details]
Calls the DB update script from pkp-lib to add controlled vocabulary entries for citation assistant on OJS install

pkp-lib fix attached separately (this doesn't seem ideal -- alec?)
Comment 2 Alex Garnett 2011-09-02 17:50:31 PDT
Created attachment 3626 [details]
DB update script for pkp-lib to add controlled vocabulary entries for citation assistant on OJS install
Comment 3 Alex Garnett 2011-12-05 10:49:34 PST
Need to run "php tools/dbXMLtoSQL.php -data execute lib/pkp/xml/controlledVocabMetadata.xml" to add database entries if OJS has already been installed -- the attached patches are only called on installation.

**Not entirely sure of the difference between -data and -schema arguments for dbXMLtoSQL; this could use a look.
Comment 4 Alec Smecher 2011-12-05 10:57:07 PST
Alex, the -data option is correct in this case. (Note that the attached patches will still need to be applied first.) FYI, -schema is for XML docs with a <schema> root node; -data is for XML docs with a <data> root node.
Comment 5 Alex Garnett 2011-12-05 11:01:04 PST
Thanks. I'd gathered, just wanted a double-check. Glad that this in fact took me all of the five minutes I expected after putting it off so long...
Comment 6 Alec Smecher 2012-03-12 12:45:02 PDT
Add missing controlled vocab data for citation assistant
https://github.com/pkp/pkp-lib/commit/9106d10b3a6a09cb7c2d9e357561d399ff29f0da
Comment 7 Alec Smecher 2012-03-12 12:50:02 PDT
Add missing controlled vocab data for citation assistant
https://github.com/pkp/ojs/commit/be26170e478cb326593252a1fb05484786e8b40a