Author Topic: Just one quick bitch ...  (Read 281090 times)

0 Members and 3 Guests are viewing this topic.

Offline odeon

  • Witchlet of the Aspie Elite
  • Webmaster
  • Postwhore Beyond Repair
  • *****
  • Posts: 108911
  • Karma: 4482
  • Gender: Male
  • Replacement Despot
Re: Just one quick bitch ...
« Reply #18990 on: July 13, 2011, 04:32:32 PM »
Some bug bit me and now I'm itching like mad.
"Only two things are infinite, the universe and human stupidity, and I'm not sure about the former."

- Albert Einstein

Offline skyblue1

  • Overlooked of the Aspie Elite
  • Elder
  • Obsessive Postwhore
  • *****
  • Posts: 8945
  • Karma: 737
  • Gender: Male
Re: Just one quick bitch ...
« Reply #18991 on: July 13, 2011, 05:11:07 PM »
Some bug bit me and now I'm itching like mad.
do you have benadryl?

Offline odeon

  • Witchlet of the Aspie Elite
  • Webmaster
  • Postwhore Beyond Repair
  • *****
  • Posts: 108911
  • Karma: 4482
  • Gender: Male
  • Replacement Despot
Re: Just one quick bitch ...
« Reply #18992 on: July 13, 2011, 05:22:25 PM »
Some bug bit me and now I'm itching like mad.
do you have benadryl?

Found something equivalent. Now waiting for it to kick in. :arrr:
"Only two things are infinite, the universe and human stupidity, and I'm not sure about the former."

- Albert Einstein

Offline WolFish

  • Elder
  • Dedicated Postwhore
  • *****
  • Posts: 3245
  • Karma: 440
  • Gender: Male
Re: Just one quick bitch ...
« Reply #18993 on: July 14, 2011, 12:23:34 AM »
All fucking day to convert my forum to SMF and two seconds to figure out how to do an sql query to fix the problem that it took all day to solve.
Even the developer didn't know what was causing it.
It was because I had deleted a member who left, but had posted, and then I made things worse by changing the user_id numbers so they were consecutive.
Damnit.
Mark Twain: “Never argue with a [troll], onlookers may not be able to tell the difference.”

#Dancewithgarygopher

Offline odeon

  • Witchlet of the Aspie Elite
  • Webmaster
  • Postwhore Beyond Repair
  • *****
  • Posts: 108911
  • Karma: 4482
  • Gender: Male
  • Replacement Despot
Re: Just one quick bitch ...
« Reply #18994 on: July 14, 2011, 03:18:40 AM »
Changing the user IDs gives you a world of trouble. Usually if I delete a member I simply force updates on the relevant logs. SMF is reasonably good at taking care of most aspects of the deletion but things like PM notifications often lag behind.

"Only two things are infinite, the universe and human stupidity, and I'm not sure about the former."

- Albert Einstein

Offline WolFish

  • Elder
  • Dedicated Postwhore
  • *****
  • Posts: 3245
  • Karma: 440
  • Gender: Male
Re: Just one quick bitch ...
« Reply #18995 on: July 14, 2011, 09:08:41 AM »
Changing the user IDs gives you a world of trouble. Usually if I delete a member I simply force updates on the relevant logs. SMF is reasonably good at taking care of most aspects of the deletion but things like PM notifications often lag behind.



Yeah, really glad we switched. Pyraxis and I use a forum for communication when we can't IM (like when I was in the hospital). We have accounts the we use kind of like a filing system.
We had phpBB2 because I was too lazy to change it. One day we got 50 spambots registered so I finally bit the bullet and did it.

Aspergers me went through the database deleting the bots and then the numbers were no longer consecutive. Couldn't tolerate that so I "fixed" it without fixing the corresponding posts, which made them orphans. To make matters worse, in a fit of angst I deleted an account that was being useless, except it had been used. The conversion hung up in three places.
For the first two I found a fix for online - just a few changes to the conversion script, and for the deleted account I just switched IDs with an actual unused account.

The conversion script fix changed the orphan post userIDs to "Guest" thereby screwing up the filing system and creating a fourth problem. I had started doing it post by post via the interface, but it took me an hour to fix one account. Since I know nothing about sql and am fearless about breaking my own things, I guessed at the sql code to change the post userIDs back to their proper "owners."

If I had applied the fix to the sql in the first place I would not have had to go through all that. At least I think so, but since everything is working, no way am I going to test it.

