| Import Datadump - Page cannot be found [message #30669] |
Wed, 08 March 2006 11:01  |
Ernesto
Messages: 413
Registered: August 2005
Karma: 0
|
Senior Member |
|
|
Hello there friends =)
I encountered a problem when trying to import a datadump from version 2.6.15 into a new installation of 2.6.15 on a new server.
I searched the forum for this problem, and found similair problems, but not exactly like mine, so I figured I would make a new topic.
Description of the problem:
When trying to import the datadump (~500mb size) it "times out" - IE I get a "Page not found" error in my browser. I do not get any error message about any mysql timeout or anything like that, just a simple page not found.
After the "page not found" I cannot use the forum, nor can i access the adm/ part.
Attempted workarounds:
I tried to increase the timer in the admimport.php from 6000 to 60000 but that did not help.
I configured the admimport.php with the suggested $_POST['path'] = '../FUDforum_07_03_2006_05_22.fud'; so I could run the script directly from the command line (and I uncommented the above line)
I read somewhere that if you had any extra columns in your datadump that were not defined in the sql/ dir, then you would get error messages, I do have that extra column, but I get no error message, just the page not found.
I have now removed the extra columns and made a new datadump, but I am unsure this will help me with my problem.
It was a bit annoying, since it takes time to download and upload the 500mb file and reimport/reexport etc.
If anyone have any idea what is wrong and how I can cure my problem I would be happy!
Could it be due to the size of the dump? (500mb) However this feels strange, because I am sure there are many communities larger than mine that had to backup or use the dump function.
So, any suggestions from anyone? =)
Ginnunga Gaming
[Updated on: Wed, 08 March 2006 11:02] Report message to a moderator |
|
|
|
| Re: Import Datadump - Page cannot be found [message #30671 is a reply to message #30669] |
Wed, 08 March 2006 12:41  |
Ernesto
Messages: 413
Registered: August 2005
Karma: 0
|
Senior Member |
|
|
I removed the extra column I had (Topic short description) and made a new datadump, downloaded it, uploaded it, ran the admimport.php again and after I dont know, perhaps 30 minutes or so it gave me page cannot be found again, and both the initial forum directory as well as the adm/ directory just gives me a blank page.
I am ripping my hair off in little clumps while banging my head on my keyboard, which could explain my spelling.
Ginnunga Gaming
|
|
|
|
|
|
|
|
|
|
| Re: Import Datadump - Page cannot be found [message #30685 is a reply to message #30669] |
Wed, 08 March 2006 20:57 |
Ernesto
Messages: 413
Registered: August 2005
Karma: 0
|
Senior Member |
|
|
This is from the SQL error file:
| Quote: |
[Wed Mar 8 20:48:12 GMT 2006] KC9ob21lL2dpbm51bmdhL3B1YmxpY19odG1sL2ZvcnVtL2luZGV4LnBocDoxMjY8YnIgLz4KL2h vbWUvZ2lubnVuZ2EvcHVibGljX2h0bWwvZm9ydW0vaW5kZXgucGhwOjIyNjxiciAvPgovaG9tZS 9naW5udW5nYS9wdWJsaWNfaHRtbC9mb3J1bS9pbmRleC5waHA6MzIwPGJyIC8+Ci9ob21lL2dpb m51bmdhL3B1YmxpY19odG1sL2ZvcnVtL2luZGV4LnBocDozNTU8YnIgLz4KL2hvbWUvZ2lubnVu Z2EvcHVibGljX2h0bWwvZm9ydW0vaW5kZXgucGhwOjk3MTxiciAvPgovaG9tZS9naW5udW5nYS9 wdWJsaWNfaHRtbC9mb3J1bS9pbmRleC5waHA6MTE1MTxiciAvPgopIDEwNTQ6IFVua25vd24gY2 9sdW1uICd1LmJhbl9leHBpcnknIGluICdmaWVsZCBsaXN0JzxiciAvPgpRdWVyeTogU0VMRUNUC gkJcy5pZCBBUyBzaWQsIHMuc2VzX2lkLCBzLmRhdGEsIHMucmV0dXJudG8sIHMuc3lzX2lkLAoJ CXQuaWQgQVMgdGhlbWVfaWQsIHQubGFuZywgdC5uYW1lIEFTIHRoZW1lX25hbWUsIHQubG9jYWx lLCB0LnRoZW1lLCB0LnBzcGVsbF9sYW5nLCB0LnRoZW1lX29wdCwKCQl1LmFsaWFzLCB1LnBvc3 RzX3BwZywgdS50aW1lX3pvbmUsIHUuc2lnLCB1Lmxhc3RfdmlzaXQsIHUubGFzdF9yZWFkLCB1L mNhdF9jb2xsYXBzZV9zdGF0dXMsIHUudXNlcnNfb3B0LAoJCXUuaWdub3JlX2xpc3QsIHUuaWdu b3JlX2xpc3QsIHUuYnVkZHlfbGlzdCwgdS5pZCwgdS5ncm91cF9sZWFkZXJfbGlzdCwgdS5lbWF pbCwgdS5sb2dpbiwgdS5zcSwgdS5iYW5fZXhwaXJ5CglGUk9NIGZ1ZDI2X3NlcyBzCgkJSU5ORV IgSk9JTiBmdWQyNl91c2VycyB1IE9OIHUuaWQ9KENBU0UgV0hFTiBzLnVzZXJfaWQmZ3Q7MjAwM DAwMDAwMCBUSEVOIDEgRUxTRSBzLnVzZXJfaWQgRU5EKQoJCUlOTkVSIEpPSU4gZnVkMjZfdGhl bWVzIHQgT04gdC5pZD11LnRoZW1lCglXSEVSRSBzLmlkPSczODYxNSc8YnIgLz4KU2VydmVyIFZ lcnNpb246IDQuMS4xNjxiciAvPgo=
|
Please please help me Ilia! I trade huggles!
Ginnunga Gaming
|
|
|
|
| Re: Import Datadump - Page cannot be found [message #30695 is a reply to message #30685] |
Thu, 09 March 2006 14:45 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
Your problem lies in the following:
Unknown column 'u.ban_expiry' in 'field list'
You need to add this column (integer) to the users table.
FUDforum Core Developer
|
|
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
and we will see how it went =)
]