Where did the name and description of my products go?

[jdelgado]

hi,

 

when I get into this OSC website that I'm making:

http://www.railowsky.com/tienda/catalog/default.php

 

I see no name or description of my products, it just shows the price and its image (well, it shows the default gif I have for them that says "no image available" in spanish but that's fine).

 

But why isn't it showing the Name and Description of the products at the entrance page?

Besides, I've realised that if you click on any of them it gives you a "Product not found" page ... and it is so weird because yesterday I uploaded the 330 list of products using EasyPopulate and it all seemed to work fine.

You can browse around the 3 Categories on the left column: Photography, Art and Cinema, and see that the products name and description is there correctly along with the rest of their information.

You can even buy any of them and everything works fine.

 

But why isn't it showing the NAME and DESCRIPTION on the defaulp.php entrance page?

And why is their link to their information page wrong?

 

Probably it is the same error, right?

Please, tell me, where should I start looking to?

 

Thanks in advance,

[jdelgado]

hi,

 

when I get into this OSC website that I'm making:

http://www.railowsky.com/tienda/catalog/default.php

 

I see no name or description of my products, it just shows the price and its image (well, it shows the default gif I have for them that says "no image available" in spanish but that's fine).

 

But why isn't it showing the Name and Description of the products at the entrance page?

Besides, I've realised that if you click on any of them it gives you a "Product not found" page ... and it is so weird because yesterday I uploaded the 330 list of products using EasyPopulate and it all seemed to work fine.

You can browse around the 3 Categories on the left column: Photography, Art and Cinema, and see that the products name and description is there correctly along with the rest of their information.

You can even buy any of them and everything works fine.

 

But why isn't it showing the NAME and DESCRIPTION on the defaulp.php entrance page?

And why is their link to their information page wrong?

 

Probably it is the same error, right?

Please, tell me, where should I start looking to?

 

Just in case it may be of help:

- it all worked fine before I installed and used EasyPopulate

- default.php has this line of code (that I haven't changed at all) where it calls for the new products:

 <tr>

           <td><br><?php include(DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); ?></td>

         </tr>

- application_top.php (at /includes) has the following line that is related to the previous code:

 define('FILENAME_NEW_PRODUCTS', 'new_products.php');

 

- and finally here you have new_products.php code (at /includes/modules):

<?php

/*

 $Id: new_products.php,v 1.33 2003/02/12 23:55:58 hpdl Exp $



 osCommerce, Open Source E-Commerce Solutions

 http://www.oscommerce.com



 Copyright (c) 2003 osCommerce



 Released under the GNU General Public License

*/

?>

<!-- new_products //-->

<?php

 $info_box_contents = array();

 $info_box_contents[] = array('text' => sprintf(TABLE_HEADING_NEW_PRODUCTS, strftime('%B')));



 new contentBoxHeading($info_box_contents);



 if ( (!isset($new_products_category_id)) || ($new_products_category_id == '0') ) {

   $new_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where products_status = '1' order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS);

 } else {

   $new_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . $new_products_category_id . "' and p.products_status = '1' order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS);

 }



 $row = 0;

 $col = 0;

 $info_box_contents = array();

 while ($new_products = tep_db_fetch_array($new_products_query)) {

   $new_products['products_name'] = tep_get_products_name($new_products['products_id']);

   $info_box_contents[$row][$col] = array('align' => 'center',

                                          'params' => 'class="smallText" width="33%" valign="top"',

                                          'text' => '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $new_products['products_image'], $new_products['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . $new_products['products_name'] . '</a><br>' . $currencies->display_price($new_products['products_price'], tep_get_tax_rate($new_products['products_tax_class_id'])));



   $col ++;

   if ($col > 2) {

     $col = 0;

     $row ++;

   }

 }



 new contentBox($info_box_contents);

?>

<!-- new_products_eof //-->

 

Thanks in advance,

[Guest]

When i look at the store it only shows the # of products,

I dont think that you created any categories!

 

The_Bear

[jdelgado]

Thanks for trying to help me.

Yeah, you have pointed a new error that I've just found too: if you visit my website from outside Europe you may see that there is not much content.

I mean that if you have set your Windows as Region Europe you see the categories ... but other visitors see the "english version" that is incomplete (because I do not intend to have an english version actually).

 

Why does that happen?

 

Thanks again,

[Guest]

Put your new language as the default language

 

The_Bear