Guest Posted March 22, 2006 Posted March 22, 2006 Help! My Joint Venture Business Partner is telling me "it's time to fish or cut bait" and I am feeling very sad, because I have wound my way through all problems I have encountered so far, with the exception of the bug for the insert Product Attributes. :'( My problem is that I can't see any Product Options with the matching Option Value boxes showing on the Product Info.php page. We have downloaded the osCommerce 2.2 Milestone 2 Update 051113 for Windows. I have inserted 4 Product Options with some matching Option Values. Can anyone tell me why please?? In gratitude for any help, Myrna W.
Guest Posted April 2, 2006 Posted April 2, 2006 Yeah!!! Just found solution in the Bug Reports, titled "Table products_attributes_id", Last Updated: 30th March 2006 07:32:55. THANKS to Reporter: 3dwdnet (AT) gmail (DOT) com. Since I asked for help on this problem, my business partner purchased a MYSQL data manager product and we have been exporting the product tables into Excel spreadsheets for formatting, then updating all the product information in the spreadsheets and importing it back. This is much faster than clicking all those buttons, then having to go back and redo them, when one discovers their mistakes. SOLUTION from "Table products_attributes_id": In admin/products_attributes.php line: +- 60 tep_db_query("insert into " . TABLE_PRODUCTS_ATTRIBUTES . " values ('', '" . (int)$products_id . "', '" . (int)$options_id . "', '" . (int)$values_id . "', '" . tep_db_input($value_price) . "', '" . tep_db_input($price_prefix) . "')"); to tep_db_query("insert into " . TABLE_PRODUCTS_ATTRIBUTES . " values ('" . (int)$products__attributes_id . "', '" . (int)$products_id . "', '" . (int)$options_id . "', '" . (int)$values_id . "', '" . tep_db_input($value_price) . "', '" . tep_db_input($price_prefix) . "')"); Regards, MyrnaW
Guest Posted April 2, 2006 Posted April 2, 2006 Yeah!!! Just found solution in the Bug Reports, titled "Table products_attributes_id", Last Updated: 30th March 2006 07:32:55. THANKS to Reporter: 3dwdnet (AT) gmail (DOT) com. Since I asked for help on this problem, my business partner purchased a MYSQL data manager product and we have been exporting the product tables into Excel spreadsheets for formatting, then updating all the product information in the spreadsheets and importing it back. This is much faster than clicking all those buttons, then having to go back and redo them, when one discovers their mistakes. SOLUTION from "Table products_attributes_id": In admin/products_attributes.php line: +- 60 tep_db_query("insert into " . TABLE_PRODUCTS_ATTRIBUTES . " values ('', '" . (int)$products_id . "', '" . (int)$options_id . "', '" . (int)$values_id . "', '" . tep_db_input($value_price) . "', '" . tep_db_input($price_prefix) . "')"); to tep_db_query("insert into " . TABLE_PRODUCTS_ATTRIBUTES . " values ('" . (int)$products__attributes_id . "', '" . (int)$products_id . "', '" . (int)$options_id . "', '" . (int)$values_id . "', '" . tep_db_input($value_price) . "', '" . tep_db_input($price_prefix) . "')"); Regards, MyrnaW
Guest Posted April 2, 2006 Posted April 2, 2006 NOTE: When you enter the PRODUCT ATTRIBUTE information in the Admin Product Attribute page, you must enter a value in the format of 9.999 in the Value Price or you will get a Decimal Error on the Insert. Regards, Myrna W.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.