Remove bad entries from stats_download

Project:RUcore Statistics
Version:7.2.1
Component:Code
Category:bug report
Priority:normal
Assigned:jgeng
Status:closed
Description

On production there are some entries in the stats_download table where the 'object' value is not a valid rutgers-lib identifier. Please remove these entries.

Comments

#1

Version:7-x» 7.2.1

sql scripts is ready now. will apply to rep-devel first.

#2

Status:active» test

Chad,

please test

#3

Status:test» fixed

Confirmed

#4

Status:fixed» active

Sorry spoke to soon. I still found some "bad" fedora ID's in the stats_download table in the 'stats_prod' database on development.

144461;"record";"RECORD";"rutgers-lib.7.3:2588";"741173"
144457;"record";"RECORD";"rutgers-lib.7.3:2588";"741169"
144458;"record";"RECORD";"rutgers-lib.7.3:2588";"741170"
144459;"record";"RECORD";"rutgers-lib.7.3:2588";"741171"
144462;"record";"RECORD";"rutgers-lib.7.3:2588";"741174"
144460;"record";"RECORD";"rutgers-lib.7.3:2588";"741172"
144451;"record";"RECORD";"rutgers-lib.7.3:2625";"741155"
144456;"record";"RECORD";"rutgers-lib.7.3:2625";"741167"
144463;"record";"RECORD";"rutgers-lib.7.3:2626";"741176"
144464;"record";"RECORD";"rutgers-lib.7.3:2626";"741177"
144465;"record";"RECORD";"rutgers-lib.7.3:2626";"741178"
144466;"record";"RECORD";"rutgers-lib.7.3:2626";"741179"
144467;"record";"RECORD";"rutgers-lib.7.3:2626";"741180"
144453;"record";"RECORD";"rutgers-lib.7.3:2637";"741160"
144452;"record";"RECORD";"rutgers-lib.7.3:2637";"741158"
144450;"record";"RECORD";"rutgers-lib.7.3:2637";"741153"
117518;"pdf";"PDF-1";"rutgers-lib:";"689236"
117519;"pdf";"PDF-1";"rutgers-lib:";"689237"
117520;"pdf";"PDF-1";"rutgers-lib:";"689238"
117521;"pdf";"PDF-1";"rutgers-lib:";"689239"
117531;"pdf";"PDF-1";"rutgers-lib:";"689250"
117534;"pdf";"PDF-1";"rutgers-lib:";"689253"
117537;"pdf";"PDF-1";"rutgers-lib:";"689256"
117538;"pdf";"PDF-1";"rutgers-lib:";"689257"
117517;"pdf";"PDF-1";"rutgers-lib:";"689235"

#5

Status:active» test

chad,

removed, please test.

#6

Status:test» fixed

Confirmed.

#7

Status:fixed» closed

Closing.

Back to top