Product Listing view change

[nelo 0]

halli hallo, I am trying to install the contribution from Norio Itabashi (12 March 2005) called "Product Listing view change" and following the installation instructions I get the following error in the catalog product listing:

 

1064 - 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 'select p.products_image, m.manufacturers_name, p.products_model

select count(select p.products_image, m.manufacturers_name, p.products_model, pd.products_name, p.products_quantity, p.products_weight, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = \'1\' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = \'1\' and p2c.categories_id = \'10\' order by pd.products_name) as total

[TEP STOP]

 

does anybody know what's wrong, why it does not work on my localhost/catalog ?

 

thanx, :huh:

nelo

[boxtel 1]

halli hallo, I am trying to install the contribution from Norio Itabashi (12 March 2005) called "Product Listing view change" and following the installation instructions I get the following error in the catalog product listing:

 

1064 - 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 'select p.products_image, m.manufacturers_name, p.products_model

select count(select p.products_image, m.manufacturers_name, p.products_model, pd.products_name, p.products_quantity, p.products_weight, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = \'1\' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = \'1\' and p2c.categories_id = \'10\' order by pd.products_name) as total

[TEP STOP]

 

does anybody know what's wrong, why it does not work on my localhost/catalog ?

 

thanx,    :huh:

  nelo

<{POST_SNAPBACK}>

 

 

not sure what you are trying to do here but my best bet is to remove the second select in:

 

select count(select p.products....

[Hkanaris 0]

I have the same error, anyone know how to fix?

[ondriab 0]

I am having the same problem. I have gone back over the instructions several times to make sure I didn't miss anything. Did anyone ever figure this one out?

 

 

Thanks,

Andrea

[hotnuts21 0]

Just wondering if anyone sorted this out?

 

I think the problem is in this bit of code.

 

  $listing_numrows_sql = $listing_sql;
 $listing_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_SEARCH_RESULTS, $listing_sql, $listing_numrows);
// fix counted products
 $listing_numrows = tep_db_query($listing_numrows_sql);
 $listing_numrows = tep_db_num_rows($listing_numrows);

Edited July 12, 2005 by hotnuts21

[hotnuts21 0]

I changed the above for the following, works for my needs, but might not be great for your needs.

<?php
 $listing_numrows_sql = $listing_sql;
 $listing_split = new splitPageResults($listing_sql, MAX_DISPLAY_SEARCH_RESULTS,  'p.products_id', $HTTP_GET_VARS['page']);
// fix counted products
 $listing_numrows = tep_db_query($listing_numrows_sql);
 $listing_numrows = tep_db_num_rows($listing_numrows);