Advertisement:

Author Topic: Convert 1.1.8 SMF Forum to 2.0.15 (Newest Version)  (Read 3806 times)

Offline themekings

  • Semi-Newbie
  • *
  • Posts: 71
Convert 1.1.8 SMF Forum to 2.0.15 (Newest Version)
« on: November 21, 2018, 02:47:30 PM »
OK, here we go.....

Need some help from the experts here. I'm to the point I could poke my own eyes out. :)

I have an old SMF forum ( 1.1.8 ) that was hosted by Godaddy that I deleted about 4 years ago. I did backup and download the database before doing so that is now saved as a .sql file

I'm now trying to rebuild the forum using the saved database, but with no luck. I've download the complete 1.1.8 version of SMF as a fresh install with a new database with Godaddy as the host, but when it goes to build the tables it crashes the site. (i.e. forum)

I believe (suspect) that maybe the 1.1.8 forum is not compatible with PHP 5.0 or 5.5 and that is the issue.

I've also uploaded the last copy (root folder) of this old forum that I saved and tried to just create a new database, restored the old database in phpmyadmin, and changed the connection strings, but that has failed too.

My Question: Is it possible that I can restore my old forum ( 1.1.8 ) at all since I have all the old files (i.e. database and old root files)?

Here is what the site looked before I deleted it: https://web.archive.org/web/20131116052302/http://policelounge.com/lounge/

Reason I'm doing this is that I had a few friends who contributed to this site pass away, and it would be nice to read old post they made.

Thanks in advance for any assistance.  ;)

Offline themekings

  • Semi-Newbie
  • *
  • Posts: 71
Re: Convert 1.1.8 SMF Forum to 2.0.15 (Newest Version)
« Reply #1 on: November 21, 2018, 02:51:47 PM »
By the way, I dont mind paying someone to help. It be worth that much. I'll shoot someone $20.00 via paypal if they can provide the info that allows me to successfully restore this. I'll do the work myself, I'm pretty good with doing this stuff, just hung up on this one.

Online vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,060
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Convert 1.1.8 SMF Forum to 2.0.15 (Newest Version)
« Reply #2 on: November 21, 2018, 02:57:40 PM »
What I suggest is grab the install SMF 2.0.13 then grab large database package upgrade for SMF 2.0.13 since that works best with PHP 5.5 and less.
And upload that to your site.
Then replace database with your back file.
Then run the upgrade.php to change it to SMF 2.0.x format
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline themekings

  • Semi-Newbie
  • *
  • Posts: 71
Re: Convert 1.1.8 SMF Forum to 2.0.15 (Newest Version)
« Reply #3 on: November 21, 2018, 03:08:21 PM »
When you say:

Quote
Then replace database with your back file.

Do you mean go into myphpadmin and delete the related database, then import the .sql file that I have?

Online vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,060
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Convert 1.1.8 SMF Forum to 2.0.15 (Newest Version)
« Reply #4 on: November 21, 2018, 03:08:50 PM »
Yes.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline themekings

  • Semi-Newbie
  • *
  • Posts: 71
Re: Convert 1.1.8 SMF Forum to 2.0.15 (Newest Version)
« Reply #5 on: November 21, 2018, 03:11:59 PM »
OK, give me about 10 minutes and I'll follow up shortly ;) Thx buddy! If this works, I'll get your paypal email and send you some money for the help ;) Means a lot!

Offline themekings

  • Semi-Newbie
  • *
  • Posts: 71
Re: Convert 1.1.8 SMF Forum to 2.0.15 (Newest Version)
« Reply #6 on: November 21, 2018, 03:18:34 PM »
OK, have it up:

http://policelounge.com/lounge/index.php

I'm going into myphpadmin and take a Screenshot of the DB I think you want me to delete... 1 moment

Online vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,060
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Convert 1.1.8 SMF Forum to 2.0.15 (Newest Version)
« Reply #7 on: November 21, 2018, 03:20:46 PM »
Ok good luck.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline themekings

  • Semi-Newbie
  • *
  • Posts: 71
Re: Convert 1.1.8 SMF Forum to 2.0.15 (Newest Version)
« Reply #8 on: November 21, 2018, 03:24:49 PM »

Online vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,060
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Convert 1.1.8 SMF Forum to 2.0.15 (Newest Version)
« Reply #9 on: November 21, 2018, 03:31:53 PM »
just delete the tables inside it not the whole database.
Then once you drop the tables.
Click on the database and then select the import tab to upload the sql
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline themekings

  • Semi-Newbie
  • *
  • Posts: 71
Re: Convert 1.1.8 SMF Forum to 2.0.15 (Newest Version)
« Reply #10 on: November 21, 2018, 03:33:15 PM »
Ok, attempting now

Offline themekings

  • Semi-Newbie
  • *
  • Posts: 71
Re: Convert 1.1.8 SMF Forum to 2.0.15 (Newest Version)
« Reply #11 on: November 21, 2018, 03:54:53 PM »
Received this error:

http://342ft.com/wp-content/uploads/2018/11/error.jpg

I dropped all table files inside that database that was circled (was successful) > selected database > click import tab > selected my .sql file > Hit go  and got that error


Offline themekings

  • Semi-Newbie
  • *
  • Posts: 71
Re: Convert 1.1.8 SMF Forum to 2.0.15 (Newest Version)
« Reply #12 on: November 21, 2018, 03:55:50 PM »
I tried not using UTF as well and got a diff error, but that didnt work either (just fyi)

Online vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,060
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Convert 1.1.8 SMF Forum to 2.0.15 (Newest Version)
« Reply #13 on: November 21, 2018, 03:56:19 PM »
Take out the create database line in .sql file that you are importing. Since you are already inside a database
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline themekings

  • Semi-Newbie
  • *
  • Posts: 71
Re: Convert 1.1.8 SMF Forum to 2.0.15 (Newest Version)
« Reply #14 on: November 21, 2018, 03:57:35 PM »
Can I open that in notepad?

Offline themekings

  • Semi-Newbie
  • *
  • Posts: 71
Re: Convert 1.1.8 SMF Forum to 2.0.15 (Newest Version)
« Reply #15 on: November 21, 2018, 03:59:49 PM »
I opened in notepad and found:

--CREATE DATABASE `DATABASE NAME HERE` (removed the DB name)

Remove that line?

Online vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,060
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Convert 1.1.8 SMF Forum to 2.0.15 (Newest Version)
« Reply #16 on: November 21, 2018, 04:00:19 PM »
Yes remove that line.

And there might be a use database line below that.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline themekings

  • Semi-Newbie
  • *
  • Posts: 71
Re: Convert 1.1.8 SMF Forum to 2.0.15 (Newest Version)
« Reply #17 on: November 21, 2018, 04:10:05 PM »
New error:

http://342ft.com/wp-content/uploads/2018/11/error2.jpg

I can send you the file if you want to edit it if you like.

Offline themekings

  • Semi-Newbie
  • *
  • Posts: 71
Re: Convert 1.1.8 SMF Forum to 2.0.15 (Newest Version)
« Reply #18 on: November 21, 2018, 04:18:20 PM »
I downloaded RazerSQL, def can read it better than on notepad.... trying again

Offline themekings

  • Semi-Newbie
  • *
  • Posts: 71
Re: Convert 1.1.8 SMF Forum to 2.0.15 (Newest Version)
« Reply #19 on: November 21, 2018, 04:21:43 PM »
It worked that time, however the site is now down:

http://342ft.com/wp-content/uploads/2018/11/success1.jpg