Debugging/solving errors using CSV Import

[cleoni]

Hello,

I am trying to import a CSV file via Prestashop's Tools/Import builtin function.

 

The most obvious problem I am experiencing is a horrible

 

500 server error

 

which, by inspecting the errror logs, turns out to be a consequence of this:

 

File does not exist: /home/snip/public_html/500.shtml, referer: http://www.mysite.tl...rt&token=*snip*

 

Actually, this says pretty nothing.

 

I am using Prestashop 1.4.8.2 and the CSV file has been produced with a script I made.

With some set of products it works brilliantly so I guess some of the products simply have got a wrong image URL or however I believe the error must be item-specific (CSV file format is OK I think).

 

It would be very helpful to know:

 

- Is there any means (log, debug function, etc) to actually see what was the last thing the importer did when it crashed?

- Is there any alternative to the builtin importer (it seems to me it's quite weak and easy to crash)

 

I am willing to write a custom PHP script to do the import, because I tend to trust more my own scripts. Is this a recommended path? Anybody has tried it and found big problems in doing that?

 

Thanks for any hint/help you might give

Edited July 9, 2012 by cleoni (see edit history)

[phrasespot]

500 server error

which, by inspecting the errror logs, turns out to be a consequence of this:

File does not exist: /home/snip/public_html/500.shtml, referer: http://www.mysite.tl...rt&token=*snip*

No this actually means that after the 500 error occured server tried to serve a 500 error document and could not find it. It is an additional error in error pages setup of Apache and not related the problem causing 500.

 

Locate /config/config.inc.php and set error display to on and try again. Also look in /override/classes/ directory for some debugging tools. That or debugging using an IDE are too involved to describe in detail here, maybe someone wrote a tutorial; Google for it.