Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

HELP: Extra Images Contribution Error


thecustomshop

Recommended Posts

Contribution Used: http://www.oscommerce.com/community/contributions,1289

 

INSERT INTO configuration VALUES ('', 'Display Extra images (on products_info)', 'DISPLAY_EXTRA_IMAGES', 'true', 'Display Extra images', 1, 87, '2005-11-17 17:20:36', '2005-10-20 17:40:05', '', 'tep_cfg_select_option(array(\'false\', \'true\'),');

 

Results In:

 

Error
SQL query:  

INSERT INTO configuration
VALUES (

'', 'Display Extra images (on products_info)', 'DISPLAY_EXTRA_IMAGES', 'true', 'Display Extra images', 1, 87, '2005-11-17 17:20:36', '2005-10-20 17:40:05', '', 'tep_cfg_select_option(array(\'false\', \'true\'),'
) 

MySQL said:  

#1264 - Out of range value adjusted for column 'configuration_id' at row 1

Link to comment
Share on other sites

I changed the code to suit my configuration file to read as follows....

 

INSERT INTO configuration VALUES ('1138', 'Display Extra images (on products_info)', 'DISPLAY_EXTRA_IMAGES', 'true', 'Display Extra images', 1, 20, '2005-11-17 17:20:36', '2005-10-20 17:40:05', 'NULL', 'tep_cfg_select_option(array(\'false\', \'true\'),');

 

This worked. Admin panel works fine and allows for additional uploads.

 

The issue now...

If you select a product, the pages are blank. No information visible at all, not columns, headers, footers, photos, etc.

 

Any ideas?

Link to comment
Share on other sites

I fixed it...

 

the directions read....

 

/catalog/product_info.php

Find :

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

 

After Add :

   if (DISPLAY_EXTRA_IMAGES == 'true'){
 if ($product_check['total'] >= 1) {
   include (DIR_WS_INCLUDES . 'products_extra_images.php');
 }
}

 

The issue is, the original code does not include an "else {" statement. I had added it to match the directions. That was the downfall. Removed the "else {" and everything worked again.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...