Mailing List Archive

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@icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users
>

_______________________________________________
interchange-users mailing list
interchange-users@icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users

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@icdevgroup.org
>> http://www.icdevgroup.org/mailman/listinfo/interchange-users
>>
>
> _______________________________________________
> interchange-users mailing list
> interchange-users@icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users
>

_______________________________________________
interchange-users mailing list
interchange-users@icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users

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@icdevgroup.org
>>> http://www.icdevgroup.org/mailman/listinfo/interchange-users
>>>
>> _______________________________________________
>> interchange-users mailing list
>> interchange-users@icdevgroup.org
>> http://www.icdevgroup.org/mailman/listinfo/interchange-users
>>
> _______________________________________________
> interchange-users mailing list
> interchange-users@icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users
>


_______________________________________________
interchange-users mailing list
interchange-users@icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users

Thanks Frank.

After I figured out how to place in my results.html code, and what part
of your code to place, it looks like
<div style="height:350px;"></div>

fixed it on the 50 some odd items I am testing on.

On 02/10/2016 09:05 AM, Frank Reitzenstein wrote:
> <div style="height:350px;">

_______________________________________________
interchange-users mailing list
interchange-users@icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users

I think the semicolon is not required and is used to separate multiple
attributes.

kerry wrote:
> Thanks Frank.
>
> After I figured out how to place in my results.html code, and what part
> of your code to place, it looks like
> <div style="height:350px;"></div>
>
> fixed it on the 50 some odd items I am testing on.
>
> On 02/10/2016 09:05 AM, Frank Reitzenstein wrote:
>> <div style="height:350px;">
> _______________________________________________
> interchange-users mailing list
> interchange-users@icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users
>


_______________________________________________
interchange-users mailing list
interchange-users@icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users

On Thu, Feb 11, 2016 at 3:13 AM, kerry <kerry@basicq.com> wrote:
> Thanks Frank.
>
> After I figured out how to place in my results.html code, and what part
> of your code to place, it looks like
> <div style="height:350px;"></div>
>
> fixed it on the 50 some odd items I am testing on.
>
> On 02/10/2016 09:05 AM, Frank Reitzenstein wrote:
>> <div style="height:350px;">

Hi Kerry

Friendly note! This mailing list has been been running in various
formats for a couple of decades and is used as supplementary support
documentation. Interchange users often search these lists to find
answers to various questions. A few basic rules, have made this
easier. One of these is, where possible stay on topic of the subject
of the thread - this way if someone searches for 'error cloning
product' they will read info related to that topic. If in doubt about
a subject first search the list, if you don't find an answer then
start a new topic with a subject that summarises the issue. This is
most helpful in keeping the list coherent and searchable.

To search the mailing list archives I often use google and add
site:icdevgroup.org to the keywords I am looking for.

Another pet hate of many developers on this list is 'top posting'.
Many subscribers will instantly ignore any questions if the 'no top
posting' rule is not followed as the responses can get very messy.

Top posting is explained on the list introduction page point number 5:
http://www.icdevgroup.org/mailman/listinfo/interchange-users

Sorry if I sound like a bore but someone has to do this and today its
my turn. This is not a dogmatic list, most respondents are extremely
friendly and helpful, but there are a few solid guidelines on the list
introduction page.

Hope these tips help in your journey in exploring and unleashing the
power of Interchange!

_______________________________________________
interchange-users mailing list
interchange-users@icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users

Quoting kerry (kerry@basicq.com):
> 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.

Confirmed in the IC 5.10 demo. I have filed a bug:
https://github.com/interchange/interchange/issues/92

--
Josh Lavin
End Point Corporation

_______________________________________________
interchange-users mailing list
interchange-users@icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users