imty786 Posted April 24, 2010 Share Posted April 24, 2010 If you go back into admin now and view the product and the checkbox is checked for the option, then it is in the database correctly. In that case, the problem is most likely on the shop side. You can try using the included product_info.php file for a quick test. If it shows up, then the problem is in that file. If not, it is in the includes/application_top.php file. Dear Thanks for your prompt Reply I checked all again But Problem is same there. 1. As you declare I add new product and checked the checkbox of Default ( Name ) text. 2. I checked coding in product_info.php It is Ok Codding is here in catalog/product_info.php **FIND: <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 } } ?> **ADD AFTER: <!-- denuz products text attributes --> <tr> <td><table border="0" cellspacing="0" cellpadding="2"> <?php $text_attributes_query = tep_db_query("select pta.*, cbta.products_text_attributes_text from products_text_attributes as pta, products_text_attributes_enabled as ptae, customers_basket_text_attributes as cbta where ptae.products_text_attributes_id = pta.products_text_attributes_id and ptae.products_id = " . tep_get_prid($HTTP_GET_VARS['products_id']) . " and cbta.products_text_attributes_id = pta.products_text_attributes_id and cbta.session_id = '" . tep_session_id() . "'"); if (tep_db_num_rows($text_attributes_query) == 0) $text_attributes_query = tep_db_query("select pta.* from products_text_attributes as pta, products_text_attributes_enabled as ptae where ptae.products_text_attributes_id = pta.products_text_attributes_id and ptae.products_id = " . tep_get_prid($HTTP_GET_VARS['products_id'])); while ($text_attributes = tep_db_fetch_array($text_attributes_query)) { ?> <tr> <td class=main><?php echo $text_attributes['products_text_attributes_name'] . ': </td><td>' . tep_draw_input_field('products_text_attributes_' . $text_attributes['products_text_attributes_id'], tep_not_null($text_attributes['products_text_attributes_text']) ? $text_attributes['products_text_attributes_text'] : ''); ?></td> </tr> <?php } ?> </table></td> </tr> <!-- eof denuz products text attributes --> 3. checked coding in includes/application_top.php It is Ok Codding is here, in catalog/includes/application_top.php **FIND: case 'update_product' : for ($i=0, $n=sizeof($HTTP_POST_VARS['products_id']); $i<$n; $i++) { if (in_array($HTTP_POST_VARS['products_id'][$i], (is_array($HTTP_POST_VARS['cart_delete']) ? $HTTP_POST_VARS['cart_delete'] : array()))) { $cart->remove($HTTP_POST_VARS['products_id'][$i]); **ADD AFTER: // denuz text attr tep_db_query("delete from customers_basket_text_attributes where products_id = " . tep_get_prid($HTTP_POST_VARS['products_id'][$i]) . " and session_id = '" . $osCsid . "'"); // eof denuz text attr **FIND: // customer adds a product from the products page case 'add_product' : if (isset($HTTP_POST_VARS['products_id']) && is_numeric($HTTP_POST_VARS['products_id'])) { $cart->add_cart($HTTP_POST_VARS['products_id'], $cart->get_quantity(tep_get_uprid($HTTP_POST_VARS['products_id'], $HTTP_POST_VARS['id']))+1, $HTTP_POST_VARS['id']); **ADD AFTER: // denuz text attr tep_db_query("delete from customers_basket_text_attributes where products_id = " . $HTTP_POST_VARS['products_id'] . " and session_id = '" . $osCsid . "'"); $attr_query = tep_db_query("select * from products_text_attributes_enabled where products_id = " . $HTTP_POST_VARS['products_id']); while ($attr = tep_db_fetch_array($attr_query)) { tep_db_query("insert into customers_basket_text_attributes values ('$osCsid', " . $HTTP_POST_VARS['products_id'] . ", " . $attr['products_text_attributes_id'] . ", '" . addslashes($HTTP_POST_VARS['products_text_attributes_' . $attr['products_text_attributes_id']]) . "');"); } // eof denuz text attr Dear Problem Is still There Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted April 24, 2010 Share Posted April 24, 2010 Dear Problem Is still There You can try replacing the product_info.php file as suggested but, other than that, I don't have any other suggestions. Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
imty786 Posted April 24, 2010 Share Posted April 24, 2010 You can try replacing the product_info.php file as suggested but, other than that, I don't have any other suggestions. Dear, Jack I done as you recommend but Problem is Still there plz can you give me your email I want to send some screen shorts [email protected] Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted April 24, 2010 Share Posted April 24, 2010 Dear, Jack I done as you recommend but Problem is Still there plz can you give me your email I want to send some screen shorts [email protected] No, sorry, but free support is only available on these forums. Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
imty786 Posted April 24, 2010 Share Posted April 24, 2010 No, sorry, but free support is only available on these forums. Its Ok Then Solve my problem it is a big fault in this addon I read all forum many people are in this problem but no solution. I think no any body interested to clear this problem by free support.......... Its good for osCommerce Community :angry: Quote Link to comment Share on other sites More sharing options...
Kalan Posted April 29, 2010 Share Posted April 29, 2010 (edited) I installed Imprint Text V 1.3.5 and it works fine except for one problem. The text option box only shows up when there are other options with the product. If there are no other standard product option with a drop down menu the text options do not show. I have checked and rechecked the code but can find no errors. Can someone point me in the right direction to fix this? Thanks, Dan Hi, I had the same problem like Dan. I have found the mistake yesterday but today i don't really know where it was so i post the whole code of product_info.php. As i remember right it was some misplaced <table> tag at the second edit position. <?php /* $Id: product_info.php 1739 2007-12-20 00:52:16Z hpdl $ 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,resizable=yes,copyhistory=no,width=100,height=100,screenX=150,screenY=150,top=150,left=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 } } ?> <!-- denuz products text attributes --> <tr> <td><table border="0" cellspacing="0" cellpadding="2"> <?php $text_attributes_query = tep_db_query("select pta.*, cbta.products_text_attributes_text from products_text_attributes as pta, products_text_attributes_enabled as ptae, customers_basket_text_attributes as cbta where ptae.products_text_attributes_id = pta.products_text_attributes_id and ptae.products_id = " . tep_get_prid($HTTP_GET_VARS['products_id']) . " and cbta.products_text_attributes_id = pta.products_text_attributes_id and cbta.session_id = '" . tep_session_id() . "'"); if (tep_db_num_rows($text_attributes_query) == 0) $text_attributes_query = tep_db_query("select pta.* from products_text_attributes as pta, products_text_attributes_enabled as ptae where ptae.products_text_attributes_id = pta.products_text_attributes_id and ptae.products_id = " . tep_get_prid($HTTP_GET_VARS['products_id'])); while ($text_attributes = tep_db_fetch_array($text_attributes_query)) { ?> <tr> <td class=main><?php echo $text_attributes['products_text_attributes_name'] . ': </td><td>' . tep_draw_input_field('products_text_attributes_' . $text_attributes['products_text_attributes_id'], tep_not_null($text_attributes['products_text_attributes_text']) ? $text_attributes['products_text_attributes_text'] : ''); ?></td> </tr> <?php } ?> </table></td> </tr> <!-- eof denuz products text attributes --> </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_MODULES . FILENAME_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'); ?> Edited April 29, 2010 by Kalan Quote Link to comment Share on other sites More sharing options...
kthursto Posted May 5, 2010 Share Posted May 5, 2010 osCommerce, php, et al newbie here! I was thrown into the deep end of OSCommerce last Friday and have been doing my best to get the hang of it all. I've installed Imprint Txt and encountered an issue while modifying the OSC files. Where it says: in catalog/product_info.php**FIND: <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 } } ?> This snippet is not found in the document. I am running v2.2 RC2a and STSv4.6. Could there be a related reason? I've been several nights in a row trying to figure out this whole OSCommerce/STS thing... so, I hopefully I am not overlooking something in Imprint Txt due to sheer exhaustion. Thank you! Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted May 5, 2010 Share Posted May 5, 2010 I am running v2.2 RC2a and STSv4.6. Could there be a related reason? You can turn STS off in admin and check to see if this contribution is working. If it is, then the probable is probably that you are using a template file for the product page. There aren't any instructions for integrating that, I don't think. Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
kthursto Posted May 6, 2010 Share Posted May 6, 2010 You can turn STS off in admin and check to see if this contribution is working. If it is, then the probable is probably that you are using a template file for the product page. There aren't any instructions for integrating that, I don't think. Whoa! I actually understood this! :D I think I just might be getting the hang of this bold new OS, et al world. Thanks Jack. I will certainly proceed down this path. Quote Link to comment Share on other sites More sharing options...
syduck Posted July 5, 2010 Share Posted July 5, 2010 Hey Thanks for the great contribution! Installed and works flawlessly. Also installed and set up for custom product builder, worked fine. Had to edit checkout_process.php to add imprint text in the outgoing emails to customers. Quote Link to comment Share on other sites More sharing options...
syduck Posted July 14, 2010 Share Posted July 14, 2010 Hey Thanks for the great contribution! Installed and works flawlessly. Also installed and set up for custom product builder, worked fine. Had to edit checkout_process.php to add imprint text in the outgoing emails to customers. So my code to put the imprint text in the outgoing emails stopped working mysteriously. I am not sure why yet.. here is the code in checkout_process.php $chris_Qry = "select ota.*, pta.products_text_attributes_name from orders_text_attributes as ota, products_text_attributes as pta where ota.orders_id = " . $insert_id. //$HTTP_GET_VARS['oID'] . " and ota.products_id = " . $pid['products_id'] . " and pta.products_text_attributes_id = ota.products_text_attributes_id"; //echo ; $attr_qq = tep_db_query($chris_Qry); while ($attr = tep_db_fetch_array($attr_qq)) { $email_order .= $attr['products_text_attributes_name'] . ': ' . $attr['products_text_attributes_text'] . "\n"; } it used to work but then stopped working, any idea why this would happen? Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted July 14, 2010 Share Posted July 14, 2010 So my code to put the imprint text in the outgoing emails stopped working mysteriously. I am not sure why yet.. here is the code in checkout_process.php $chris_Qry = "select ota.*, pta.products_text_attributes_name from orders_text_attributes as ota, products_text_attributes as pta where ota.orders_id = " . $insert_id. //$HTTP_GET_VARS['oID'] . " and ota.products_id = " . $pid['products_id'] . " and pta.products_text_attributes_id = ota.products_text_attributes_id"; } it used to work but then stopped working, any idea why this would happen? That's not a very well formed statement. Is it part of the contribution? Try removng //$HTTP_GET_VARS['oID'] . It could be that your host upgraded something which allowed the code to work before but not now. Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
fan4chevy Posted July 20, 2010 Share Posted July 20, 2010 Adding more text field space. Right now I am only able to type in 19 characters, how do I make the text box longer so it can have lets say 40 characters? Quote Link to comment Share on other sites More sharing options...
jferezy Posted August 13, 2010 Share Posted August 13, 2010 I am using the text imprint option but I am having a problem getting the data over to PayPal and Google Checkout. I am using oscmax and all attributes get transferred except the text option. I am sure I missed something but if anyone has any idea of what I missed, that would be great... I appreciate any help you can provide... Jason Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted August 13, 2010 Share Posted August 13, 2010 Adding more text field space. Right now I am only able to type in 19 characters, how do I make the text box longer so it can have lets say 40 characters? You normally make such changes to the database directly but there isn't such a limit in this contribution so I don't have any suggestions for you. Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
Jack_mcs Posted August 13, 2010 Share Posted August 13, 2010 I am using the text imprint option but I am having a problem getting the data over to PayPal and Google Checkout. I am using oscmax and all attributes get transferred except the text option. I am sure I missed something but if anyone has any idea of what I missed, that would be great... The options are treated as regualr attributes so they should get passed over as attributes would. But support of your shop is not allowed here, by forum rules, so I can't offer any suggestions. Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
adabristian Posted September 11, 2010 Share Posted September 11, 2010 I have installed the attribute, however the information is not passing through to the admin invoice, packing slip or paypal. The last place where I am able to see it is right before you confirm the order it will tell you all the attributes. Also, it will not place the attribute info tect box option on product page unless there are other types of options chosen for the same item. Did I miss a placement of some code or something? Quote Link to comment Share on other sites More sharing options...
Top_Speed Posted October 26, 2010 Share Posted October 26, 2010 (edited) Hi Jack and ecommers, I have a unique situation with this contrib. (On an existing Invoice with a items "products_model" over 12 characters) ps. the db is set for 20 chars Product XYZ model_XYZ123456 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and pta.products_text_attributes_id = ota.products_text_attributes_id' at line 1 select ota.*, pta.products_text_attributes_name from orders_text_attributes as ota, products_text_attributes as pta where ota.orders_id = 12370 and ota.products_id = and pta.products_text_attributes_id = ota.products_text_attributes_id [TEP STOP] All other functions work great, all invoices, packing lists load except on long(er) than 12 model numbered items. Hope there's an answer, I like the contrib :) Many Pre-Thanks, KJ ------- UPDATE ------- It's something in the admin/orders.php i believe? I backed up the copy and went back to it and i don't get the error. Edited October 26, 2010 by Top_Speed Quote define('PROJECTS', 'Something that goes on forever!'); Link to comment Share on other sites More sharing options...
Jack_mcs Posted October 26, 2010 Share Posted October 26, 2010 I have a unique situation with this contrib. (On an existing Invoice with a items "products_model" over 12 characters) ps. the db is set for 20 chars Product XYZ model_XYZ123456 All other functions work great, all invoices, packing lists load except on long(er) than 12 model numbered items. Hi KJ. Hadn't seen you around for awhile - glad to see you're still here. :) As for that problem, there's nothing in the code that limits the size and there isn't a field for it in the database changes. Are you sure you changed the model number size in the orders_products table? This is often missed when the model number size is changed. Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
Top_Speed Posted October 27, 2010 Share Posted October 27, 2010 Hi Jack, yep been a long time... still going strong, i try to keep the airwaves clear for those in need of yours and others excellent help & responses. Good to see your still here!! Your spot on (as usual). The orders_products wasn't updated (been this way for years! lol). I guess this contrib changed how it reads from the db on orders model#. THe long sku's were chopped off and this is what caused the 1064's. I now can go back and edit the invoice to add on the longer sku and the old invoices are fine. The new invoices are already correct thanks to YOU!! Great work, hope things r going well w/ you and you family! TC, -KJ Quote define('PROJECTS', 'Something that goes on forever!'); Link to comment Share on other sites More sharing options...
coyote064 Posted December 20, 2010 Share Posted December 20, 2010 hi all Did someone use this contrib in "products_listing" ? Thank bye coyote064 Quote Link to comment Share on other sites More sharing options...
Guest Posted February 20, 2011 Share Posted February 20, 2011 Hey Jack I have not asked you questions for awhile lol hehe...hope you are doing well. Your posts are always very helpful, the inputting fields on product info page were not showing and I followed suggestion you gave to other ppl that use contribution's stock product_info.php to check if its the problem in this file or application_top.php.....then I found I mistakenly (heavy modded store, guide for product_info page is not precise against my store) put the additional code of this contribution within <table> that is for product attributes in product_info.php ;) Now I have moved it out of that table and everything is working fine. Also you mentioned there is no database entry to limit number of characters in the field, and you would not be able to advice on it. The thing is, this contribution said all inputted texts are store in database, there must be a table to contain those info so can I find those database tables and insert different value into each table to limit the number of characters been entered? Or say DROP those info table and CREATE same tables again but with extra value that will limit how many characters can be inputted? Thanks Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted February 20, 2011 Share Posted February 20, 2011 Also you mentioned there is no database entry to limit number of characters in the field, and you would not be able to advice on it. The thing is, this contribution said all inputted texts are store in database, there must be a table to contain those info so can I find those database tables and insert different value into each table to limit the number of characters been entered? Or say DROP those info table and CREATE same tables again but with extra value that will limit how many characters can be inputted? I don't recall that conversation but I'm guessing I was talking about in the code. You can change the size of the fields in the database to limit the input but that would no stop someone from entering a longer string unless the code was changed too. The longer text entered would just be truncated so the customer would be confused since what they entered didn't match what is shown. So the correct way to do it would be to change the code to limit the input. Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
steffanih Posted February 25, 2011 Share Posted February 25, 2011 Hello, The customer input attributes are not appearing in the shopping cart. Could there be something causing a problem with this section of code(shopping_cart.php)? // denuz text attr $b = strpos($products[$i]['id'], '{'); if ($b === false) { $pid = $products[$i]['id']; } else { $pid = substr($products[$i]['id'], 0, $B); } $attr_q = tep_db_query("select cbta.*, pta.products_text_attributes_name from customers_basket_text_attributes as cbta, products_text_attributes as pta where cbta.products_text_attributes_id = pta.products_text_attributes_id and cbta.products_id = " . $pid . " and cbta.session_id = '" . $osCsid . "'"); while ($attr = tep_db_fetch_array($attr_q)) { $products_name .= '<br><small><i> - ' . $attr['products_text_attributes_name'] . ' ' . stripslashes($attr['products_text_attributes_text']) . '</i></small>'; } // eof denuz text attr Quote Link to comment Share on other sites More sharing options...
steffanih Posted February 25, 2011 Share Posted February 25, 2011 Nevermind, I had the second part of the manual install in the wrong place in application_top.php Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.