Author Topic: Resurecting x10's forum?  (Read 12571 times)

woodyl

  • Jr. Member
  • **
  • Posts: 21
Re: Resurecting x10's forum?
« Reply #15 on: August 07, 2013, 11:51:41 AM »
Tuicemen:  Good work!  Looks like the old forum is working pretty well.

Tuicemen

  • Administrator
  • Hero Member
  • *****
  • Posts: 249
  • Software Developer
    • Tuicemens Software
Re: Resurecting x10's forum?
« Reply #16 on: August 07, 2013, 12:42:57 PM »
Thanks, at least we didn't loose the valuable info it contained.
Not to take any thing away from this forum, I've setup sections on my forum to continue on if users experience software issues not covered it the old forum.
X10 turned me into a Software programmer.
A warning label should have been added ;)

rsisinni

  • Active Newbie
  • *
  • Posts: 9
Re: Resurecting x10's forum?
« Reply #17 on: August 08, 2013, 08:15:03 AM »

I'm going to attempt to parse the html and make a live forum out of it.

   There will still be some problems, first of all people will need to claim their accounts, I do not have email addresses so there needs to be some kind of process defined on how to do this.  Hopefully an automated process.

As for hosting It, I was thinking that some kind of foundation or club can be formed to keep it going, that way it won't be in the hands of one person and if they lose interest, get hit by a car etc,  it won't disappear.

If I manage to achieve an import, the forum size should become a lot smaller, and more manageable.



Some other updates:
1)  I am doing another backup of the site this time with attachments, I managed have wget login before doing the backup, so this time the attachments should come down, it will probably take a couple of days to complete.
2) I have backed up the knowledge base
3) I have done a complete backup of the ftp site, (previously I had only retrieved the manuals).



Tuicemen

  • Administrator
  • Hero Member
  • *****
  • Posts: 249
  • Software Developer
    • Tuicemens Software
Re: Resurecting x10's forum?
« Reply #18 on: August 08, 2013, 09:56:30 AM »
If you manage a import you'll need to get the repair_settings.php file from SMF so that you can gain access to change the forums file locations.

Once that is done a update to the current version it may allow extra automatic options not found in 1.1.4.
In any case you'd need Admin access. I can help with that.
If your successful using the repair_settings.php file all users will have access with out any extra work.
X10 turned me into a Software programmer.
A warning label should have been added ;)

rsisinni

  • Active Newbie
  • *
  • Posts: 9
Re: Resurecting x10's forum?
« Reply #19 on: August 08, 2013, 06:27:15 PM »
Hi Tucemen, since I'm working the web pages that I grabbed and not the database, since I don't have access to it. What I am doing is parsing the pages, and extracting as much information as I can from it.  From the extracted information I will directly write into the database, reconstructing a version of the forums.   I have made some progress  I'm extracting and am pulling out plain text posts, but I want to try to keep some formatting.  I need to learn a little more about the database structure of the SMF forum, I don't know if they put HTML directly into the database for things like that.  Anyway I'm setting up a sandbox SMF forum so I can post into it and see what happens in the database.

Tuicemen

  • Administrator
  • Hero Member
  • *****
  • Posts: 249
  • Software Developer
    • Tuicemens Software
Re: Resurecting x10's forum?
« Reply #20 on: August 20, 2013, 04:55:20 PM »
Some good news.
I've been able to finally get on the X10forums and backup the file structure and do a complete database backup.
Though I've never tried to restore a forum from a SLQ back up I'm going to give it an attempt.
If anyone is experienced in this I'd love to hear from you. ;)
X10 turned me into a Software programmer.
A warning label should have been added ;)

Jeff

  • Administrator
  • Hero Member
  • *****
  • Posts: 209
    • Owner, JV Digital Engineering
Re: Resurecting x10's forum?
« Reply #21 on: August 20, 2013, 09:12:14 PM »
That is really good news.  While you have already preserved that storehouse of information, having a complete working Forum again is certainly better.

On another news front, I'm pursuing an alternate X10 controller that I discovered last week.  One is on order for evaluation, and I hope to post the results here in a week or two.

Heff
X10 automation since the BSR days...

hawk1

  • Jr. Member
  • **
  • Posts: 12
