(no subject)

[theaeblackthorn.livejournal.com]

Ok.

This is just horrific. I can't quite believe I've done it.

This is exactly why people shouldn't make a sas correct this many points.

I've accidentally deleted all knuts from the system where a person didn't earn any points.

SO. as far as I can tell this would only effect Order things. Except somehow it affected 7050 sets of points.

I know.

Anyone feel like replying with activities they know could have given out knuts and no points?

ETA: Yes, I know it's me that cocked up, and you won't believe how much of a tit I am for deleting the backup accidentally yesterday and saying I'll make a copy after I do the points. So stupid.

Essentially I deleted any knuts where a person had only earnt knuts for an activity.

Hm.

ETA2: I'm even dimmer than that. I deleted all knuts off of the system. Tits.


ETA: I just lost the whole hih db. I'm going to bed. Sorry everyone. Sorry so much.

Comments

[yinepu.livejournal.com]

What does that mean for us mods? Resubmit everything?

[theaeblackthorn.livejournal.com]

No, I had a static version so I'm reentering this months. I'll bribe people with points to reenter the old ones for me.

It should only take me another hour.

[djmayhem-aubrey.livejournal.com]

When you say all of them, do you mean everything from just this month, or like.. all knuts ever?

Not that I really need to know or can help, but just out of curiosity.

[theaeblackthorn.livejournal.com]

All knuts ever. It's what a slip of a statement will do. We've got records of them, but they nolonger exist in the system.

I'll be needing volunteers to format the other months, I've almost done this one.

[djmayhem-aubrey.livejournal.com]

And if I had any idea of where to even begin, I'd volunteer to help, but I actually have to go in like two minutes. Sorry!

[alohachary1851.livejournal.com]

in an effort to avoid as much school work as possible, and granted that the system isn't as difficult as it sounds, I'll volunteer.

[theaeblackthorn.livejournal.com]

all I'll need is a list of username, knuts, act_id

I can autoformat them into sql statements and insert them back in. It's just a lot of copy & pasting and looking up activity numbers tbh.

I'll post the format and search thing to allow people to find act_ids when I've finished these points.

[dorasolo.livejournal.com]

If something is simple and menial, sign me up, I'm not so good with formatting or html, etc., but data entry, on the other hand, is entirely doable.

[omfgerbear.livejournal.com]

OMG! O_O O_O I hope it does get fixed up, and I'm sorry it all went... boom. Clerical work is my thing (woe), so sign me up for the volunteering thing! :D

People must get their knuts. Or there will be angry mobs with blazing pitchforks battering down the castle walls.