ElkArte Community

General => OpenImporter => Topic started by: Gryzor on September 02, 2020, 10:06:38 am

Title: Stuck with importer...
Post by: Gryzor on September 02, 2020, 10:06:38 am
Hello everyone!

N00b here by any measure, so please bear with me :)

Unzipped the importer to my server, /forum2/import/ .

If I navigate to /forum2/import/ I get the folder listings. Executing import.php gives me an error 500.  I try to  navigate to OpenImporter/Importer.php, and all I get is a white page. Adding the usual php error reporting options to the php gives me a 500 error again...

I have the feeling I'm doing something spectacularly wrong, can anyone help? :(

Thanks!
Title: Re: Stuck with importer...
Post by: radu81 on September 02, 2020, 10:14:20 am
Hello and welcome to Elkarte!
Post the server logs you get. What php version are you using?
Title: Re: Stuck with importer...
Post by: Gryzor on September 02, 2020, 10:28:55 am
Thanks for the welcome and for the reply :)

I'm still on  5.5.9 as far as php goes. Which logs are you interested in? My /var/log/apache2/error.log doesn't contain much related, only one entry for today...
Title: Re: Stuck with importer...
Post by: Gryzor on September 04, 2020, 02:30:26 pm
Bump? :(
Title: Re: Stuck with importer...
Post by: Antechinus on September 05, 2020, 03:44:46 am
Why are you on PHP 5.5.9? What are you trying to convert?
Title: Re: Stuck with importer...
Post by: Gryzor on September 07, 2020, 01:40:43 pm
Trying to convert from SMF - forgot to mention but it doesn't really matter because I didn't go as far as to pick :D

Still on 5.5.9 because it Just Works (TM) :D Unsure how a move to 7.x will affect SMF, so...
Title: Re: Stuck with importer...
Post by: Antechinus on September 07, 2020, 02:30:18 pm
Depends on which version of SMF it is. If it's 2.0.17 will be fine on 7.2, but if it's an older version it may not be.
I don't know if Elk will handle 5.5.9 though. That's pretty old PHP.

ETA: Just checked the requirements for Elk. Says it should be ok with PHP 5.2+
Title: Re: Stuck with importer...
Post by: Gryzor on September 08, 2020, 02:51:40 pm
Yeah, Elk is already up and running, and I'm at the phase of trying to import data from SMF.

Yes, I know 2.0.17 is supposed to be fine, though I've seen comments indicating issues, but anyhow. The problem for now is with the importer! :D
Title: Re: Stuck with importer...
Post by: ahrasis on September 09, 2020, 05:50:46 am
Better test it and report. Guessing won't help that much.
Title: Re: Stuck with importer...
Post by: Gryzor on September 09, 2020, 11:35:35 am
Test what? I'm posting because I have an issue with the importer, the rest are irrelevant at this point.
Title: Re: Stuck with importer...
Post by: ahrasis on September 09, 2020, 12:19:51 pm
You said you are a newbie so please note that error 500 is not the importer error but the server error. You can google around to ascertain what it is. All I can say is fix your server, then test it and report. You want people to bear with you, so bear with us too.
Title: Re: Stuck with importer...
Post by: Gryzor on September 09, 2020, 03:15:33 pm
I know what a 500 error is (I didn't say I'm a newbie in general, I'm a newbie *here*)... but it doesn't make any sense, I'm just turning debugging on, otherwise I get a blank page. You suggested trying "it" and I'm saying, try what.
Title: Re: Stuck with importer...
Post by: badmonkey on September 09, 2020, 06:57:36 pm
The php memory limit can produce a 500 error if it is exceeded.
Title: Re: Stuck with importer...
Post by: Gryzor on September 10, 2020, 10:02:12 am
The php memory limit can produce a 500 error if it is exceeded.

Interesting, that is something I didn't know. However, since we're using big uploads on our site, our memory_limit is set at 128MB. I doubt that's not enough?
Title: Re: Stuck with importer...
Post by: badmonkey on September 10, 2020, 01:55:44 pm
The php memory limit can produce a 500 error if it is exceeded.
   
Interesting, that is something I didn't know. However, since we're using big uploads on our site, our memory_limit is set at 128MB. I doubt that's not enough?
 
 

128 should be plenty. How about php, apache/nginx or mysql timeouts?
Title: Re: Stuck with importer...
Post by: Gryzor on September 11, 2020, 08:28:11 am
128 should be plenty. How about php, apache/nginx or mysql timeouts?

Not sure if it's an indication, but the issues (either the blank page or the 500) appear instantaneously. I doubt it's a performance issue since the server is handling a mediawiki and a smf installation with some traffic and quite a few visitors with no issues... I'm hitting my head against a wall right now :D
Title: Re: Stuck with importer...
Post by: badmonkey on September 11, 2020, 01:35:07 pm
128 should be plenty. How about php, apache/nginx or mysql timeouts?
  
Not sure if it's an indication, but the issues (either the blank page or the 500) appear instantaneously. I doubt it's a performance issue since the server is handling a mediawiki and a smf installation with some traffic and quite a few visitors with no issues... I'm hitting my head against a wall right now :D
 
 It isn't about performance. The importer can take some time, even on a smaller forum. Regardless, a proper solution requires a methodical troubleshooting approach. Lost car keys are never, ever where we *think* they are. If they were, they wouldn't be lost.

Also check file ownership. Pay particular attention to the importer itself.
Title: Re: Stuck with importer...
Post by: Gryzor on September 14, 2020, 11:39:34 am
No, I know it's not about performance. What I was saying was that there was no opportunity for time outs since I got the issue immediately. Also, note that the import process hadn't even started yet, I haven't gotten that far :D

Is there somewhere I can see what permissions the files must have?

Thanks again!
Title: Re: Stuck with importer...
Post by: badmonkey on September 14, 2020, 01:50:36 pm
No, I know it's not about performance. What I was saying was that there was no opportunity for time outs since I got the issue immediately. Also, note that the import process hadn't even started yet, I haven't gotten that far :D

Is there somewhere I can see what permissions the files must have?

Thanks again!
 
 Ah! Gotcha! You should be able to see file ownership using your ftp client. For example, in Filezilla, right click the file to view and select from the popup. Or you can list them in SSH. 
Title: Re: Stuck with importer...
Post by: Gryzor on September 14, 2020, 03:02:51 pm
Apologies, I wasn't clear :D I know how to see them, I was asking what they should be! ("where can I see what they must be?")

Apologies again, I can see how I wasn't very succinct :D
Title: Re: Stuck with importer...
Post by: badmonkey on September 14, 2020, 07:22:07 pm
Apologies, I wasn't clear :D I know how to see them, I was asking what they should be! ("where can I see what they must be?")

Apologies again, I can see how I wasn't very succinct :D
 
 No worries Gryzor. Sometimes internet communication can be tricky. Lol!

Since the importer should be deleted after the process is successful, there is no harm in giving it full read/write permissions. I'd go 777. As for ownership, it depends on your particular OS configuration. Assuming your forum operated correctly previously, ownership should match that of the other forum files. 
Title: Re: Stuck with importer...
Post by: ahrasis on September 15, 2020, 02:57:12 am
I would personally just test and do it on my pc. Once it is successful, I would transfer them back to the host.
Title: Re: Stuck with importer...
Post by: Gryzor on September 16, 2020, 02:30:53 pm
Argh... I had already given it 777, owner and group are www-group, all seems fine but I still gall at the first hurdle...

Unfortunately my time is up :( I'm beginning a new job on monday so I won't have the time to look into it for the foreseeable future probably... thanks for trying to help, people. With you all the best!