alfinator

Well, looks like I figured this out. Replace the query posted earlier with this one instead: $specials_query_raw = "select A.products_id, B.products_name, A.products_price, C.specials_id, C.specials_new_products_price, C.specials_date_added, C.specials_last_modified, C.expires_date, C.date_status_change, C.status, F.special_id from (" . TABLE_PRODUCTS . " A, " . TABLE_PRODUCTS_DESCRIPTION . " B , products_to_categories E ) left join " . TABLE_SPECIALS . " C on C.products_id = A.products_id left join special_product F on A.products_id = F.product_id left join special_category D on E.categories_id = D.categ_id where E.categories_id = $categ_id and E.products_id = A.products_id and A.products_id = B.products_id and B.language_id = '" . (int)$languages_id . "' order by F.special_id, C.specials_id, B.products_name "; For mysql5, you have to wrap multiple table declarations prior to a LEFT JOIN in parenthesis. I just tried it out on my site and it seems to work again. Hope this helps. Alfredo

I'm also at a loss on how to convert this to work with MYSQL5. Does anyone have a fix for this? Many thanks in advance.

I am also very interested in a solution to this. We currently use a laser printer to print our labels from the automated FedEx labels contrib but really want to move to using a thermal printer for cost/speed gains.

Thanks! The tip given for the mysql error worked like a charm.

Hello, I've got a really wierd thing going on with my WishList. When I am logged in as a user from the United States, I can click on the "Move to Cart" button in the Wishlist info box and all works well. However, if I am logged in as a user from any other country, and attempt this same operation, I get the following error from wishlist.php: 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 '-12, 12' at line 1 select * from customers_wishlist where customers_id = '48' order by products_name limit -12, 12 Does anyone have an idea what might be causing this? I'm not that versed in SQL, so I don't know how to look and see if something is corrupt in the database. Thanks.

Thanks. This worked great. The only change I had to make was instead of calling: $order_info['delivery_street_address_2'] I called $order_info['delivery_suburb'] Thanks again for the quick and in-depth response.

Hello, Great contrib! This is working well on my site with only following issue. The Address Line2 is not showing up on the generated label. Does anyone know what might be causing this. Thanks in advance.

I got it working. The problem was with the PayPal sandox .... again. It's amazing how much time that thing has cost me. Anyway, thanks so much for the wonderful contribution.

Didn't get a response so thought I would post again. My "internal error" problem from before was indeed a PayPal problem. Thanks. I'm now able to get to the payment screen, but when I click on the "Return to Merchant" button after paying, I get directed to an empty shopping cart on my site. Here is the code snippet from my checkout_success.php file: require('includes/application_top.php'); // if the customer is not logged on, redirect them to the shopping cart page if (!tep_session_is_registered('customer_id')) { tep_redirect(tep_href_link(FILENAME_SHOPPING_CART)); } if (isset($HTTP_GET_VARS['action']) && ($HTTP_GET_VARS['action'] == 'update')) { $notify_string = 'action=notify&'; $notify = $HTTP_POST_VARS['notify']; if (!is_array($notify)) $notify = array($notify); for ($i=0, $n=sizeof($notify); $i<$n; $i++) { $notify_string .= 'notify[]=' . $notify[$i] . '&'; } if (strlen($notify_string) > 0) $notify_string = substr($notify_string, 0, -1); //begin PayPal_Shopping_Cart_IPN tep_redirect(tep_href_link(FILENAME_DEFAULT, $notify_string)); } else if ((isset($HTTP_GET_VARS['action']) && $HTTP_GET_VARS['action'] == 'success')) { paypal_order::reset_checkout_cart_session(); } //end PayPal_Shopping_Cart_IPN require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_CHECKOUT_SUCCESS); Can anyone see what I might have done wrong? I see the orders show up as pending on my admin screen, but don't see any IPN traffic. Thanks again for all of your help.

My "internal error" problem from before was indeed a PayPal problem. Thanks. I'm now able to get to the payment screen, but when I click on the "Return to Merchant" button after paying, I get directed to an empty shopping cart on my site. Here is the code snippet from my checkout_success.php file: require('includes/application_top.php'); // if the customer is not logged on, redirect them to the shopping cart page if (!tep_session_is_registered('customer_id')) { tep_redirect(tep_href_link(FILENAME_SHOPPING_CART)); } if (isset($HTTP_GET_VARS['action']) && ($HTTP_GET_VARS['action'] == 'update')) { $notify_string = 'action=notify&'; $notify = $HTTP_POST_VARS['notify']; if (!is_array($notify)) $notify = array($notify); for ($i=0, $n=sizeof($notify); $i<$n; $i++) { $notify_string .= 'notify[]=' . $notify[$i] . '&'; } if (strlen($notify_string) > 0) $notify_string = substr($notify_string, 0, -1); //begin PayPal_Shopping_Cart_IPN tep_redirect(tep_href_link(FILENAME_DEFAULT, $notify_string)); } else if ((isset($HTTP_GET_VARS['action']) && $HTTP_GET_VARS['action'] == 'success')) { paypal_order::reset_checkout_cart_session(); } //end PayPal_Shopping_Cart_IPN require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_CHECKOUT_SUCCESS); Can anyone see what I might have done wrong? I'm also not getting any emails to my debug email address and my virtual customer is not getting emailed once the transaction is paid. I see the orders show up as pending on my admin screen, but don't see any IPN traffic. Thanks again for all of your help.

Hello, I've been trying to integrate this contribution into my installation of osCommerce but get the same failure each time. Basically I get all the way through the checkout process, my customer information transfers to the PayPal sandbox, but when I try to pay for the item and hit "Continue Checkout", I get the following error message: Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error. More information about this error may be available in the server error log. Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request. Apache/1.3.27 Server at www.sandbox.paypal.com Port 443 Any ideas? I've installed the module twice with the same results. Thanks. Alfredo Nevarez