Advertisement:

Author Topic: Convert 1.1.8 SMF Forum to 2.0.15 (Newest Version)  (Read 3807 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

Offline themekings

  • Semi-Newbie
  • *
  • Posts: 71
Re: Convert 1.1.8 SMF Forum to 2.0.15 (Newest Version)
« Reply #20 on: November 21, 2018, 04:25:17 PM »
Here are the 2 lines i deleted:

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

Lines 22 and 23

Live site now gives this error: Table 'policeLoungeXX.smf_settings' doesn't exist

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 #21 on: November 21, 2018, 04:26:41 PM »
Are all your database have the prefix of smf_ inside the database?

And does the smf_settings table exist in your database after it was imported?
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 #22 on: November 21, 2018, 04:30:00 PM »
They do have the smf_ prefix but I see no settings table. Only 18 tables are in there now

Offline themekings

  • Semi-Newbie
  • *
  • Posts: 71
Re: Convert 1.1.8 SMF Forum to 2.0.15 (Newest Version)
« Reply #23 on: November 21, 2018, 04:34:21 PM »
Heres a pic of table now: http://342ft.com/wp-content/uploads/2018/11/success2.jpg

Believe there was over 60 in there before i dropped them

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 #24 on: November 21, 2018, 04:50:29 PM »
Hmm hopefully your backup file is complete. Open the backfile in notepad and see if it ends with a smf_topics table it should be in that file.
If the backup file was made from SMF it could be incomplete
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 #25 on: November 21, 2018, 05:02:28 PM »
OK, i drop those last files and tried this......

I went into godaddys backend and Restore a backup version of my database in their system and now it gave me all these files:

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

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 #26 on: November 21, 2018, 05:04:28 PM »
That looks perfect.
Yeah now just grab the large upgrade package to upgrade your site.
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 #27 on: November 21, 2018, 05:21:03 PM »
Do I upload the zip file in the forum root, and extract it there?

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 #28 on: November 21, 2018, 05:28:23 PM »
Or just upload the contents of zip file to the forum root. Make sure it is the large upgrade package for 2.0.13
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 #29 on: November 21, 2018, 05:35:36 PM »
Downloaded (smf_2-0-13_upgrade) and Uploaded ZIP to root file and extracted there, overwriting files and folders, and still not wanting to work. :(

Man I appreciate the help. Not sure what to do from here.

Got file from here: https://download.simplemachines.org/index.php?thanks;filename=smf_2-0-13_upgrade.zip

Offline themekings

  • Semi-Newbie
  • *
  • Posts: 71
Re: Convert 1.1.8 SMF Forum to 2.0.15 (Newest Version)
« Reply #30 on: November 21, 2018, 05:37:07 PM »
Direct link to site: http://policelounge.com/lounge/

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 #31 on: November 21, 2018, 05:55:16 PM »
Download and upload the repair settings tool
What is repair_settings.php?

We are going to change paths on your web host.
Mainly make sure all file paths start with /home/content/23/12305423/html/POLICE/lounge/
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 #32 on: November 21, 2018, 06:13:15 PM »
Getting these 2 error messages when i open the repair_settings.php;

    
Notice: Undefined index: database_error in /home/content/23/12305423/html/POLICE/lounge/Sources/Subs-Db-mysql.php on line 594

Fatal error: Call to undefined function allowedTo() in /home/content/23/12305423/html/POLICE/lounge/Sources/Subs-Db-mysql.php on line 595


Here is those lines in that file:

Code: [Select]
$context['error_title'] = $txt['database_error'];
if (allowedTo('admin_forum'))



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 #33 on: November 21, 2018, 06:17:03 PM »
Hmm open your settings.php file and make sure the file paths start with  /home/content/23/12305423/html/POLICE/lounge/
I would do the same with the smf_themes table and smf_settings table if the repair settings tool doesn't work.
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 #35 on: November 21, 2018, 06:27:39 PM »
As well as the settings.php file. That direct URL is correct there too

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 #36 on: November 21, 2018, 06:49:07 PM »
Strange do you have it working now? I can visit your site. Checked upgrade.php says missing file from sources/Subs-Db-mysql.php
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 #37 on: November 21, 2018, 06:53:49 PM »
Nahh, I went in and deleted those lines and got it to work, but no categories showed. Send me your paypal email and I'll send you some money. Maybe we can work on it tomorrow and I'll hook you up with more money ;) I feel like we are getting close.

Offline Sir Osis of Liver

  • SMF Hero
  • ******
  • Posts: 8,612
Re: Convert 1.1.8 SMF Forum to 2.0.15 (Newest Version)
« Reply #38 on: November 21, 2018, 09:30:00 PM »
You're not going to be able to upgrade directly from 1.1.8 -> 2.0.15.  You'll have to up to 1.1.21, then to 2.0.15, and it will require juggling php versions to do it.  Doesn't help that you're on GoDaddy. :P

Offline themekings

  • Semi-Newbie
  • *
  • Posts: 71
Re: Convert 1.1.8 SMF Forum to 2.0.15 (Newest Version)
« Reply #39 on: November 22, 2018, 12:28:35 AM »
ANSWER HERE:

OK here is what I did and it works;  (Using Godaddy Hosting)

1. I installed fresh version of 2.0.13 SMF using PHP version 5.0
2. I then logged into myphpadmin and dumped all the tables associated with forum database. (65 total table files in this install)
3. Using Godaddy, I opened MySQL in the control panel of my hosting site and found my database associated to my new forum.
4. I then clicked the "actions" button by this database and selected "Restore". It asked me to select my backup, and I found the old SQL file for this forum (4 years old) and installed it.
5. I then uploaded the 1.1.12 Large Upgrade zip file into the new forums root directory and extracted the contents there using Godaddys File Manger.
6. I then opened the Upgrade PHP in my web browser associated to this forum and followed the instructions. After 5 seconds it was done.
7. The upgrade php file then will delete all the upgrade files you dont need, you can then click to see the forum. WOW! FINALLY! It works again!


Offline themekings

  • Semi-Newbie
  • *
  • Posts: 71
Re: Convert 1.1.8 SMF Forum to 2.0.15 (Newest Version)
« Reply #40 on: November 22, 2018, 09:48:13 PM »
Forgot 1 final step, you need to download and install the 2.0.15 Full Upgrade file to finalize the update. That takes it up the newest version, and compatibility with PHP 5.5 and above.

Special thanks to vbgamer45 for all his help! Couldn't had done it without your help!!!