Imprint Text Options

Daddyslipdisk · July 10, 2009

so maybe someone can help me here so I don't kill myself trying to find this. If the product_info.php appears to work okay with the template with this contribution BUT the product info area is like half as wide as it should be, where is that setting. The template is staying in place fine, but just that area of the page where the description is is 50% narrower than it should be. Where does that get fixed to widen that to double what it is now?

Well it's not right. The original one with the template has breadcrumbs and everything else, but if I have to handle it this way, that may be alright. Here is the code for the EXISTING template (not the one in denuz contribution);

<?php

/*

$Id: product_info.php,v 1.97 2003/07/01 14:34:54 hpdl Exp $

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

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">

<head>

function popupWindow(url) {

window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,res

izable=yes,copyhistory=no,width=100,height=100,screenX=150,screenY=150,top=150,le

ft=150')

}

//--></script>

</head>

<?php require(DIR_WS_INCLUDES . 'header.php'); ?>

<tr>

<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>

</td>

<?php

if ($product_check['total'] < 1) {

?>

<? tep_draw_heading_top(); ?>

<?php echo tep_draw_title_top();?>

<?php echo TEXT_PRODUCT_NOT_FOUND;?>

<?php echo tep_draw_title_bottom();?>

<? tep_draw_heading_top_1(); ?>

<!--

<td>

-->

<tr>

<td align="right"><?php echo '<a href="' . tep_href_link(FILENAME_DEFAULT) . '">' . tep_image_button('button_continue.gif', IMAGE_BUTTON_CONTINUE) . '</a>'; ?></td>

</tr>

</table>

<!--

</td>

</tr>

</table>

-->

<? tep_draw_heading_bottom_1(); ?>

<? tep_draw_heading_bottom(); ?>

<?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>

<? tep_draw_heading_top(); ?>

<?php echo tep_draw_title_top();?>

<?php echo $breadcrumb->trail(' » ')?>

<?php echo tep_draw_title_bottom();?>

<? tep_draw_heading_top_1(); ?>

<? tep_draw_heading_top_2(); ?>

<?php

if (tep_not_null($product_info['products_image'])) {

?>

<?php echo tep_draw_prod_top();?>

document.write('<?php echo '<a href="java script: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, ' style="margin:0px 0px 0px 0px;"') . ''; ?>');

//--></script>

<?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, ' style="margin:0px 0px 0px 0px;"') . ''; ?>

</noscript>

<?php echo tep_draw_prod_bottom();?>

</td></tr>

document.write('<?php echo '<div><a href="java script:popupWindow(\\\'' . tep_href_link(FILENAME_POPUP_IMAGE, 'pID=' . $product_info['products_id']) . '\\\')">' . TEXT_CLICK_TO_ENLARGE . '</a></div>'; ?>');

//--></script>

<?php echo '<div><a href="' . tep_href_link(DIR_WS_IMAGES . $product_info['products_image']) . '" target="_blank"><br style="line-height:7px">' . TEXT_CLICK_TO_ENLARGE . '</a></div>'; ?>

</noscript>

</td></tr>

</table>

</table>

</td></tr>

</table>

</td>

</tr>

</table>

<?php

}

?>

<? tep_draw_heading_bottom_2(); ?>

</table>

<? tep_draw_heading_top_2();?>

<?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) {

?>

<?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>

<?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)) {

?>

<br>

<?php echo $text_attributes['products_text_attributes_name'] . ': ' . 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'] : ''); ?>

<?php

}

?>

</td>

</tr>

<?php

}

?>

</table>

<?php

}

?>

<?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) {

?>

</table>

<?php

}

if (tep_not_null($product_info['products_url'])) {

?>

</table>

<?php

}

if ($product_info['products_date_available'] > date('Y-m-d H:i:s')) {

?>

</table>

<?php

} else {

?>

</table>

<?php

}

?>

<!--

-->

<tr>

<td class="main bg_input"><?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>'; ?><?php echo tep_draw_separator('spacer.gif', '15', '1'); ?><?php echo tep_draw_hidden_field('products_id', $product_info['products_id']) . tep_image_submit('button_add_to_cart1.gif', IMAGE_BUTTON_IN_CART); ?></td>

</tr>

</table><br style="line-height:1px;"><br style="line-height:10px;">

<!--

</td></tr>

</table>

-->

<? tep_draw_heading_bottom_2();?>

<? tep_draw_heading_bottom_1(); ?>

<?php tep_draw_heading_bottom();?>

<?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>

<?php require(DIR_WS_INCLUDES . 'column_right.php'); ?>

</td>

</tr>

</table>

<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>

</body>

</html>

<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

mandynl · August 3, 2009

Hi All,

i tried to install this before ,

but had a lot of problems with it .

Now I have been install this Contribution V1.3.5 (tnx jack for solve the problems)

now this contribute works great . (so far as i tested)

But......

I have also installed the contribution U HTML EMAILS

And here starts my little problem ,

if i order something and i fill in the extra text , no problem and i can also see it if i log in in my admin and check the order

but in the email what i and my customer get ,, i can't find anything back from this extra text ..

Does anyone has the experience what i need to change or what to do ?

to see the extra added text in the emails

Many thanks

mandy

helimanick · August 4, 2009

Jack_mcs · August 4, 2009

There are changed files in the contribution. Use those to find the problem.

Jack

mandynl · August 4, 2009

Hi Nick,

I had the same , problem was a little typo from me in catalog-admin-orders.php

i use Examdiff to compare the files ,,

the contribution works good here , except i have still the problem that the added text isnt in the E-mail pfffffffff

anyway hope someone can help me with this ,,

would really apreciate it

mandy

chadodes · August 11, 2009

Hey Guys, Hopefully someone can point me in the right direction..

I'm using Jack's Contrib 1.3.5

I'm not getting any errors, however I don't see the options to customize the text on the product info page..

I have double checked all my mods.. I even tried replacing my product_info.php

I know the admin side is working because i can create a new custom field, and it get's written to the database..

I ran

$query="select * from products_text_attributes where products_text_attributes_id = 3";

$result = mysql_query($query);

$array=mysql_fetch_assoc($result);

print_r($array);

and got my:

Array ( [products_text_attributes_id] => 3 [products_text_attributes_name] => First Name )

another thing I noticed, is in the admin side, after I put a check mark box beside the text option I want, save, update, and exit, I notice that when I go back in to that item, that the text field items are not showing up as being checked.. they are all defaulted to being unchecked but by new text field item I created is listed at least.

The only other contrib that might be getting in the way is the Prod Info (QTPro) (keeps track of stock and allows for product options.

my server: PHP Version 5.2.6, MySQL 5.0.67

I'm not running STS..

Ideas?

chadodes · August 11, 2009

Hey Guys, Hopefully someone can point me in the right direction..

I'm using Jack's Contrib 1.3.5

I'm not getting any errors, however I don't see the options to customize the text on the product info page..

I have double checked all my mods.. I even tried replacing my product_info.php

I know the admin side is working because i can create a new custom field, and it get's written to the database..

I ran

$query="select * from products_text_attributes where products_text_attributes_id = 3";

$result = mysql_query($query);

$array=mysql_fetch_assoc($result);

print_r($array);

and got my:

Array ( [products_text_attributes_id] => 3 [products_text_attributes_name] => First Name )

another thing I noticed, is in the admin side, after I put a check mark box beside the text option I want, save, update, and exit, I notice that when I go back in to that item, that the text field items are not showing up as being checked.. they are all defaulted to being unchecked but by new text field item I created is listed at least.

The only other contrib that might be getting in the way is the Prod Info (QTPro) (keeps track of stock and allows for product options.

my server: PHP Version 5.2.6, MySQL 5.0.67

I'm not running STS..

Ideas?

Never mind.. I fixed the error..

I placed one of the denuz file mod's too early in my admin\categories.php

I basically searched for "$languages = tep_get_languages();" and placed the denuz text right above it.. little did I know.. that that string repeats its self.

Thanks for reading :)

chadodes · August 12, 2009

Hello All,

New problem,

I can now see the customize text option..

I fill it out, hit add to cart.. and in the "What's in my cart" section.. I see the item, but I don't see the imprint text..

The text is written to the DB..and I have replaced my custom shopping_cart.php with the Jack 1.3.5 contrib and still no go..

am I supposed to see the text when I view my cart? or only when I click the item to edit it?

I also don't see the imprint text in my invoice or packing slip which are both replaced files.. so I expect something is broken.. I'm just not sure where.. as I have replaced pretty well all files on my site with the contrib one..

Jack_mcs · August 12, 2009

Hello All,

New problem,

I can now see the customize text option..

I fill it out, hit add to cart.. and in the "What's in my cart" section.. I see the item, but I don't see the imprint text..

The text is written to the DB..and I have replaced my custom shopping_cart.php with the Jack 1.3.5 contrib and still no go..

am I supposed to see the text when I view my cart? or only when I click the item to edit it?

I also don't see the imprint text in my invoice or packing slip which are both replaced files.. so I expect something is broken.. I'm just not sure where.. as I have replaced pretty well all files on my site with the contrib one..

If the attributes are set up correctly and showing on the product page, then when you add that product to the cart, the attribute should show too. If not, then there is most likely a mistake in either the includes/application_top.php or shopping_cart.php files, or maybe both.

Jack

mandynl · August 13, 2009

Hi ,

does anyone a solution ?

I have also installed the contribution U HTML EMAILS

,

if i order something and i fill in the extra text that is needed, no problem ,

everything works great

but in the email what i and my customer get ,,

i can't find anything back from this extra text ..

But if i log in as admin and check the order everything is there , also if i log in as custumor and check the order history i see the extra added text,

Does anyone has the experience what i need to change and what to do ?

to become the extra added text also in the emails

Many thanks

mandy

Edited August 13, 2009 by mandynl

railroadguy · August 28, 2009

I have this working, however, I can't seem to control the order. On the product page it's

line 1

line 2

line 3

line 4

but on the What's In My Cart? and Order Confirmation the order is totally different. Even on one or two product pages it's different. Is there a way to control the order of the options?

Coming from the database base I would have thought that they would always be in the same order.

Jack_mcs · August 28, 2009

I have this working, however, I can't seem to control the order. On the product page it's
line 1

line 2

line 3

line 4

but on the What's In My Cart? and Order Confirmation the order is totally different. Even on one or two product pages it's different. Is there a way to control the order of the options?

Coming from the database base I would have thought that they would always be in the same order.

There's not sorting code built in although I think adding them in the correct order may work. Or you can change this line in products_info.php. I haven't tried it but I think it will work.

  $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() . "'");

to this

  $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() . "' order by cbta.products_text_attributes_text ");

Jack

railroadguy · August 28, 2009

Thanks for the try. Did not work. It's really maddening.

Look at: https://www.brettcardsonline.com/Cards/prod...;products_id=45 that is the way they should be.

But then we have https://www.brettcardsonline.com/Cards/prod...;products_id=63

All items were loaded at the same time. Some show one while others show the other. I don't know what is causing this.

anointed · September 9, 2009

I have a small issue, nothing too major, please help if you can...

I've installed everything according to instructions.

Here is what's working properly...

1. Text Input boxes are showing on product_info.php

2. Input text data is showing on shopping cart summary page after adding item to cart

3. The last place I see input text data is on checkout confirmation page before submitting order

Here is the issue...

After hitting submit order on checkout confirmation page it goes to checkout confirmation page as normal.

However, my text input data never makes it to my admin panel orders.php page

I do see the other basic product attribute options show up, but the "text input" fields I entered on product info never made it. The confirmation email doesn't show "text input fields either.

Any idea whats happening? Here are some screenshots for your reference

product_info.php - Showing input fields - this is ok

Shopping Cart Page - this is ok

Checkout Confirmation Page - this is ok - last place I see input data

Order Page - this is the issue, data is not showing up under other attribute

Jack_mcs · September 9, 2009

After hitting submit order on checkout confirmation page it goes to checkout confirmation page as normal.

However, my text input data never makes it to my admin panel orders.php page

I do see the other basic product attribute options show up, but the "text input" fields I entered on product info never made it. The confirmation email doesn't show "text input fields either.

Any idea whats happening? Here are some screenshots for your reference

It is probably an installation error. Be sure you made the changes to all of the pages.

Jack

GR8M8 · September 24, 2009

G Day everyone

Firstly great contribution. Love it

I am having exactly the same problem as anoited

Any ideas?

Ray

dangerman · October 22, 2009

If you did a manual install of v1.3.5 and text input fields are not showing in your confirmation email this is how to fix it. Open checkout_process.php

1. FIND FOLLOWING (around line 220)

--------------------------------

//------insert customer choosen option eof ----
   $total_weight += ($order->products[$i]['qty'] * $order->products[$i]['weight']);
   $total_tax += tep_calculate_tax($total_products_price, $products_tax) * $order->products[$i]['qty'];
   $total_cost += $total_products_price;

   $products_ordered .= $order->products[$i]['qty'] . ' x ' . $order->products[$i]['name'] . ' (' . $order->products[$i]['model'] .') = ' . $currencies->display_price($order->products[$i]['final_price'], $order->products[$i]['tax'], $order->products[$i]['qty']) . $products_ordered_attributes . "\n\n";
 }

2. AND REPLACE BY FOLLOWING
  ------------------------

// denuz_arun text attr

     $pid = @mysql_result(tep_db_query("select products_id from products_description where products_name='" . tep_db_input($order->products[$i]['name']) . "'"), 0, "products_id");
  $denux_arunQry = "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 . " and pta.products_text_attributes_id = ota.products_text_attributes_id";
  //echo ;
     $attr_q = tep_db_query($denux_arunQry); $denux_arun_ ='';
     while ($attr = tep_db_fetch_array($attr_q)) {
       $denux_arun_ .=  $attr['products_text_attributes_name'] . ': ' . stripslashes($attr['products_text_attributes_text'])."\n";
     }

// eof denuz_arun text attr

//------insert customer choosen option eof ----
   $total_weight += ($order->products[$i]['qty'] * $order->products[$i]['weight']);
   $total_tax += tep_calculate_tax($total_products_price, $products_tax) * $order->products[$i]['qty'];
   $total_cost += $total_products_price;

   $products_ordered .= $order->products[$i]['qty'] . ' x ' . $order->products[$i]['name'] . ' (' . $order->products[$i]['model'] .') = ' . $currencies->display_price($order->products[$i]['final_price'], $order->products[$i]['tax'], $order->products[$i]['qty']) . $products_ordered_attributes . "\n". $denux_arun_ . "\n";
 }

The last line of code has been modified (. $denux_arun_ . "\n") but it is outside of the denuz tag. If you are copy/pasting code blocks obviously it will get missed. :(

I am still having the issue of text input fields showing on the customer side but not in admin. The best part is, it's only for some items, others work fine. Also, if the text input does not show in admin it does not show in the confirmation email as well. When it works, it works for both. Anyone seen this or have a solution?

October 23, 2009

The last line of code has been modified (. $denux_arun_ . "\n") but it is outside of the denuz tag. If you are copy/pasting code blocks obviously it will get missed. :(

I am still having the issue of text input fields showing on the customer side but not in admin. The best part is, it's only for some items, others work fine. Also, if the text input does not show in admin it does not show in the confirmation email as well. When it works, it works for both. Anyone seen this or have a solution?

Thanks, I would have gone nuts looking for that piece of code.

Do the items that show have other attributes attached?

When I add 2 different items with text options to the cart and go look at a third, it shows the options for both the items in the cart on a different product. Can this be fixed?

dangerman · October 28, 2009

This is what I did to fix the text input fields showing on the customer side but not in admin issue.

Open admin/invoice.php and find the following:

// denuz text attr

//      $pid = @mysql_result(tep_db_query("select products_id from products_description where products_name='" . tep_db_input($order->products[$i]['name']) . "'"), 0, "products_id");
     $pid_query = tep_db_query("select products_id from " . TABLE_PRODUCTS . " where products_model LIKE '" . tep_db_input($order->products[$i]['model']) . "'");

Replace with:



//      $pid = @mysql_result(tep_db_query("select products_id from products_description where products_name='" . tep_db_input($order->products[$i]['name']) . "'"), 0, "products_id");
     $pid_query = tep_db_query("select products_id from " . TABLE_PRODUCTS_DESCRIPTION . " where products_name = '" . tep_db_input($order->products[$i]['name']) . "'");

Open admin/packingslip.php and find the following:

// denuz text attr

     $pid_query = tep_db_query("select products_id from " . TABLE_PRODUCTS . " where products_model LIKE '" . tep_db_input($order->products[$i]['model']) . "'");

Replace with:

// denuz text attr

     $pid_query = tep_db_query("select products_id from " . TABLE_PRODUCTS_DESCRIPTION . " where products_name = '" . tep_db_input($order->products[$i]['name']) . "'");

Also (this may be a known issue but I was unaware) once you create a text attribute for a product don't use that same attribute for another product. This was causing problems for me as well.

Big Bear - sorry, I haven't seen that issue.

dangerman · October 28, 2009

I forgot to mention, after I got the text input fields to work in admin I had to make one more change so they would show up in the confirmation email as well.

Open checkout_process.php and find the following:

// denuz_arun text attr

     $pid_query = tep_db_query("select products_id from " . TABLE_PRODUCTS . " where products_model LIKE '" . tep_db_input($order->products[$i]['model']) . "'");

Replace with:

// denuz_arun text attr

     $pid_query = tep_db_query("select products_id from " . TABLE_PRODUCTS_DESCRIPTION . " where products_name = '" . tep_db_input($order->products[$i]['name']) . "'");

djruffle · November 20, 2009

Hi

I have just installed the imprint text options and all seems ok except the admin page under catalog.

When I click it I get a message saying:

"1146 - Table '####################.TABLE_TEXT_ATTRIBUTES' doesn't exist

select count(*) as total from TABLE_TEXT_ATTRIBUTES

[TEP STOP]"

########### is the database name

I have doubled checked the table is there and all other parts seem to function correctly as in on the product pages etc.

Can anyone help please?

Thanks

Dan

Jack_mcs · November 20, 2009

Capital letters in an error mean you made a mistake in the installation. Search through the instructions and/or files for TABLE_TEXT_ATTRIBUTES and compare what is there to what was actually done.

November 23, 2009

Thank you dangerman for your two last posts no #227 and #228 - I followed your advice/solutions and now this contribution works perfectly in my store!

Thanks :)

thierryc · November 30, 2009

Good morning, please excuse me for the writing because I do not speak English.

I use a translator to write you.

My problem, I installed the contribution without problem.

The frame to put the text is well in the chip article, on the contrary when I come back from the text, it is not displayed in the shopping cart.

On the contrary, if there is an article already in the shopping cart, the text and good in the shopping cart.

I do not succeed in understanding why, if there is 1 only article in the shopping cart the text is not displayed, if there is 2 the second article shows the text well.

I did again the installation, but nothing changes, I do not find why the first article in the shopping cart does not take the text.

Thank you in advance for your assistant.

thierryc · November 30, 2009

Good morning, please excuse me for the writing because I do not speak English.

I use a translator to write you.

My problem, I installed the contribution without problem.

The frame to put the text is well in the chip article, on the contrary when I come back from the text, it is not displayed in the shopping cart.

On the contrary, if there is an article already in the shopping cart, the text and good in the shopping cart.

I do not succeed in understanding why, if there is 1 only article in the shopping cart the text is not displayed, if there is 2 the second article shows the text well.

I did again the installation, but nothing changes, I do not find why the first article in the shopping cart does not take the text.

Thank you in advance for your assistant.

here are pictures

I also have problem when I turn articles on one I have the text of both articles

bye thierry

Edited November 30, 2009 by thierryc

Imprint Text Options

Recommended Posts

Link to comment

Share on other sites

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Posted Images

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation