beachkitty85

I have attempted to install this contribution twice, both times with no luck. The first time I compared my files to the "Registry Redux" package files and made all the necessary changes. The second time I followed the manual install instructions posted in the "oops this is it for real" package. Both times I had the same problem: I can create registries but cannot add items to them. Also, I am not shown the text at the top of the page saying "You are in registry mode" or anything like that. I checked and there is no value being passed for the "registry_mode_id" variable. Any help is much appreciated!

Here is my upsxml.log DATE AND TIME: 2007-10-01 11:39:26 UPS URL: https://www.ups.com:443/ups.app/xml/TimeInTransit UPS REQUEST using exec(): <?xml version="1.0"?> <AccessRequest xml:lang="en-US"> <AccessLicenseNumber>xxx</AccessLicenseNumber> <UserId>xxx</UserId> <Password>xxx</Password> </AccessRequest> <?xml version="1.0"?> <TimeInTransitRequest xml:lang="en-US"> <Request> <TransactionReference> <CustomerContext>Time in Transit</CustomerContext> <XpciVersion>1.0002</XpciVersion> </TransactionReference> <RequestAction>TimeInTransit</RequestAction> </Request> <TransitFrom> <AddressArtifactFormat> <PoliticalDivision2>Charlotte</PoliticalDivision2> <PoliticalDivision1>NC</PoliticalDivision1> <CountryCode>US</CountryCode> <PostcodePrimaryLow>28269</PostcodePrimaryLow> </AddressArtifactFormat> </TransitFrom> <TransitTo> <AddressArtifactFormat> <PoliticalDivision2>Woodstock</PoliticalDivision2> <PoliticalDivision1>ON</PoliticalDivision1> <CountryCode>CA</CountryCode> <PostcodePrimaryLow>N4S9A2</PostcodePrimaryLow> <PostcodePrimaryHigh>N4S9A2</PostcodePrimaryHigh> </AddressArtifactFormat> </TransitTo> <ShipmentWeight> <UnitOfMeasurement> <Code>LBS</Code> </UnitOfMeasurement> <Weight>0.6</Weight> </ShipmentWeight> <InvoiceLineTotal> <CurrencyCode>USD</CurrencyCode> <MonetaryValue>9</MonetaryValue> </InvoiceLineTotal> <PickupDate>20071004</PickupDate> </TimeInTransitRequest>

I'm having the exact same issues with my store. I have added the suggested GoDaddy fix and read all the information I can get my hands on. I am getting the same error log emails above as well as a 2013 Lost Connection error. Any help is much appreciated!

After doing all I can think of to lower my db queries, it's not helping the problem. It seemed to help, but it's hard to tell because the 2013 error comes and goes. Today it is occurring every single time I try and checkout. When I disable UPS XML shipping, the error immediately disappears. Also, the error does not appear on any other page except checkout_shipping. Any help is much appreciated. Edit: This post sums up my problem exactly. I was just notified that the store is receiving the following 3 error messages when attempting to checkout: UPSXML TimeInTransit Error: : experienced by customer with id 32 on 2007-10-01 10:55:13 UPSXML Rates Error: Rating and Service 1.0001 0 An unknown error occured while attempting to contact the UPS gateway : Rating and Service 1.0001 0 An unknown error occured while attempting to contact the UPS gateway experienced by customer with id 32 on 2007-10-01 10:54:44 Error from cURL: Error [28]: connect() timed out! experienced by customer with id 32 on 2007-10-01 10:53:43

Thanks for your help. I'll post in the thread you linked to.

Okay, I installed optimize categories_box and optimize tep_get_tax_rate and now I'm down to: Current Parse Time: 5.076 s with 247 queries. So, I've gotten rid of 72 queries and 8.5 seconds. Any other contributions or posts that might help me? Thank so much.

Okay, my checkout shipping page gave me the following information: Current Parse Time: 13.657 s with 319 queries Obviously something needs to be done about that. Can you point me in the right direction?

I'm also having the 2013 issue. I've installed UPS XML shipping, but the module has been installed for several months and this error just recently cropped up. I have, however, recently added Canadian taxes and Canadian shipping fees (a handling fee and a low order fee only for international customers, to be exact). While waiting on the checkout_shipping page to load, I get the following message (sometimes): Categories 2013 - Lost connection to MySQL server during query select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name [TEP STOP]

