thecustomshop Posted April 23, 2007 Share Posted April 23, 2007 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 More sharing options...
thecustomshop Posted April 23, 2007 Author Share Posted April 23, 2007 Need to get this fixed ASAP. Site is showing blank pages for products now! Link to comment Share on other sites More sharing options...
thecustomshop Posted April 23, 2007 Author Share Posted April 23, 2007 ttt Link to comment Share on other sites More sharing options...
thecustomshop Posted April 23, 2007 Author Share Posted April 23, 2007 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 More sharing options...
thecustomshop Posted April 24, 2007 Author Share Posted April 24, 2007 Anyone else have the problem of blank screens when attempting to view products, when they had installed this contribution? Link to comment Share on other sites More sharing options...
thecustomshop Posted April 24, 2007 Author Share Posted April 24, 2007 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 More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.