Jump to content

RobinSomes

Member
  • Posts

    24
  • Joined

  • Last visited

Posts posted by RobinSomes

  1. On 7/8/2021 at 9:13 PM, bsmither said:

    "Would it help..."

    No, I think it wouldn't, although the non-faulting entries in the various logs has some interest.

    I am going to post an issue in the Github to request that additional info be logged, if present, for problematic request/responses in the PayPal module.

     

    I have just had another PayPal transaction failure, as above. The order stuck at Pending, despite payment arriving in our PayPal account correctly. There was a digital item in the cart, and no other physical goods. Marking the order as Completed sends an "Order Complete" email to the customer, but no "Your Purchased Downloads" email.

    The Request Log contains 11 identical red entries, between 03:34 and 03:37 UTC, as follows:

     
    Request Sent (cURL) - https://api.paypal.com/v2/checkout/orders/***************[{"op":"replace","path":"/purchase_units/@reference_id=='*************'/amount","value":{"value":"18.00","currency_code":"GBP","breakdown":{"item_total":{"value":"18","currency_code":"GBP"},"shipping":{"value":"0","currency_code":"GBP"},"tax_total":{"value":"0","currency_code":"GBP"},"discount":{"value":"0","currency_code":"GBP"}}}}]
    Error:cURL Error (22): The requested URL returned error: 422 Unprocessable Entity
    Response received (422 - Unprocessable Entity)

    Apart from the use of the PayPal Commerce gateway, there's no obvious connection between the two customers in these stuck transactions (the first, on July 7th, was an unregistered customer in the UK, the second, this morning, was a registered customer in Chile). Each ordered a different downloadable item. The ability to send a "Your Purchased Downloads" email manually would go some way towards helping, but it's becoming frustrating and embarrassing to keep failing customers in this way. 

    (Since my original query, the shop has been updated to the latest incarnations of CC and PayPal Commerce).

     

     

  2. 1 hour ago, bsmither said:

    "Would it help..."

    No, I think it wouldn't, although the non-faulting entries in the various logs has some interest.

    I am going to post an issue in the Github to request that additional info be logged, if present, for problematic request/responses in the PayPal module.

     

    Thank you; great response as ever, I appreciate it. Meanwhile, if I do see any other stuck orders I shall report their circumstances here.

    Thanks again,

    Robin

  3. 1 hour ago, bsmither said:

    Do you think, along with the data shown in the Request Log entries, there are more data sent with the request - like in a POST method containing an address?

    If so, could it possibly be that PayPal is not agreeing to process this request not because of faulty syntax in the data stream, but rather a questionable or suspect customer or customer address?

    Which is to be asking, do we know when the entry gets logged in the Request Log? Before the customer gets sent off to the PayPal screen, or after the customer makes payment? This is a strange thing to ask, I know, as you say the order does get paid for by all other indications.

    (And again, why no Download Delivery email?)

     

    Would it help to send you the full set of entries from the Request Log for the order? (I would post it here but there's sensitive bits of information, I guess). Perhaps one set for yesterday's stuck order, and another set from today's successful test order?

    Looking at the evidence available to me for one of the test orders I made this morning, it seems to be in this order; Request Log entries in italics:

    09:16:17 (GMT) - Request Sent (cURL) - https://api.paypal.com/v2/checkout/orders/   Response received (201 - Created)

    09:16:58 - Request Sent (cURL) - https://api.paypal.com/v2/checkout/orders/  Response received (201 - Created)

    09:18 + some unknown seconds but record below suggests 09:18:21 - Request Sent (cURL) - https://api.paypal.com/v2/checkout/orders/************ Response received (200 - OK)

    09:18 + unknown seconds - Request Sent (cURL) - https://api.paypal.com/v2/checkout/orders/****************** Response received (204 - No Content)

    09:20 + unknown seconds - Request Sent (cURL) - https://www.google.com/recaptcha/api/siteverify?secret=******   Response received (200 - OK){ "success": true, "challenge_ts": "2021-07-08T09:18:21Z", "hostname": "******" }

    09:20 + unknown - 4 identical Request Sent (cURL) - https://api.paypal.com/v2/checkout/orders/**************[SNIPPED FOR BREVITY]{"op":"add","path":"/purchase_units/@reference_id=='*************'/invoice_id","value":"210708-092019-****"},{"op":"add","path":"/purchase_units/@reference_id=='*************'/description","value":"Payment for order 210708-092019-****"}] Response received (204 - No Content)

    09:20:19 - The order was placed (judging from the order reference number 210708-092019-XXXX)

    09:20:21 - Request Sent (cURL) - https://api.paypal.com/v2/checkout/orders/***********/capture  Response received (201 - Created)

    09:20:22 - "Thank you for your payment!" email sent by the shop
    09:20:25 - "Thank you for your payment!" email recorded in shop email log

    09:20:25 - "Order Confirmation" email sent by the shop
    09:20:27 - "Order Confirmation" email recorded in shop email log

    09:20:27 - "New Order #210708-092019-****" email sent to my office
    09:20:27 - "New Order #210708-092019-****" email recorded in shop email log

    09:20:35 - "Your Purchased Downloads" email sent by the shop
    09:20:37 - "Your Purchased Downloads" email recorded in shop email log

  4. I've just put through one order using Microsoft Edge, and PayPal Checkout as a guest. Order completed successfully and emails sent OK; Request Log has no red entries, but the following line with the total value truncated:

    Request Sent (cURL) - https://api.paypal.com/v2/checkout/orders/***********[{"op":"replace","path":"/purchase_units/@reference_id=='*************'/amount","value":{"value":"21.60","currency_code":"GBP","breakdown":{"item_total":{"value":"21.6","currency_code":"GBP"},"shipping":{"value":"0","currency_code":"GBP"},"tax_total":{"value":"0","currency_code":"GBP"},"discount":{"value":"0","currency_code":"GBP"}}}}]
    Response received (204 - No Content)

    Another order in the Chrome browser, PayPal Checkout as a guest. Order successful, emails OK; similar result in Request Log:

    Request Sent (cURL) - https://api.paypal.com/v2/checkout/orders/**************[{"op":"replace","path":"/purchase_units/@reference_id=='*******************'/amount","value":{"value":"15.60","currency_code":"GBP","breakdown":{"item_total":{"value":"15.6","currency_code":"GBP"},"shipping":{"value":"0","currency_code":"GBP"},"tax_total":{"value":"0","currency_code":"GBP"},"discount":{"value":"0","currency_code":"GBP"}}}}]
    Response received (204 - No Content)

    A third order, using Chrome, PayPal Checkout, using PayPal balance. Order successful, emails OK, similar Request Log entry:

    Request Sent (cURL) - https://api.paypal.com/v2/checkout/orders************[{"op":"replace","path":"/purchase_units/@reference_id=='************'/amount","value":{"value":"10.80","currency_code":"GBP","breakdown":{"item_total":{"value":"10.8","currency_code":"GBP"},"shipping":{"value":"0","currency_code":"GBP"},"tax_total":{"value":"0","currency_code":"GBP"},"discount":{"value":"0","currency_code":"GBP"}}}}]
    Response received (204 - No Content)

    I'm not sure continuing with every possible combination of browser I have / PayPal as guest / PayPal as user would tell us much more, but it looks like the truncated total value, on its own, isn't the trigger for the failure.

     


     

  5. 10 hours ago, bsmither said:

    I think it strange that CubeCart isn't emailing a Download email when the order goes to Processing - assuming there is a digital item in the cart to trigger this.

    We may need to do some diagnostic analysis to determine why CubeCart is deciding not to do this.

    Ten percent of orders through PayPal? If you can recall any past order (maybe examine the Request Log for other red-colored entries) that exhibited the same issue, please examine the total price to see if it ended with zeros.

    There are no other red entries in the Request Log, which dates back only as far as June 8th. However I can see one order on June 11th where the total price was truncated, as in our example above. That order went on to be completed successfully, and all the requisite emails were sent, so I'm not sure where that leaves us!

    Request Sent (cURL) - https://api.paypal.com/v2/checkout/orders/***************[{"op":"replace","path":"/purchase_units/@reference_id=='****************'/amount","value":{"value":"44.40","currency_code":"GBP","breakdown":{"item_total":{"value":"44.4","currency_code":"GBP"},"shipping":{"value":"0","currency_code":"GBP"},"tax_total":{"value":"0","currency_code":"GBP"},"discount":{"value":"0","currency_code":"GBP"}}}}]
    Response received (204 - No Content)
     
    I will put through some sample orders today, and see if I can reproduce the behaviour.
     
    Many thanks for your help.
    Robin
     
  6. 4 hours ago, bsmither said:

    "occasionally do not complete"

    So, if most of the time there is no problem, then it can't be a condition that doesn't vary - such as a server feature (like, OpenSSL or CA certs).

    At a rough guess, 10% of orders transacted through the PayPal Commerce Platform stick like this, We also use Sagepay; I'm not aware of any of those transactions sticking at Pending.

    4 hours ago, bsmither said:

    Is it possible that the 'unprocessable entity' (that is, a node in the JSON string) is not formatted exactly correctly? I am looking at the value->value node value of "21.60", and comparing that to value->breakdown->item_total->value value of "21.6".

    That does indeed seem odd...

    4 hours ago, bsmither said:

    Please let us know if in admin, Store Settings, Features tab, "Allow order "Processing" status to be skipped?" is not checked.

     

    That is correct, it's not checked.

     

    4 hours ago, bsmither said:

     

     

     

  7. Site: piscesconservation.com/cube
    CC 6.4.2 / AllInOneShipping 10.0.21 / Facebook 1.0.1 / PayPal Commerce Platform 1.4.4 / PayPal Standard Gateway 1.0.8 (disabled) / ProductAddons 1.0.12 / SagePay 1.0.11

    Sales of downloadable goods made using PayPal occasionally do not complete, so remain Pending. I can see in our PayPal a/c that the money has been received, and get an email to that effect. "Thank you for your payment" and "Order Confirmation #123456789XYZ" emails are sent to the customer, but no "Order Complete" or "Your Purchased Downloads" mails.

    The Request Log has a series of 5 identical errors in red, from the time of the order:

     
    Request Sent (cURL) - https://api.paypal.com/v2/checkout/orders/0S044361FS6103330[{"op":"replace","path":"/purchase_units/@reference_id=='***********'/amount","value":{"value":"21.60","currency_code":"GBP","breakdown":{"item_total":{"value":"21.6","currency_code":"GBP"},"shipping":{"value":"0","currency_code":"GBP"},"tax_total":{"value":"0","currency_code":"GBP"},"discount":{"value":"0","currency_code":"GBP"}}}}]
    Error:cURL Error (22): The requested URL returned error: 422 Unprocessable Entity
    Response received (422 - Unprocessable Entity)

    I can mark the order as Completed by hand, and this triggers an "Order Complete" email being sent, but no "Your Purchased Downloads".

    1: I know that the 422 - Unprocessable Entity error has been mentioned here before (https://forums.cubecart.com/topic/56248-paypal-not-finalising/?tab=comments#comment-243761) but there didn't seem to be any resolution to it, other than "get your server admin to rattle a stick up the pipe and see what comes down". Is there any advance on that?

    2: Having now marked the order as Complete, how can I trigger the sending of a "Your Purchased Downloads" email, so our customer can get what he's paid for? I know I can copy/paste the download link and email it in a separate message, but it would be great if the site could do it for me, like it should.

     

    TIA,

    Robin

  8. CC6.2.9 / All In One Shipping 1.0.19 /  PayPal Commerce Platform 1.3.20 

    Site: shop.robinsomes.co.uk

    I've just had a sale this evening, where the customer used a discount code to get 15% off the order. In the shop, the order appears to have processed perfectly:

                Sub-total: £3.50

    15.14% discount: -£0.53

                        Total: £2.98

    - see the first image attached below.

    However, looking at the PayPal transaction, there's no discount amount applied (image in first reply).

    Looking at the request log, there are 5 entries in red which look to be the cause of the problem (image in 2nd reply).

    Previous discounted orders have gone through OK; I've not knowingly changed anything about the site.

    Inevitable question: what do I do to prevent this happening again?

    TIA, Robin

    2020-09-21-Image1.jpg

    2 minutes ago, RobinSomes said:

    ...

     

    2020-09-21-Image2.jpg

    2020-09-21-Image3.jpg

  9. 10 minutes ago, bsmither said:

    "I'm reluctant to revert to older versions"

    Sorry, I think you misunderstood. I said: "I manually changed the value in the "modified" column in the CubeCart_extension_info table to simulate an older version installed."

    Having done this, and having CubeCart make a version check, then I got the Dashboard tab saying that a newer version is available. (The module actual version installed was not disturbed in any way.)

    From my tests, I will conclude we must wait for CubeCart HQ to fix their server.

     

    OK, got that, thanks. As I said to Al elsewhere in this thread, it's causing me no real trouble, so I'm content to sit and wait.

    Thanks again for your help.

    Robin

  10. 2 hours ago, bsmither said:

    So, db{code}_cubecart: set up 24/04/2018 using CC 6.1.15, in use ever since, regularly updated to latest CC version, is complete, but does not present to you a tab showing extensions that do, in fact, have a version available more recent than what is installed?

    Yes, that's correct.

    2 hours ago, bsmither said:

    Looking at db{code}_cubecart, what does CubeCart_extension_info contain?

    See the image below; 4 plugins - AIOS 1.0.18, SagePay 1.0.11, Facebook 1.0.1 and paypal_commerce 1.3.20
     

    2 hours ago, bsmither said:

    A version check uses CubeCart's Request functionality, Unfortunately, this request and response is not logged. Let's change that and then make a test.

    In the admin script /sources/dashboard.index.inc.php:

    Near line 112, find:
    
    ## Check current version
    if (!$GLOBALS['session']->has('version_check') && $request = new Request('www.cubecart.com', '/version-check/'.CC_VERSION)) {
        $request->skiplog(true);
    
    Change:
    $request->skiplog(true);
    
    To:
    $request->skiplog(false);

    OK, done...

    2 hours ago, bsmither said:

     

    Based on what CubeCart_extension_info has, will determine how we test this.

    But, logging out (clears the session), then logging in and viewing the Dashboard, will cause a version check request to be made and now get logged.

    In admin, view the Request Log to see if it got logged at all.

     

    Yes, it got logged:

    Today, 23:23

    Request Sent (cURL) - https://www.cubecart.com/version-check/6.2.9?version=6.2.9&extensions[44]=1596699083&extensions[80]=1548263568&extensions[108]=1551776120&extensions[452]=1597078286version=6.2.9&extensions%5B44%5D=1596699083&extensions%5B80%5D=1548263568&extensions%5B108%5D=1551776120&extensions%5B452%5D=1597078286
    Response received (200 - OK){"version":"6.2.9"}

    Image3.jpg

    2 hours ago, bsmither said:

    If it did get logged, this is what you should see if no modules need updating:

    Today, 12:22
    Request Sent (cURL) - https://www.cubecart.com/version-check/6.2.9?version=6.2.9&extensions%5B44%5D=1596699083&extensions%5B105%5D=1474387528&extensions%5B452%5D=1597078286
    version=6.2.9&extensions%5B44%5D=1596699083&extensions%5B105%5D=1474387528&extensions%5B452%5D=1597078286
    Response received (200 - OK)
    {"version":"6.2.9"}

    I manually changed the modified value in the CubeCart_extension_info table to simulate an older version installed.

    Then I logged out and back in.

    Today, 12:48
    Request Sent (cURL) - https://www.cubecart.com/version-check/6.2.9?version=6.2.9&extensions%5B44%5D=1096699083&extensions%5B105%5D=1474387528&extensions%5B452%5D=1597078286
    version=6.2.9&extensions%5B44%5D=1096699083&extensions%5B105%5D=1474387528&extensions%5B452%5D=1597078286
    Response received (200 - OK)
    {"version":"6.2.9","updates":{"44":true}}

    The "44" extension key is the All in One Shipping module.

    I'm reluctant to revert to older versions of any of my extension (even if such were available), as the site is still live. Can you suggest another extension with older versions available that I could install, to test whether or not it works for me?

    Many thanks again for your help.

    Robin

  11. 2 hours ago, Al Brookbanks said:

    This year has been rough for us all. I'm out the office until Friday with family in Suffolk, UK, working here and there. I'll have a good look at this on my return.

    Al, it's absolutely no problem to me, in the main I'm just curious as to what might be going on and whether it has any other implications. Whenever you get the chance, no worries.

    Robin

  12. 20 minutes ago, bsmither said:

    The above checks were for the database with the missing table.

    As for the freshly installed CC629, AIOS and PPC were automatically installed the first time the admin visited the Manage Extensions page in admin,  but the data logged in the CubeCart_extension_info table during that auto install was probably corrupted. If so, the first time the Dashboard did a version check, those particular records were deleted. (See: https://github.com/cubecart/v6/issues/2586)

    For this CC629 store, have you ever actually logged out of admin since Aug 6, 2020? (An odd question, but my development installation hasn't been logged out for a couple of months.)

    That's when PPC1.3.18 was published. PPC1.3.19 was published Aug 10, immediately followed by PPC1.3.20.

    The version check happens when an admin first logs in and views the Dashboard. The fact that a version check took place is remembered in session, and will not make another check until a new session is started (admin logs out then logs in).

    Many thanks for the explanation. Just to confirm, yes, I've logged out of admin probably a dozen times since August 6th; aside from processing sales, I'm not logged in at all as a matter of course.

    Will check the details on the other site when I return to work tomorrow.

     

  13. Incidentally, I have just checked my own shop site (shop.robinsomes.co.uk). This was a completely fresh installation of CC 6.2.9 in March 2020, with very little customisation. The database has the table Cubecart_extension_info, and that table has 3 rows corresponding to the 3 extensions I have installed (ByWeight, All In One Shipping, and PayPal Commerce).

    CubeCart_inventory has a new column: 'latest' - CORRECT
    CubeCart_order_history has a new column 'initiator' - CORRECT
    CubeCart_coupons has a new column 'free_shipping' - CORRECT
    CubeCart_email_log is a new table - CORRECT
    CubeCart_extension_info is a new table - CORRECT
    CubeCart_coupons has a new column 'email_sent' - CORRECT

    However, the site still did not notify me that the latest version of PayPal Commerce Platform (1.3.18 to 1.3.20) was available.

    Robin

  14. 5 minutes ago, bsmither said:

    The 6.1.0 is 7th from the bottom. CubeCart processed the upgrade step for CC610 on 24 April 2018 from CC607 on its way to CC6115.

    Please check these other aspects of the CC610 changes to the database (the one missing the CubeCart_extension_info table):

    CubeCart_inventory has a new column: 'latest'
    CubeCart_order_history has a new column 'initiator'
    CubeCart_coupons has a new column 'free_shipping'
    CubeCart_email_log is a new table
    CubeCart_extension_info is a new table
    CubeCart_coupons has a new column 'email_sent'

    Do any of these new columns/tables exist?

    Sorry, I was mis-reading 6.1.0 for 6.0.10...

    I can't access phpMyAdmin for my work account from home (well I probably could, but it would probably take me the rest of the evening to track down the correct username/pwd combination), so will have to return to your questions tomorrow morning. Thanks for your help, I appreciate it.

    Robin

  15. 2 hours ago, bsmither said:

    Ok, two databases---

    One database does not have CubeCart_extension_info, which means it is still at CC6012 or earlier, or the upgrade scripts were not run having updated CubeCart to a version more current than or at CC610.

    In the database, there is a CubeCart_history table. The contents of which are revealed in admin, Maintenance, Upgrade tab. Does the history show CubeCart passing through 6.1.0 (if it was initially installed earlier than that)?

     

     

    Replying from my home a/c, rather than work, hopefully this is still followable. Here is the full upgrade history from Advanced: Maintenance: Upgrade. The upgrades in April 2018, September 2018 and March 2019 were done by Al; fairly sure I did the rest. While the version installed has gone *past* 6.1.0, it doesn't appear to have gone *through* it.

    Hope that helps,

    Robin
     

    Upgrade History

    CubeCart Version Date
    6.2.9 Tuesday, 12 May 2020
    6.2.8 Tuesday, 12 May 2020
    6.2.7 Tuesday, 12 May 2020
    6.2.6 Tuesday, 12 May 2020
    6.2.5 Friday, 19 July 2019
    6.2.4 Monday, 25 March 2019
    6.2.3 Monday, 25 March 2019
    6.2.2 Monday, 10 September 2018
    6.2.1 Monday, 10 September 2018
    6.2.0-b1 Monday, 10 September 2018
    6.1.15 Tuesday, 24 April 2018
    6.1.14 Tuesday, 24 April 2018
    6.1.13 Tuesday, 24 April 2018
    6.1.11 Tuesday, 24 April 2018
    6.1.9 Tuesday, 24 April 2018
    6.1.7 Tuesday, 24 April 2018
    6.1.6 Tuesday, 24 April 2018
    6.1.5 Tuesday, 24 April 2018
    6.1.4 Tuesday, 24 April 2018
    6.1.2 Tuesday, 24 April 2018
    6.1.0 Tuesday, 24 April 2018
    6.0.12 Tuesday, 24 April 2018
    6.0.11 Tuesday, 24 April 2018
    6.0.9 Tuesday, 24 April 2018
    6.0.7 Tuesday, 24 April 2018
    6.0.6 Wednesday, 24 June 2015
    6.0.5 Thursday, 4 June 2015
  16. site: piscesconservation.com/cube

    CC6.2.5 / All In One Shipping 1.0.16 / Facebook 1.0.1 / PayPal Commerce Platform 1.3.5 / PayPal standard commerce platform 1.08 / ProductAddons 1.0.12 / SagePay 1.0.11

    Trying to switch from the old PayPal standard commerce platform to PayPal Commerce Platform, as the former is deprecated. I'm seeing a repeated HTTP 500 server error on trying to link to our PayPal account (which is a full business account, and has been for years).

    I notice there's another support ticket from a few days ago showing the same problem (link below).

    PayPal's help page for the 500 error just states "your use case has not yet been approved for the PayPal Commerce Platform." - which isn't really much help. I've flagged the error to PayPal but have yet to receive any notification from them.

    Any other suggestions gratefully received.

    Robin

     

     

     

  17. 21 hours ago, bsmither said:

    Please fetch and install the By Weight shipping module.

    This module allows to specify the packaging weight separate from the total of the product weights. Also a separate handling cost for each zone. The zones are not as granular as the AIOS module.

    The shipping bands are expressed differently than AIOS:

    Colon-grouped, comma-separated:
    
    0.25:29 <- weight up to and including .25 costs 29
    0.5:38 <- weight above .25 up to and including .5 costs 38
    1:49 <- weight above .5 up to and including 1 costs 49
    10:58 <- weight above 1 up to and including 10 costs 58
    30:89 <- weight above 10 up to and including 30 costs 89
    
    is expressed as:
    
    0.25:29,0.5:38,1:49,10:58,30:89

    There may be other modules that would suffice.

    Many thanks; I've installed it and will try tomorrow. 
    Robin

  18. Site: shop.robinsomes.co.uk

    CC 6.2.9 / PayPal Commerce Platform 1.3.5 / All In One Shipping 1.0.16

    Perhaps I'm missing something obvious, but is it possible to refine the product details and shipping rates, to separate the weights of product and packaging?

    Example: I'm selling small booklets, which weigh 75 g. A standard cardboard mailer plus printed receipt weighs another 75 g, so in Products: General I give the booklet a weight of 150 g.

    I have All In One Shipping set up with the standard Royal Mail weight bands of up to 100 g / 101 - 250 g, etc.

    This works well with single items, but if the customer orders, say, 4 copies of a booklet, CC calculates the total weight as 4 x 150 = 600 g, when in fact it's only 375 (4 x 75 + 75). So the customer is charged £3.70, when £2.89 would be sufficient.

    It seems that whichever way I go, at some point I run the risk of ripping someone off. If I set the product weight too high, the customer can get overcharged. If I set it too low, then there's the risk I'll rip myself off, by having to pay more postage than I've been paid for.

    If I could assign 1 weight to the product, and another to the packaging, so that CC knows to charge for X times product plus 1 times package I could (hopefully) avoid that.

    TIA,

    Robin

  19. site: shop.robinsomes.co.uk

    CC 6.2.9 / PayPal Commerce Platform 1.3.4 / All In One Shipping 1.0.16

    I've had 4 transactions - from 2 different people - in the last 24 hours where orders have stayed at 'Pending', rather than completing and going to 'Processing'. In each case, there's no sign in PayPal of any transaction.

    One customer appears to be using a Windows laptop, the other an iPad. Both are quite elderly, and not entirely certain about how to order, so it's possible that they're simply omitting to press a final "OK" button somewhere.

    In the same time period, I've had 9 other sales (also paid via PayPal) which have completed successfully.

    The failed transactions all happened using PayPal Commerce Platform 1.3.4; I've since upgraded to v 1.3.5.

    Excluding the possibility that it's just repeated customer error, are there any other settings or potential issues I should be looking for, to try to prevent this happening again?

    PayPal platform settings in the attached image; I can post request logs if need be.

    TIA,

    Robin

    Image2.gif

  20. 38 minutes ago, bsmither said:

    1. Something in your environment isn't UTF-8 compliant. It might be the database collation isn't set for utf8-unicode-ci, PHP's default_charset did not get set to UTF-8 (as per a statement in CubeCart's ini.inc.php), PHP's connector to the database did not get set to utf8 (as seen in /classes/db/mysqli.class.php, at the end of the file), or your workstation's web browser or operating system isn't UTF-8 aware.

    The UTF-8 pound character (https://www.fileformat.info/info/unicode/char/00a3/index.htm) is hex C2A3 where A3 is also a pound symbol in some collations, leaving C2 as a capital A with circumflex.

    However, since this appears only in one location on the page, please check in CubeCart's admin, Currencies, for the GBP currency symbol.

    2+4. In admin, Languages, click the edit icon for the language(s) you are using. On the next page, choose Confirm from the Phrase Group drop-down selector. Make your edits here. (You will need to actually click the mouse pointer on an area just to the immediate direct left of the text entry box to activate that box for editing.) Making changes here will database the changes and thus will survive an upgrade.

    Your proposed phrase would pose no problems.

    Do this for other phrase changes. Observe the <group name> in definitions.xml for the appropriate choice on the drop-down selector. For example, the Contact Us phrase is found in the Documents group, 'document_contact' key.

    3. That can be done.

    1: PHP on the server appears to be set to use UTF-8 correctly; problem appears in 3 different browsers, Chrome, IE and Firefox, and on my phone browser. I'm not in my office these days so can't check on a different system. No great importance, it's just odd.

    2 & 4: Many thanks, all done and working.

    3: Is not so crucial, now that the message on the Order Complete page mentions that a download email has been sent. Without either, customers wouldn't have any indication of how they might access their content; now they do :)

    Thanks again

    Robin

  21. CC 6.2.9 / All In One Shipping 1.0.16 / PayPal Commerce Platform 1.2.11

    Site: shop.robinsomes.co.uk

    I know that I've asked some of these questions previously, in relation to another site, but cannot for the moment find them. 

    (1) Throughout the site, there's an extra character before the pound symbol on the currency selector drop-down, top right (see the attached image). Perhaps because something, somewhere, has the wrong character set specified? How can I eliminate it? Inspecting the HTML shows:
    <a href="#" data-dropdown="currency-switch" class="button white small" rel="nofollow">£ GBP</a>

    If I check the symbol set in the Currencies section (as suggested by Ian of Havenstreet, downthread), it's just the plain old pound sign (see 2nd image below) nothing untoward showing.

    (2) On the Order Complete page (again, see the attached image), I'd like to change the text in the green panel, currently saying "Many thanks for your order! Payment has been received and your order is now complete". I want to mention that an email will be sent with a link to download the content just purchased, etc. Is it simply a matter of editing the relevant line in definitions.xml, and re-uploading that file? Any formatting or parsing issues I should watch out for if I include the shop email address and a hyperlink in that string?

    i.e. changing

    <string name="order_complete" introduced="5.2.6"><![CDATA[Many thanks for your order! Payment has been received and your order is now complete.]]></string>

    to

    <string name="order_complete" introduced="5.2.6"><![CDATA[Many thanks for your order! Payment has been received and your order is now complete. You will shortly receive an email from Robin Somes - Shop <[email protected]> containing a link to download your content - please check your Spam folder or <a href="http://shop.robinsomes.co.uk/contact-us.html">contact me</a> if it doesn't arrive.]]></string>

    (3) It would be great if there could also be a link to download the content on that Order Complete page; fairly sure I've done it before on another site, but can't remember how to implement it.

    (4) I'd like to change the link text on all the site pages from "Contact Us" to "Contact Me" - for the obvious reason that there's only one of me. Again, is it just a case of changing all instances of "Contact Us" in definitions.xml? Ditto, the "Follow Us" link, and "Thank you for shopping with us" on the invoice.

    TIA,

    Robin

    Image1.jpg

    Image2.jpg

×
×
  • Create New...