Advertisement:

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

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

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,390
    • 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

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,390
    • 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

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,390
    • 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?

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,390
    • 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/

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,390
    • 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'))



Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,390
    • 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

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,390
    • 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: 9,137
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!