IPB

Welcome Guest ( Log In | Register )

1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 
Closed TopicStart new topic
> Database (partly) repaired
Stealth
post Oct 22 2008, 06:25 PM
Post #1


Administrator
*****

Group: Root Administrators
Posts: 2,760
Joined: 26-December 05
From: Milwaukee, Wisconsin USA
Member No.: 1



Hi folks,

I've restored topic titles from a LunarPages database backup performed October 4th, 2008. This was the best available backup. As a result, you should see the [MISSING TITLE]s on older topics restored to their correct names.

In between October 4th and October 16th or so, however, you will see a page or two of posts still missing their titles. Feel free to correct them if board permissions allow you to.

Thanks for your patience and understanding during this issue.


--------------------
Stealth
IPB Image | IPB Image

I don't provide tech support by PM. Please use our Technical Support forum for that.
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
riffruff
post Oct 22 2008, 06:30 PM
Post #2


I riffruff
********

Group: Sr. Members
Posts: 3,727
Joined: 19-February 06
From: USA
Member No.: 278



So, does Pyro get banned for breaking the $75 it costs you to fix the forums?

This post has been edited by riffruff: Oct 22 2008, 06:30 PM


--------------------
What you should tell your girlfriend...
QUOTE
ALL men see in only 16 colors, like Windows default settings. Peach, for example, is a fruit, not a color. Pumpkin is also a fruit. We have no idea what mauve is.

QUOTE
Women, learn to work the toilet seat. You're a big girl. If it's up, put it down. We need it up, you need it down. You don't hear us complaining about you leaving it down.

http://riffruff.mybrute.com
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
Pyro
post Oct 22 2008, 06:30 PM
Post #3


huh?
********

Group: Root Administrators
Posts: 9,073
Joined: 23-February 07
From: Orlando, Florida
Member No.: 19,243



Thanks, but can someone with mass editing powers (or SQL) approve all of the topics that were repaired? I don't really want to go through a few hundred pages and select a few thousand topics to make them visible.

Should be something like:
CODE
UPDATE ibf_topics SET approved = 1 WHERE title != "[MISSING TITLE]"


--------------------
Pyro
Chieftain of Clan BoT.
Host of pyro.no-ip.biz
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
Stealth
post Oct 22 2008, 06:31 PM
Post #4


Administrator
*****

Group: Root Administrators
Posts: 2,760
Joined: 26-December 05
From: Milwaukee, Wisconsin USA
Member No.: 1



Ah, yes.. were they deactivated en-masse? What query was used -- can I just
CODE
UPDATE ibf_topics SET approved='1';
?


--------------------
Stealth
IPB Image | IPB Image

I don't provide tech support by PM. Please use our Technical Support forum for that.
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
Pyro
post Oct 22 2008, 06:33 PM
Post #5


huh?
********

Group: Root Administrators
Posts: 9,073
Joined: 23-February 07
From: Orlando, Florida
Member No.: 19,243



Yep.

If you set all of them to approved, then even the ones that are still broken will be visible. sad.gif


--------------------
Pyro
Chieftain of Clan BoT.
Host of pyro.no-ip.biz
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
Eric
post Oct 22 2008, 06:37 PM
Post #6


The Causeless Cause
*****

Group: Root Administrators
Posts: 2,952
Joined: 26-December 05
Member No.: 2



QUOTE(PyroManiac @ Oct 22 2008, 05:33 PM) *

Yep.

If you set all of them to approved, then even the ones that are still broken will be visible. sad.gif

Done.
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
riffruff
post Oct 22 2008, 06:38 PM
Post #7


I riffruff
********

Group: Sr. Members
Posts: 3,727
Joined: 19-February 06
From: USA
Member No.: 278



You need to rebuild post stats now -- the topics are reporting the wrong number of topics and posts...


--------------------
What you should tell your girlfriend...
QUOTE
ALL men see in only 16 colors, like Windows default settings. Peach, for example, is a fruit, not a color. Pumpkin is also a fruit. We have no idea what mauve is.

QUOTE
Women, learn to work the toilet seat. You're a big girl. If it's up, put it down. We need it up, you need it down. You don't hear us complaining about you leaving it down.

http://riffruff.mybrute.com
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
Pyro
post Oct 22 2008, 06:38 PM
Post #8


huh?
********

Group: Root Administrators
Posts: 9,073
Joined: 23-February 07
From: Orlando, Florida
Member No.: 19,243



They should update on their own after a while.

I'll do it manually. Should only take a few minutes.

Or not.


