attributes cause 500 internall server error

8 replies [Last post]

Thu, 05/14/2009 - 21:02

flint

Offline

Joined: 05/14/2009

Juice: 13

I have been helping a friend to set up a Drupal based site so she could sell homemade candles.

This issue did not come when the attributes were first put to use.
When the site was first being configured, about two days before any issue, Ubercart had no problems, nor did the attributes module.

The issue may be caused by the large amount of options we are using, over 50 on some, but it runs for a long time before getting the 500 Internal Server Error so I have no way of knowing.

I do know it is the Attributes module because the errors are only gotten when I visit a product with attributes attached and in the attribute administration menu.

We really like Ubercart, but we will have to abandon it if we cant make it work.
Does anyone know what this could be caused by?

PS: Both the newest 5.x and 6.x versions did the same thing.

Thu, 05/14/2009 - 21:33

#1 View page

mikejoconnor

Offline

Joined: 08/07/2007

Juice: 536

Re: attributes cause 500 internall server error

How many attributes, and how many options for each attribute?

Commerce Guys | Ubercart Development | Ubercart Training

Thu, 05/14/2009 - 21:48

#2 View page

flint

Offline

Joined: 05/14/2009

Juice: 13

Re: Re: attributes cause 500 internall server error

There were six attributes:

Size= 20~
Shape= 2
Scent= 62~
Color1= 7
Color2= 7
Color3= 7

I cant get the exact number of options for size and scent, but that is close to the number of options on everything.

Thu, 05/14/2009 - 22:13

#3 View page

mikejoconnor

Offline

Joined: 08/07/2007

Juice: 536

Re: Re: Re: attributes cause 500 internall server error

are you experiencing the error on every page, the node view page, or just the adjustments page?

Commerce Guys | Ubercart Development | Ubercart Training

Thu, 05/14/2009 - 22:16

#4 View page

flint

Offline

Joined: 05/14/2009

Juice: 13

Re: Re: Re: Re: attributes cause 500 internall server error

I am experiencing it on the node view and adjustments pages.

Thu, 05/14/2009 - 22:20

#5 View page

Avyi

Offline

Joined: 05/14/2009

Juice: 6

Re: Re: Re: Re: Re: attributes cause 500 internall server error

I'm the owner of the site and have plans to add at least 6 more attributes with a minimum of 6 options each...not sure if this is helpful or not.

Fri, 05/15/2009 - 20:07

#6 View page

Avyi

Offline

Joined: 05/14/2009

Juice: 6

Re: Re: Re: Re: Re: Re: attributes cause 500 internall server er

Anyone?...my whole life (website) is on hold because of this issue.

Mon, 05/18/2009 - 16:43

#7 View page

Avyi

Offline

Joined: 05/14/2009

Juice: 6

Re: Re: Re: Re: Re: Re: Re: attributes cause 500 internall serve

Is there Anyone that can provide a solution to my problem? Please

Mon, 05/18/2009 - 16:52

#8 View page

mikejoconnor

Offline

Joined: 08/07/2007

Juice: 536

Re: Re: Re: attributes cause 500 internall server error

So here is the issue. The attribute adjustment page allows you to set a different SKU for every single attribute combination. In this case you have 20 * 2 * 62 * 7 * 7 * 7 options. In this case, the server is attempting to generate a form with 850,000+ fields.

Unfortunately we don't really have a good solution for this right now. A few ideas have been proposed, however nobody has been willing to step up and fund the solution.

I would recommend 2 makeshift solutions.
1. don't use the adjustments system in this case. Instead write some custom code to generate the sku for you.
2. write a script to populate the adjustments table.

If your looking for a better solution and would like to have someone else code it, feel free to get ahold of me via PM.

Commerce Guys | Ubercart Development | Ubercart Training

Ubercart

Navigation

User login