New Mars Forums

Official discussion forum of The Mars Society and MarsNews.com

You are not logged in.

Announcement

Announcement: We've recently made changes to our user database and have removed inactive and spam users. If you can not login, please re-register.

#51 2015-05-10 20:39:32

SpaceNut
Administrator
From: New Hampshire
Registered: 2004-07-22
Posts: 10,527

Re: The great crash

Have contiunued to fix topics that I have found the old artifacts in and the latest is solar sail - solar sail
The only ones that I could not edit were the posts by Josh Cryer as Administrator with the moderator powers that I have. They currently are not showing any shifting of the panels but there is the extra thick line before the reply post box that shows.

Online

#52 2015-05-10 20:51:05

SpaceNut
Administrator
From: New Hampshire
Registered: 2004-07-22
Posts: 10,527

Re: The great crash

I have fixed the signature line that was in the profile and this is gone now....

SpaceNut wrote:

Here is another oddity that I found in the sig line post 39 in topic http://www.newmars.com/forums/viewtopic.php?id=1128&p=2

Give someone a sufficient [b:sig_uid][i:sig_uid]why[/i:sig_uid][/b:sig_uid] and they can endure just about any [b:sig_uid][i:sig_uid]how[/i:sig_uid][/b:sig_uid]


Also I fixed all the previously meantion code on page 1 and 2 and the topic is now allowing posts to it. See my post #38 for what was an issue....

Online

#53 2015-05-11 19:11:17

SpaceNut
Administrator
From: New Hampshire
Registered: 2004-07-22
Posts: 10,527

Re: The great crash

I have been trying to pin down what is damaged and needs repair on the forum as well as getting a handle on when it went through its various conversions in php formats...

Here is a strange one in that there is no post in the topic...

57Universe Today!
by UNIVERSE TODAY  2006-05-02 00:29:18

http://www.newmars.com/forums/viewtopic.php?id=5536

http://www.newmars.com/forums/viewtopic.php?id=4665

http://www.newmars.com/forums/viewtopic.php?id=4644

Last edited by SpaceNut (2015-05-11 21:16:31)

Online

#54 2015-05-11 21:00:28

SpaceNut
Administrator
From: New Hampshire
Registered: 2004-07-22
Posts: 10,527

Re: The great crash

Have been searching back into the other 0 post topics to see when the shifting pane event starts and have been able to confirm that its when the *quote* is not terminated correctly by */quote* but rather */quote:post_uid#*
where the * = [ or ] and the # = 0 through 14 for numbers which was member category rankings of priveledge with the :post_uid no longer applies....

http://www.newmars.com/forums/viewtopic.php?id=43


http://www.newmars.com/forums/viewtopic.php?id=3358

Its looking like up until 2005-07-19 21:05:20 the forum was using these but after 2005-07-21 it does not appear.....

Last edited by SpaceNut (2015-05-11 21:29:31)

Online

#55 2015-05-24 22:00:46

SpaceNut
Administrator
From: New Hampshire
Registered: 2004-07-22
Posts: 10,527

Re: The great crash

Two more topics fixed for the shifting pane of view....
Japan Eyes Future Manned Moon Base, Space Shuttle
Early retirement for orbiter?

Online

#56 2015-06-08 20:29:14

SpaceNut
Administrator
From: New Hampshire
Registered: 2004-07-22
Posts: 10,527

Re: The great crash

another fixed topic » Fossils on Mars - discuss fossil images and musings here

Online

#57 2015-07-12 16:18:32

SpaceNut
Administrator
From: New Hampshire
Registered: 2004-07-22
Posts: 10,527

Re: The great crash

another shifter topic for Josh to fix his post in http://www.newmars.com/forums/viewtopic.php?id=920

Online

#58 2017-07-05 23:51:42

jburk
Webmaster
From: Seattle, WA
Registered: 2011-11-17
Posts: 131
Website

Re: The great crash

Good News!  I have recovered the old database from the crashed server!  I found another set of files that I was able to restore into an old version of MySQL:

1. I set up an Azure VM running Ubuntu, compiled the old MySql version (5.0.51a) from source, copied in the files and voila!  All the old tables were available from the mysql command line.
2. I upgraded that instance of MySQL to 5.6 (the latest one), and installed Phpmyadmin.
3. I exported all the data using Phpmyadmin.
4. Right now I am importing the data into the web host we use for the Mars Society, and am setting up the old version of phpBB that the forums used when they crashed.