The good news is that since it is a private forum and I didn't delete the old one, the only person who had to suffer was me.
Mark Twain: “Never argue with a [troll], onlookers may not be able to tell the difference.”

#Dancewithgarygopher

Offline odeon

  • Witchlet of the Aspie Elite
  • Webmaster
  • Postwhore Beyond Repair
  • *****
  • Posts: 108911
  • Karma: 4482
  • Gender: Male
  • Replacement Despot
Re: Just one quick bitch ...
« Reply #18996 on: July 14, 2011, 09:17:17 AM »
That's a very novel way to do things. :plus: for the effort.
"Only two things are infinite, the universe and human stupidity, and I'm not sure about the former."

- Albert Einstein

Offline Parts

  • The Mad
  • Caretaker Admin
  • Almighty Postwhore
  • *****
  • Posts: 37477
  • Karma: 3062
  • Gender: Female
  • Who are you?
Re: Just one quick bitch ...
« Reply #18997 on: July 14, 2011, 01:46:27 PM »
Max just farted :zombiefuck:
"Eat it up.  Wear it out.  Make it do or do without." 

'People who say it cannot be done should not interrupt those who are doing it.'
George Bernard Shaw

Offline lutra

  • Elder
  • Obsessive Postwhore
  • *****
  • Posts: 5350
  • Karma: 481
  • Gender: Male
  • nosce te ipsum
Re: Just one quick bitch ...
« Reply #18998 on: July 14, 2011, 04:08:30 PM »
Fuck. My favourite pen just run out of ink.
Solum certum nihil esse certi et homine nihil miserius aut superbius.

Offline odeon

  • Witchlet of the Aspie Elite
  • Webmaster
  • Postwhore Beyond Repair
  • *****
  • Posts: 108911
  • Karma: 4482
  • Gender: Male
  • Replacement Despot
Re: Just one quick bitch ...
« Reply #18999 on: July 14, 2011, 04:11:51 PM »
I have a headache that is killing me.
"Only two things are infinite, the universe and human stupidity, and I'm not sure about the former."

- Albert Einstein

Offline Queen Victoria

  • Ruler of Aspie Universe
  • Elder
  • Almighty Postwhore
  • *****
  • Posts: 28244
  • Karma: 2805
  • Gender: Female
Re: Just one quick bitch ...
« Reply #19000 on: July 14, 2011, 05:41:11 PM »
Freaking, annoying fly.
A good monarch is a treasure. A good politician is an oxymoron.

My brain is both uninhibited and uninhabited.

:qv:

Offline Charlotte Quin

  • Abbess from the Abyss
  • Elder
  • Obsessive Postwhore
  • *****
  • Posts: 5198
  • Karma: 422
  • Gender: Female
Re: Just one quick bitch ...
« Reply #19001 on: July 15, 2011, 02:15:11 AM »
Will this stupid annoying persistant dry cough go away?? I've had it for weeks now. Suppressants are only half working and it's disturbing people at work too :thumbdn:


Also, I wish I knew what size sofa could fit in my new place. I was thinking of getting a chaise sofa from Fantastic Furniture, but then I went there and sat on all of them. The seat "cushions" feel like they're stuffed with cardboard. Now I'm leaning towards getting something more expensive from Hardly Normal or Oz Design, just for the sake of getting something my ass can tolerate. Their chaise sofas run a bit big in dimensions is all.

Offline odeon

  • Witchlet of the Aspie Elite
  • Webmaster
  • Postwhore Beyond Repair
  • *****
  • Posts: 108911
  • Karma: 4482
  • Gender: Male
  • Replacement Despot
Re: Just one quick bitch ...
« Reply #19002 on: July 15, 2011, 03:06:28 AM »
There's a fly bothering me.
"Only two things are infinite, the universe and human stupidity, and I'm not sure about the former."

- Albert Einstein

Offline 'andersom'

  • Pure Chocolate Bovine PIMP of the Aspie Elite
  • Elder
  • Almighty Postwhore
  • *****
  • Posts: 39199
  • Karma: 2556
  • Gender: Female
  • well known as hyke.
Re: Just one quick bitch ...
« Reply #19003 on: July 15, 2011, 03:39:13 AM »
There's so much to do, and I am doing so little.
I can do upside down chocolate moo things!

Offline ShyOne

  • Elder
  • Intense Poster
  • *****
  • Posts: 844
  • Karma: 195
  • Gender: Female
Re: Just one quick bitch ...
« Reply #19004 on: July 15, 2011, 04:12:08 AM »
I wish I came to intensity earlier, there's so much history to this place and stuff I wanna know about.