Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

JUST RELEASED! Printable Catalog


Guest

Recommended Posts

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

Best regards

Kjolebutikken

Link to comment
Share on other sites

  • 1 month later...

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

Log Cabin Fever Gifts

Link to comment
Share on other sites

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

Link to comment
Share on other sites

  • 3 weeks later...
  • 4 weeks later...

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.

Link to comment
Share on other sites

  • 1 month later...

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:

Link to comment
Share on other sites

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 :)

____________________________________________________________________

____________________________________________________________________

Link to comment
Share on other sites

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.

____________________________________________________________________

____________________________________________________________________

Link to comment
Share on other sites

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.

____________________________________________________________________

____________________________________________________________________

Link to comment
Share on other sites

  • 2 weeks later...

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.

Link to comment
Share on other sites

  • 3 months later...

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

:'(

 

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

  • 3 weeks later...

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.

Link to comment
Share on other sites

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'); ?>

Link to comment
Share on other sites

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

cdickson

Link to comment
Share on other sites

  • 3 weeks later...

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?

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

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?

cdickson

Link to comment
Share on other sites

  • 3 weeks later...
I have the same issue below - wasnt having it yesterday..... hmmm

i 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:

Link to comment
Share on other sites

  • 1 month later...
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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...