| Importing forum data 2.7.7 to 3.0 [message #163662] |
Mon, 22 November 2010 13:45  |
BAD35th
Messages: 61
Registered: February 2007
Location: Hammertown
Karma: 0
|
Member |
|
|
Quick Overview: Back in early 2008 I attempted to move my forum data to new free hosting. I was running 2.7.7 in production and in preparation for that I got 2.7.7 installed at new, I ran the backup of production site ok, however everytime I tried to import my forum data it would time out and ultimately corrupt the entire forum with an HTTP 500 error meaning a reinstall of forum from ground up was necessary. I posted about it a couple of times but then gave up.
I was hoping as newer versions of the forum came out the import issue would go away.
FF to today: our forum is now down and I am trying to get it onto current platform of 3.0.2.
Frank you answered my question in the 3.02 announcement area but I am not sure I like the answer you gave as I am thinking I am going to be stuck again with the above error by having to work with 2.7.7.
Quote:You need to download 2.7.7, import your backup, upgrade to 3.0.0, and then upgrade to 3.0.2.
Key points:
- you need to restore to the version you've backed-up.
- FUDforum 2.x releases must first be upgraded to 3.0.0 before it can be upgraded to the latest release.
Curious as to why V3.x would not be able to import from ver 2.x forums? Will any of the revisional versions of 2.X work that are higher than 2.7.7 import the data, or am I stuck trying to troubleshoot this again in 2.7.7?
Because of the 3rd party hosting I have minimal access and control over the db environment, so probably can't even see log files on the db server which could make troubleshooting tough.
Suggestions??
[Updated on: Mon, 22 November 2010 13:51] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Importing forum data 2.7.7 to 3.0 [message #163735 is a reply to message #163734] |
Mon, 29 November 2010 03:09  |
BAD35th
Messages: 61
Registered: February 2007
Location: Hammertown
Karma: 0
|
Member |
|
|
That was quick. Here is what it said, not a huge SQL guy but seems it can't find a table. I looked in phpadmin and they were all there before the import.
As previously when I stalled out trying this 2 years ago it also currupts the forum and if you try to Return to Forum from admin console or to browse to it you get an HTTP500 error 
/services9/webpages/f/o/forums.tfbm.org/277forum/include/theme/default/db.i nc:72
/services9/webpages/f/o/forums.tfbm.org/277forum/include/theme/default/db.i nc:132
/services9/webpages/f/o/forums.tfbm.org/public/OLDforum/adm/admimport.php:2 23
) 1146: Table 'old_fud_forums_tfbm_org.fud26_users' doesn't exist
Query: SELECT id FROM fud26_users WHERE login='admin' AND users_opt>=1048576 AND (users_opt & 1048576) > 0
_POST: array ( 'S' => 'df4e5c495f14aeac15694a0123d99d57', 'SQ' => '7ad834158282020ac758389cfb54febb', 'path' => '/tmp', 'btn_submit' => 'Import Data', )
Server Version: 4.0.27-standard
[Referring Page] http://forums.tfbm.org/OLDforum/adm/admimport.php
Edit: and it kills all the tables in the db. The fud26_users was there prior to attempting the import.
[Updated on: Mon, 29 November 2010 03:12] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: Importing forum data 2.7.7 to 3.0 [message #163751 is a reply to message #163750] |
Mon, 29 November 2010 15:42 |
BAD35th
Messages: 61
Registered: February 2007
Location: Hammertown
Karma: 0
|
Member |
|
|
Ok I ran 7-Zip on it (which says it understands gunzip).
Not to be a PITA but I now have one 142 mg file that nothing knows how to open. Using Wordpad I can browse it and see a lot of script and SQL commands, and there is user messege data but I am unsure how to go about inserting it manually. Hmm.
Different item here: I found an old screen shot of the forum System Info it shows 2.6RC3, so I wondering if maybe we never got upgraded to 2.7.7 successfully and were still on 2.6. Since you said import must be for exact version, next question is can I get my hands on a 2.6RC3 install archive to try??
Edit: I looked in the Download link on Sourceforge, there is old 2.6 forum installs...why are there so many versions?
Still trying to determine if there is a marker in the backup file that IDs the forum version 100%.
[Updated on: Mon, 29 November 2010 15:46] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: Importing forum data 2.7.7 to 3.0 [message #163777 is a reply to message #163776] |
Tue, 30 November 2010 17:28 |
BAD35th
Messages: 61
Registered: February 2007
Location: Hammertown
Karma: 0
|
Member |
|
|
Ernesto wrote on Tue, 30 November 2010 12:24After you did the forum datadump, did you download it locally and then upload it again to have it imported?
Yes, I downloaded it to my PC.
It is now going to totally different hosting. I FTP'd it using binary option as it was a gz archive. Do you think it is curropt in some way?? I checked the integrity of the archive and it says it is fine.
EDIT: checked your link, see that you are a guild. I'm on WOW myself, which is why I only have one week to get this operational before Cataclysym ships!! 
[Updated on: Tue, 30 November 2010 17:32] Report message to a moderator |
|
|
|
| Re: Importing forum data 2.7.7 to 3.0 [message #163778 is a reply to message #163777] |
Tue, 30 November 2010 22:35 |
BAD35th
Messages: 61
Registered: February 2007
Location: Hammertown
Karma: 0
|
Member |
|
|
Ok I may have found an answer right here (thanks Google!).
Seems like the import code was buggy way back in 06 too, but this guy got it to go with some changes.
http://fudforum.org/forum/index.php?t=msg&goto=34867&#msg_34867
Now can someone walk me thru how I would use Command Line mode on my webhosting site?? Is this where you need an SSH client?? What directory would I run it from??
EDIT: Found quite a nice Windows based SSH terminal called PenguiNet here: www.siliconcircus.com
Found the file admimport.php in the adm folder
So I took out the comment on: define('recovery_mode', 1);
And changed the path in multiple locations in the file from this:
$_POST['path'];
To:
$_POST['/tmp']; - Which is where my fud.gz backup file is located
Now it says run the script as follows:
$ php -q admimport.php
BUT when I try, it comes back and says command not found for php. Where did I go wrong??
EDITEDIT:
Found out the forum hosting does not permit php scripts to be run from SSH shell So they suggest either use path in browser or replicate entire environment to linux PC, run the commands locally and then upload the imported forum. At least I have a road map to try to get this going.
Also they said I could edit the maxtimeout parameter of the HTAaccess file which may help.
Does the running it in browser method sound like it will work??
[Updated on: Wed, 01 December 2010 01:28] Report message to a moderator |
|
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]