Latest News: (loading..)
alenkij

Imprint Text Options

332 posts in this topic

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?

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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 :)

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Imageimp1.jpg

 

Imageimp3.jpg

 

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

Imageimp2.jpg

 

 

 

bye thierry

Edited by thierryc

Share this post


Link to post
Share on other sites

Hello!, I'm new here, let me tell you about my issue, it's really weird, everything works just fine with the installation and I added the text fields and all. During the purchase process everything seems ok, the fields are displayed and filled with the info I entered, but the problem comes when the purchase is completed, the fields are not stored in the orders_text_attributes table, so the fields are not displayed in the invoice, the confirmation email, the purchase order or anything.

 

I've been fighting with this for the last two weeks, please help me!!!, what's wrong?, thanks in advance.

 

Greetings.

Share this post


Link to post
Share on other sites

Hello!, I'm new here, let me tell you about my issue, it's really weird, everything works just fine with the installation and I added the text fields and all. During the purchase process everything seems ok, the fields are displayed and filled with the info I entered, but the problem comes when the purchase is completed, the fields are not stored in the orders_text_attributes table, so the fields are not displayed in the invoice, the confirmation email, the purchase order or anything.

It sounds like you missed the changes for the checkout_confirmation, or maybe the checkout_process, page.

Share this post


Link to post
Share on other sites

It sounds like you missed the changes for the checkout_confirmation, or maybe the checkout_process, page.

 

Hey!, thanks for the fast answer, I just double checked the files you mention but they are fine, I have all the "denuz" code that must be included.

 

I don't know, I'm with a really big headache here, do you have any other idea, maybe it has something to do with sessions?, thanks in advance for your help.

 

Greetings.

Share this post


Link to post
Share on other sites

No, I'm sorry but can't think of any other reason why it would fail. You could try setting up a regular attribute (with the build-in code) and if that fails to follow through, then there is something wrong with your shop. Otherwise, it is probably related to this contribution.

Share this post


Link to post
Share on other sites

Hello,

 

Can somebody tell me how to get the imprint text options not to show in the shopping cart if the fields arent filled in at the product info page?

 

See example

 

PRODUCT INFO

productinfo-imprint.jpg

 

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

 

 

SHOPPING CART

shoppingcart-imprint.jpg

 

 

Nasco

Edited by wervelweb

Share this post


Link to post
Share on other sites

hi out there!

 

I am using this contribution and it really works fine.

 

Expect in the case when a customer is paying via IPAYMENT...

 

the contribution doesn't write all the database-records! The text-options are written into the table "customer_basket_text_attributes" but are not transferred to "orders_text_attributes".

 

in my checkout_process.php there are the following lines:

// denuz text attr

   $attr_q = tep_db_query("select * from customers_basket_text_attributes where session_id = '$osCsid' and products_id = " . tep_get_prid($order->products[$i]['id']));
   while ($attr = tep_db_fetch_array($attr_q)) {
      tep_db_query("insert into orders_text_attributes values ($insert_id, " . tep_get_prid($order->products[$i]['id']) . ", " . $attr['products_text_attributes_id'] . ", '" .  $attr['products_text_attributes_text'] . "')");
   }
   tep_db_query("delete from customers_basket_text_attributes where products_id = " . tep_get_prid($order->products[$i]['id']) . " and session_id = '" . $osCsid . "'");

// eof denuz text attr

 

but the query doesn't seem to be fired...

 

Any clues about solving this problem?

Share this post


Link to post
Share on other sites

no one out there who uses this contribution in combination with ipayment?!?!

 

Do i have to modify includes/modules/payment/ipayment_cc.php !?

Share this post


Link to post
Share on other sites

Downloaded 1_3_5 and ran the install sql query. Copied all files over. I cannot delete or edit the date & name attribs...I get 404 errors on the following URL:

 

http://www.mydomain.com/admin/FILENAME_TEXT_ATTRIBUTES?page=1&taID=2&action=edit&osCAdminID=e3ba99c616f6c2d034ccf998612b50dc

 

 

I read through the other replies to this error, but I'm not seeing why I would get an error...clean install, copied files over...?

