search

knilssen / Founding_Fathers

Provides a reliable political feed for readers to become knowledgeable and informed voters on the state political level.
https://knilssen.github.io/Founding_Fathers
1 stars 1 forks source link

David/Dave Reichert #29

Open knilssen opened 6 years ago

knilssen commented 6 years ago

Problem with finding Divid Reichert. Usually called by his nickname, dave reichert, we are for some reason trying to create a article person link in our database still using his nickname, dave reichert instead of sending over his real name which is used in the database, David Reichert.

Error is as follows:

ERROR: PROBLEM WITH MYSQL_ARTICLE_PERSON_LINK
MOST LIKELY HAS TO DO WITH PERSON NOT BEING IN DATABASE TABLE NEWS_PEOPLE

ARTICLE_ID:                       355
ARTICLE_PEOPLE:                   {'cathy mcmorris rodgers': 1, 'dave reichert': 2}
PERSON:                           dave reichert
MENTION_PERCENTAGE:               13.33
ARTICLE_TOTAL_COUNT_MENTIONS:     15
ERROR ON LINE 55:
               data = data[0]
PRINT DATA:
               []
knilssen commented 6 years ago

This is now a large problem since Dave/ David Reichert is quite popular so it seams and is causing problems now with the amount of articles he is involved with.

I have noticed that in some instances, his nickname is correctly changed over from Dave to David and entered correctly into the database