This is just a guess, but maybe you should enter a value for MODULE_PAYMENT_AUTHORIZENET_EMAIL_CUSTOMER in your control panel, or if you can't find it there enter the value directly from the database. I think your shop is timing out because the specified configuration_key is not defined. Hope that helps!

I made these changes, uninstalled the module, re-installed it, and the checkout shipping page seems to work fine now. I'll update you if something goes haywire. Thanks so much for your help!

I installed this module several months ago and I added the GoDaddy fix as suggested. This module works perfectly most of the time, but every now and again I get the following in the error log: UPSXML TimeInTransit Error: 270019: TimeInTransit system not available experienced by customer with id 152 on 2007-09-22 22:01:59 When I go to test things out, sometimes I am able to checkout with no problem (when logged in as the customer in question with the same items in my cart) and sometimes the checkout_shipping.php page never loads, causing the error above. I've searched and can't find anyone having a similar problem. Any suggestions?

Well my only option at this point (after hours of frustration and wasted time) is to uninstall the contribution and search for a more functional, better supported one.

One more thing I forgot to mention. Admin_account.php was giving me the following error: 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 g.admin_groups_id=' at line 1 select a.admin_id, a.admin_firstname, a.admin_lastname, a.admin_email_address, a.admin_created, a.admin_modified, a.admin_logdate, a.admin_lognum, g.admin_groups_name from admin a, admin_groups g where a.admin_id= and g.admin_groups_id= [TEP STOP] I assume that the error is caused by $login_id and $login_groups_id being empty. So, to get rid of the error, I replaced $my_account_query = tep_db_query ("select a.admin_id, a.admin_firstname, a.admin_lastname, a.admin_email_address, a.admin_created, a.admin_modified, a.admin_logdate, a.admin_lognum, g.admin_groups_name from " . TABLE_ADMIN . " a, " . TABLE_ADMIN_GROUPS . " g where a.admin_id=". $login_id ." and g.admin_groups_id=". $login_groups_id .""); with $my_account_query = tep_db_query ("select a.admin_id, a.admin_firstname, a.admin_lastname, a.admin_email_address, a.admin_created, a.admin_modified, a.admin_logdate, a.admin_lognum, g.admin_groups_name from " . TABLE_ADMIN . " a, " . TABLE_ADMIN_GROUPS . " g where a.admin_id=1 and g.admin_groups_id=1");

Okay, when I cleared out the sessions table I was then able to login. Now, after login, I am taken immediately to admin_account.php and am not shown aolumn_left.php at all. I can't do anything (productive) from this page and all I see is an 'Edit' button that allows me to confirm my password. Please help!

I have followed all the instructions for installation, but I can't login. Even when I generate a new password from password_forgotten.php, this will not allow me to login. When I enter the correct username and password, login.php just refreshes. If I enter incorrect info, it gives me an error message telling me my info was incorrect. Can anyone help me?

I have followed the install instruction exactly. At first, I could login just fine. Then, when I created another user, I could no longer login. Login.php will either refresh or give me an error message about my username/password. Even when I get a new password through password_forgtotten.php, I still can't login. Could anyone help me out? Thanks in advance.

I figured out how to get the quantity to work on the product_info.php page with this contribution. I don't know is anyone else is having this problem, but just in case here is the solution.

