lcontreras27 Posted December 21, 2009 Share Posted December 21, 2009 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. Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted December 22, 2009 Share Posted December 22, 2009 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. 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...
lcontreras27 Posted December 22, 2009 Share Posted December 22, 2009 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. Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted December 22, 2009 Share Posted December 22, 2009 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. 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...
wervelweb Posted December 22, 2009 Share Posted December 22, 2009 (edited) 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 ---------------------------------------------------------------------------------------------------------------------------------------- SHOPPING CART Nasco Edited December 22, 2009 by wervelweb Quote Link to comment Share on other sites More sharing options...
mef-u Posted January 8, 2010 Share Posted January 8, 2010 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? Quote Link to comment Share on other sites More sharing options...
mef-u Posted January 12, 2010 Share Posted January 12, 2010 no one out there who uses this contribution in combination with ipayment?!?! Do i have to modify includes/modules/payment/ipayment_cc.php !? Quote Link to comment Share on other sites More sharing options...
massdigitalmedia Posted January 15, 2010 Share Posted January 15, 2010 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...? Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted January 16, 2010 Share Posted January 16, 2010 http://www.mydomain.com/admin/FILENAME_TEXT_ATTRIBUTES? 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. 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...
massdigitalmedia Posted January 16, 2010 Share Posted January 16, 2010 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! Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted January 16, 2010 Share Posted January 16, 2010 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. 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...
massdigitalmedia Posted January 16, 2010 Share Posted January 16, 2010 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 Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted January 16, 2010 Share Posted January 16, 2010 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. 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...
massdigitalmedia Posted January 16, 2010 Share Posted January 16, 2010 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 Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted January 17, 2010 Share Posted January 17, 2010 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. 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...
massdigitalmedia Posted January 17, 2010 Share Posted January 17, 2010 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! Quote Link to comment Share on other sites More sharing options...
mickamber Posted February 9, 2010 Share Posted February 9, 2010 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! Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted February 9, 2010 Share Posted February 9, 2010 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! Go to google and type this in the search box: site:www.oscommerce.com/forums Fatal error: Cannot redeclare _sess_open() 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...
mickamber Posted February 9, 2010 Share Posted February 9, 2010 Go to google and type this in the search box: site:www.oscommerce.com/forums Fatal error: Cannot redeclare _sess_open() Thanks for your swift reply - I've already googled this and can't find anything that looks like it could be useful. Everything else in Admin/Catalog is working OK, just the new 'Text Attributes' that produces this error. Quote Link to comment Share on other sites More sharing options...
Guest Posted February 13, 2010 Share Posted February 13, 2010 Can someone help me with this error: Error: Undefined index: products_text_attributes_text File: product_info.php Line: 328 How can I fix this? Quote Link to comment Share on other sites More sharing options...
fan4chevy Posted February 22, 2010 Share Posted February 22, 2010 Hi, Just installed the mod but getting errors. Not sure where to start! Below is error 1146 - Table 'MYDATABASE NAME HERE.products_text_attributes' doesn't exist 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 = 32 and cbta.products_text_attributes_id = pta.products_text_attributes_id and cbta.session_id = '4a644215f86adaacec4952cc13b2b63c' Your help is deeply appreciated Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted February 22, 2010 Share Posted February 22, 2010 Below is error 1146 - Table 'MYDATABASE NAME HERE.products_text_attributes' doesn't exist The answer totally depends on the actual error. 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 February 23, 2010 Share Posted February 23, 2010 (edited) The answer totally depends on the actual error. Do you think that something in the contrib is not matching my the sql uploaded to database? Here is some more of the errors on other pages relating to the contrib install: After adding product to cart: 1146 - Table 'MYDATABSE NAME.customers_basket_text_attributes' doesn't exist 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 = 89 and cbta.session_id = '' [TEP STOP] Edited February 23, 2010 by fan4chevy Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted February 23, 2010 Share Posted February 23, 2010 1146 - Table 'MYDATABSE NAME.customers_basket_text_attributes' doesn't exist Well, I doubt that the actual error says MYDATABSE NAME but since you've posted it twice, even after I asked for the real error, I assume that is the real error. And in that case, the code in your shop has a major problem and nothing to do with this contribution. You should post in the general support thread for assitance. 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 February 23, 2010 Share Posted February 23, 2010 Well, I doubt that the actual error says MYDATABSE NAME but since you've posted it twice, even after I asked for the real error, I assume that is the real error. And in that case, the code in your shop has a major problem and nothing to do with this contribution. You should post in the general support thread for assitance. Thank you for your help. Actually I was just removing the personal site information and leaving it general for security purposes which is why I put MYDATABSE instead of the actual. The resolution was actually a database issue which is now resolved. Thanks again. Quote Link to comment Share on other sites More sharing options...
New 
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.