DemonGoddess

Prompts kerfuffle kinetic killjoy Rules Happy Writing! This topic will autolock at 11:59 pm EDT 8-17

July Age Verification/Underagers (Current) Confirmed as 18 or older – 219 Now 18, but underage when registered – 20 accounts, 17 actual users Currently underage, deleted once – 50 accounts, 48 actual users Inconclusive data found – 378 users Users posting for minors – 0 users Returning minors – 5 accounts, 5 actual users Total users age checked - 667 Year to Date - 3375 Old Underage Users (by registration year) 2002 – 0 accounts, 0 users deleted, 0 users modified; total of 0 actual users 2003 – 8 accounts, 6 users deleted, 1 users modified; total of 7 actual users 2004 – 15 accounts, 14 users deleted, 1 users modified; total of 15 actual users 2005 – 28 accounts, 14 users deleted, 3 users modified; total of 17 actual users 2006 – 62 accounts, 42 users deleted, 4 users modified; total of 46 actual users 2007 – 20 accounts, 10 users deleted, 8 users modified; total of 18 actual users 2008 – 16 accounts, 10 users deleted, 6 users modified; total of 16 actual users Grand total – 119 accounts, 96 users deleted, 23 users modified; total of 119 actual users Year to Date – 2102 accounts, 1515 users deleted, 269 users modified; total of 1782 actual users Plagiarism Stories deleted (co-author information not provided) – 1, YTD - 4 Stories deleted (permissions not provided) – 3, YTD – 8 Story adoption confirmed – 1, YTD 2 Co – authors verified – 0, YTD – 7 Permissions provided – 4, YTD 16 Unsubstantiated claims of plagiarism – 2, YTD – 6 Users deleted – 1, YTD - 8 Added to the monitor list (for arrival to the archive) – 2, YTD - 4 Posting for another/posting others' work – 0, YTD 5 Added to the Hall of Shame – 0, YTD 3 Trolls/Flamers/Spammers users and content deleted (trolls) – 5, YTD 21 unfounded (trolls) – 0, YTD 2 flaming (instances found) – 1, YTD 7 spam registrations – 0, YTD 22 Other ToS Violations 56 violations resolved Year to Date – 278 The bulk of the violations this month was insufficient/improper story tags. Orphan and Duplicate stories Total orphan stories found and deleted – 0, YTD 0 Stories to merge – 4, YTD 64 Total stories left after merge – 2, YTD 31 Total stories looked at – 4, YTD 64 Shared Accounts and allowed alternate accounts Allowed additional accout – 1, YTD - 1 Found and allowed shared/joint accounts - 0, YTD - 7 Invalid and/or disposable email accounts No issues found with email address – 0, YTD - 0 Users registered with false or disposable mail addresses (deleted when found) – 1, YTD - 14 Users - deleted for non correction bad email address – 50, YTD - 707 Users - corrected email address issue - 2, YTD - 17 Duplicate Users Processed Users with no duplicates found - 0,YTD - 1 Users merged - 65, YTD - 403 Users where duplicate had no data, and was deleted - 125, YTD - 693 Total extra accounts deleted after processing - 224, YTD - 1305 Total accounts looked at - 414, YTD - 2414 Actual user amount - 190, YTD – 1101

anytime! I usually read her stuff on LJ since she's not here

Manta is still testing her changes offsite, to be sure that they work before I deploy them. She expects we'll be able to complete the upgrade on Monday.

Okay, so you all know exactly what I'm doing now, which will explain why it's a tad time consuming, this task. First, I had to split the review table in to smaller chunks for import. It's too big to import in one fell swoop. Next, I have to split those smaller chunks in to a series of import queries, limiting the number of records per query to about 15 so that I don't get a time out while importing the records and then have nothing imported at all. Finally, I have to be sure each record is on its own line, and the end of the record line has the proper closing mark for the line statement. I've already got over 2500 imported back in, and am working on setting up more as we speak.

Thanks! added

Actually, we have people use that as a tag in their story summary.

Lissa, that link is to a deleted story.

I'd say a fair number of us have been insulted in that manner. Yes, it is an insult. If a reader goes out of his or her way to give you what you ask for, and because you dislike hearing truth you delete the review, that makes reviewers who used to be willing to give that kind of review reluctant to do so.

somewhat, but then again, I'm up waaaay too late, so maybe looking at it a bit more tomorrow after some sleep I'll remember.

There are a few where Xander is taking martial arts classes. Any more you can remember? Maybe it'll jog my overcrowded brain so I remember it, because it's awful damn familiar

will you show me some links please? That's the requirement for a pair specific category, that the requester show me 5 pre existing of the stories.

added

category already exists

Okay, I told everyone already that I made a mistake in a story merge (typo'd my query and didn't see the typo before executing). End result was that the bulk of the reviews ended up attached to one story. So, to fix this, first I had to download the latest (at the time) back up of the entire database. It was either that, or have Nexcess restore the database entirely, which would have downed the entire archive for 3 to 5 hours. It took 30 hours to download the raw db file, as it's enormous. Next was extracting the table data. But first, I had to find a plain text editor which could handle a file bigger than 2GB (the db file is 9GB in raw form, give or take a few hundred MB). Got that, installed it. Next step was to open the file itself. That took about 25 minutes. From there, I copied the table data in to a new .sql file. Keeping in mind I was at roughly 15% complete of fixing the review table data to begin with, I'm going to kill two birds with one stone. As I have to restore this, I may as well fix the scrambled stuff as I come across it as well. Yes, the reviews were scrambled years ago in the big crash as well. With work and other RL obligations, I expect it'll take me roughly 1 to 2 week to finish the restore of the affected reviews to their stories. Thanks again for your patience.

How you determine where your story belongs, is which series of arcs you're writing for. If you're writing for the manga based arcs, you post to manga. Anime based arcs to anime.

Are there already 5 pre-existing stories of this pair in the subdomain?

merged

processed

don't. many of 'em were here even though they weren't supposed to be, for a very long time. We've been cleaning up loads and loads of it...

done

done

merged

merged