In my post #616, my code was wrong. I noticed that the files where no longer being uploaded. So, to get the quantity in product_info.php to work with Option Types 1.6 and File Uplaod .7, change lines 399-434, (the add_product case), to: // 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'])) { $qty = preg_replace('/[^0-9]/i', '', $HTTP_POST_VARS['quantity']); // iii 030813 added: File uploading: save uploaded files with unique file names $real_ids = $HTTP_POST_VARS['id']; if ($HTTP_POST_VARS['number_of_uploads'] > 0) { require(DIR_WS_CLASSES . 'upload.php'); for ($i = 1; $i <= $HTTP_POST_VARS['number_of_uploads']; $i++) { if (tep_not_null($_FILES['id']['tmp_name'][TEXT_PREFIX . $HTTP_POST_VARS[uPLOAD_PREFIX . $i]]) and ($_FILES['id']['tmp_name'][TEXT_PREFIX . $HTTP_POST_VARS[uPLOAD_PREFIX . $i]] != 'none')) { $products_options_file = new upload('id'); $products_options_file->set_destination(DIR_FS_UPLOADS); if ($products_options_file->parse(TEXT_PREFIX . $HTTP_POST_VARS[uPLOAD_PREFIX . $i])) { if (tep_session_is_registered('customer_id')) { tep_db_query("insert into " . TABLE_FILES_UPLOADED . " (sesskey, customers_id, files_uploaded_name) values('" . tep_session_id() . "', '" . $customer_id . "', '" . tep_db_input($products_options_file->filename) . "')"); } else { tep_db_query("insert into " . TABLE_FILES_UPLOADED . " (sesskey, files_uploaded_name) values('" . tep_session_id() . "', '" . tep_db_input($products_options_file->filename) . "')"); } $insert_id = tep_db_insert_id(); $real_ids[TEXT_PREFIX . $HTTP_POST_VARS[uPLOAD_PREFIX . $i]] = $insert_id . ". " . $products_options_file->filename; $products_options_file->set_filename("$insert_id" . $products_options_file->filename); if (!($products_options_file->save())) { break 2; } } else { break 2; } } else { // No file uploaded -- use previous value $real_ids[TEXT_PREFIX . $HTTP_POST_VARS[uPLOAD_PREFIX . $i]] = $HTTP_POST_VARS[TEXT_PREFIX . UPLOAD_PREFIX . $i]; } } } $cart->add_cart($HTTP_POST_VARS['products_id'], $cart->get_quantity(tep_get_uprid($HTTP_POST_VARS['products_id'], $real_ids))+($qty == '' || $qty < 1 ? '1' : $qty), $real_ids); // iii 030813 end of changes. } tep_redirect(tep_href_link($goto, tep_get_all_get_params($parameters))); break;