With luck, I should be able to convert this new instance of the crashed board to FluxBB, so that I can prepare & import the years we don't have on here.

I also have the old Wiki which I will also work on after this.

Wish me luck!


James Burk | Webmaster & IT Director | The Mars Society
jburk@marssociety.org  |  +1 (206) 601-7143

Offline

#59 2017-07-06 00:16:57

Rxke
Member
From: Belgium
Registered: 2003-11-03
Posts: 3,657

Re: The great crash

Wow, that is totally, incredibly unexpected news!

Are you a wizard?  wink


ExoMars' launcher's 2nd stage is probably en route to Mars. Unsterilised... yikes

Offline

#60 2017-07-06 00:45:20

jburk
Webmaster
From: Seattle, WA
Registered: 2011-11-17
Posts: 131
Website

Re: The great crash

I have everything loaded into phpBB and I'm running the conversion to FluxBB now.   Here's some stats:

Last post on the crashed server:
Mon Jan 03, 2011 10:49 pm

Last post on here that was restored from our earlier backup.
Wednesday, May 28, 2008 10:45:58 PM

First new post on here after we restored the forums:
Saturday, November 19, 2011 10:44:14 PM


So, we'll be getting over 2.5 years of restored posts (everything between May 28, 2008 and Jan 3, 2011)

Will probably take me a few days to get this completed since I have to painstakingly merge in the users & posts tables to our current install without breaking anything.  I will do this on a test instance and make sure it works before I do it for real.  Stay tuned...


James Burk | Webmaster & IT Director | The Mars Society
jburk@marssociety.org  |  +1 (206) 601-7143

Offline

#61 2017-07-06 01:14:53

Rxke
Member
From: Belgium
Registered: 2003-11-03
Posts: 3,657

Re: The great crash

my head hurts just thinking about this. merging probably old phpBB to flux, old and new users, topics spanning years.....You're a brave man!


ExoMars' launcher's 2nd stage is probably en route to Mars. Unsterilised... yikes

Offline

#62 2017-07-06 08:09:18

SpaceNut
Administrator
From: New Hampshire
Registered: 2004-07-22
Posts: 10,527

Re: The great crash

That is good news and hopefully will work. when we did the sub forum stuff i am crossing fingers that it does not come into play and cause havick.

Edit:
I talked about the sub forum numbers in post 43

Online

#63 2017-07-06 09:30:31

jburk
Webmaster
From: Seattle, WA
Registered: 2011-11-17
Posts: 131
Website

Re: The great crash

I will test everything thoroughly before I do the merge.


James Burk | Webmaster & IT Director | The Mars Society
jburk@marssociety.org  |  +1 (206) 601-7143

Offline

#64 2017-07-06 13:23:58

louis
Member
From: UK
Registered: 2008-03-24
Posts: 2,599

Re: The great crash

Well done James! smile

jburk wrote:

I will test everything thoroughly before I do the merge.


Let's Go to Mars...Google on: Fast Track to Mars blogspot.com

Offline

#65 2017-07-06 15:46:43

SpaceNut
Administrator
From: New Hampshire
Registered: 2004-07-22
Posts: 10,527

Re: The great crash

Ya and you thought my post count was high not as its going to gain about 4k or 5k more and there is going to be lots of links to stuff that I hope have not gone dead.....

Online

#66 2017-07-08 01:06:23

jburk
Webmaster
From: Seattle, WA
Registered: 2011-11-17
Posts: 131
Website

Re: The great crash

Hi guys,

This is a hard technical problem but I am hopeful it will be solved.  I have a working instance of phpBB with all the posts & users.  I am having issues converting that to FluxBB (which is prereq so I can easily prep a block of SQL that can be imported into this FluxBB instance).  I will keep at it but it's going to take longer than I thought.