Share this post


Link to post
Share on other sites

The capital letters, FILENAME_TEXT_ATTRIBUTES, indicate you made a mistake in the installation. Search the install instructions for FILENAME_TEXT_ATTRIBUTES and double check that you made that change.

 

 

My mistake, I thought all I had to do was run the install query & copy files. I made the changes per the install step 4, and now get this:

 

1146 - Table 'denisonco.TABLE_ADMINISTRATORS' doesn't exist

 

select id from TABLE_ADMINISTRATORS limit 1

 

[TEP STOP]

 

Unable to get into the admin area of the site...??? I appreciate the help!

Share this post


Link to post
Share on other sites

My mistake, I thought all I had to do was run the install query & copy files. I made the changes per the install step 4, and now get this:

 

1146 - Table 'denisonco.TABLE_ADMINISTRATORS' doesn't exist

Same problem. Capital letters mean a definition is missing. However, in this case, it is because you uploaded the files over the shops original. The files in the package are for an MS2 shop and you have an RC2 shop so you removed a standard definition that is needed by doing that. You need to restore your original files and make the changes manually.

Share this post


Link to post
Share on other sites

Same problem. Capital letters mean a definition is missing. However, in this case, it is because you uploaded the files over the shops original. The files in the package are for an MS2 shop and you have an RC2 shop so you removed a standard definition that is needed by doing that. You need to restore your original files and make the changes manually.

 

My apologies Jack...and thanks for your patience. I have double & triple checked. All files have been updated manually, I see the text attributes box in the admin. I can add & edit them now. However when I go to edit the actual product to check off the text attributes, it is not there. Once again I have double checked all the files that I've added your "denuz" code. Not sure where to troubleshoot next...?

 

Once again, thanks for the help...

 

Scott

Share this post


Link to post
Share on other sites

However when I go to edit the actual product to check off the text attributes, it is not there.

That's handled by the admin/categories.php file so if it is not working, and the attributest are setup correctly in admin->Catalog->Product Attributes, then there is most likely a mistake in that file. You can use the included one for a test but don't leave it in for production since it is not the same version. If it works, then use a compare program like WinMerge to compare the two files to find the mistake.

Share this post


Link to post
Share on other sites

That's handled by the admin/categories.php file so if it is not working, and the attributest are setup correctly in admin->Catalog->Product Attributes, then there is most likely a mistake in that file. You can use the included one for a test but don't leave it in for production since it is not the same version. If it works, then use a compare program like WinMerge to compare the two files to find the mistake.

For anyone else reading...having the same problem...it was user error once again. There were 2 spots for code in the categories.php file.

 

Thanks Jack

 

I'd like to know how to make sure the order is correct...it's coming up as line 2, line 1 & then line 3 when I added them I added them in order...? You can see it here:

http://denisonco.com/product_info.php?products_id=262

Share this post


Link to post
Share on other sites

I thought that was already handled but maybe not. Try this. In product_info.php, find this line

    $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']));

and change it to

    $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']) . " order by pta.products_text_attributes_name ASC");

I haven't tested this so be sure to backup your original file so you can restore it if there is a problem.

Share this post


Link to post
Share on other sites

I thought that was already handled but maybe not. Try this. In product_info.php, find this line

    $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']));

and change it to

    $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']) . " order by pta.products_text_attributes_name ASC");

I haven't tested this so be sure to backup your original file so you can restore it if there is a problem.

Great Job! That fixed it! Very good support!

Share this post


Link to post
Share on other sites

Hi,

I have installed Imprint Text V 1.3.5 using the manual method. When I attempt to open Admin/Catalog/Text Attributes (/admin/text_attributes.php) I get -

"Fatal error: Cannot redeclare _sess_open() (previously declared in /home/*****/public_html/****/admin/includes/functions/sessions.php:23) in /home/****/public_html/****/admin/includes/functions/sessions.php on line 23"

 

I've rechecked my install for any mistakes I may have made but can't find anything, please can anyone point me in the right direction? I'm fairly new to oscommerce so any help will be much appreciated, thanks in advance!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now