--------------------
Pyro
Chieftain of Clan BoT.
Host of pyro.no-ip.biz
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
Eric
post Oct 22 2008, 06:45 PM
Post #9


The Causeless Cause
*****

Group: Root Administrators
Posts: 2,952
Joined: 26-December 05
Member No.: 2



QUOTE(riffruff @ Oct 22 2008, 05:38 PM) *

You need to rebuild post stats now -- the topics are reporting the wrong number of topics and posts...

Done.
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
Ribose
post Oct 22 2008, 07:07 PM
Post #10


So, it's all about fame, huh?
*****

Group: Global Moderators
Posts: 2,950
Joined: 13-February 06
From: Connecticut, USA. (GMT -5:00)
Member No.: 74



-.-


--------------------
~Ribose
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
itsryan
post Oct 22 2008, 07:56 PM
Post #11


I paid for my place on this site
*****

Group: Sr. Members
Posts: 1,187
Joined: 3-February 06
From: Ontario, Canada
Member No.: 40



Aw its only partly repaired


--------------------
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
Alendar
post Oct 22 2008, 08:00 PM
Post #12


StealthBot.net Moderator
*****

Group: Global Moderators
Posts: 1,239
Joined: 16-March 06
From: New York
Member No.: 2,332



Thanks Stealth, good work!



--------------------
<3 ~Pyro <3 -PhiX <3
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
Pyro
post Oct 22 2008, 08:19 PM
Post #13


huh?
********

Group: Root Administrators
Posts: 9,073
Joined: 23-February 07
From: Orlando, Florida
Member No.: 19,243



QUOTE(itsryan @ Oct 22 2008, 09:56 PM) *

Aw its only partly repaired

It's only ~100 topics that weren't fixed, and most of those were very insignificant but nevertheless, will be restored over the next few days.


--------------------
Pyro
Chieftain of Clan BoT.
Host of pyro.no-ip.biz
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
roamer
post Oct 22 2008, 09:21 PM
Post #14


Rookie
*

Group: Beta Testers
Posts: 6
Joined: 30-May 06
Member No.: 5,040



Thanks Cheesey!
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
-------
post Oct 23 2008, 02:44 PM
Post #15


Full Member
***

Group: Sr. Members
Posts: 198
Joined: 16-September 06
Member No.: 8,394



<object width="425" height="344"><param name="movie" value="http://www.youtube.com/v/DEtP9zQAOI4&hl=en&fs=1"></param><param name="allowFullScreen" value="true"></param><embed src="http://www.youtube.com/v/DEtP9zQAOI4&hl=en&fs=1" type="application/x-shockwave-flash" allowfullscreen="true" width="425" height="344"></embed></object>
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
riffruff
post Oct 23 2008, 02:52 PM
Post #16


I riffruff
********

Group: Sr. Members
Posts: 3,727
Joined: 19-February 06
From: USA
Member No.: 278



idiat you went to Auburn soccer camp?


--------------------
What you should tell your girlfriend...
QUOTE
ALL men see in only 16 colors, like Windows default settings. Peach, for example, is a fruit, not a color. Pumpkin is also a fruit. We have no idea what mauve is.

QUOTE
Women, learn to work the toilet seat. You're a big girl. If it's up, put it down. We need it up, you need it down. You don't hear us complaining about you leaving it down.

http://riffruff.mybrute.com
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
Ribose
post Oct 23 2008, 03:06 PM
Post #17


So, it's all about fame, huh?
*****

Group: Global Moderators
Posts: 2,950
Joined: 13-February 06
From: Connecticut, USA. (GMT -5:00)
Member No.: 74



bwahahaha!


--------------------
~Ribose
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
Pyro
post Oct 23 2008, 03:10 PM
Post #18


huh?
********

Group: Root Administrators
Posts: 9,073
Joined: 23-February 07
From: Orlando, Florida
Member No.: 19,243



News != OT. Stop spamming.


--------------------
Pyro
Chieftain of Clan BoT.
Host of pyro.no-ip.biz
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
Distant
post Oct 23 2008, 07:11 PM
Post #19


The man.
*****

Group: Administrators
Posts: 1,047
Joined: 26-December 05
From: Rochester, New York
Member No.: 10



Closed.


--------------------
Search | Technical Support | For forum issues, please send me a private message.
Distant.no-ip.org JBLS status: IPB Image
User is offlineProfile CardPM
Go to the top of the page
+Quote Post

Closed TopicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 



- Lo-Fi Version Time is now: 17th June 2019 - 05:01 PM
Skin by Andrea
Website Legal Information | Hosted by LunarPages