Specials

[Ajeh]

That is why I was hoping it was your template or an old file out of date etc.

[klevans]

This is the source for the main page too..

<!-- bof: specials -->
<div class="centerBoxWrapper" id="specialsDefault">
<h2 class="centerBoxHeading">Monthly Specials For August</h2>
<div class="centerBoxContentsSpecials centeredContent back" style="width:100%;"><a href="http://www.jazmin-books.co.uk/index.php?main_page=product_info&amp;cPath=1117_1144&amp;products_id=31538"><img src="http://www.images.jazmin-books.co.uk/images/011/m_9781416948872.jpg" alt="The Tudors: King Takes Queen: Series Two Companion" title=" The Tudors: King Takes Queen: Series Two Companion " width="100" height="150" /></a><br /><a href="http://www.jazmin-books.co.uk/index.php?main_page=product_info&amp;cPath=1117_1144&amp;products_id=31538">The Tudors: King Takes Queen: Series Two Companion</a><br /><span class="normalprice">&pound;9.87 </span>&nbsp;<span class="productSpecialPrice">&pound;9.00</span><span class="productPriceDiscount"><br />Save:&nbsp;9% off</span></div>
<div class="centerBoxContentsSpecials centeredContent back" style="width:100%;"><a href="http://www.jazmin-books.co.uk/index.php?main_page=product_info&amp;cPath=1117_1144&amp;products_id=31538"><img src="http://www.images.jazmin-books.co.uk/images/011/m_9781416948872.jpg" alt="The Tudors: King Takes Queen: Series Two Companion" title=" The Tudors: King Takes Queen: Series Two Companion " width="100" height="150" /></a><br /><a href="http://www.jazmin-books.co.uk/index.php?main_page=product_info&amp;cPath=1117_1144&amp;products_id=31538">The Tudors: King Takes Queen: Series Two Companion</a><br /><span class="normalprice">&pound;9.87 </span>&nbsp;<span class="productSpecialPrice">&pound;9.00</span><span class="productPriceDiscount"><br />Save:&nbsp;9% off</span></div>
<div class="centerBoxContentsSpecials centeredContent back" style="width:100%;"><a href="http://www.jazmin-books.co.uk/index.php?main_page=product_info&amp;cPath=1117_1144&amp;products_id=31538"><img src="http://www.images.jazmin-books.co.uk/images/011/m_9781416948872.jpg" alt="The Tudors: King Takes Queen: Series Two Companion" title=" The Tudors: King Takes Queen: Series Two Companion " width="100" height="150" /></a><br /><a href="http://www.jazmin-books.co.uk/index.php?main_page=product_info&amp;cPath=1117_1144&amp;products_id=31538">The Tudors: King Takes Queen: Series Two Companion</a><br /><span class="normalprice">&pound;9.87 </span>&nbsp;<span class="productSpecialPrice">&pound;9.00</span><span class="productPriceDiscount"><br />Save:&nbsp;9% off</span></div>
<br class="clearBoth" />

</div>
<!-- eof: specials -->

[Ajeh]

In phpMyAdmin ...

When you check the table:
products_to_categories

for the products_id 31538 ... what does the categories_id read?

If you recheck the table:
products

for the products_id 31538 ... what does the master_categories_id now read?

If you run this query in the SQL of phpMyAdmin, do you get 1 row?

select distinct p.products_id, p.products_image, pd.products_name, p.master_categories_id
                             from (products p
                             left join specials s on p.products_id = s.products_id
                             left join products_description pd on p.products_id = pd.products_id )
                             where p.products_id = s.products_id
                             and p.products_id = pd.products_id
                             and p.products_status = '1' and s.status = '1'
                             and pd.language_id = 1
                             and p.products_id in (31538);

[klevans]

products_id categories_id
31538 1144

master_categories_id
1144


products_id products_image products_name master_categories_id
31538 http://www.images.jazmin-books.co.uk/images/011/m_... The Tudors: King Takes Queen: Series Two Companion 1144

[klevans]

I think it could be down to the mass amount of books I have there is over 250k of books in the data base so I guess it might have some problems not sure what the max is for Zen Cart

[Ajeh]

The number of products should not affect this at all ...

I just cannot pinpoint if this is bad data or something with the files ...

Could you edit the file:
/includes/modules/specials_index.php

and around line 52 add this code:

echo 'SQL SAYS: ' . $specials_index_query;
if ($specials_index_query != '') $specials_index = $db->ExecuteRandomMulti($specials_index_query, MAX_DISPLAY_SPECIAL_PRODUCTS_INDEX);

What does that read on the screen?

[klevans]

Hi

Its not just doing it for specials through.

Check this out

http://www.jazmin-books.co.uk/index....Path=1264_1266

When there is not 12 products its doubling them its wired.


I have even done a update query to start adding dates to products inserted but its not really had a effect on it.

[Ajeh]

Any chance you could try adding the echo so we can see what the SELECT is reading?

[klevans]

SQL SAYS: select p.products_id, p.products_image, pd.products_name, p.master_categories_id from (products p left join specials s on p.products_id = s.products_id left join products_description pd on p.products_id = pd.products_id ) where p.products_id = s.products_id and p.products_id = pd.products_id and p.products_status = '1' and s.status = 1 and pd.language_id = '1'

[Ajeh]

That looks correct ...

Without actually seeing your database and code on the server I really cannot go much further with this ...

It strikes me as bad data, or possibly something in the code, but so far we have not pin pointed it ...

You do not have Products and Categories mixed in your Categories do you?