Skip to content

Instantly share code, notes, and snippets.

@rushirajnenuji

rushirajnenuji/crossref_errors_not_like_5070P4.sql Secret

Last active September 17, 2021 20:52
Show Gist options
  • Save rushirajnenuji/63df53891a4f6e46feb1f62d02ce5c55 to your computer and use it in GitHub Desktop.
Save rushirajnenuji/63df53891a4f6e46feb1f62d02ce5c55 to your computer and use it in GitHub Desktop.
Download ZIP
crossref_errors_not_like_5070P4.sql
Raw
crossref_errors_not_like_5070P4.sql
MySQL [ezid]> select seq, identifier, owner, operation, status, FROM_UNIXTIME(submitTime), message from CQ where identifier not like 'doi:10.5070/P4%' order by message asc;
+--------+---------------------------+----------------------+-----------+--------+---------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| seq | identifier | owner | operation | status | FROM_UNIXTIME(submitTime) | message |
+--------+---------------------------+----------------------+-----------+--------+---------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 233848 | doi:10.5070/BP328133885 | ark:/99166/p9vt1gs8k | C | W | 2019-03-20 17:16:23 | Added with conflict
conflict_id=5460856
in conflict with: 10.5070/BP328133884 |
| 233868 | doi:10.5070/BP327124511 | ark:/99166/p9vt1gs8k | C | W | 2019-03-20 17:18:40 | Added with conflict
conflict_id=5460857
in conflict with: 10.5070/BP327124512 |
| 233869 | doi:10.5070/BP327120808 | ark:/99166/p9vt1gs8k | C | W | 2019-03-20 17:18:40 | Added with conflict
conflict_id=5460858
in conflict with: 10.5070/BP327124500 |
| 250980 | doi:10.5070/BS3152011585 | ark:/99166/p9vt1gs8k | C | W | 2021-06-09 15:46:07 | Added with conflict
conflict_id=6076047
in conflict with: 10.5070/BS3152012056 |
| 254647 | doi:10.5070/D3202021534 | ark:/99166/p94t6f90d | C | W | 2021-06-09 18:33:35 | Added with conflict
conflict_id=6076100
in conflict with: 10.5070/D3202019455 |
| 256061 | doi:10.5070/D3202018323 | ark:/99166/p94t6f90d | C | W | 2021-06-09 19:42:39 | Added with conflict
conflict_id=6076117
in conflict with: 10.5070/D3202021538 |
| 257516 | doi:10.5070/C720020912 | ark:/99166/p96688r1t | C | W | 2021-06-10 15:53:33 | Added with conflict
conflict_id=6076192
in conflict with: 10.5070/C720020911 |
| 259979 | doi:10.5070/M3271014511 | ark:/99166/p96688r1t | C | W | 2021-06-10 18:06:30 | Added with conflict
conflict_id=6076260
in conflict with: 10.5070/M3271014510 |
| 261749 | doi:10.5070/LR8141027090 | ark:/99166/p96688r1t | C | W | 2021-06-11 09:35:47 | Added with conflict
conflict_id=6076281
in conflict with: 10.5070/LR8141027089 |
| 261778 | doi:10.5070/LR8211027173 | ark:/99166/p96688r1t | C | W | 2021-06-11 09:37:09 | Added with conflict
conflict_id=6076282
in conflict with: 10.5070/LR8211027174 |
| 261801 | doi:10.5070/LR8201027159 | ark:/99166/p96688r1t | C | W | 2021-06-11 09:38:30 | Added with conflict
conflict_id=6076283
in conflict with: 10.5070/LR8201027160 |
| 261875 | doi:10.5070/LR8151027102 | ark:/99166/p96688r1t | C | W | 2021-06-11 09:42:35 | Added with conflict
conflict_id=6076284
in conflict with: 10.5070/LR8151027103 |
| 261908 | doi:10.5070/LR8161027117 | ark:/99166/p96688r1t | C | W | 2021-06-11 09:43:59 | Added with conflict
conflict_id=6076285
in conflict with: 10.5070/LR8161027116 |
| 263406 | doi:10.5070/F7311-2018316 | ark:/99166/p96688r1t | C | W | 2021-06-11 11:36:49 | Added with conflict
conflict_id=6076287
in conflict with: 10.5070/F7311-2016522 |
| 265000 | doi:10.5070/C411025265 | ark:/99166/p9z02zf9d | C | W | 2021-06-11 12:49:54 | Added with conflict
conflict_id=6076288
in conflict with: 10.5070/C411025266 |
| 266000 | doi:10.5070/BS3222039578 | ark:/99166/p9vt1gs8k | C | W | 2021-06-22 16:48:14 | Added with conflict
conflict_id=6082071
in conflict with: 10.5070/BS322239578 |
| 266001 | doi:10.5070/D3228032192 | ark:/99166/p94t6f90d | C | W | 2021-06-22 16:48:15 | Added with conflict
conflict_id=6082072
in conflict with: 10.5070/D322832192 |
| 266003 | doi:10.5070/D3225030957 | ark:/99166/p94t6f90d | C | W | 2021-06-22 16:48:15 | Added with conflict
conflict_id=6082073
in conflict with: 10.5070/D322530957 |
| 266004 | doi:10.5070/D3241037964 | ark:/99166/p94t6f90d | C | W | 2021-06-22 16:48:15 | Added with conflict
conflict_id=6082074
in conflict with: 10.5070/D324137964 |
| 266005 | doi:10.5070/D3227031656 | ark:/99166/p94t6f90d | C | W | 2021-06-22 16:48:16 | Added with conflict
conflict_id=6082075
in conflict with: 10.5070/D322731656 |
| 266007 | doi:10.5070/PG7261003197 | ark:/99166/p96688r1t | C | W | 2021-06-22 16:49:22 | Added with conflict
conflict_id=6082076
in conflict with: 10.5070/PG72613197 |
| 266008 | doi:10.5070/L5331028750 | ark:/99166/p96688r1t | C | W | 2021-06-22 16:49:22 | Added with conflict
conflict_id=6082077
in conflict with: 10.5070/L533128750 |
| 266009 | doi:10.5070/L5332029230 | ark:/99166/p96688r1t | C | W | 2021-06-22 16:49:23 | Added with conflict
conflict_id=6082078
in conflict with: 10.5070/L533229230 |
| 266010 | doi:10.5070/L5331028751 | ark:/99166/p96688r1t | C | W | 2021-06-22 16:49:23 | Added with conflict
conflict_id=6082079
in conflict with: 10.5070/L533128751 |
| 266011 | doi:10.5070/L5332029241 | ark:/99166/p96688r1t | C | W | 2021-06-22 16:49:23 | Added with conflict
conflict_id=6082080
in conflict with: 10.5070/L533229241 |
| 266013 | doi:10.5070/L5332029239 | ark:/99166/p96688r1t | C | W | 2021-06-22 16:49:24 | Added with conflict
conflict_id=6082081
in conflict with: 10.5070/L533229239 |
| 266014 | doi:10.5070/L5331028752 | ark:/99166/p96688r1t | C | W | 2021-06-22 16:49:24 | Added with conflict
conflict_id=6082082
in conflict with: 10.5070/L533128752 |
| 255419 | doi:10.5070/D37WB600HS | ark:/99166/p94t6f90d | C | F | 2021-06-09 19:10:39 | Deposit contains title error(s): Title name value is missing from the title element |
| 265638 | doi:10.5070/P2PG6B | ark:/99166/p9pz51k8v | U | F | 2021-06-15 10:32:36 | DOI has been marked as an alias and therefore cant be updated |
| 267610 | doi:10.31223/X5790P | ark:/99166/p93776180 | C | F | 2021-09-06 06:49:34 | Error in posted_content (Author ORCID): ORCID URL "0000-0002-3464-6366" has duplicates in contributor list |
| 260373 | doi:10.31223/X5CW3X | ark:/99166/p93776180 | C | F | 2021-06-10 18:22:57 | Error: cvc-complex-type.2.4.a: Invalid content was found starting with element 'jats:abstract'. One of '{"http://www.crossref.org/schema/4.4.0":titles}' is expected.
|
| 267629 | doi:10.5070/P9381052082 | ark:/99166/p9vt1gs8k | U | F | 2021-09-07 12:31:38 | Error: cvc-complex-type.2.4.a: Invalid content was found starting with element 'ns0:journal_volume'. One of '{"http://www.crossref.org/schema/4.3.5":contributors, "http://www.crossref.org/schema/4.3.5":publication_date}' is expected.
Error: cvc-complex-type.2.4.a: Invalid content was found starting with element 'ns0:doi_data'. One of '{"http://www.ncbi.nlm.nih.gov/JATS1":abstract, "http://www.crossref.org/schema/4.3.5":publication_date}' is expected.
|
| 267630 | doi:10.5070/P9381052265 | ark:/99166/p9vt1gs8k | U | F | 2021-09-07 12:31:38 | Error: cvc-complex-type.2.4.a: Invalid content was found starting with element 'ns0:journal_volume'. One of '{"http://www.crossref.org/schema/4.3.5":contributors, "http://www.crossref.org/schema/4.3.5":publication_date}' is expected.
Error: cvc-complex-type.2.4.a: Invalid content was found starting with element 'ns0:doi_data'. One of '{"http://www.ncbi.nlm.nih.gov/JATS1":abstract, "http://www.crossref.org/schema/4.3.5":publication_date}' is expected.
|
| 267631 | doi:10.5070/P9381052825 | ark:/99166/p9vt1gs8k | U | F | 2021-09-07 12:31:38 | Error: cvc-complex-type.2.4.a: Invalid content was found starting with element 'ns0:journal_volume'. One of '{"http://www.crossref.org/schema/4.3.5":contributors, "http://www.crossref.org/schema/4.3.5":publication_date}' is expected.
Error: cvc-complex-type.2.4.a: Invalid content was found starting with element 'ns0:doi_data'. One of '{"http://www.ncbi.nlm.nih.gov/JATS1":abstract, "http://www.crossref.org/schema/4.3.5":publication_date}' is expected.
|
| 267632 | doi:10.5070/P9381052921 | ark:/99166/p9vt1gs8k | U | F | 2021-09-07 12:31:39 | Error: cvc-complex-type.2.4.a: Invalid content was found starting with element 'ns0:journal_volume'. One of '{"http://www.crossref.org/schema/4.3.5":contributors, "http://www.crossref.org/schema/4.3.5":publication_date}' is expected.
Error: cvc-complex-type.2.4.a: Invalid content was found starting with element 'ns0:doi_data'. One of '{"http://www.ncbi.nlm.nih.gov/JATS1":abstract, "http://www.crossref.org/schema/4.3.5":publication_date}' is expected.
|
| 267633 | doi:10.5070/P9381053299 | ark:/99166/p9vt1gs8k | U | F | 2021-09-07 12:31:39 | Error: cvc-complex-type.2.4.a: Invalid content was found starting with element 'ns0:journal_volume'. One of '{"http://www.crossref.org/schema/4.3.5":contributors, "http://www.crossref.org/schema/4.3.5":publication_date}' is expected.
Error: cvc-complex-type.2.4.a: Invalid content was found starting with element 'ns0:doi_data'. One of '{"http://www.ncbi.nlm.nih.gov/JATS1":abstract, "http://www.crossref.org/schema/4.3.5":publication_date}' is expected.
|
| 267634 | doi:10.5070/P9381054113 | ark:/99166/p9vt1gs8k | U | F | 2021-09-07 12:31:39 | Error: cvc-complex-type.2.4.a: Invalid content was found starting with element 'ns0:journal_volume'. One of '{"http://www.crossref.org/schema/4.3.5":contributors, "http://www.crossref.org/schema/4.3.5":publication_date}' is expected.
Error: cvc-complex-type.2.4.a: Invalid content was found starting with element 'ns0:doi_data'. One of '{"http://www.ncbi.nlm.nih.gov/JATS1":abstract, "http://www.crossref.org/schema/4.3.5":publication_date}' is expected.
|
| 267635 | doi:10.5070/P938054460 | ark:/99166/p9vt1gs8k | U | F | 2021-09-07 12:31:40 | Error: cvc-complex-type.2.4.a: Invalid content was found starting with element 'ns0:journal_volume'. One of '{"http://www.crossref.org/schema/4.3.5":contributors, "http://www.crossref.org/schema/4.3.5":publication_date}' is expected.
Error: cvc-complex-type.2.4.a: Invalid content was found starting with element 'ns0:doi_data'. One of '{"http://www.ncbi.nlm.nih.gov/JATS1":abstract, "http://www.crossref.org/schema/4.3.5":publication_date}' is expected.
|
| 267636 | doi:10.5070/P938054472 | ark:/99166/p9vt1gs8k | U | F | 2021-09-07 12:31:40 | Error: cvc-complex-type.2.4.a: Invalid content was found starting with element 'ns0:journal_volume'. One of '{"http://www.crossref.org/schema/4.3.5":contributors, "http://www.crossref.org/schema/4.3.5":publication_date}' is expected.
Error: cvc-complex-type.2.4.a: Invalid content was found starting with element 'ns0:doi_data'. One of '{"http://www.ncbi.nlm.nih.gov/JATS1":abstract, "http://www.crossref.org/schema/4.3.5":publication_date}' is expected.
|
| 266664 | doi:10.5070/P938054113 | ark:/99166/p9vt1gs8k | U | F | 2021-07-13 13:16:02 | Error: cvc-complex-type.2.4.a: Invalid content was found starting with element 'ns0:journal_volume'. One of '{"http://www.crossref.org/schema/4.3.5":contributors, "http://www.crossref.org/schema/4.3.5":publication_date}' is expected.
Error: cvc-complex-type.2.4.a: Invalid content was found starting with element 'ns0:doi_data'. One of '{"http://www.ncbi.nlm.nih.gov/JATS1":abstract, "http://www.crossref.org/schema/4.3.5":publication_date}' is expected.
|
| 235326 | doi:10.5070/D6110000 | ark:/99166/p9rb6w21w | U | F | 2019-07-10 17:01:37 | Error: cvc-datatype-valid.1.2.1: '' is not a valid value for 'integer'.
Error: cvc-type.3.1.3: The value '' of element 'ns0:year' is not valid.
Error: cvc-minLength-valid: Value '' with length = '0' is not facet-valid with respect to minLength '1' for type '#AnonType_volume'.
Error: cvc-type.3.1.3: The value '' of element 'ns0:volume' is not valid.
Error: cvc-complex-type.2.4.b: The content of element 'ns0:contributors' is not complete. One of '{"http://www.crossref.org/schema/4.3.5":organization, "http://www.crossref.org/schema/4.3.5":person_name}' is expected.
Error: cvc-datatype-valid.1.2.1: '' is not a valid value for 'integer'.
Error: cvc-type.3.1.3: The value '' of element 'ns0:year' is not valid.
|
| 252440 | doi:10.5070/D303Q7614Q | ark:/99166/p94t6f90d | C | F | 2021-06-09 16:52:45 | Error: cvc-maxLength-valid: Value 'Howard Maibach Video procedures by Robert S. Scheinberg review by James' with length = '71' is not facet-valid with respect to maxLength '35' for type '#AnonType_given_name'.
Error: cvc-type.3.1.3: The value 'Howard Maibach Video procedures by Robert S. Scheinberg review by James' of element 'ns0:given_name' is not valid.
|
| 255360 | doi:10.5070/D3269050176 | ark:/99166/p94t6f90d | C | F | 2021-06-09 19:07:55 | Error: cvc-maxLength-valid: Value 'The University of California, Davis School of Medicine' with length = '54' is not facet-valid with respect to maxLength '35' for type '#AnonType_given_name'.
Error: cvc-type.3.1.3: The value 'The University of California, Davis School of Medicine' of element 'ns0:given_name' is not valid.
|
| 267193 | doi:10.5070/D32610050499 | ark:/99166/p94t6f90d | U | F | 2021-08-25 17:11:23 | Error: cvc-maxLength-valid: Value 'The University of California, Davis, School of Medicine,' with length = '56' is not facet-valid with respect to maxLength '35' for type '#AnonType_given_name'.
Error: cvc-type.3.1.3: The value 'The University of California, Davis, School of Medicine,' of element 'ns0:given_name' is not valid.
|
| 255958 | doi:10.5070/D3269050178 | ark:/99166/p94t6f90d | C | F | 2021-06-09 19:38:17 | Error: cvc-maxLength-valid: Value 'University of California, Davis School of Medicine' with length = '50' is not facet-valid with respect to maxLength '35' for type '#AnonType_given_name'.
Error: cvc-type.3.1.3: The value 'University of California, Davis School of Medicine' of element 'ns0:given_name' is not valid.
|
| 267194 | doi:10.5070/D32610050500 | ark:/99166/p94t6f90d | U | F | 2021-08-25 17:11:23 | Error: cvc-maxLength-valid: Value 'University of California, Davis, School of Medicine,' with length = '52' is not facet-valid with respect to maxLength '35' for type '#AnonType_given_name'.
Error: cvc-type.3.1.3: The value 'University of California, Davis, School of Medicine,' of element 'ns0:given_name' is not valid.
|
| 266325 | doi:10.31223/OSF.IO/XGWA3 | ark:/99166/p93776180 | U | F | 2021-06-29 12:33:52 | Error: cvc-minLength-valid: Value '' with length = '0' is not facet-valid with respect to minLength '1' for type '#AnonType_given_name'.
Error: cvc-type.3.1.3: The value '' of element 'ns0:given_name' is not valid.
|
| 245347 | doi:10.31223/X5V306 | ark:/99166/p93776180 | C | F | 2020-10-21 13:11:10 | Error: cvc-pattern-valid: Value '0000-0002-4027-3965' is not facet-valid with respect to pattern 'https?://orcid.org/[0-9]{4}-[0-9]{4}-[0-9]{4}-[0-9]{3}[X0-9]{1}' for type 'orcid_t'.
Error: cvc-complex-type.2.2: Element 'ns0:ORCID' must have no element [children], and the value must be valid.
|
| 255016 | doi:10.5070/D36ST6752T | ark:/99166/p94t6f90d | C | F | 2021-06-09 18:51:56 | Error: cvc-pattern-valid: Value '21 A. Richard Gallo 21 B. John P.' is not facet-valid with respect to pattern '[^\d\?]*' for type '#AnonType_given_name'.
Error: cvc-type.3.1.3: The value '21 A. Richard Gallo 21 B. John P.' of element 'ns0:given_name' is not valid.
Error: cvc-pattern-valid: Value 'Philip Fleckman 21 C. Robert Baran 21 D. B.' is not facet-valid with respect to pattern '[^\d\?]*' for type '#AnonType_given_name'.
Error: cvc-type.3.1.3: The value 'Philip Fleckman 21 C. Robert Baran 21 D. B.' of element 'ns0:given_name' is not valid.
Error: cvc-pattern-valid: Value 'M. Baghaie 21 E. Edward Krull 21F. Edward M Jackson 21 G. Erin Warshaw 21 H. Bita' is not facet-valid with respect to pattern '[^\d\?]*' for type '#AnonType_given_name'.
Error: cvc-type.3.1.3: The value 'M. Baghaie 21 E. Edward Krull 21F. Edward M Jackson 21 G. Erin Warshaw 21 H. Bita' of element 'ns0:given_name' is not valid.
Error: cvc-pattern-valid: Value 'Richard K Scher 21 I. Francis W. Busch 21 J. Philip' is not facet-valid with respect to pattern '[^\d\?]*' for type '#AnonType_given_name'.
Error: cvc-type.3.1.3: The value 'Richard K Scher 21 I. Francis W. Busch 21 J. Philip' of element 'ns0:given_name' is not valid.
|
| 253965 | doi:10.5070/D34266X6GP | ark:/99166/p94t6f90d | C | F | 2021-06-09 18:03:21 | Error: cvc-pattern-valid: Value '3rd' is not facet-valid with respect to pattern '[^\d\?]*[^\d\?\s]+[^\d\?]*' for type '#AnonType_surname'.
Error: cvc-type.3.1.3: The value '3rd' of element 'ns0:surname' is not valid.
|
| 264700 | doi:10.5070/C592V4X1WD | ark:/99166/p9z02zf9d | C | F | 2021-06-11 12:35:56 | Error: cvc-pattern-valid: Value 'Borb6n' is not facet-valid with respect to pattern '[^\d\?]*[^\d\?\s]+[^\d\?]*' for type '#AnonType_surname'.
Error: cvc-type.3.1.3: The value 'Borb6n' of element 'ns0:surname' is not valid.
|
| 265995 | doi:10.5070/V321029260 | ark:/99166/p98k75332 | U | F | 2021-06-22 16:48:13 | Error: cvc-pattern-valid: Value 'Issue 3' is not facet-valid with respect to pattern '[^\d\?]*[^\d\?\s]+[^\d\?]*' for type '#AnonType_surname'.
Error: cvc-type.3.1.3: The value 'Issue 3' of element 'ns0:surname' is not valid.
|
| 252411 | doi:10.5070/D30178V6KT | ark:/99166/p94t6f90d | C | F | 2021-06-09 16:51:14 | Error: cvc-pattern-valid: Value 'Paksoy1' is not facet-valid with respect to pattern '[^\d\?]*[^\d\?\s]+[^\d\?]*' for type '#AnonType_surname'.
Error: cvc-type.3.1.3: The value 'Paksoy1' of element 'ns0:surname' is not valid.
|
| 239408 | doi:10.5070/B89249114 | ark:/99166/p9vt1gs8k | C | F | 2020-07-15 13:15:43 | Error: cvc-pattern-valid: Value 'V9, N2' is not facet-valid with respect to pattern '[^\d\?]*[^\d\?\s]+[^\d\?]*' for type '#AnonType_surname'.
Error: cvc-type.3.1.3: The value 'V9, N2' of element 'ns0:surname' is not valid.
|
| 235280 | doi:10.20354/B4414110000 | ark:/99166/p9js9hb3n | U | F | 2019-06-28 15:01:06 | ISSN "23771666" has already been assigned, title/issn: Proceedings of the Annual Meeting of the Berkeley Linguistics Society/23771666 is owned by publisher: 10.3765 |
| 236003 | doi:10.5070/B89146420 | ark:/99166/p9vt1gs8k | U | W | 2020-01-04 11:02:06 | Updated with conflict
conflict_id=5569418
in conflict with: 10.5070/B89146419 |
| 236251 | doi:10.5070/B89146419 | ark:/99166/p9vt1gs8k | U | W | 2020-02-08 16:11:11 | Updated with conflict
conflict_id=5569418
in conflict with: 10.5070/B89146420 |
| 236245 | doi:10.5070/B89146461 | ark:/99166/p9vt1gs8k | U | W | 2020-02-08 16:11:09 | Updated with conflict
conflict_id=5569735
in conflict with: 10.5070/B89146451 |
+--------+---------------------------+----------------------+-----------+--------+---------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
58 rows in set (0.00 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment