bbaez

The following fixed "PayPal returned invalid or incomplete data to complete your order. Please try again or select an alternate payment method." < if (!preg_match("([C-E]{2})-([A-Z0-9]{17})", $_SESSION['paypal_ec_token'])) { --- > if (!preg_match("/([C-E]{2})-([A-Z0-9]{17})/", $_SESSION['paypal_ec_token'])) { The following fixed "Unfortunately the country of the address you selected is not currently one that we offer service to. If you have any questions, please feel free to contact us." $billing_address is being set to FALSE if no billing address is returned, so the statement will always be true. < if (isset($billing_address)) { --- > if (is_array($billing_address) &! empty($billing_address)) {

For anyone wanting to see the code changes (line numbers will be different): 1697c1697 < $this->cardinal_centinel_before_process(&$order_info); --- > $this->cardinal_centinel_before_process($order_info); 2266c2266 < function cardinal_centinel_before_process($order_info = '') { --- > function &cardinal_centinel_before_process($order_info = '') { 2301c2301 < $this->cardinal_centinel_lookup($auth_info, &$order_info); --- > $this->cardinal_centinel_lookup($auth_info, $order_info); 2303c2303 < $this->cardinal_centinel_authenticate($auth_info, &$order_info); --- > $this->cardinal_centinel_authenticate($auth_info, $order_info); 2308c2308 < function cardinal_centinel_lookup($auth_info, $order_info) { --- > function &cardinal_centinel_lookup($auth_info, $order_info) { 2383c2383 < function cardinal_centinel_authenticate($auth_info) { --- > function &cardinal_centinel_authenticate($auth_info) {

Rename to product_updates.php and place in catalog/admin/ to update a current install. BTW, you will need to download the full package in the contribution section to perform the full install and update with this file. Thanks for all the work MatthewRitchie!

Sorry to post so often, but if I don't note it I won't remember to post it later :) The order reappeared once I inserted "Shipped" to Localization -> Orders Status. Forgot to do that in our production server.

CP_track_num is on line 114 on eShipper_v2/admin/eshipper_export.php and is from Canada Post Tracking http://www.oscommerce.com/community/contri...ons,2464/page,2 CP_track_num varchar(18) default NULL Maybe since it is not documented it should be changed to eshipper_track_num?

Hi Natrium42, I posted a confirmation to a problem another user is having and would be interested in you mod to eShipper as the current workaround is to manually create labels at the eShipper site. Perhaps you can post the mod somewhere we can all have access to it. Thanks!

Hi Qbfinest83, Well today I just got the same problems that you are describing, including the label having FedEx Pri Overnight as well. I had to manually create eshipper/orders_documentation/ with 777 permissions. After that fix I get tep stop could not "update orders set CP_track_num = '123456789012' where orders_id = 1". So I'm smarter than that! I added the column with int(12) and the next thing that happened is the order disappeared off the orders page. Still exists in the database and you can manually alter the URL to see it. Looking back at the doc there is no information about CP_track_num. I canceled the incorrect shipping orders at eShipper and manually created a correct shipping order with UPS ground. This was the first time I used eShipper, someone else has to have had this problem? Any help out there? Thanks!

Thanks surfalot for the SEO link!

Problem: Pop up image not being displayed when selected from product_info.php, instead the homep page is being shown in a reduced size window. This may have started after URL Search Engine Safe is enabled. Example java script:popupWindow('http://www.infantstart.com/popup_add_image.php/imagesID/5&products_id=120&cPath=37') This would fix it, haven't located code yet to diagnose issue java script:popupWindow('http://www.infantstart.com/popup_add_image.php?imagesID=5&products_id=120&cPath=37') Did someone else come across this problem yet and I missed it in the board? Thanks!

This is to help Dan out: In my notes I have the following: # --- Missing ready_to_ship from eShipper v2.4. UPS_XML contribution? ALTER TABLE `products` ADD products_ready_to_ship INT(1) NOT NULL DEFAULT '0' AFTER `products_dim_type`; ALTER TABLE `products` ADD `products_hs_code` VARCHAR(13) NOT NULL DEFAULT '' AFTER `products_dim_type`; the classes directory in the package is shortened and should go into the existing classes. I have the following path for the missing file catalog/includes/classes/xmldocument_ex.php Missing text definitions for package dimensions/weight in admin/includes/languages/english/categories.php Bundled Mult-Product Update had missing products_ready_to_ship field in products table from UPS XML Rates and Services v1.0 contribution (http://www.oscommerce.com/community/contributions,1323, http://www.oscommerce.com/forums/index.php?showtopic=49382). // eShipper Beg define('TEXT_PRODUCTS_WEIGHT_TYPE', 'Unit of Weight'); define('TEXT_PRODUCTS_DIM_TYPE', 'Unit of Dimensions'); define('TEXT_PRODUCTS_LENGTH', 'Dimensional Length'); define('TEXT_PRODUCTS_WIDTH', 'Dimensional Width'); define('TEXT_PRODUCTS_HEIGHT', 'Dimensional Height'); // eShipper End Integrated Multi-Product_Update_1_5e $search and $listing fixes. Help my dump helps you! Check out www.infantstart.com after Jan. 15th 2009 for baby products!

Problem with code in function tep_is_image_still_used($image) file 'Additional Images v2.1.0\1_files_to_upload\catalog\admin\includes\functions' Manifested itself with query error due to single quote or backslashes. Crux of problem is that the file name needs to have none file system safe characters replaced and/or tep_db_input() or tep_db_prepare_input() used on variable $image for proper escaping of string for db queries. Am I correct in the diagnosis? [Mon Dec 15 16:30:35 2008] [error] [client 64.142.102.66] File does not exist: /var/www/html/images/products/bath/bath-accessories/Tub Time Rinse n\\' Pour Pitcher 08800 44f6d6396e90a1c9235ab83f0883d388s.jpg, referer: http://www.infantstart.com/admin/categorie...product_preview [Mon Dec 15 16:33:50 2008] [error] [client 64.142.102.66] File does not exist: /var/www/html/images/Rite-Temp\xe2\x84\xa2 Baby Bath Tub 08084 cd27cb692b23a88e8fe950bae9a5bf, referer: http://www.infantstart.com/admin/categorie...n=edit_category Error in admin panel during product update: 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 'Pour Pitcher 08800 44f6d6396e90a1c9235ab83f0883d388s.jpg' or products_image_med ' at line 1 select count(*) as total from products where products_image = 'products/bath/bath-accessories/Tub Time Rinse n' Pour Pitcher 08800 44f6d6396e90a1c9235ab83f0883d388s.jpg' or products_image_med = 'products/bath/bath-accessories/Tub Time Rinse n' Pour Pitcher 08800 44f6d6396e90a1c9235ab83f0883d388s.jpg' or products_image_pop = 'products/bath/bath-accessories/Tub Time Rinse n' Pour Pitcher 08800 44f6d6396e90a1c9235ab83f0883d388s.jpg' [TEP STOP]

Problems with gv_mail.ph and create_account.php already reported, but here is an explanation and line numbers. tep_db_insert_id() incorrect usage, db_link is expected by tep_db_insert_id; not a resource or boolean: Change the following lines to tep_db_insert_id(); catalog/create_account.php:251: $insert_id = tep_db_insert_id($insert_query); catalog/admin/gv_mail.php:64: $insert_id = tep_db_insert_id($insert_query); catalog/admin/gv_mail.php:84: $insert_id = tep_db_insert_id($insert_query);

Errors in coupon_admin.php and corrections catalog/admin/coupon_admin.php Epoch start time being inserted into date_created, also noticed that preview is removing time from datetime format to leave only YYYY-MM-DD. DATETIME ereg option not being used (ereg ('([0-9]{4})-([0-9]{1,2})-([0-9]{1,2})[ ]([0-9]{2}):([0-9]{2}):([0-9]{2})', $date)) change line 139 'date_created' => (($HTTP_POST_VARS['date_created'] != '0') ? $HTTP_POST_VARS['date_created'] : 'now()'), 'date_created' => ( (ereg( '([0-9]{4})-([0-9]{1,2})-([0-9]{1,2})', $HTTP_POST_VARS['date_created']) ) ? $HTTP_POST_VARS['date_created'] : 'now()'), Adding new coupon error: mysql_insert_id(): supplied argument is not a valid MYSQL-Link resource in .../admin/includes/functions/database.php on line 117 change line 159 $insert_id = tep_db_insert_id($query); $insert_id = tep_db_insert_id();