If you want to help with this, please email me and I can show you what I have so far.  (Or if you just want to see some of the posts, I can give you the URL but I don't want to post it here since it is only temporary.)


James Burk | Webmaster & IT Director | The Mars Society
jburk@marssociety.org  |  +1 (206) 601-7143

Offline

#67 2017-07-08 01:36:41

Rxke
Member
From: Belgium
Registered: 2003-11-03
Posts: 3,657

Re: The great crash

I'm of no use here, I have an inkling of what is involved, but all my former experiments with phpBB tinkering led to pure chaos...


ExoMars' launcher's 2nd stage is probably en route to Mars. Unsterilised... yikes

Offline

#68 2017-07-08 08:27:40

SpaceNut
Administrator
From: New Hampshire
Registered: 2004-07-22
Posts: 10,527

Re: The great crash

The version of the phpbb may be the issue. The other thought is the version of the sql may also be at the root cause.
Good luck

Online

#69 2017-07-08 16:10:54

RobertDyck
Member
From: Winnipeg, Canada
Registered: 2002-08-20
Posts: 4,993
Website

Re: The great crash

Before the crash we used phpBB version 3, but it was modified. There were modifications to add subscripts and superscripts so we could post chemical and atomic formulae. I was told there were some other modifications before that. The modifications may be interfering.

In late 2005 I asked what New Mars uses, so I could set up the same system for a politician. She wanted a forum on her website so she could interact with voters. I installed phpBB version 3 with no modifications. After all, it only had to work for the election campaign period.

If you want, I could look at it. I'll send an email.

Last edited by RobertDyck (2017-07-08 16:12:52)

Offline

#70 2017-07-08 20:51:23

SpaceNut
Administrator
From: New Hampshire
Registered: 2004-07-22
Posts: 10,527

Re: The great crash

looking at the log file I see that the version of sql was 5.0.5
there was input coming into it from drupal as well as the phpbb

Newmars_wiki tags and Fmars2009 pages as well

Online

#71 2017-07-11 00:41:47

jburk
Webmaster
From: Seattle, WA
Registered: 2011-11-17
Posts: 131
Website

Re: The great crash

@RobertDyck I think you may be right about the addins for formulae, as the errors I was seeing were string-processing related.  I sent you all the details so let me know if you can figure things out.  If not, I will have time next weekend.

@SpaceNut yes I did a make/make install for the exact MySQL version (5.0.51a) that was being used and it worked flawlessly and I was able to put all the files I received from the crashed server's actual HD into the appropriate directory and all of them were accessible.  I have everything (EVERYTHING) from that server now including the NewMars wiki, actual website files for FMARS/MDRS/Chapters/etc, and all Mars Society data, etc etc etc. 

The server crash back in 2011 was a setback for sure, but NewMars and the Mars Society and its projects are stronger than ever. 

...At least i think so and I will continue to push push push as much as I can as long as I am alive.  Mars or Bust!


James Burk | Webmaster & IT Director | The Mars Society
jburk@marssociety.org  |  +1 (206) 601-7143

Offline

#72 2017-07-11 19:02:05

SpaceNut
Administrator
From: New Hampshire
Registered: 2004-07-22
Posts: 10,527

Re: The great crash

This does sound wonderful and thank you for the effort....

Online

#73 2017-07-15 19:56:11

SpaceNut
Administrator
From: New Hampshire
Registered: 2004-07-22
Posts: 10,527

Re: The great crash

I found another little bug in the coversions from the Ikon board to the Php and that it how we identify the topic string as a view. links in quotes for the
ikon board was * viewtopic.php?T=3212 *
php is             * viewtopic.php?id=3212 *
I am not sure for when we blend the topics back in or not...
I topics that are identified with the T are still there if you change it to ID in the string....

topic post was here http://newmars.com/forums/viewtopic.php … 042#p67042
the links says different discussion....

Online

#74 2017-09-03 11:42:24

jburk
Webmaster
From: Seattle, WA
Registered: 2011-11-17
Posts: 131
Website

Re: The great crash

As part of modernizing & building out Marspedia.org:

I have restored the New Mars Wiki! - wiki.newmars.com

Right now, creating new user accounts are turned off to prevent spam, but let me know if you want me to set one up for you.

Enjoy!


James Burk | Webmaster & IT Director | The Mars Society
jburk@marssociety.org  |  +1 (206) 601-7143

Offline

#75 2017-09-03 15:40:57

SpaceNut
Administrator
From: New Hampshire
Registered: 2004-07-22
Posts: 10,527

Re: The great crash

Great progress back on the path to mars.. Thank You for your efforts....

Online

Board footer

Powered by FluxBB