Home         Message Forums         E-Zine          Scene Database          FAQs          Friends Page          Contact


Database Correction Page

Welcome to the Database Correction page. This page is for letting me or the other editors know of corrections that need to be made. Please read the posting instructions carefully.

Post a Message


November
SMTWTFS
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30
December
SMTWTFS
    1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 31
          

Friday November 06 04:31:31 2020
[11441] Dove comincia il sole (1997) aka Verwirrung des Herzens
The unknown is Francesca Rinaldi.
nulla72
Friday November 06 09:08:20 2020
Re: [11441] Dove comincia il sole (1997) aka Verwirrung des Herzens
On November 06 2020 nulla72 wrote:

> The unknown is Francesca Rinaldi.

The entry has been updated.
Gagster
Friday November 06 09:31:16 2020
[791] The Killer Likes Candy (1968) aka Un Killer persua maesta
Un Killer Per Sua Maestà.
nulla72
Friday November 06 11:03:46 2020
Melissa O'Neil does not appear in all searches
I don't know if this is the right place to question this:

This is an odd error: If you search by the actress name alone for Melissa O'Neil she only appears in the database for the show "Dark Matter". Yet, if you search the show "The Rookie" she appears under 'actress'.

Her name is correctly spelled under both searches yet you cannot get all her appearances by searching under her name alone in the correct search field.

Can this be fixed? Also brings up the question about how many other actresses this may be happening to.
Zack
Friday November 06 11:20:27 2020
Re: Melissa O'Neil does not appear in all searches
On November 06 2020 Zack wrote:

> I don't know if this is the right place to question this:
> This is an odd error: If you search by the actress name

I don't know why this happened here. As you say, it was spelled correctly in The Rookie entry, but wasn't showing up. On a hunch I moved the comma over so that there was a space after her name, but it didn't make any difference in the search results. I then replaced the name with a copy/paste from your comment, and it is now showing up in response to a query as it should. My best guess is that there was some unprintable character on the line which interfered with the search, but I have no idea what it might have been. Since I don't know what caused the issue for this entry, I have no way to determine how many other entries may have the same problem.
Gagster
Friday November 06 11:21:49 2020
Re: [791] The Killer Likes Candy (1968) aka Un Killer persua maesta
On November 06 2020 nulla72 wrote:

> Un Killer Per Sua Maestà.

The entry has been updated.
Gagster
Friday November 06 12:51:30 2020
[14476] Terry and the Pirates (1952)
Just watched this episode on YT. It doesn't seem to be the right one.
Henry Fool
Friday November 06 13:33:52 2020
Re: Melissa O'Neil does not appear in all searches
I'll take a look.
Brian R
Friday November 06 14:02:45 2020
Re: Melissa O'Neil does not appear in all searches
On November 06 2020 Brian R wrote:

> I'll take a look.

I didn't realize that you'd made it go away. I will try
to review the change log to see what that was.

Brian R
Friday November 06 14:29:28 2020
Re: Melissa O'Neil does not appear in all searches
On November 06 2020 Brian R wrote:

> On November 06 2020 Brian R wrote:
> > I'll take a look.
> I didn't realize that you'd made it go away. I will try
> to review the change log to see what that was.

Yeah, I painted myself into a corner. When I made it go away, I thought I had a text dump of the DB that I could work from, but my last dump was before that entry was created. My best guess is still some hex-crap in the entry, but I can't see what it was.
Gagster
Friday November 06 14:29:42 2020
Re: Melissa O'Neil does not appear in all searches
Kind of what I guessed from the description. The original
entry had a "curly" apostrophe, which doesn't match
the one from many keyboards.

Melissa O’Neil
Melissa O'Neil

Searching for that symbol in the Actress field only turns
up two others: 24455 (The 100) and 24778 (The Good Place).
I will leave those for the moment so you guys can look
at them.

Brian R
Friday November 06 14:32:27 2020
Re: Melissa O'Neil does not appear in all searches
On November 06 2020 Gagster wrote:

> Yeah, I painted myself into a corner.

That's what the change log is for.

< Actress: Melissa O’Neil , Annie Wersching
---
> Actress: Melissa O'Neil, Annie Wersching
Brian R
Friday November 06 14:49:22 2020
Re: Melissa O'Neil does not appear in all searches
On November 06 2020 Brian R wrote:

> On November 06 2020 Gagster wrote:
> > Yeah, I painted myself into a corner.
> That's what the change log is for.
> < Actress: Melissa O’Neil , Annie Wersching
> ---
> > Actress: Melissa O'Neil, Annie Wersching

All three of those entries were initially entered by me. I use Microsoft Word to type up entries, and then copy/paste to actually put them into the DB. I don't recall any option in Word to use an alternate apostrophe, and considering how many entries I've put in, there should be far more problem entries if it always used the alternate apostrophe.

That leaves me stumped for the moment, but I have a bunch of new entries that I need to type up, so I'll see if I can spot a problem with the punctuation as I'm writing them up.
Gagster
Friday November 06 15:09:19 2020
Re: Melissa O'Neil does not appear in all searches
On November 06 2020 Gagster wrote:

> On November 06 2020 Brian R wrote:
> > On November 06 2020 Gagster wrote:
> > > Yeah, I painted myself into a corner.
> > That's what the change log is for.
> > < Actress: Melissa O’Neil , Annie Wersching
>
Doing some more investigating, and it appears that MS word uses some strange codes for some of their punctuation. If you want to check some out:
https://stackoverflow.com/questions/2826191/converting-ms-word-curly-quotes-and-apostrophes

I don't think its worth the effort for you to do any coding to track the entries, easier to just correct any entries which get entered.
Gagster
Friday November 06 16:59:56 2020
Re: Melissa O'Neil does not appear in all searches
If I get a chance, and don't forget, I'll look at the code to see about a detect and replace.

Brian R

Post a Message

Home         Message Forums         E-Zine          Scene Database          FAQs          Friends Page          Contact