maddy (themadone) wrote,

poo :(

It's been a while since I looked at the lovemap, but I just had a look at it and I noticed that there is a slighty teeny bit of confusion with the data. Namely that some people have entered in X "facts" and they have Y links, where X and Y are not the same number. I have no idea how this could have happened or entirely what has happened. Has it randomly decided to delete the "facts" people have entered or has it not been correctly updating the links?

Since I can't decrypt the information without having everyones' passwords to fix it, I've come up with what I think is a pretty cunning plan. If/when someone logs in again, it'll put in entries to delete every possible link to everyone else and then put in partial links to everyone they should have. This should mean that when someone (else) logs in, it'll delete their current links and then re-add, where applicable, any actual links that should exist.

I've yet to think of any drawbacks yet. Apart from it requiring people to log in a lot. But then that's a drawback with the thing in the first place - it'd work a whole lot better if it was tied in to something that everyone used a lot.

EDIT: Oops. Looks like it's be so long that I'd completely failed to remember how the whole thing hung together. Or rather I appear to have made a change to the database schema and this meant I was missing out a whole bunch of data. In the end it appears it's out by 2 links...I think I'll leave in the code to re-validate everything cos it can't possibly hurt just to make sure :)

  • Post a new comment


    default userpic

    Your reply will be screened

    Your IP address will be recorded 

    When you submit the form an invisible reCAPTCHA check will be performed.
    You must follow the Privacy Policy and Google Terms of use.