chrometweaks.org

How do I connect coldfusion to an access database on iPage.com?

Click Here To View All Answers...


Quick question: How do I connect coldfusion to an access database on iPage.com? Thanks in advance for any comment. Another question... Could someone send me a copy of their catalog/product_info.php? I don't know what i've done to mine, but it's definitely not working!.

If you have a copy where the text box is already removed that would be soooo FABULOUS!!!!.

Thanks for any help in advance!!..

Comments (178)

Good question... I dunno what is the right answer to your question. I'll do some research and get back to you if I got an useful answer. You should email the people at iPage as they probably can answer it..

Comment #1

Download a copy of osc into a temp directory and use the one from there...

Comment #2

Ok that I can do since I'm not getting anywhere trying to fix it..

Could you please tell me the correct way to remove the "review" button from the product info page?.

The way that I found in the forum to do it is causing a fatal error on my product info page..

Thanks again.....

Comment #3

Here it is....

<! header //><!p require(DIR_WS_INCLUDES'header.php');><! header_eof //><! body //><table cellspacing="3" cellpadding="3" width="100%" border="0"><tbody><tr><td valign="top"><table cellspacing="0" cellpadding="2" border="0"><! left_navigation //><!p require(DIR_WS_INCLUDES'column_left.php');><! left_navigation_eof //><tbody></tbody></table></td><! body_text //><td valign="top" width="100%"><!p echo tep_draw_form('cart_quantity', tep_href_link(FILENAME_PRODUCT_INFO, tep_get_all_get_params(array('action'))'action=add_product'));><table cellspacing="0" cellpadding="0" width="100%" border="0"><!p.

 if ($product_check['total'] < 1) {.

><tbody><tr><td><!p new infoBox(array(array('text'>TEXT_PRODUCT_NOT_FOUND))); ?&gt;</td></tr><tr><td><!p echo tep_draw_separator('pixel_trans.gif', '100%', '10');></td></tr><tr><td><table class="infoBox" cellspacing="1" cellpadding="2" width="100%" border="0"><tbody><tr class="infoBoxContents"><td><table cellspacing="0" cellpadding="2" width="100%" border="0"><tbody><tr><td width="10"><!p echo tep_draw_separator('pixel_trans.gif', '10', '1');></td><td align="right"><!p echo '<a href="'tep_href_link(FILENAME_DEFAULT)'">'tep_image_button('button_continue.gif', IMAGE_BUTTON_CONTINUE)'</a>';></td><td width="10"><!p echo tep_draw_separator('pixel_trans.gif', '10', '1');></td></tr></tbody></table></td></tr></tbody></table></td></tr><!p.

 } else {.

   $product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from "TABLE_PRODUCTS" p, "TABLE_PRODUCTS_DESCRIPTION" pd where p.products_status = '1' and p.products_id = '"(int)$HTTP_GET_VARS['products_id']"' and pd.products_id = p.products_id and pd.language_id = '"(int)$languages_id"'");.

   $product_info = tep_db_fetch_array($product_info_query);.

   tep_db_query("update "TABLE_PRODUCTS_DESCRIPTION" set products_viewed = products_viewed+1 where products_id = '"(int)$HTTP_GET_VARS['products_id']"' and language_id = '"(int)$languages_id"'");.

   if ($new_price = tep_get_products_special_price($product_info['products_id'])) {.

     $products_price = '<s>'$currencie><>display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id']))'</s /> <span class="productSpecialPrice">'$currencies-&gt;display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id']))'</span>'; } else { $products_price = $currencies-&gt;display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])); } if (tep_not_null($product_info['products_model'])) { $products_name = $product_info['products_name']'<br /><span class="smallText">['$product_info['products_model']']</span>'; } else { $products_name = $product_info['products_name']; } ?&gt; </><tr><td><table cellspacing="0" cellpadding="0" width="100%" border="0"><tbody><tr><td class="pageHeading" valign="top"><!p echo $products_name;></td><td class="pageHeading" valign="top" align="right"><!p echo $products_price;></td></tr></tbody></table></td></tr><tr><td><!p echo tep_draw_separator('pixel_trans.gif', '100%', '10');></td></tr><tr><td class="main"><!p.

   if (tep_not_null($product_info['products_image'])) {.

><table cellspacing="0" cellpadding="2" align="right" border="0"><tbody><tr><td class="smallText" align="center"><script language="javascript"></script><noscript /></td></tr></tbody></table><!p.

   }.

