Kjolebutikken Posted July 3, 2006 Share Posted July 3, 2006 Hi, I just installed the "Search engine friendly URL v.1.10" contribution, and my printable catalog disappeard. When I try to open it I get this error: Fatal error: Class 'url_rewrite' not found in /customers/kjolebutikken.com/kjolebutikken.com/httpd.www/oscdemo1/includes/functions/html_output.php on line 70 I've tried to ask on the Search engine friendly contribution support, but did not get any answer, so I will try here. Is it something special with the printable catalog that provokes this error maybe? It works fine except for the printable catalog and for another page I have for comparission of products. Hope somebody can help. Thank you so much:-) Kjolebutikken Quote Best regards Kjolebutikken Link to comment Share on other sites More sharing options...
Logcbnfvr Posted August 14, 2006 Share Posted August 14, 2006 My host just upgraded myphp to 5 and now my printable catalog has errors. Does anyone have the fix for this? I am getting the dreaded 1054 error. I did go to the bug fixes and seem to have everything else working now but the printable catalog. Thank you, Kim Quote Log Cabin Fever Gifts Link to comment Share on other sites More sharing options...
cpeters Posted August 20, 2006 Share Posted August 20, 2006 Greetings unto all, I am attempting to use the printable catalog mod with very little success. I have added all the files and correctly configured it. Yet when I try to pull it up it is not accessing my catalog and the images are not coming up. I have tried putting in the url to my image directory with no success whatsoever. It also says products not found when I try to click on them. Here is my current print_catalog.php file: <?php /* $Id: print_catalog.php,v 1.2 2004/09/17 Stephen Walker SNJ Computers$ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2002 osCommerce Released under the GNU General Public License */ ?> <table class="products" width="100%" border="0" cellspacing="1" cellpadding="1"> <?php if (sizeof($print_catalog_array) == '0') { ?> <tr> <td><?php echo TEXT_NO_NEW_PRODUCTS; ?></td> </tr> <?php } else { for($i=0; $i<sizeof($print_catalog_array); $i++) { if ($print_catalog_array[$i]['specials_price']) { $products_price = '<s>' . $currencies->display_price($print_catalog_array[$i]['price'], tep_get_tax_rate($print_catalog_array[$i]['tax_class_id'])) . '</s> <span class="productSpecialPrice">' . $currencies->display_price($print_catalog_array[$i]['specials_price'], tep_get_tax_rate($print_catalog_array[$i]['tax_class_id'])) . '</span>'; } else { $products_price = $currencies->display_price($print_catalog_array[$i]['price'], tep_get_tax_rate($print_catalog_array[$i]['tax_class_id'])); } ?> <tr> <!-- product name --> <td class="main" align="center"><hr width="95%" align="center"> <?php echo '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $print_catalog_array[$i]['id'], 'NONSSL') . '"><b> ' . $print_catalog_array[$i]['name'] . ' </b></a> '; ?> </td> </tr> <tr> <!-- image & product description --> <td><table width="100%" border="0" cellspacing="5" cellpadding="5"> <tr> <!-- product image --> <td width="" align="center" valign="top"> <?php $linking=''; if(ENABLE_SSL===false){ $linking=HTTP_SERVER . DIR_WS_HTTP_CATALOG; } else{ $linking=HTTP_SERVER . DIR_WS_HTTPS_CATALOG; } echo '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $print_catalog_array[$i]['id'], 'NONSSL') . '"><img border="0" height="80" width="100" src="'. $linking . DIR_WS_IMAGES . $print_catalog_array[$i]['image'] . '"></a>'; ?> </td> <!-- product description --> <td class="products"><?php echo $print_catalog_array[$i]['description']; ?></td> </tr> </table></td> </tr> <tr> <!-- attributes --> <td><!-- product attributes when I figure out the code to get them --></td> </tr> <tr> <!-- other information --> <td><table class="headerContents" width="80%" align="right" border="0" cellspacing="2" cellpadding="2"> <tr> <!-- product price --> <td><?php echo TEXT_PRICE . $products_price; ?></td> <!-- manufacturer --> <td><?php echo TEXT_MANUFACTURER . $print_catalog_array[$i]['manufacturer']; ?></td> </tr> <tr> <!-- model number --> <td><?php echo TEXT_MODEL . $print_catalog_array[$i]['model']; ?></td> <!-- added to inventory --> <td><?php echo TEXT_DATE_ADDED . $print_catalog_array[$i]['date_added']; ?></td> </tr> <?php if (($i+1) != sizeof($print_catalog_array)) { ?> </table></td> </tr> <?php } } } ?> </table> I see others have gotten this working so waht am I doing wrong? NOTE currently I do not have the url fimages inputted. when I do that it inputs it twice into the formatted page. My site is : http://afterdarkfashion.com/print_catalog.php Quote Link to comment Share on other sites More sharing options...
JIM454 Posted September 9, 2006 Share Posted September 9, 2006 Hello did this ever get sorted out? I have read carefully through the replies.Thanks Linda In catalog_print.php find this cd on c.parent_id='0' and change the 0 to 1. Rick www.celticfirestone.com Quote Link to comment Share on other sites More sharing options...
Guest Posted October 7, 2006 Share Posted October 7, 2006 Hi all. Just installed the lasted of Printable Catalog 2.0 and I can NOT for the life of me split the catalog into pages. I have undone //s and then I get an unexpected $ at the end of the file, even though none show. *shrugs* I have over 700 products with roughly 300 more to add. I really don't it all on one page! Any detailed help would be greatly appreciated. Quote Link to comment Share on other sites More sharing options...
Guest Posted October 10, 2006 Share Posted October 10, 2006 Could really use some help with this. I've tried all different way to split the catalog up into multiple pages. All I get are errors. Quote Link to comment Share on other sites More sharing options...
Tsuri Japan Posted November 11, 2006 Share Posted November 11, 2006 I really don't know why your're getting errors....did you install the SQL properly? Check your admin/confi/product listing and you should see the place where you can make the certain amount of images and stuff.... I just installed the 2.0 series and all is well except one small blemish.....it's slightly stretching out my banner and footer out? Any ideas how or why? Here's mine so far: http://www.tsurishopjapan.com/catalog_prod...with_images.php I don't know why it's doing that because I made the spacer thing quite small and that's really the only thing that would stretch out my table so much. Any help would be great and cheers for this one! Nigelman :thumbsup: Quote Link to comment Share on other sites More sharing options...
UncleSteve Posted November 18, 2006 Share Posted November 18, 2006 I've had mine running for a while now. However I've recently had installed a few contribs. I've been assured the database has not been changed, yet I now have a database error. As far as I can establish, my php files are sound.... I've established this by replacing my existing (todays file) database file with an older one, and everything is fine. I've now replaced the back up file with today's file, only to have the error return as expected. My error message is... 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 '-10, 10' at line 1 select distinct p.products_id, p.products_image, p.products_model, p.products_quantity, p.products_weight, pd.products_name, p.manufacturers_id, p.products_price, p.products_date_added, 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, m.manufacturers_name, pd.products_description, cd.categories_name, p.products_tax_class_id, p2c.categories_id from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join categories_description cd on p2c.categories_id = cd.categories_id 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 cd.language_id = '1' order by cd.categories_name DESC, pd.products_name LIMIT -10, 10 [TEP STOP] Is there a way to compare databases? I use a programme called WinMerge to compare normal files. I don't know if it works with databases, but about to try. Thanks in advance for any help and guidence :) Quote ____________________________________________________________________ ____________________________________________________________________ Link to comment Share on other sites More sharing options...
UncleSteve Posted November 18, 2006 Share Posted November 18, 2006 Is there a way to compare databases? I use a programme called WinMerge to compare normal files. I don't know if it works with databases, but about to try. The answer to my question is yes. WinMerge ca be used to compare sql files. I just need to identify the bit causing the error. Quote ____________________________________________________________________ ____________________________________________________________________ Link to comment Share on other sites More sharing options...
UncleSteve Posted November 18, 2006 Share Posted November 18, 2006 I've had mine running for a while now. However I've recently had installed a few contribs. I've been assured the database has not been changed, yet I now have a database error. Now sorted :) The one contrib. I had installed was "Page Cache". After changing this to 'false' in admin, away it went! :D So it looks like I need to investigate why the Page Cache is messing up the database. Quote ____________________________________________________________________ ____________________________________________________________________ Link to comment Share on other sites More sharing options...
Guest Posted November 29, 2006 Share Posted November 29, 2006 UGH! Had ANYONE figured out how to span your printable catalog over multiple pages, instead of one long page? I have over 700 products and it just doesn't work with all products on one page. PLEASE! Changing the numbers within the file hasn't done a darn thing. I was wanting to do 50 products per page. Quote Link to comment Share on other sites More sharing options...
Guest Posted March 27, 2007 Share Posted March 27, 2007 Just for the record: To get Printable Catalog V3.5 MS2 paginating properly, in catalog/catalog_products_with_images.php replace line 351 $limit = mysql_result(mysql_query("SELECT configuration_value from " . TABLE_CONFIGURATION . " WHERE configuration_key = 'PRODUCT_LIST_CATALOG_PERPAGE'"), 0 , 0); with $limit = PRODUCT_LIST_CATALOG_PERPAGE; and this will allow you to set the items per page in your admin menu. FYI: The catalog/catalog_products_with_images_full.php file is set tol display all products in your catalog, and can then be paginated when printed. This is a good contribution if your are looking for a simple way to display a printable, sortable catalog, with links to all products as well! Hope this helps someone, Ed Quote Link to comment Share on other sites More sharing options...
stephenbrett Posted March 27, 2007 Share Posted March 27, 2007 Please help i just installed this contrib and when i open it this appears: 1054 - Unknown column 'p.products_id' in 'on clause' select distinct p.products_id, p.products_image, p.products_model, p.products_quantity, p.products_weight, pd.products_name, p.manufacturers_id, p.products_price, p.products_date_added, 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, m.manufacturers_name, pd.products_description, cd.categories_name, p.products_tax_class_id, p2c.categories_id from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join categories_description cd on p2c.categories_id = cd.categories_id 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 cd.language_id = '1' order by cd.categories_name, pd.products_name [TEP STOP] Now i have searched all over and it mentions about msql 5 etc, though normally to do with other types of contribs or general enquirys on there web site! but none for this contrib. can anyone point me in the right direction, please take a look for yourself http://www.bitsandbytespcs.blogdns.com. thankyou Stephen Quote Link to comment Share on other sites More sharing options...
mdoupal Posted March 31, 2007 Share Posted March 31, 2007 1054 - Unknown column 'p.products_id' in 'on clause' select distinct p.products_id, p.products_image, p.products_model, p.products_quantity, p.products_weight, pd.products_name, p.manufacturers_id, p.products_price, p.products_date_added, 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, m.manufacturers_name, pd.products_description, cd.categories_name, p.products_tax_class_id, p2c.categories_id from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join categories_description cd on p2c.categories_id = cd.categories_id 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 cd.language_id = '1' order by cd.categories_name, pd.products_name [TEP STOP] Hello, I have the same problem with msql 5. Can anybody help me please ? Best Regards Miro Quote Link to comment Share on other sites More sharing options...
frypan Posted April 5, 2007 Share Posted April 5, 2007 :'( Hi, I need someone's help that knows php better than me. ;) I really like the Printable Catalog and have it on my website, however, I would like the user to be able to filter it. For example, to be able to print a catalog for products that contain a particular word. Would you be able to help me with this? Thanks, Jennifer Just for the record: To get Printable Catalog V3.5 MS2 paginating properly, in catalog/catalog_products_with_images.php replace line 351 $limit = mysql_result(mysql_query("SELECT configuration_value from " . TABLE_CONFIGURATION . " WHERE configuration_key = 'PRODUCT_LIST_CATALOG_PERPAGE'"), 0 , 0); with $limit = PRODUCT_LIST_CATALOG_PERPAGE; and this will allow you to set the items per page in your admin menu. FYI: The catalog/catalog_products_with_images_full.php file is set tol display all products in your catalog, and can then be paginated when printed. This is a good contribution if your are looking for a simple way to display a printable, sortable catalog, with links to all products as well! Hope this helps someone, Ed Quote Link to comment Share on other sites More sharing options...
jody00 Posted April 10, 2007 Share Posted April 10, 2007 I have the same issue below - wasnt having it yesterday..... hmmm i am on mysql 4.x any ideas Please help i just installed this contrib and when i open it this appears: 1054 - Unknown column 'p.products_id' in 'on clause' select distinct p.products_id, p.products_image, p.products_model, p.products_quantity, p.products_weight, pd.products_name, p.manufacturers_id, p.products_price, p.products_date_added, 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, m.manufacturers_name, pd.products_description, cd.categories_name, p.products_tax_class_id, p2c.categories_id from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join categories_description cd on p2c.categories_id = cd.categories_id 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 cd.language_id = '1' order by cd.categories_name, pd.products_name [TEP STOP] Now i have searched all over and it mentions about msql 5 etc, though normally to do with other types of contribs or general enquirys on there web site! but none for this contrib. can anyone point me in the right direction, please take a look for yourself http://www.bitsandbytespcs.blogdns.com. thankyou Stephen Quote Link to comment Share on other sites More sharing options...
dcc Posted April 11, 2007 Share Posted April 11, 2007 I would like to know if anyone is expericencing the same problems i am with the printable catalog and search engines. For example if I google a product with maufacturers name i.e. simat shears. Instead of the actual product getting listed . Google displays the entire printable catalog. How do I get around not having the printable catalog apear in search engine results??? Thanks Quote Link to comment Share on other sites More sharing options...
Mystex Posted May 3, 2007 Share Posted May 3, 2007 I'm having problems with my catalog paginating. I'm using Printable Catalog V3.5 MS2. Everything looks ok but its not going to another page when you click on the navigation bar at the bottom. Here's my store that i'm working with right now I set the items per page to 3 so that I could test it but I've yet to figure out why its not paginating. Any and all help with this would definetly be appreciated. Quote Link to comment Share on other sites More sharing options...
Guest Posted May 6, 2007 Share Posted May 6, 2007 Thanks, but I guess we're talking about two different printable catalog contribs ... mine only has catalog/print_catalog.php, which I will display at the end of this post. Just for the record: To get Printable Catalog V3.5 MS2 paginating properly, in catalog/catalog_products_with_images.php replace line 351 $limit = mysql_result(mysql_query("SELECT configuration_value from " . TABLE_CONFIGURATION . " WHERE configuration_key = 'PRODUCT_LIST_CATALOG_PERPAGE'"), 0 , 0); with $limit = PRODUCT_LIST_CATALOG_PERPAGE; and this will allow you to set the items per page in your admin menu. FYI: The catalog/catalog_products_with_images_full.php file is set tol display all products in your catalog, and can then be paginated when printed. This is a good contribution if your are looking for a simple way to display a printable, sortable catalog, with links to all products as well! Hope this helps someone, Ed <?php /* $Id: print_catalog.php,v 1.2 2004/09/17 Stephen Walker SNJ Computers$ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2002 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_PRINT_CATALOG); $breadcrumb->add(NAVBAR_TITLE, tep_href_link(FILENAME_PRINT_CATALOG, '', 'NONSSL')); ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html <?php echo HTML_PARAMS; ?>> <head> <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> <title><?php echo TITLE; ?></title> <base href="<?php echo (getenv('HTTPS') == 'on' ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>"> <link rel="stylesheet" type="text/css" href="catalogstylesheet.css"> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0"> <table class="uebersicht"> <tr> <!-- header --> <td><table class="header" width="80%" border="0" cellspacing="0" cellpadding="0" align="center"> <tr> <td><table class="headerContents" width="100%" border="0" cellspacing="2" cellpadding="2"> <tr> <td align="left"><?php echo tep_image(DIR_WS_IMAGES . 'sitebanner2.jpg', 'Moonlight Delights'); ?></td> <td align="right"><?php echo nl2br(STORE_NAME_ADDRESS); ?></td> </tr> </table></td> </tr> <tr> <td><table class="headerContents" width="100%" border="0" cellspacing="2" cellpadding="2"> <tr> <td align="right"><?php echo (HEADER_TEXT_1) . ' ' . strftime(DATE_FORMAT_LONG); ?></td> </tr> </table></td> </tr> </table></td> <!-- header-eof --> </tr> <?php $print_catalog_query_raw = "select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, cd.categories_name, m.manufacturers_name from " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c on p.products_id=p2c.products_id left join " . TABLE_CATEGORIES . " c on p2c.categories_id=c.categories_id left join " . TABLE_CATEGORIES_DESCRIPTION . " cd on c.parent_id='0' and c.categories_id=cd.categories_id left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where products_status = '1' order by cd.categories_name, c.parent_id, c.sort_order, c.categories_id, pd.products_name"; //$print_catalog_split = new splitPageResults($print_catalog_query_raw, MAX_DISPLAY_PRINT_CATALOG); //$featured_products_split = new splitPageResults($featured_products_query_raw, MAX_DISPLAY_FEATURED_PRODUCTS); $print_catalog_query = tep_db_query($print_catalog_query_raw); while ($print_catalog = tep_db_fetch_array($print_catalog_query)) { $print_catalog_array[] = array('id' => $print_catalog['products_id'], 'name' => $print_catalog['products_name'], 'description' => $print_catalog['products_description'], 'model' => $print_catalog['products_model'], 'image' => $print_catalog['products_image'], 'price' => $print_catalog['products_price'], 'specials_price' => $print_catalog['specials_new_products_price'], 'tax_class_id' => $print_catalog['products_tax_class_id']); } ?> <tr> <!-- top page navigation --> <!-- <td><table class="header" border="0" width="100%" cellspacing="2" cellpadding="2"> <tr> <td class="smallText"> <?php //echo $print_catalog_split->display_count(TEXT_DISPLAY_NUMBER_OF_PRODUCTS); ?> </td> <td align="right" class="smallText"> <?php //echo TEXT_RESULT_PAGE; //echo $print_catalog_split->display_links(MAX_DISPLAY_PAGE_LINKS, tep_get_all_get_params(array('page', 'info', 'x', 'y'))); ?> </td> </tr> </table></td> --> <!-- top page navigation-eof --> </tr> <tr> <!-- catalog --> <td><?php require(DIR_WS_MODULES . 'print_catalog.php');?></td> <!-- catalog-eof --> </tr> <?php //if (($print_catalog_split->number_of_rows > 50) && (PREV_NEXT_BAR_LOCATION == '2' || PREV_NEXT_BAR_LOCATION == '3')) { ?> <tr> <!-- bottom page navigation --> <!-- <td><table class="header" border="0" width="100%" cellspacing="2" cellpadding="2"> <tr> <td class="smallText"> <?php //echo $print_catalog_split->display_count(TEXT_DISPLAY_NUMBER_OF_PRODUCTS); ?> </td> <td align="right" class="smallText"> <?php //echo TEXT_RESULT_PAGE; //echo $print_catalog_split->display_links(MAX_DISPLAY_PAGE_LINKS, tep_get_all_get_params(array('page', 'info', 'x', 'y'))); ?> </td> </tr> </table></td> --> <!-- bottom page navigation-eof --> </tr> <?php // } ?> <tr> <!-- footer --> <td><table class="footer" width="100%" border="0" cellspacing="2" cellpadding="2"> <tr> <td align="center"><?php echo (FOOTER_TEXT_BODY); ?></td> </tr> </table></td> <!-- footer-eof --> </tr> </table> </body> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?> Quote Link to comment Share on other sites More sharing options...
cdickson Posted May 7, 2007 Share Posted May 7, 2007 I'm having this problem too: all paginated pages show the same products. I was hoping that timidphper's easy fix would work, but unfortunately it doesn't (same versions of OSC and the mod). I can sort the products by category, price, etc. and the products do change. It is only when I use the pagination links at the bottom of the page that the same products keep appearing, so there is something in the pagination code that seems to be off. Any suggestions? Just for the record: To get Printable Catalog V3.5 MS2 paginating properly, in catalog/catalog_products_with_images.php replace line 351 $limit = mysql_result(mysql_query("SELECT configuration_value from " . TABLE_CONFIGURATION . " WHERE configuration_key = 'PRODUCT_LIST_CATALOG_PERPAGE'"), 0 , 0); with $limit = PRODUCT_LIST_CATALOG_PERPAGE; and this will allow you to set the items per page in your admin menu. FYI: The catalog/catalog_products_with_images_full.php file is set tol display all products in your catalog, and can then be paginated when printed. This is a good contribution if your are looking for a simple way to display a printable, sortable catalog, with links to all products as well! Hope this helps someone, Ed Quote cdickson Link to comment Share on other sites More sharing options...
Leak-Proof Posted May 28, 2007 Share Posted May 28, 2007 Hi. A) I would like to use the product description column but my product descriptions have alot of HTML in them that mess up the printable catalog page because of the font sizes etc.. I would like to put in a strip tags to take it out. Where do I put it and how? B) Also, The currency drop down streches all the way across the page at the top. I would like to shorten that up with a size (width) restiction. I think this is the section of code: <?PHP if (PRODUCT_LIST_CATALOG_CURRENCY == 'show') { require(DIR_WS_BOXES . 'currencies.php'); } ?> How does one do that? How do I change the Font type and size? Quote I like these mods, there fun! ...65 70 72 75 80 85 125+ contributions installed and counting... Tools I'm using: OSC2.2 milestone2, Filezilla for FTP, PHP Designer 2007PE (nice), Araxis Merge 6.5 to compare files, XP(my box), Remote Server is shared Apache 1.3 Cpanel, CURL, and PHPmyAdmin through my hosts Cpanel to mess up the database. Link to comment Share on other sites More sharing options...
cdickson Posted May 31, 2007 Share Posted May 31, 2007 bump? I have uninstalled and reinstalled this mod with the same results. You can view the error in action at http://www.blaineraytprs.com/catalog_produ...with_images.php. I'm having this problem too: all paginated pages show the same products. I was hoping that timidphper's easy fix would work, but unfortunately it doesn't (same versions of OSC and the mod). I can sort the products by category, price, etc. and the products do change. It is only when I use the pagination links at the bottom of the page that the same products keep appearing, so there is something in the pagination code that seems to be off. Any suggestions? Quote cdickson Link to comment Share on other sites More sharing options...
weerd Posted June 20, 2007 Share Posted June 20, 2007 I have the same issue below - wasnt having it yesterday..... hmmmi am on mysql 4.x any ideas Hi all, I've seen this problem before - it has to do with the mysql syntax and adding brackets in newer versions of mysql. this is the code that worked fo me: $products_query_raw = "select distinct p.products_id, p.products_image, p.products_model, p.products_quantity, p.products_weight, pd.products_name, p.manufacturers_id, p.products_price, p.products_date_added, 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, m.manufacturers_name, pd.products_description, cd.categories_name, p.products_tax_class_id, p2c.categories_id from (" . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c) left join " . TABLE_CATEGORIES_DESCRIPTION . " cd on p2c.categories_id = cd.categories_id left join " . TABLE_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 = '" . $languages_id . "' and cd.language_id = '" . $languages_id . "' order by $order"; Note the added open and close brackets "(" & ")" near TABLE_PRODUCTS_DESCRIPTION and TABLE_PRODUCTS_TO_CATEGORIES. Change this in both catalog_products_with_images.php & in catalog_products_with_images_full.php Hope this helps! And Thanks for the great contrib! :thumbsup: Quote Link to comment Share on other sites More sharing options...
Guest Posted July 23, 2007 Share Posted July 23, 2007 Hi all,I've seen this problem before - it has to do with the mysql syntax and adding brackets in newer versions of mysql. this is the code that worked fo me: $products_query_raw = "select distinct p.products_id, p.products_image, p.products_model, p.products_quantity, p.products_weight, pd.products_name, p.manufacturers_id, p.products_price, p.products_date_added, 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, m.manufacturers_name, pd.products_description, cd.categories_name, p.products_tax_class_id, p2c.categories_id from (" . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c) left join " . TABLE_CATEGORIES_DESCRIPTION . " cd on p2c.categories_id = cd.categories_id left join " . TABLE_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 = '" . $languages_id . "' and cd.language_id = '" . $languages_id . "' order by $order"; Note the added open and close brackets "(" & ")" near TABLE_PRODUCTS_DESCRIPTION and TABLE_PRODUCTS_TO_CATEGORIES. Change this in both catalog_products_with_images.php & in catalog_products_with_images_full.php Hope this helps! And Thanks for the great contrib! :thumbsup: Hey, I'm having the same problem here. Can you please, let me know where I must insert that code? :sweating: I'm sorry for asking you that, I'm sure this might be a newby question but I can't find the solution for my problem. Thanks for your help Quote Link to comment Share on other sites More sharing options...
Guest Posted July 25, 2007 Share Posted July 25, 2007 Could someone please help? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.