Kit Problem!

[krittleb]

We set up a number of kits where customers can purchase a large variety of items at once. Some of them include 32 color options and the others are 84 color options. The kits with 32 items are working fine.

The kits with 84 options are not working. When you go to add it to the cart, it just "processes" for around 10 seconds and then..... nothing. No error message, no directing to the shopping basket, just nothing.

I am assuming it is an issue with the number of items in the kit as all of the 84 are not working and all of the 32 are working.

Anybody have a similar experience or any idea what the cause may be??

http://www.hairbowcenter.com/Solid-Gros ... -C134.aspx

[krittleb]

I have not received any response on this.

Anybody with any ideas??

[kevinSand]

It looks the add to cart button generates a server side error. Can you see what error was generated in your error log with the admin section of your site or in the file App_Data/logs/app.log?

[jmestep]

It looks like a string or binary data would be truncated error, so maybe you are passing too many characters for the field size that Able has set in the database.

[krittleb]

Is it possible to have the code modified so it can function???

[jmestep]

If that is the problem, then then the size of the field in the database could be increased so that it will hold more characters. If I'm guessing at the problem correctly, the data would go into the kitlist field in the ac_BasketItems and that is set to allow only 255 characters in Able.

[plugables]

Judy is probably right. Problem starts at 84th - on average an option Id probably takes 3 - 4 characters. So a coma separated list of 84 Ids will approximately take 84*3 = 252+ characters.

If this is true you should be able to solve the problem by running this on your database.

Code: Select all

ALTER TABLE ac_BasketItems ALTER COLUMN [KitList] varchar(1000)
ALTER TABLE ac_OrderItems ALTER COLUMN [KitList] varchar(1000)

[krittleb]

Is this something that I can fix or does it have to be changed on the actual database by our server host?

[plugables]

You probably don't have direct access to your database. In that case ask your host to run the above queries on your database.