[ic] Demo error cloning product

kerry kerry at basicq.com
Wed Feb 10 13:41:39 UTC 2016


Somehow, the original message did not go through that prompted me to
test the demo.

I have categories that have 10 to 50 products. The flypage seems to list
in an un-tidy way depending on the length of the description which
caused the height of the box it is in to be longer on some items than
others. This makes some rows have less items than others. Was going to
test the demo but ran into the problem below.

On 02/10/2016 08:29 AM, kerry wrote:
> I just cloned a product on my test system and it worked fine. So, must
> be some changes someone made in the demo.
> 
> 
> 
> On 02/10/2016 08:24 AM, kerry wrote:
>> Hmmm, was going to add some products to force the demo to go past four
>> items in a category for standard size monitor and get this error.
>>
>> table products: set_slice error as called by Vend::Data: DBD::mysql::st
>> execute failed: You have an error in your SQL syntax; check the manual
>> that corresponds to your MySQL server version for the right syntax to
>> use near ',,,,,,,,,,,) VALUES
>> ('os29001xxx','','','','os28108_b.gif','Hand Brush With Very' at line 1
>> at /home/demo1/interchange/lib/Vend/Table/DBI.pm line 1412. query
>> was:insert into products (`sku`,,,,,,,,,,,,,) VALUES
>> (?,?,?,?,?,?,?,?,?,?,?,?,?,?) values
>> were:'os29001xxx','','','','os28108_b.gif','Hand Brush With Very Long
>> Short Description for testing display','os28108.gif','Hand Tools',' This
>> carpenters hand brush is ideal for the small clean ups needed for
>> precision work. Made of refined horse hair it is perfect for even the
>> most sensitive of materials. ','1','1','Brushes','5.99','3'
>>
>> I have not tried to clone a product on my test site yet, but will
>> attempt to see if it is the same.
>>
>> Kerry
>>
>> _______________________________________________
>> interchange-users mailing list
>> interchange-users at icdevgroup.org
>> http://www.icdevgroup.org/mailman/listinfo/interchange-users
>>
> 
> _______________________________________________
> interchange-users mailing list
> interchange-users at icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users
> 



More information about the interchange-users mailing list