I figured out the problem. In application_top.php, I changed lines 399-434 from // 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'])) { // iii 030813 added: File uploading: save uploaded files with unique file names $real_ids = $HTTP_POST_VARS['id']; if ($HTTP_POST_VARS['number_of_uploads'] > 0) { require(DIR_WS_CLASSES . 'upload.php'); for ($i = 1; $i <= $HTTP_POST_VARS['number_of_uploads']; $i++) { if (tep_not_null($_FILES['id']['tmp_name'][TEXT_PREFIX . $HTTP_POST_VARS[uPLOAD_PREFIX . $i]]) and ($_FILES['id']['tmp_name'][TEXT_PREFIX . $HTTP_POST_VARS[uPLOAD_PREFIX . $i]] != 'none')) { $products_options_file = new upload('id'); $products_options_file->set_destination(DIR_FS_UPLOADS); if ($products_options_file->parse(TEXT_PREFIX . $HTTP_POST_VARS[uPLOAD_PREFIX . $i])) { if (tep_session_is_registered('customer_id')) { tep_db_query("insert into " . TABLE_FILES_UPLOADED . " (sesskey, customers_id, files_uploaded_name) values('" . tep_session_id() . "', '" . $customer_id . "', '" . tep_db_input($products_options_file->filename) . "')"); } else { tep_db_query("insert into " . TABLE_FILES_UPLOADED . " (sesskey, files_uploaded_name) values('" . tep_session_id() . "', '" . tep_db_input($products_options_file->filename) . "')"); } $insert_id = tep_db_insert_id(); $real_ids[TEXT_PREFIX . $HTTP_POST_VARS[uPLOAD_PREFIX . $i]] = $insert_id . ". " . $products_options_file->filename; $products_options_file->set_filename("$insert_id" . $products_options_file->filename); if (!($products_options_file->save())) { break 2; } } else { break 2; } } else { // No file uploaded -- use previous value $real_ids[TEXT_PREFIX . $HTTP_POST_VARS[uPLOAD_PREFIX . $i]] = $HTTP_POST_VARS[TEXT_PREFIX . UPLOAD_PREFIX . $i]; } } } $cart->add_cart($HTTP_POST_VARS['products_id'], $cart->get_quantity(tep_get_uprid($HTTP_POST_VARS['products_id'], $real_ids))+1, $real_ids); // iii 030813 end of changes. } tep_redirect(tep_href_link($goto, tep_get_all_get_params($parameters))); break; to // 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'])) { $qty = preg_replace('/[^0-9]/i', '', $HTTP_POST_VARS['quantity']); // iii 030813 added: File uploading: save uploaded files with unique file names $real_ids = $HTTP_POST_VARS['id']; if ($HTTP_POST_VARS['number_of_uploads'] > 0) { require(DIR_WS_CLASSES . 'upload.php'); for ($i = 1; $i <= $HTTP_POST_VARS['number_of_uploads']; $i++) { if (tep_not_null($_FILES['id']['tmp_name'][TEXT_PREFIX . $HTTP_POST_VARS[uPLOAD_PREFIX . $i]]) and ($_FILES['id']['tmp_name'][TEXT_PREFIX . $HTTP_POST_VARS[uPLOAD_PREFIX . $i]] != 'none')) { $products_options_file = new upload('id'); $products_options_file->set_destination(DIR_FS_UPLOADS); if ($products_options_file->parse(TEXT_PREFIX . $HTTP_POST_VARS[uPLOAD_PREFIX . $i])) { if (tep_session_is_registered('customer_id')) { tep_db_query("insert into " . TABLE_FILES_UPLOADED . " (sesskey, customers_id, files_uploaded_name) values('" . tep_session_id() . "', '" . $customer_id . "', '" . tep_db_input($products_options_file->filename) . "')"); } else { tep_db_query("insert into " . TABLE_FILES_UPLOADED . " (sesskey, files_uploaded_name) values('" . tep_session_id() . "', '" . tep_db_input($products_options_file->filename) . "')"); } $insert_id = tep_db_insert_id(); $real_ids[TEXT_PREFIX . $HTTP_POST_VARS[uPLOAD_PREFIX . $i]] = $insert_id . ". " . $products_options_file->filename; $products_options_file->set_filename("$insert_id" . $products_options_file->filename); if (!($products_options_file->save())) { break 2; } } else { break 2; } } else { // No file uploaded -- use previous value $real_ids[TEXT_PREFIX . $HTTP_POST_VARS[uPLOAD_PREFIX . $i]] = $HTTP_POST_VARS[TEXT_PREFIX . UPLOAD_PREFIX . $i]; } } } $cart->add_cart($HTTP_POST_VARS['products_id'], $cart->get_quantity(tep_get_uprid($HTTP_POST_VARS['products_id'], $HTTP_POST_VARS['id']))+ ($qty == '' || $qty < 1 ? '1' : $qty), $HTTP_POST_VARS['id']); // iii 030813 end of changes. } tep_redirect(tep_href_link($goto, tep_get_all_get_params($parameters))); break;

This contribution is wonderful and I absolutely love it! With that being said, I need some help. I have a quanity box in my product_info page that no longer works after installing this contribution in combination with the file upload add on. I posted in that forum with no response so I thought I'd try my luck here. Could someone please give me a hint as to where to look. Also, is there a way to have a product option type that works as a quantity field?

First please take a look at what I'm trying to do with product attributes at my test site. Ok, so I need to charge customers the wordcount multiplied by the turnaround time. For example, if the turnaround time of 12 hours is selected, it's value might be $0.10. Then the wordcount selected might be 500. I need these two values to be multiplied to get at a final price of $50.00. Any ideas? I'm totally stumped. I tried using a standard quantity field for the wordcount, but I can't get it to work after installing this contribution. Thanks in advance! B)

Verify that you added the changes to htaccess correctly. This is most likely where the 500 error is coming from.

In includes/modules/article_listing.php I'd like to have the rows split into even and odd rows, like the product listing pages. This way I'll be able to give an alternating background color so it's easier to look at the page and tell what's going on. Is this something fairly simple to do and, if so, does anyone know how? Thanks so much. Here is a link to the page in question.

I'm sure I changed it at some point without realizing what it would cause, but I can't find where. Could you possibly give me a hint as to where to look? It's not in html_output.php. Thanks so much.

Wow, now it works perfectly! You said I needed to find the initial encoding and remove it, so how do I do that? Thanks so much for your help already.