FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » FUDforum Installation Issues » Import Datadump - Page cannot be found
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
Import Datadump - Page cannot be found [message #30669] Wed, 08 March 2006 11:01 Go to next message
Ernesto is currently offline  Ernesto   Sweden
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? =)


[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 Go to previous messageGo to next message
Ernesto is currently offline  Ernesto   Sweden
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.


Re: Import Datadump - Page cannot be found [message #30672 is a reply to message #30669] Wed, 08 March 2006 13:13 Go to previous messageGo to next message
Ernesto is currently offline  Ernesto   Sweden
Messages: 413
Registered: August 2005
Karma: 0
Senior Member
I got the server admin to increate the apache timeout value just so I can run the script, I will get back here in an hour or two when the script is done running Rolling Eyes and we will see how it went =)

Re: Import Datadump - Page cannot be found [message #30680 is a reply to message #30669] Wed, 08 March 2006 15:00 Go to previous messageGo to next message
Ernesto is currently offline  Ernesto   Sweden
Messages: 413
Registered: August 2005
Karma: 0
Senior Member
After one hour the Cannot find page appeared, but apache is still stealing 90% CPU, so I am not gonna touch the page and hope it finishes in the background.

Re: Import Datadump - Page cannot be found [message #30682 is a reply to message #30669] Wed, 08 March 2006 16:28 Go to previous messageGo to next message
Ernesto is currently offline  Ernesto   Sweden
Messages: 413
Registered: August 2005
Karma: 0
Senior Member
Script finished, both the WWW root and the adm/ gives me white blank pages.

*headache*


Re: Import Datadump - Page cannot be found [message #30685 is a reply to message #30669] Wed, 08 March 2006 20:57 Go to previous messageGo to next message
Ernesto is currently offline  Ernesto   Sweden
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!


Re: Import Datadump - Page cannot be found [message #30695 is a reply to message #30685] Thu, 09 March 2006 14:45 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
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
Re: Import Datadump - Page cannot be found [message #30696 is a reply to message #30669] Thu, 09 March 2006 14:49 Go to previous message
Ernesto is currently offline  Ernesto   Sweden
Messages: 413
Registered: August 2005
Karma: 0
Senior Member
After 14 hours I found the error hehe, it was so simple, yet so annoying.

My forum was version 2.6.13 and I was trying to import to 2.6.15, which didnt work at all - My ged so much time wasted on my own moronity.


  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: Installation database creation
Next Topic: Warning: gzuncompress(): data error
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Mar 28 19:20:46 GMT 2024

Total time taken to generate the page: 0.02389 seconds