[ic] Demo error cloning product

Frank Reitzenstein frank at aussievitamin.com
Wed Feb 10 14:05:08 UTC 2016


Hello Kerry,

"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."

You mean the results page. I put an extra <div></div> to force a height of 350 in results.html and all my other custom search pages.


See here just inside the <div class="col-xs-6 col-sm-4 col-md-6 col-lg-3"> container


[if-item-field discount]
[discount [item-code]] $s * [item-field discount] [/discount]
[/if-item-field]
	<div class="col-xs-6 col-sm-4 col-md-6 col-lg-3">
<div style="height:350px;">
			<a href="/[item-code].html"><img src="/images/thumb/[item-field thumb]"   width="[item-field bullet_six]"  height="[item-field bullet_seven]" alt="[item-field description]"></a>
			<div class="caption">
				<h4><a href="/[item-code]">[item-description]</a></h4>
[if-item-field discount]
[if-item-field option_type]
		[if-item-data !options o_modular]
[calc]subtotalgst('[item-options td=0 label=0 bold=1 price=1]','[item-data products description]')[/calc]
		[/if-item-data]
[else]
<br>Retail Price: <s>[price code="[item-code]" discount=0]</s>
<br>Our Price: <b>[price code="[item-code]" discount=1]</b>
[/else]
[/if-item-field]
[else]
Our Price: [price code="[item-code]" discount=0]
<br>
[item-options td=0 label=0 bold=1 price=1]
[/else]
[/if-item-field]
</div>
		</div>
	</div>
[/search-list]
</div>

That mysql error I haven't seen it for a while. You can post the entire line of products.txt it is complaining about.

Frank Reitzenstein

kerry wrote:
> 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
>>
> _______________________________________________
> 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