Author Topic: Happy Belated Birthday Tris!  (Read 3902 times)

Offline dmpdesign

  • Moonlight Retiree
  • Administrator
  • Dark Slayer Destroyer
  • *****
  • Posts: 1864
    • http://swordofmoonlight.com
Happy Belated Birthday Tris!
« on: March 03, 2010, 07:34:40 pm »
one month late...but I figured it would be ok since today marks the repair of the trismegistus forum itself.

Tom, there is one topic (the one called cheater!!) that I havent figured out the mystery of why its not showing up yet...but i can work on that more later.

For now, happy birthday tris....one month over due=)

- Todd DuFore (DMPDesign)
Site Founder

Offline dmpdesign

  • Moonlight Retiree
  • Administrator
  • Dark Slayer Destroyer
  • *****
  • Posts: 1864
    • http://swordofmoonlight.com
Re: Happy Belated Birthday Tris!
« Reply #1 on: March 03, 2010, 10:21:46 pm »
Got the last page of posts back in, this is as good as its going to get (we only lost some data under the "cheaters!!!" topic).
- Todd DuFore (DMPDesign)
Site Founder

Offline Hguols

  • Moderator
  • Guardian in Groundal
  • *****
  • Posts: 624
    • Orationem
Re: Happy Belated Birthday Tris!
« Reply #2 on: March 03, 2010, 11:45:39 pm »
That cake rawks HARD!!!!!!!!!

IT RAWKS OF HAWTNESS!

 :yumm:


Probable mucosal damage may contraindicate the use of gastric lavage.

Offline Holy_Diver

  • Holy Diver
  • Archmage of Light
  • *****
  • Posts: 2280
  • This account won't read/reply to Private Messages
Re: Happy Belated Birthday Tris!
« Reply #3 on: March 04, 2010, 04:51:11 am »
So what all did recovering the posts entail in the end?

Offline dmpdesign

  • Moonlight Retiree
  • Administrator
  • Dark Slayer Destroyer
  • *****
  • Posts: 1864
    • http://swordofmoonlight.com
Re: Happy Belated Birthday Tris!
« Reply #4 on: March 04, 2010, 08:06:40 am »
Well, luckily I had your mirror site to compare topics/messages with else I would have been screwed.

There is probably an easier way out there to fix the problem, I am however not smart enough to know what it is.

I found an old decemberish backup I think you made of the forums lying around the server...so I pulled the sql dump and opened it in wordpad hehe.

I then made a new dump of the smf_messages and smf_topics table from the current backup from yesterday.

Then I had to do two things....I had to filter through all the smf_topics table and add in everything that was missing in the new table vs the old one...thankfully in all but one topic, nothing had been overwritten (for some reason the database has written data into the same topic number as the one that contained "cheater!!!" and i couldnt get all the posts to show up).

Then I had to go through the whole smf_topics dump and copy/paste all the messages back in by using a 'find' function for the topic headers.  Not rocket science, but very time consuming...especially since for whatever reason wordpad was not playing nice in the highlighting dept.

But anyways its here, and I will never prune the forums again!
- Todd DuFore (DMPDesign)
Site Founder

Offline Holy_Diver

  • Holy Diver
  • Archmage of Light
  • *****
  • Posts: 2280
  • This account won't read/reply to Private Messages
Re: Happy Belated Birthday Tris!
« Reply #5 on: March 04, 2010, 12:23:03 pm »
So when you were done transplanting everything you imported your sql file back in??

Did you not ask for advise in the SMF support forum? I hope your profession played some part in your confidence in what you were doing...

Offline dmpdesign

  • Moonlight Retiree
  • Administrator
  • Dark Slayer Destroyer
  • *****
  • Posts: 1864
    • http://swordofmoonlight.com
Re: Happy Belated Birthday Tris!
« Reply #6 on: March 04, 2010, 12:29:31 pm »
Nope didnt bother with the SMF forum.

Once I saw the link to your forum on which topics needed to be added back in it was just a matter of finding them and copying it back and making sure there were no ID conflicts.
- Todd DuFore (DMPDesign)
Site Founder

Offline Holy_Diver

  • Holy Diver
  • Archmage of Light
  • *****
  • Posts: 2280
  • This account won't read/reply to Private Messages
Re: Happy Belated Birthday Tris!
« Reply #7 on: January 12, 2011, 02:26:13 am »
So does Trism have an official "birthday" or can I use February 3, 2009? (working backwards from the opening post)  :redface:

EDITED: Btw, does Trismegistus have more than one release? Ie. versions, eg. 1.1 for example?
« Last Edit: January 12, 2011, 02:33:35 am by Holy Diver »