Admin refresh error message

earthchem / EarthChemAdmin2

Admin tools for Earthchem database person, organization, affiliation, citation

Apache License 2.0

0 stars 0 forks source link

Admin refresh error message #6

Closed annikakj closed 5 years ago

annikakj commented 5 years ago

@sparkji Refreshed, and got this error:

Error! ERROR: could not create unique index "uc_mvdrs_citation_action_variable_analyzed_sample_num_idx" Detail: Key (citation_num, action_num, analyzed_sample_num, variable_num)=(3557, 81739, 702658, 378) is duplicated.

bhchen8 commented 5 years ago

I will take a look

bhchen8 commented 5 years ago

Sorry! I don't know what caused this problem.

sparkji commented 5 years ago

It caused by one result with multiple vaules citation_num 3557 'rock' row 28, column 'BC' 4783433 | 4507386 | 38.2002 | 0.0048 | | 46 | 2018-12-10 4782052 | 4507386 | 38 | 2002 | | 46 | 2018-12-10 I have delete the second one, try refresh again, it should work now.

annikakj commented 5 years ago

Tested. Confirming it is fixed