gtmall Posted June 16, 2006 Share Posted June 16, 2006 anyone know that this means: 1054 - Unknown column 'p.products_bimage' in 'field list' select pd.products_name, p.products_image, p.products_bimage from products p left join products_description pd on p.products_id = pd.products_id where p.products_status = '1' and p.products_id = '103' and pd.language_id = '1' [TEP STOP] this happened when i click 'click to enlarge' thanks in advance Link to comment Share on other sites More sharing options...
Guest Posted June 16, 2006 Share Posted June 16, 2006 open your catalog\popup_image.php locate the products_bimage and change it to products_image Link to comment Share on other sites More sharing options...
site Posted December 21, 2006 Share Posted December 21, 2006 hi! same problem, but the popup_image.php looks like: <?php /* $Id: popup_image.php,v 1.18 2003/06/05 23:26:23 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); $navigation->remove_current_page(); $products_query = tep_db_query("select pd.products_name, p.products_image from " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "' and pd.language_id = '" . (int)$languages_id . "'"); $products = tep_db_fetch_array($products_query); ?> <!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 $products['products_name']; ?></title> <base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>"> <script language="javascript"><!-- var i=0; function resize() { if (navigator.appName == 'Netscape') i=40; if (document.images[0]) window.resizeTo(document.images[0].width +30, document.images[0].height+60-i); self.focus(); } //--></script> </head> <body onload="resize();"> <?php echo tep_image(DIR_WS_IMAGES . $products['products_image'], $products['products_name']); ?> </body> </html> <?php require('includes/application_bottom.php'); ?> There is no bimage :/ Link to comment Share on other sites More sharing options...
jdvb Posted December 21, 2006 Share Posted December 21, 2006 then either you do not get this error on the popup window (click to enlarge), or you are not updating the file correctly, couse I see nothing wrong with this popup_image script. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.