Kit Problem!
Kit Problem!
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
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
Re: Kit Problem!
I have not received any response on this.
Anybody with any ideas??
Anybody with any ideas??
Re: Kit Problem!
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
- AbleCommerce Angel
- Posts: 8164
- Joined: Sun Feb 29, 2004 8:04 pm
- Location: Dayton, OH
- Contact:
Re: Kit Problem!
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.
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx
Re: Kit Problem!
Is it possible to have the code modified so it can function???
- jmestep
- AbleCommerce Angel
- Posts: 8164
- Joined: Sun Feb 29, 2004 8:04 pm
- Location: Dayton, OH
- Contact:
Re: Kit Problem!
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.
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx
Re: Kit Problem!
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.
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)
Re: Kit Problem!
Is this something that I can fix or does it have to be changed on the actual database by our server host?
Re: Kit Problem!
You probably don't have direct access to your database. In that case ask your host to run the above queries on your database.