Re: Resurecting x10's forum?
« Reply #22 on: August 21, 2013, 04:19:05 AM »
Thank God for you guys!   :)    8)
"I don't know what I'm doing but, I'm having fun doing it!"
Windows Xp Home
Ihouse, BVC, PCC, Blue Iris
Cm15A Transceiver
V572 Receiver
XTB Amplifier
XTB-IIR Coupler, Amplifier, Repeater

Tuicemen

  • Administrator
  • Hero Member
  • *****
  • Posts: 249
  • Software Developer
    • Tuicemens Software
Re: Resurecting x10's forum?
« Reply #23 on: August 22, 2013, 07:13:59 AM »
I've submitted a support ticket to Godaddy about this.
It seems the x10forums SQL backup is to big for the MySQL download restrictions currently in place.
Hopefully they will increase the limit to allow me to upload or better yet do the whole rebuild thing for me!  8)
 ;)
X10 turned me into a Software programmer.
A warning label should have been added ;)

Tuicemen

  • Administrator
  • Hero Member
  • *****
  • Posts: 249
  • Software Developer
    • Tuicemens Software
Re: Resurecting x10's forum?
« Reply #24 on: August 23, 2013, 05:03:52 AM »
Well news from support wasn't what I'd hoped. :'(
They won't increase the upload limit for me .
Files need to be 2meg or smaller so the data base needs to be broken up into 2meg or smaller chunks for uploading.
Since I have no experience with SQL this is going to take some time to figure the whole think out. :(
However I haven't given up.
I'm still looking for anyone experienced with forum restoring and or SQL.
X10 turned me into a Software programmer.
A warning label should have been added ;)

rsisinni

  • Active Newbie
  • *
  • Posts: 9
Re: Resurecting x10's forum?
« Reply #25 on: August 24, 2013, 05:03:13 AM »
Do you have ssh access, if so you can compress the database before you download it.

Tuicemen

  • Administrator
  • Hero Member
  • *****
  • Posts: 249
  • Software Developer
    • Tuicemens Software
Re: Resurecting x10's forum?
« Reply #26 on: August 24, 2013, 05:49:31 AM »
File is 32 meg compressed and support isn't willing to hep with this matter. :'(
However I downloaded SQL Workbench and was able to upload the complete backup to a newly created data base.
However I'm learning this is only a part of the puzzle and this will be a long proccess.
If I could get  the files as well as the data base it would be so much simpler. ;)
All attachments will be lost which in some cases were what made the post. :'(
It may be possible to retrieve some of these manually however that too would be a big job.
X10 turned me into a Software programmer.
A warning label should have been added ;)

Tuicemen

  • Administrator
  • Hero Member
  • *****
  • Posts: 249
  • Software Developer
    • Tuicemens Software
Re: Resurecting x10's forum?
« Reply #27 on: August 29, 2013, 04:52:21 AM »
There is a bit of good news on this front.
Although I'm still fighting this one there are others that have taken up the fight.
Some have reported a bit of progress but it is still a long go.
User with experience in SQL will most likely have better luck.
As would someone that has restored a forum in the past.
But even with that experience it was a very large forum and will take some time. ;)

I've been able to pull the backup into a created forum however I'm still missing a few steps. ??? :-[
The new forum sees the boards the number of posts and numbers of threads however not the members nor the actual posts  ???
X10 turned me into a Software programmer.
A warning label should have been added ;)

bkenobi

  • Hero Member
  • *****
  • Posts: 103
Re: Resurecting x10's forum?
« Reply #28 on: December 16, 2013, 10:49:14 AM »
The old X10 forums are back up today!  I have not tried posting, but I was able to load the main page and at least one thread.

Tuicemen

  • Administrator
  • Hero Member
  • *****
  • Posts: 249
  • Software Developer
    • Tuicemens Software
Re: Resurecting x10's forum?
« Reply #29 on: December 16, 2013, 11:38:57 AM »
Yes, sorry  I didn't get that posted here in this thread. I've been busy restructuring the old forum.
It is up and running, there is a thread on my forum which sheds some more light on things
http://tuicemen.com/forum/index.php?topic=688.0
X10 turned me into a Software programmer.
A warning label should have been added ;)