Latest News: (loading..)

Roaddoctor

Members
  • Content count

    1,167
  • Joined

  • Last visited

  • Days Won

    1

Roaddoctor last won the day on September 13 2015

Roaddoctor had the most liked content!

3 Followers

About Roaddoctor

Profile Information

  1. I don't know if its related, but yesterday, an overnight cURL update on my server did not go right or something, because I had the complete paypal failure situation just like you described until I did a graceful reboot of the server and all was suddenly resolved... hope that helps
  2. @@Harald Ponce de Leon Harald, I'm sorry - I have no idea why, but I rebooted the server and all is well... hrmmmmmmmmmmmmm how frustrating. Thank you for the quick reply!! David on True/Default cURL Version: 7.29.0 cURL SSL Version: NSS/3.21 Basic ECC Default Setting: Success TLS v1.2: Success
  3. it was working just fine on default since the 5.010 update. Then it seems all logging and orders ceased sometime yesterday afternoon. the server is very modern php5.6 tls 1.2 etc,,, Using the test tool I get "A general error occurred. Please try again." with both settings
  4. @@Harald Ponce de Leon
  5. WTF is going on.... the PayPal AP is not working, not logging, nothing.... not even pulling a balance... is it PayPal or the AP developer?.... I'm losing orders in droves. Express goes to page not found, standard freezes on process... I'm on 5.010... and also noted the update button is gone this morning....
  6. @@kymation @@bruyndoncx I went with this for now - seems to be OK. Thank you for the help! // echo 'ecomm_totalvalue: \'' . $this->page_totalvalue . '\'' . "\n"; // default // Fix if( empty( $this->page_totalvalue ) ) { echo 'ecomm_totalvalue: ' . '0' . '' . "\n"; // No use including the variable if it's empty (null) } else { echo 'ecomm_totalvalue: ' . $this->page_totalvalue . '' . "\n"; } // end fix
  7. echo 'ecomm_totalvalue: \'' . $this->page_totalvalue . '\'' . "\n"; This line is giving me issues... First the current Google spec call for a numeric entry with no quotes. I tried changing to echo 'ecomm_totalvalue: ' . $this->page_totalvalue . '' . "\n"; which works on product pages that have a price, but gives an error on all other pages that do not have a product (null entries), with error "Tag Paramater object could not be parsed." So the original line works ok on non product pages but not well on product pages. The revised line works ok on product pages, but not on other pages What do do? Any help appreciated. The code is brief, so here is the whole file: adwords_tag.php (remarketing tag) class adwords_tag { /** * $page_totalvalue is the current page type * @var object */ var $page_type; /** * $page_totalvalue is the current page products ids * @var object */ var $page_products_id; /** * $page_totalvalue is the current page products total value * @var object */ var $page_totalvalue; /** * $installer is the installer object * @var object */ var $installer; function adwords_tag() { $this->installer = new adwords_tag_install; $scriptname = ltrim(basename($_SERVER['SCRIPT_NAME'])); $return = array(); switch($scriptname){ case FILENAME_DEFAULT: global $category_depth; if($category_depth == 'top') $this->page_type = 'home'; else $this->page_type = 'category'; $this->page_products_id = "''"; break; case FILENAME_PRODUCT_INFO: global $_GET, $currency, $currencies; if(tep_not_null($_GET['products_id'])){ $this->page_products_id = "'" . $_GET['products_id'] . "'"; global $product_info; $rate = $currencies->currencies[$currency]['value']; $decimal_places = $currencies->currencies[$currency]['decimal_places']; $this->page_totalvalue = number_format(tep_add_tax($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) * $rate, $decimal_places); if($new_price = tep_get_products_special_price($product_info['products_id'])) $this->page_totalvalue = number_format(tep_add_tax($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])), $decimal_places); }else{ $this->page_products_id = "''"; } $this->page_type = 'product'; break; case FILENAME_SHOPPING_CART: global $cart, $currency, $currencies; if($cart && is_object($cart)){ $products_id_list = array(); foreach($cart->contents as $products_id => $products_content) $products_id_list[] = "'" . (int)$products_id . "'"; if(count($products_id_list) <= 0) $this->page_products_id = "''"; elseif(count($products_id_list) == 1) $this->page_products_id = $products_id_list[0]; else $this->page_products_id = '[' . implode(',', $products_id_list) . ']'; $rate = $currencies->currencies[$currency]['value']; $decimal_places = $currencies->currencies[$currency]['decimal_places']; $this->page_totalvalue = number_format($cart->show_total() * $rate, $decimal_places); }else{ $this->page_products_id = "''"; } $this->page_type = 'cart'; break; case FILENAME_CHECKOUT_SHIPPING: case FILENAME_CHECKOUT_PAYMENT: case FILENAME_CHECKOUT_CONFIRMATION: case FILENAME_CHECKOUT_SUCCESS: global $order, $currency, $currencies; if($order && is_object($order)){ $products_id_list = array(); foreach($order->products as $product) $products_id_list[] = "'" . (int)$product['id'] . "'"; if(count($products_id_list) <= 0) $this->page_products_id = "''"; elseif(count($products_id_list) == 1) $this->page_products_id = $products_id_list[0]; else $this->page_products_id = '[' . implode(',', $products_id_list) . ']'; $rate = $currencies->currencies[$currency]['value']; $decimal_places = $currencies->currencies[$currency]['decimal_places']; if($scriptname == FILENAME_CHECKOUT_SHIPPING || $scriptname == FILENAME_CHECKOUT_PAYMENT){ // calculate the shipping tax if($scriptname == FILENAME_CHECKOUT_PAYMENT){ require(DIR_WS_CLASSES . 'shipping.php'); $shipping_modules = new shipping; } $module = substr($GLOBALS['shipping']['id'], 0, strpos($GLOBALS['shipping']['id'], '_')); $shipping_tax = tep_get_tax_rate($GLOBALS[$module]->tax_class, $order->delivery['country']['id'], $order->delivery['zone_id']); $order->info['total'] += tep_calculate_tax($order->info['shipping_cost'], $shipping_tax); } $this->page_totalvalue = number_format($order->info['total'] * $rate, $decimal_places); }else{ $this->page_products_id = "''"; } $this->page_type = 'purchase'; break; case FILENAME_ADVANCED_SEARCH_RESULT: $this->page_products_id = "''"; $this->page_type = 'searchresults'; break; default: $this->page_products_id = "''"; $this->page_type = 'other'; } } function output() { echo '<script type="text/javascript">' . "\n"; echo 'var google_tag_params = {' . "\n"; echo 'ecomm_prodid: ' . $this->page_products_id . ',' . "\n"; echo 'ecomm_pagetype: \'' . $this->page_type . '\',' . "\n"; // echo 'ecomm_totalvalue: \'' . $this->page_totalvalue . '\'' . "\n"; echo 'ecomm_totalvalue: ' . $this->page_totalvalue . '' . "\n"; echo '};' . "\n"; echo '</script>' . "\n"; echo '<script type="text/javascript">' . "\n"; echo '/* <![CDATA[ */' . "\n"; echo 'var google_conversion_id = ' . ADWORDS_TAG_GOOGLE_CONVERSION_ID . ';' . "\n"; if (tep_not_null(ADWORDS_TAG_GOOGLE_CONVERSION_LABEL)) echo 'var google_conversion_label = "' . ADWORDS_TAG_GOOGLE_CONVERSION_LABEL . '";' . "\n"; echo 'var google_custom_params = window.google_tag_params;' . "\n"; echo 'var google_remarketing_only = true;' . "\n"; echo '/* ]]> */' . "\n"; echo '</script>' . "\n"; echo '<script type="text/javascript" src="//www.googleadservices.com/pagead/conversion.js">' . "\n"; echo '</script>' . "\n"; echo '<noscript>' . "\n"; echo '<div style="display:inline;">' . "\n"; echo '<img height="1" width="1" style="border-style:none;" alt="" src="//googleads.g.doubleclick.net/pagead/viewthroughconversion/' . ADWORDS_TAG_GOOGLE_CONVERSION_ID . '/?value=0&' . (tep_not_null(ADWORDS_TAG_GOOGLE_CONVERSION_LABEL) ? 'label=' . ADWORDS_TAG_GOOGLE_CONVERSION_LABEL . '&' : '') . 'guid=ON&script=0"/>' . "\n"; echo '</div>' . "\n"; echo '</noscript>' . "\n"; } }
  8. sorted - orders table -> orders_status was 0... changed and fixed. Order now appears again. Jack - Thanks again
  9. Jack - thanks for the reply! I think this was more of a one time internet glitch than a code problem, as this is the first time this has happened in over 14400 orders... - Can I ask which database table is likely missing customers_id ?? The orders_status_id failed to update in the orders_status_history table, which I've manually corrected. So has customers_id done the same ? I'm trying here
  10. Weird error occurred today -need some help. Standard 2.3.4 shop, been stable as a rock and no code changes lately. I was updating an order form pending to shipped, and when I clicked update, I got the message below, and now the order is not visible on the orders page. 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 '' at line 1 select cg.customers_group_name from customers c, customers_groups cg where c.customers_group_id = cg.customers_group_id and c.customers_id = I went into the database - Orders_Status_History and noticed that orders_status_id was 0 for that order. I changed it to 3. Still, the order is not visible on the orders page. If I search for the order, I get the same error as above. Could anyone provide some guidance? Thanks much, Dave
  11. I'd suggest this instead http://addons.oscommerce.com/info/9206 ‚Äč
  12. @@porrier Your missing the point - in the USA anyway, you configure your "calculated" shipping methods within Google Merchant Center (i.e. fedex, ups, etc....) Then in your upload you provide weight and/or any override. If Germany is different I would not know.
  13. @@porrier You set up your shipping methods at the Google Merchant Center. Then all you need in your feed is the weight. You can also override the weight calculated shipping by adding a fixed ship charge or 0.00 for free shipping to column "shipping(price)"
  14. @@gvv Adding that line is OPTIONAL, personal preference. The line is added to the product_info.php in the root of your shop.
  15. @@douglaswalker Only your local cert and the intermediary need to be sha-2 If you are seeing sha-1 at the issuers root, that is ok/normal still, at least I think so. I'm reading up on this now.