nelo 0 Posted April 3, 2005 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 Share this post Link to post Share on other sites
boxtel 1 Posted April 3, 2005 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.... Treasurer MFC Share this post Link to post Share on other sites
Hkanaris 0 Posted April 5, 2005 I have the same error, anyone know how to fix? Share this post Link to post Share on other sites
ondriab 0 Posted June 6, 2005 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 Share this post Link to post Share on other sites
hotnuts21 0 Posted July 12, 2005 (edited) 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 Feel free to ask me for help beep... beep....My Pager Share this post Link to post Share on other sites
hotnuts21 0 Posted July 12, 2005 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); Feel free to ask me for help beep... beep....My Pager Share this post Link to post Share on other sites