X-Cart forums

[Blackhawk]

I put in to separate pieces of code I found on the site to fix two issues I had..

1) I put in the code in Product.tpl to display 2 products per row, and it works.. when I browse down through my categories I've got two per row with no issues.

2) I put in the code to fix the mySQL errors when you use the Advanced Search feature. Which finds the proper products with no errors now..

Now here is the problem.. with both scripts running, If I do a search that would yield 2 products.. it displays 4.. The first 2 displayed (on one row) are the two it should find.. the second 2 are both place fillers.. no product title, no price, no description.. nothing.

If I search and get 3.. It shows 6.. 3 real, 3 blank.

Anyone else have these two fixes in and had this problem??

Let me know, thanks!

[ATKOgirl]

Hi Blackhawk,

This is a little beyond my scope, but it sounds like a problem with the loop pulling the products. Can you paster your code here so we can see?

;->

ATKOgirl

[deb]

Which way are you doing your 2 products per row?

1. Smarty's 'div by 2' feature

2. The check in Smarty for an "even" number that I saw posted in just the last week or 10 days

[Blackhawk]

Smarty Div by 2... got any ideas Deb?

[Blackhawk]

I assumed you meant products.tpl.. I'm thinking that the way the info passes to the search engine.. that maybe the div by 2 command should be in a different place.. I mean.. browsing thru categories works fine.. its only on searches do I get the phantom doubling.

{* $Id: products.tpl,v 1.16 2002/09/25 10:12:05 zorg Exp $ *} 

<table border=0 width=100%><tr><td> 

<table border=0 width=100%> 

{section name=product loop=$products} 
{if $smarty.section.product.index is div by 2} 
</tr><tr valign="top"> 
{/if} 

<td valign="top"> 

<table border=0 width=100%> 
<tr><td width=90 align=center valign=top> 
<a href=product.php?productid={$products[product].productid}&cat={$cat}&page={$navigation_page}>{include file="product_thumbnail.tpl" productid=$products[product].productid image_x=70 product=$products[product].product}
{ $lng.lbl_see_details }</a> 
</td> 
<td valign=top> 
{$products[product].productcode | escape} - {$products[product].product|escape}</font> <font class=TableCenterProductTitleOrange></font> 
<font size=1> 

 

 
{$products[product].descr|truncate:300:"...":true} 

 
</font> 
<hr size=1 noshade width=230 align=left> 
{if $active_modules.Subscriptions ne "" and $products[product].catalogprice} 
{include file="modules/Subscriptions/subscription_info_inlist.tpl"} 
{else} 
{if $products[product].price ne 0} 
{if $products[product].discount ne 0} 
<font class=MarketPrice>{$lng.lbl_market_price}: <s>{math equation="(price/(100-discount))*100" price=$products[product].price discount=$products[product].discount format="%d.00" assign=unformatted}{include file="currency.tpl" value=$unformatted}</s></font>
 
{/if} 
<font class=TableCenterProductTitleOrange>{$lng.lbl_our_price}: {include file="currency.tpl" value=$products[product].price}</font><font class=MarketPrice>{include file="customer/main/alter_currency_value.tpl" alter_currency_value=$products[product].price}</font>{if $products[product].discount ne 0}, save {$products[product].discount}%{/if} 
{else} 
<font class=TableCenterProductTitleOrange>{$lng.lbl_enter_your_price}</font> 
{/if} 
{/if} 
</td> 
<tr><td> 
<form name=orderform_{%product.index%} method=post action="cart.php?mode=add"> 
<td align=left> <a href="javascript: document.orderform_{%product.index%}.submit()"> 
{include file="buttons/add_to_cart.tpl"}</a> 
<input type=hidden name=amount value=1> 
<input type=hidden name=mode value=add> 
<input type=hidden name=productid value="{$products[product].productid}"> 
<input type=hidden name=cat value="{$smarty.get.cat}"> 
<input type=hidden name=page value="{$smarty.get.page}"> 
<a href=product.php?productid={$products[product].productid}&cat={$cat}&page={$navigation_page}>
{* {include 
file="buttons/moreinfo.tpl"}
 *}</a> 
</td> 
</form> 
</td> 
</tr> 

</tr> 
</table> 
<table width="100" border="0" cellspacing="0" cellpadding="0"> 
<tr> 
</tr> 
</table> 

 

 

 
</td> 

{/section} 
</td></tr></table> 
</td></tr></table>

[Blackhawk]

BUMP AND HELP!!

[B00MER]

{if $smarty.section.product.index is div by 2} 

should be:

{if $smarty.section.products.index is div by 2} 

note s in products.

I think

{section name=product loop=$products} 

name=product should be products as well, but give those two methods a try.

[Blackhawk]

I've made the changes, but my site is so slow I can't load the front page.. I only have 2400 products, so I'm not sure why..

I've got a call in to my webhosting, but I don't think it's them.. It got slow right as I uploaded my inventory.

so.. I'll test the changes when I can get my site sped up.

Thanks!!

[B00MER]

Run a traceroute or a ping to your host and see if your getting any timeouts or high ping times, if so its your host, if not its the x-cart or mysql that is creeping along.

[Blackhawk]

I tried that.. I did get one time out..
I have called my ISP..

also, what do you consider "high"?
Most were <10ms.. some up to 15-18.. and then a few hit 88ms and one 102ms.