You are here:  » Error 500 - Internal server error after adding a Drop Record If Not RegExp Filter

Support Forum



Error 500 - Internal server error after adding a Drop Record If Not RegExp Filter

Submitted by Thomas on Thu, 2010-11-18 18:29 in

Hi ;) I just downloaded the script yesterday and i am working on it at the moment.

As some of the others, I have the problem that i do want to filter a lot of uneeded Items from a feed.
As the needed Categories are a lower number that the uneeded ones i decided to use the Drop Record If Not RegExp Filter.

I created a list of the 98 Categories from the feed that i need (yes i know thats a lot but the uneeded ones are much more)

Then I addded them up like this:

(Bogensport > Bögen > Langbogen|Bogensport > Bögen > Reiterbogen
(Bogensport > Bögen > Langbogen|Bogensport > Bögen > ReiterbogenBogensport > Bogenequipment > Nocken
etc. and added a ) in the end.

This makes a very long string, but the Filter Field accepted it.

Regrettably it seems to be too long, as the import crashes with the Error 500 - Internal server error
Any Ideas how to solve this?

The Shops I want to add to the comparison all have similarily large feeds and i need to filter out those i dont want as it will be a very specific price comparison.

Kindest regards
Thomas
(from Germany)

Submitted by Thomas on Thu, 2010-11-18 19:40

PS: removed the < and replaced it with * tried several other things. nothing worked.
Maybe its too long / too many rules in one?

Submitted by support on Thu, 2010-11-18 19:40

Hello Thomas,

Welcome to the forum!

Can you confirm that without the filter in place, the feed does import fully without any 500 errors?

Secondly, can you confirm that after configuring the filter, when you return to the configuration page for that filter the value that you had previously put in the text field was still there in full and had not been made shorter?

Cheers,
David.
--
PriceTapestry.com

Submitted by Thomas on Thu, 2010-11-18 19:47

Hi David

Without filters, the script imports all products - 7748

You can see the result on {link saved}
I also removed the admin password from the admin folder so you can also take a look in there.

In the original feed, the Categories look like this:
Bogensport > Bögen > Langbogen
Bogensport > Bögen > Reiterbogen
Bogensport > Bogenequipment > Nocken
Bogensport > Bogenequipment > Sehnen

As you can see after a filterless import they look like this:
Bogensport Bögen Kinderbogen
Bogensport Bögen Langbogen
Bogensport Bögen Recurvebogen
Bogensport Bögen Reiterbogen

So importing (without filter) already drops out some characters.

Also, it seems to crash the Category page somehow, as not all categries are shown - regrettably the merchant uses book author names as kategories, which makes a lot of them.
At the end I dont need all these - i just need around 100 of them which also make a quite good structure for the whole Price comparison.

Thank you for your help.

Thomas

Submitted by Thomas on Thu, 2010-11-18 19:49

Hi David, I forgot:

if i configure the filter, save and edit the filter it keeps the whole string until the final )

Submitted by support on Thu, 2010-11-18 20:05

Hi Thomas,

I downloaded the feed from your /feeds/ folder and also without any filters I got 7748 products. I added the same filter, and there were no errors, but also no products imported.

I will pick this up first thing tomorrow for you; first I will get it to work on my server with your filter configuration; (it may need some changing with the > and UTF-8 special characters) and once that is working then I will contact you with the working configuration, and if that still causes a 500 Error on your server then we can work on that separately...

Cheers,
David.
--
PriceTapestry.com

Submitted by Thomas on Thu, 2010-11-18 20:08

Thank you David!

Cheers
Thomas

Submitted by support on Fri, 2010-11-19 14:34

Hi Thomas,

Will follow up by email...

Cheers,
David.
--
PriceTapestry.com