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. ;)
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.
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
When you say:
QuoteThen 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?
Yes.
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!
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
Ok good luck.
Delete the file circled in red?
http://342ft.com/wp-content/uploads/2018/11/delete.jpg
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
Ok, attempting now
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
I tried not using UTF as well and got a diff error, but that didnt work either (just fyi)
Take out the create database line in .sql file that you are importing. Since you are already inside a database
Can I open that in notepad?
I opened in notepad and found:
--CREATE DATABASE `DATABASE NAME HERE` (removed the DB name)
Remove that line?
Yes remove that line.
And there might be a use database line below that.
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.
I downloaded RazerSQL, def can read it better than on notepad.... trying again
It worked that time, however the site is now down:
http://342ft.com/wp-content/uploads/2018/11/success1.jpg
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
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?
They do have the smf_ prefix but I see no settings table. Only 18 tables are in there now
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
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
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
That looks perfect.
Yeah now just grab the large upgrade package to upgrade your site.
Do I upload the zip file in the forum root, and extract it there?
Or just upload the contents of zip file to the forum root. Make sure it is the large upgrade package for 2.0.13
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
Direct link to site: http://policelounge.com/lounge/
Download and upload the repair settings tool
What is repair_settings.php? (https://wiki.simplemachines.org/smf/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/
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:
$context['error_title'] = $txt['database_error'];
if (allowedTo('admin_forum'))
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.
They appear correct:
http://342ft.com/wp-content/uploads/2018/11/smf-settings.jpg
http://342ft.com/wp-content/uploads/2018/11/smf-theme.jpg
As well as the settings.php file. That direct URL is correct there too
Strange do you have it working now? I can visit your site. Checked upgrade.php says missing file from sources/Subs-Db-mysql.php
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.
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
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!
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!!!