><p><!p echo stripslashes($product_info['products_description']);></p><!p.

   $products_attributes_query = tep_db_query("select count(*) as total from "TABLE_PRODUCTS_OPTIONS" popt, "TABLE_PRODUCTS_ATTRIBUTES" patrib where patrib.products_id='"(int)$HTTP_GET_VARS['products_id']"' and patrib.options_id = popt.products_options_id and popt.language_id = '"(int)$languages_id"'");.

   $products_attributes = tep_db_fetch_array($products_attributes_query);.

   if ($products_attributes['total'>0) { ?&gt; <table cellspacing="0" cellpadding="2" border="0"><tbody><tr><td class="main" colspan="2"><!p echo TEXT_PRODUCT_OPTIONS;></td></tr><!p.

     $products_options_name_query = tep_db_query("select distinct popt.products_options_id, popt.products_options_name from "TABLE_PRODUCTS_OPTIONS" popt, "TABLE_PRODUCTS_ATTRIBUTES" patrib where patrib.products_id='"(int)$HTTP_GET_VARS['products_id']"' and patrib.options_id = popt.products_options_id and popt.language_id = '"(int)$languages_id"' order by popt.products_options_name");.

     while ($products_options_name = tep_db_fetch_array($products_options_name_query)) {.

       $products_options_array = array();.

       $products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from "TABLE_PRODUCTS_ATTRIBUTES" pa, "TABLE_PRODUCTS_OPTIONS_VALUES" pov where pa.products_id = '"(int)$HTTP_GET_VARS['products_id']"' and pa.options_id = '"(int)$products_options_name['products_options_id']"' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '"(int)$languages_id"'");.

       while ($products_options = tep_db_fetch_array($products_options_query)) {.

         $products_options_array[] = array('id'><>$products_options['products_options_values_id'], 'text' =&gt; $products_options['products_options_values_name']); if ($products_options['options_values_price'] != '0') { $products_options_array[sizeof($products_options_array)-1]['text'] .= ' ('$products_options['price_prefix']$currencies-&gt;display_price($products_options['options_values_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) .') '; } } if (isset($cart-&gt;contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']])) { $selected_attribute = $cart-&gt;contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']]; } else { $selected_attribute = false; } ?&gt; </><tr><td class="main"><!p echo $products_options_name['products_options_name']':';></td><td class="main"><!p echo tep_draw_pull_down_menu('id['$products_options_name['products_options_id']']', $products_options_array, $selected_attribute);></td></tr><!p.

     }.

></tbody></table><!p.

   }.

></td></tr><tr><td><!p echo tep_draw_separator('pixel_trans.gif', '100%', '10');></td></tr><!p.

   $reviews_query = tep_db_query("select count(*) as count from "TABLE_REVIEWS" where products_id = '"(int)$HTTP_GET_VARS['products_id']"'");.

   $reviews = tep_db_fetch_array($reviews_query);.

   if ($reviews['count'><>0) { ?&gt; </><tr><td class="main"><!p echo TEXT_CURRENT_REVIEWS' '$reviews['count'];></td></tr><tr><td><!p echo tep_draw_separator('pixel_trans.gif', '100%', '10');></td></tr><!p.

   }.

   if (tep_not_null($product_info['products_url'])) {.

><tr><td class="main"><!p echo sprintf(TEXT_MORE_INFORMATION, tep_href_link(FILENAME_REDIRECT, 'action=url&goto='urlencode($product_info['products_url']), 'NONSSL', true, false));></td></tr><tr><td><!p echo tep_draw_separator('pixel_trans.gif', '100%', '10');></td></tr><!p.

   }.

   if ($product_info['products_date_available'><>date('Y-m-d H:i:s')) { ?&gt; </><tr><td class="smallText" align="center"><!p echo sprintf(TEXT_DATE_AVAILABLE, tep_date_long($product_info['products_date_available']));></td></tr><!p.

   } else {.

><tr><td class="smallText" align="center"><!p echo sprintf(TEXT_DATE_ADDED, tep_date_long($product_info['products_date_added']));></td></tr><!p.

   }.

><tr><td><!p echo tep_draw_separator('pixel_trans.gif', '100%', '10');></td></tr><tr><td><table class="infoBox" cellspacing="1" cellpadding="2" width="100%" border="0"><tbody><tr class="infoBoxContents"><td><table cellspacing="0" cellpadding="2" width="100%" border="0"><tbody><tr><td width="10"><!p echo tep_draw_separator('pixel_trans.gif', '10', '1');></td><td class="main"><!p echo '<a href="'tep_href_link(FILENAME_PRODUCT_REVIEWS, tep_get_all_get_params())'">'tep_image_button('button_reviews.gif', IMAGE_BUTTON_REVIEWS)'</a>';></td><td class="main" align="right"><!p echo tep_draw_hidden_field('products_id', $product_info['products_id'])tep_image_submit('button_in_cart.gif', IMAGE_BUTTON_IN_CART);></td><td width="10"><!p echo tep_draw_separator('pixel_trans.gif', '10', '1');></td></tr></tbody></table></td></tr></tbody></table></td></tr><tr><td><!p echo tep_draw_separator('pixel_trans.gif', '100%', '10');></td></tr><tr><td><!p.

   if ((USE_CACHE == 'true') && empty($SID)) {.

     echo tep_cache_also_purchased(3600);.

   } else {.

     include(DIR_WS_MODULESFILENAME_ALSO_PURCHASED_PRODUCTS);.

   }.

 }.

></td></tr></tbody></table></form /></td><! body_text_eof //><td valign="top"><table cellspacing="0" cellpadding="2" border="0"><! right_navigation //><!p require(DIR_WS_INCLUDES'column_right.php');><! right_navigation_eof //><tbody></tbody></table></td></tr></tbody></table><! body_eof //><! footer //><!p require(DIR_WS_INCLUDES'footer.php');><! footer_eof //><br />..

Comment #4

Actually here's a copy out of my editor instead.

<?php.

/*.

 $Id: product_info.php,v 1.97 2003/07/01 14:34:54 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');.

 require(DIR_WS_LANGUAGES$language'/'FILENAME_PRODUCT_INFO);.

 $product_check_query = tep_db_query("select count(*) as total from "TABLE_PRODUCTS" p, "TABLE_PRODUCTS_DESCRIPTION" pd where p.products_status = '1' and p.products_id = '"(int)$HTTP_GET_VARS['products_id']"' and pd.products_id = p.products_id and pd.language_id = '"(int)$languages_id"'");.

 $product_check = tep_db_fetch_array($product_check_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 TITLE; ?></title>.

<base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER)DIR_WS_CATALOG; ?>">.

<link rel="stylesheet" type="text/css" href="stylesheet.css">.

<script language="javascript"><!.

Function popupWindow(url) {.

 window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,res.

Izable=yes,copyhistory=no,width=100,height=100,screenX=150,screenY=150,top=150,le.

Ft=150').

}.

//></script>.

</head>.

<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">.

<! header //>.

<?php require(DIR_WS_INCLUDES'header.php'); ?>.

<! header_eof //>.

<! body //>.

<table border="0" width="100%" cellspacing="3" cellpadding="3">.

 <tr>.

   <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">.

<! left_navigation //>.

<?php require(DIR_WS_INCLUDES'column_left.php'); ?>.

<! left_navigation_eof //>.

   </table></td>.

<! body_text //>.

   <td width="100%" valign="top"><?php echo tep_draw_form('cart_quantity', tep_href_link(FILENAME_PRODUCT_INFO, tep_get_all_get_params(array('action'))'action=add_product')); ?><table border="0" width="100%" cellspacing="0" cellpadding="0">.

<?php.

 if ($product_check['total'] < 1) {.

?>.

     <tr>.

       <td><?php new infoBox(array(array('text' => TEXT_PRODUCT_NOT_FOUND))); ?></td>.

     </tr>.

     <tr>.

       <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>.

     </tr>.

     <tr>.

       <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">.

         <tr class="infoBoxContents">.

           <td><table border="0" width="100%" cellspacing="0" cellpadding="2">.

             <tr>.

               <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>.

               <td align="right"><?php echo '<a href="'tep_href_link(FILENAME_DEFAULT)'">'tep_image_button('button_continue.gif', IMAGE_BUTTON_CONTINUE)'</a>'; ?></td>.

               <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>.

             </tr>.

           </table></td>.

         </tr>.

       </table></td>.

     </tr>.

<?php.

 } else {.

   $product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from "TABLE_PRODUCTS" p, "TABLE_PRODUCTS_DESCRIPTION" pd where p.products_status = '1' and p.products_id = '"(int)$HTTP_GET_VARS['products_id']"' and pd.products_id = p.products_id and pd.language_id = '"(int)$languages_id"'");.

   $product_info = tep_db_fetch_array($product_info_query);.

   tep_db_query("update "TABLE_PRODUCTS_DESCRIPTION" set products_viewed = products_viewed+1 where products_id = '"(int)$HTTP_GET_VARS['products_id']"' and language_id = '"(int)$languages_id"'");.

   if ($new_price = tep_get_products_special_price($product_info['products_id'])) {.

     $products_price = '<s>'$currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id']))'</s> <span class="productSpecialPrice">'$currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id']))'</span>';.

   } else {.

     $products_price = $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id']));.

   }.

   if (tep_not_null($product_info['products_model'])) {.

     $products_name = $product_info['products_name']'<br><span class="smallText">['$product_info['products_model']']</span>';.

   } else {.

     $products_name = $product_info['products_name'];.

   }.

?>.

     <tr>.

       <td><table border="0" width="100%" cellspacing="0" cellpadding="0">.

         <tr>.

           <td class="pageHeading" valign="top"><?php echo $products_name; ?></td>.

           <td class="pageHeading" align="right" valign="top"><?php echo $products_price; ?></td>.

         </tr>.

       </table></td>.

     </tr>.

     <tr>.

       <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>.

     </tr>.

     <tr>.

       <td class="main">.

<?php.

   if (tep_not_null($product_info['products_image'])) {.

?>.

         <table border="0" cellspacing="0" cellpadding="2" align="right">.

           <tr>.

             <td align="center" class="smallText">.

<script language="javascript"><!.

Document.write('<?php echo '<a href="javascript:popupWindow(\\\''tep_href_link(FILENAME_POPUP_IMAGE, 'pID='$product_info['products_id'])'\\\')">'tep_image(DIR_WS_IMAGES$product_info['products_image'], addslashes($product_info['products_name']), SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"')'<br>'TEXT_CLICK_TO_ENLARGE'</a>'; ?>');.

//></script>.

<noscript>.

<?php echo '<a href="'tep_href_link(DIR_WS_IMAGES$product_info['products_image'])'" target="_blank">'tep_image(DIR_WS_IMAGES$product_info['products_image'], $product_info['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"')'<br>'TEXT_CLICK_TO_ENLARGE'</a>'; ?>.

</noscript>.

             </td>.

           </tr>.

         </table>.

<?php.

   }.

?>.

         <p><?php echo stripslashes($product_info['products_description']); ?></p>.

<?php.

   $products_attributes_query = tep_db_query("select count(*) as total from "TABLE_PRODUCTS_OPTIONS" popt, "TABLE_PRODUCTS_ATTRIBUTES" patrib where patrib.products_id='"(int)$HTTP_GET_VARS['products_id']"' and patrib.options_id = popt.products_options_id and popt.language_id = '"(int)$languages_id"'");.

   $products_attributes = tep_db_fetch_array($products_attributes_query);.

   if ($products_attributes['total'] > 0) {.

?>.

         <table border="0" cellspacing="0" cellpadding="2">.

           <tr>.

             <td class="main" colspan="2"><?php echo TEXT_PRODUCT_OPTIONS; ?></td>.

           </tr>.

<?php.

     $products_options_name_query = tep_db_query("select distinct popt.products_options_id, popt.products_options_name from "TABLE_PRODUCTS_OPTIONS" popt, "TABLE_PRODUCTS_ATTRIBUTES" patrib where patrib.products_id='"(int)$HTTP_GET_VARS['products_id']"' and patrib.options_id = popt.products_options_id and popt.language_id = '"(int)$languages_id"' order by popt.products_options_name");.

     while ($products_options_name = tep_db_fetch_array($products_options_name_query)) {.

       $products_options_array = array();.

       $products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from "TABLE_PRODUCTS_ATTRIBUTES" pa, "TABLE_PRODUCTS_OPTIONS_VALUES" pov where pa.products_id = '"(int)$HTTP_GET_VARS['products_id']"' and pa.options_id = '"(int)$products_options_name['products_options_id']"' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '"(int)$languages_id"'");.

       while ($products_options = tep_db_fetch_array($products_options_query)) {.

         $products_options_array[] = array('id' => $products_options['products_options_values_id'], 'text' => $products_options['products_options_values_name']);.

         if ($products_options['options_values_price'] != '0') {.

           $products_options_array[sizeof($products_options_array)-1]['text'] .= ' ('$products_options['price_prefix']$currencies->display_price($products_options['options_values_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) .') ';.

         }.

       }.

       if (isset($cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']])) {.

         $selected_attribute = $cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']];.

       } else {.

         $selected_attribute = false;.

       }.

?>.

           <tr>.

             <td class="main"><?php echo $products_options_name['products_options_name']':'; ?></td>.

             <td class="main"><?php echo tep_draw_pull_down_menu('id['$products_options_name['products_options_id']']', $products_options_array, $selected_attribute); ?></td>.

           </tr>.

<?php.

     }.

?>.

         </table>.

<?php.

   }.

?>.

       </td>.

     </tr>.

     <tr>.

       <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>.

     </tr>.

<?php.

   $reviews_query = tep_db_query("select count(*) as count from "TABLE_REVIEWS" where products_id = '"(int)$HTTP_GET_VARS['products_id']"'");.

   $reviews = tep_db_fetch_array($reviews_query);.

   if ($reviews['count'] > 0) {.

?>.

     <tr>.

       <td class="main"><?php echo TEXT_CURRENT_REVIEWS' '$reviews['count']; ?></td>.

     </tr>.

     <tr>.

       <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>.

     </tr>.

<?php.

   }.

   if (tep_not_null($product_info['products_url'])) {.

?>.

     <tr>.

       <td class="main"><?php echo sprintf(TEXT_MORE_INFORMATION, tep_href_link(FILENAME_REDIRECT, 'action=url&goto='urlencode($product_info['products_url']), 'NONSSL', true, false)); ?></td>.

     </tr>.

     <tr>.

       <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>.

     </tr>.

<?php.

   }.

   if ($product_info['products_date_available'] > date('Y-m-d H:i:s')) {.

?>.

     <tr>.

       <td align="center" class="smallText"><?php echo sprintf(TEXT_DATE_AVAILABLE, tep_date_long($product_info['products_date_available'])); ?></td>.

     </tr>.

<?php.

   } else {.

?>.

     <tr>.

       <td align="center" class="smallText"><?php echo sprintf(TEXT_DATE_ADDED, tep_date_long($product_info['products_date_added'])); ?></td>.

     </tr>.

<?php.

   }.

?>.

     <tr>.

       <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>.

     </tr>.

     <tr>.

       <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">.

         <tr class="infoBoxContents">.

           <td><table border="0" width="100%" cellspacing="0" cellpadding="2">.

             <tr>.

               <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>.

               <td class="main"><?php echo '<a href="'tep_href_link(FILENAME_PRODUCT_REVIEWS, tep_get_all_get_params())'">'tep_image_button('button_reviews.gif', IMAGE_BUTTON_REVIEWS)'</a>'; ?></td>.

               <td class="main" align="right"><?php echo tep_draw_hidden_field('products_id', $product_info['products_id'])tep_image_submit('button_in_cart.gif', IMAGE_BUTTON_IN_CART); ?></td>.

               <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>.

             </tr>.

           </table></td>.

         </tr>.

       </table></td>.

     </tr>.

     <tr>.

       <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>.

     </tr>.

     <tr>.

       <td>.

<?php.

   if ((USE_CACHE == 'true') && empty($SID)) {.

     echo tep_cache_also_purchased(3600);.

   } else {.

     include(DIR_WS_MODULESFILENAME_ALSO_PURCHASED_PRODUCTS);.

   }.

 }.

?>.

       </td>.

     </tr>.

   </table></form></td>.

<! body_text_eof //>.

   <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">.

<! right_navigation //>.

<?php require(DIR_WS_INCLUDES'column_right.php'); ?>.

<! right_navigation_eof //>.

   </table></td>.

 </tr>.

</table>.

<! body_eof //>.

<! footer //>.

<?php require(DIR_WS_INCLUDES'footer.php'); ?>.

<! footer_eof //>.

<br>.

</body>.

</html>.

<?php require(DIR_WS_INCLUDES'application_bottom.php'); ?>..

Comment #5

Remove:.

<td class="main"><?php echo '<a href="'tep_href_link(FILENAME_PRODUCT_REVIEWS, tep_get_all_get_params())'">'tep_image_button('button_reviews.gif', IMAGE_BUTTON_REVIEWS)'</a>'; ?></td>..

Comment #6

Ok...I did what you said...I commented out that line and got another fatal error!.

Here's the error.

And here's my product_info.php.

<?php.

/*.

 $Id: product_info.php,v 1.97 2003/07/01 14:34:54 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');.

 require(DIR_WS_LANGUAGES$language'/'FILENAME_PRODUCT_INFO);.

 $product_check_query = tep_db_query("select count(*) as total from "TABLE_PRODUCTS" p, "TABLE_PRODUCTS_DESCRIPTION" pd where p.products_status = '1' and p.products_id = '"(int)$HTTP_GET_VARS['products_id']"' and pd.products_id = p.products_id and pd.language_id = '"(int)$languages_id"'");.

 $product_check = tep_db_fetch_array($product_check_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 TITLE; ?></title>.

<base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER)DIR_WS_CATALOG; ?>">.

<link rel="stylesheet" type="text/css" href="stylesheet.css">.

<script language="javascript"><!.

Function popupWindow(url) {.

 window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,res.

Izable=yes,copyhistory=no,width=100,height=100,screenX=150,screenY=150,top=150,le.

Ft=150').

}.

//></script>.

</head>.

<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">.

<! header //>.

<?php require(DIR_WS_INCLUDES'header.php'); ?>.

<! header_eof //>.

<! body //>.

<table border="0" width="100%" cellspacing="3" cellpadding="3">.

 <tr>.

   <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">.

<! left_navigation //>.

<?php require(DIR_WS_INCLUDES'column_left.php'); ?>.

<! left_navigation_eof //>.

   </table></td>.

<! body_text //>.

   <td width="100%" valign="top"><?php echo tep_draw_form('cart_quantity', tep_href_link(FILENAME_PRODUCT_INFO, tep_get_all_get_params(array('action'))'action=add_product')); ?><table border="0" width="100%" cellspacing="0" cellpadding="0">.

<?php.

 if ($product_check['total'] < 1) {.

?>.

     <tr>.

       <td><?php new infoBox(array(array('text' => TEXT_PRODUCT_NOT_FOUND))); ?></td>.

     </tr>.

     <tr>.

       <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>.

     </tr>.

     <tr>.

       <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">.

         <tr class="infoBoxContents">.

           <td><table border="0" width="100%" cellspacing="0" cellpadding="2">.

             <tr>.

               <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>.

               <td align="right"><?php echo '<a href="'tep_href_link(FILENAME_DEFAULT)'">'tep_image_button('button_continue.gif', IMAGE_BUTTON_CONTINUE)'</a>'; ?></td>.

               <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>.

             </tr>.

           </table></td>.

         </tr>.

       </table></td>.

     </tr>.

<?php.

 } else {.

   $product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from "TABLE_PRODUCTS" p, "TABLE_PRODUCTS_DESCRIPTION" pd where p.products_status = '1' and p.products_id = '"(int)$HTTP_GET_VARS['products_id']"' and pd.products_id = p.products_id and pd.language_id = '"(int)$languages_id"'");.

   $product_info = tep_db_fetch_array($product_info_query);.

   tep_db_query("update "TABLE_PRODUCTS_DESCRIPTION" set products_viewed = products_viewed+1 where products_id = '"(int)$HTTP_GET_VARS['products_id']"' and language_id = '"(int)$languages_id"'");.

   if ($new_price = tep_get_products_special_price($product_info['products_id'])) {.

     $products_price = '<s>'$currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id']))'</s> <span class="productSpecialPrice">'$currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id']))'</span>';.

   } else {.

     $products_price = $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id']));.

   }.

   if (tep_not_null($product_info['products_model'])) {.

     $products_name = $product_info['products_name']'<br><span class="smallText">['$product_info['products_model']']</span>';.

   } else {.

     $products_name = $product_info['products_name'];.

   }.

?>.

     <tr>.

       <td><table border="0" width="100%" cellspacing="0" cellpadding="0">.

         <tr>.

           <td class="pageHeading" valign="top"><?php echo $products_name; ?></td>.

           <td class="pageHeading" align="right" valign="top"><?php echo $products_price; ?></td>.

         </tr>.

       </table></td>.

     </tr>.

     <tr>.

       <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>.

     </tr>.

     <tr>.

       <td class="main">.

<?php.

   if (tep_not_null($product_info['products_image'])) {.

?>.

         <table border="0" cellspacing="0" cellpadding="2" align="right">.

           <tr>.

             <td align="center" class="smallText">.

<script language="javascript"><!.

Document.write('<?php echo '<a href="javascript:popupWindow(\\\''tep_href_link(FILENAME_POPUP_IMAGE, 'pID='$product_info['products_id'])'\\\')">'tep_image(DIR_WS_IMAGES$product_info['products_image'], addslashes($product_info['products_name']), SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"')'<br>'TEXT_CLICK_TO_ENLARGE'</a>'; ?>');.

//></script>.

<noscript>.

<?php echo '<a href="'tep_href_link(DIR_WS_IMAGES$product_info['products_image'])'" target="_blank">'tep_image(DIR_WS_IMAGES$product_info['products_image'], $product_info['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"')'<br>'TEXT_CLICK_TO_ENLARGE'</a>'; ?>.

</noscript>.

             </td>.

           </tr>.

         </table>.

<?php.

   }.

?>.

         <p><?php echo stripslashes($product_info['products_description']); ?></p>.

<?php.

   $products_attributes_query = tep_db_query("select count(*) as total from "TABLE_PRODUCTS_OPTIONS" popt, "TABLE_PRODUCTS_ATTRIBUTES" patrib where patrib.products_id='"(int)$HTTP_GET_VARS['products_id']"' and patrib.options_id = popt.products_options_id and popt.language_id = '"(int)$languages_id"'");.

   $products_attributes = tep_db_fetch_array($products_attributes_query);.

   if ($products_attributes['total'] > 0) {.

?>.

         <table border="0" cellspacing="0" cellpadding="2">.

           <tr>.

             <td class="main" colspan="2"><?php echo TEXT_PRODUCT_OPTIONS; ?></td>.

           </tr>.

<?php.

     $products_options_name_query = tep_db_query("select distinct popt.products_options_id, popt.products_options_name from "TABLE_PRODUCTS_OPTIONS" popt, "TABLE_PRODUCTS_ATTRIBUTES" patrib where patrib.products_id='"(int)$HTTP_GET_VARS['products_id']"' and patrib.options_id = popt.products_options_id and popt.language_id = '"(int)$languages_id"' order by popt.products_options_name");.

     while ($products_options_name = tep_db_fetch_array($products_options_name_query)) {.

       $products_options_array = array();.

       $products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from "TABLE_PRODUCTS_ATTRIBUTES" pa, "TABLE_PRODUCTS_OPTIONS_VALUES" pov where pa.products_id = '"(int)$HTTP_GET_VARS['products_id']"' and pa.options_id = '"(int)$products_options_name['products_options_id']"' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '"(int)$languages_id"'");.

       while ($products_options = tep_db_fetch_array($products_options_query)) {.

         $products_options_array[] = array('id' => $products_options['products_options_values_id'], 'text' => $products_options['products_options_values_name']);.

         if ($products_options['options_values_price'] != '0') {.

           $products_options_array[sizeof($products_options_array)-1]['text'] .= ' ('$products_options['price_prefix']$currencies->display_price($products_options['options_values_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) .') ';.

         }.

       }.

       if (isset($cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']])) {.

         $selected_attribute = $cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']];.

       } else {.

         $selected_attribute = false;.

       }.

?>.

           <tr>.

             <td class="main"><?php echo $products_options_name['products_options_name']':'; ?></td>.

             <td class="main"><?php echo tep_draw_pull_down_menu('id['$products_options_name['products_options_id']']', $products_options_array, $selected_attribute); ?></td>.

           </tr>.

<?php.

     }.

?>.

         </table>.

<?php.

   }.

?>.

       </td>.

     </tr>.

     <tr>.

       <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>.

     </tr>.

<?php.

   $reviews_query = tep_db_query("select count(*) as count from "TABLE_REVIEWS" where products_id = '"(int)$HTTP_GET_VARS['products_id']"'");.

   $reviews = tep_db_fetch_array($reviews_query);.

   if ($reviews['count'] > 0) {.

?>.

     <tr>.

       <td class="main"><?php echo TEXT_CURRENT_REVIEWS' '$reviews['count']; ?></td>.

     </tr>.

     <tr>.

       <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>.

     </tr>.

<?php.

   }.

   if (tep_not_null($product_info['products_url'])) {.

?>.

     <tr>.

       <td class="main"><?php echo sprintf(TEXT_MORE_INFORMATION, tep_href_link(FILENAME_REDIRECT, 'action=url&goto='urlencode($product_info['products_url']), 'NONSSL', true, false)); ?></td>.

     </tr>.

     <tr>.

       <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>.

     </tr>.

<?php.

   }.

   if ($product_info['products_date_available'] > date('Y-m-d H:i:s')) {.

?>.

     <tr>.

       <td align="center" class="smallText"><?php echo sprintf(TEXT_DATE_AVAILABLE, tep_date_long($product_info['products_date_available'])); ?></td>.

     </tr>.

<?php.

   } else {.

?>.

     <tr>.

       <td align="center" class="smallText"><?php echo sprintf(TEXT_DATE_ADDED, tep_date_long($product_info['products_date_added'])); ?></td>.

     </tr>.

<?php.

   }.

?>.

     <tr>.

       <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>.

     </tr>.

     <tr>.

       <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">.

         <tr class="infoBoxContents">.

           <td><table border="0" width="100%" cellspacing="0" cellpadding="2">.

             <tr>.

               <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>.

               /*<td class="main"><?php echo '<a href="'tep_href_link(FILENAME_PRODUCT_REVIEWS, tep_get_all_get_params())'">'tep_image_button('button_reviews.gif', IMAGE_BUTTON_REVIEWS)'</a>'; ?></td>*/.

               <td class="main" align="right"><?php echo tep_draw_hidden_field('products_id', $product_info['products_id'])tep_image_submit('button_in_cart.gif', IMAGE_BUTTON_IN_CART); ?></td>.

               <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>.

             </tr>.

           </table></td>.

         </tr>.

       </table></td>.

     </tr>.

     <tr>.

       <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>.

     </tr>.

     <tr>.

       <td>.

<?php.

   if ((USE_CACHE == 'true') && empty($SID)) {.

     echo tep_cache_also_purchased(3600);.

   } else {.

     include(DIR_WS_MODULESFILENAME_ALSO_PURCHASED_PRODUCTS);.

   }.

 }.

?>.

       </td>.

     </tr>.

   </table></form></td>.

<! body_text_eof //>.

   <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">.

<! right_navigation //>.

<?php require(DIR_WS_INCLUDES'column_right.php'); ?>.

<! right_navigation_eof //>.

   </table></td>.

 </tr>.

</table>.

<! body_eof //>.

<! footer //>.

<?php require(DIR_WS_INCLUDES'footer.php'); ?>.

<! footer_eof //>.

<br>.

</body>.

</html>.

<?php require(DIR_WS_INCLUDES'application_bottom.php'); ?>.

Why is this happening??? I JUST did a new install again and scrapped all of my work because of this fatal error. How do I fix it?..

Comment #7

The commenting out you have done I think will only work in php - not in html..

Remove the line altogether...

Comment #8

I've deleted the line all together and the fatal error is still there....

The problem is the fatal error is referring to databases.php which I haven't even touched....

What else can I do to fix this??..

Comment #9

Did the problem occur bg4 your did anything to the product_info.php file ? .

Also look here:.

Http://forums.oscomm...showtopic=92368..

Comment #10

No it happened after...I've reinstalled like 4 times now because of this problem so I was sure to check to make sure something wasn't wrong with it before removing any code..

Here's the really messed up part...I can't even paste the code back in as it was originally...it still gives me the fatal error..

I am at a complete loss as to what to do...

Comment #11

By the way...you referred me to my own question that I asked yesterday while having this same problem...none of that worked either......

Comment #12

That shows how late it is here - 3am....LOL...

Comment #13

No worries! Any other ideas of how I can fix this??..

Comment #14

Did you upload the product_info.php file to the correct directory i.e. root rather than includes/languages/english..

Comment #15

It's in public_html/catalog/product_info/php....that's how it went in on the upload...I didn't move it anywhere.....

Comment #16

Just this....

<?php.

/*.

 $Id: product_info.php,v 1.15 2002/11/19 01:48:08 dgw_ Exp $.

 osCommerce, Open Source E-Commerce Solutions.

 http://www.oscommerce.com.

 Copyright (c) 2002 osCommerce.

 Released under the GNU General Public License.

*/.

Define('TEXT_PRODUCT_NOT_FOUND', 'Product not found!');.

Define('TEXT_CURRENT_REVIEWS', 'Current Reviews:');.

Define('TEXT_MORE_INFORMATION', 'For more information, please visit this products <a href="%s" target="_blank"><u>webpage</u></a>.');.

Define('TEXT_DATE_ADDED', 'This product was added to our catalog on %s.');.

Define('TEXT_DATE_AVAILABLE', '<font color="#ff0000">This product will be in stock on %s.</font>');.

Define('TEXT_ALSO_PURCHASED_PRODUCTS', 'Customers who bought this product also purchased');.

Define('TEXT_PRODUCT_OPTIONS', 'Available Options:');.

Define('TEXT_CLICK_TO_ENLARGE', 'Click to enlarge');.

?>..

Comment #17

Could someone send me a copy of their catalog/product_info.php? I don't know what i've done to mine, but it's definitely not working!.

If you have a copy where the text box is already removed that would be soooo FABULOUS!!!!.

Thanks for any help in advance!!..

Comment #18

Just download the source code for osCommerce, then extract it from there...

Comment #19


This question was taken from a support group/message board and re-posted here so others can learn from it.