Jump to content

jasehead

Member
  • Content Count

    149
  • Joined

  • Last visited

Community Reputation

0 Neutral

1 Follower

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Turned out the problem was a Safari extension. When turned off, the CubeCart modals worked OK. However, that particular extension wasn't a problem prior to upgrading the OS + Browser.
  2. First thing I did was check error logs for SQL errors, but nothing found. I agree that a mod_security rule update was probably the issue - this has been a problem in the past with my hyper-vigilant web host. I did some testing today and it seems to have been remedied.
  3. It isn't a bug in 6.1.14 either. These products were created with 6.1.14 within the last few months (and updated since then with no problem) - only in the last week or so has there been any issue, which is why I think it's due to some background server update. Upgrading cubecart is not an option because that would cause a major disruption - not looking to spend weeks fixing all the new problems from an upgrade until well after Christmas. How can I capture the SQL that is generated when a product is updated so I can show this to my webhost support?
  4. This is a recent problem, so I expect it is from some background server update rather than CubeCart. I'm running CCv6.1.14 because it's been stable and upgrades are a major disruption - so no recent changes at my end. The problem is that if the product contains CASE in the product title (pencil case, glasses case) then I can not update the product - it just defaults back to the retail storefront (probably caught as a 403 or 404 error by .htaccess and redirected). The only workaround is to make the item one word, eg. pencilcase, which is not ideal. What I want to be able to do is either: use some mod to make cubecart more robust by making sure the string is being treated as just a string, and not containing SQL commands, or capture the SQL that is generated when a product is updated so I can show this to my webhost support Any help?
  5. Just a heads up that Apple's sensitivity about blocking popups in Safari seems to have rendered any "delete" modal dialogue boxes in CubeCart useless. In 6.1.14, clicking the delete icon on a customer address or credit card details should show a modal that asks for an OK to confirm the deletion. A recent upgrade to MacOS Mojave 10.14 and Safari 12.0 has seen the behaviour change to no modal box displayed and the page hangs. It is possible to reload the page. A workaround is to copy the link from the delete icon, and paste this into the address bar to activate (skipping the modal). Or just use another browser. I have not found any settings in the Safari 12.0 browser that will allow CubeCart modals to display correctly (content blockers off, popups allow). If the modal popup method hasn't changed in later versions of CubeCart (eg. 6.2.2) then other Mojave+Safari users may find the same problem.
  6. jasehead

    White screen during checkout using gateway

    Is there a way to get CubeCart to add the correct customer_id number to the CubeCart_newsletter_subscriber table rather than just a zero? Get signup during checkout to use the Register process rather than the newsletter subscription box process (if that's the problem)? If the customer_id is zero then, instead of matching the customer_id, fall back to matching the email address instead and getting title, first name and last name that way (eg. for mailing list export)? Verify subscribers by email address and update any with a customer_id of zero to their actual customer_id?
  7. jasehead

    White screen during checkout using gateway

    The missing first name/last name issue happens when a guest agrees to create an account during checkout (in 6.1.14 anyway). The customer is being added to the CubeCart_newsletter_subscriber table with a customer_id of zero, which is the same as if they were signing up just using their email in the subscription box. So is the signup at checkout using the wrong process (basic newsletter signup instead of register signup)? Or maybe executing too soon, before the new customer has been signed in properly?
  8. jasehead

    White screen during checkout using gateway

    I think that exploring the plugin in more depth is probably up to the plugin developer. Your first suggestion allowed the plugin to function without blocking the payment gateway - that's a huge improvement. There is still the CubeCart issue of first name and surname not making it to the CubeCart mailing list for new customer signup during checkout. The "Register" page works OK, but registration at checkout doesn't. Also, I see in the table CubeCart_newsletter_subscriber that some entries have a "validation" code like 51edf897c51348103717f4e05d8578e8 where others are NULL. NOTE: By CubeCart Mailing List I mean the list that can be exported from (in 6.1.14 admin) Newsletters > Export Mailing List with format: {$EMAIL_ADDRESS} <{$FIRST_NAME} {$LAST_NAME}> It's not clear to me where CubeCart is pulling this data from, so not clear why First Name and Last Name are not available for entries made during signup at checkout.
  9. jasehead

    White screen during checkout using gateway

    @bsmither Only your first suggestion worked. The second resulted in a page that hanged for a few seconds, white screen of death, and this error in the site error log: PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 8960 bytes) in /home2/mysite/public_html/mystore/modules/plugins/SFWS_Mailchimp/hooks/class.newsletter.subscribe.php on line 108 (line number would be approximate because I have original code commented out rather than replaced)
  10. jasehead

    White screen during checkout using gateway

    Thank you - I can undo my clumsy workaround. No subscription during signup at checkout followed by subscribe after address/shipping update works OK - through to gateway with no WSOD. First name and surname in CubeCart mailing list and sent to MailChimp OK. Subscribe during signup at checkout - through to gateway OK but still no first name or surname in CubeCart mailing list (so email address only sent through to MailChimp). No PHP Errors in the error log.
  11. jasehead

    White screen during checkout using gateway

    5 if(!defined('CC_DS')) die('Access Denied'); 6 7 $mailchimp_status = $GLOBALS['config']->get('sfws_mailchimp', 'status'); 8 $mailchimp_api_key = $GLOBALS['config']->get('sfws_mailchimp', 'mailchimp_api_key'); 9 $mailchimp_list_id = $GLOBALS['config']->get('sfws_mailchimp', 'mailchimp_list_id'); 10 11 if ($GLOBALS['user']->is() && !isset($email)) {
  12. jasehead

    White screen during checkout using gateway

    I've managed to break a clean 6.2.1 store with MailChimp plugin enabled and reproduce my problem (my store is 6.1.14). - Add test product to basket - Click Checkout in Mini Basket - Fill all details, all checkboxes selected EXCEPT DO NOT SUBSCRIBE TO MAILING LIST - Card Capture as gateway - Secure Checkout button - Green banner - address updated, shipping options, logged in at top of screen, SUBSCRIBE CHECKBOX VISIBLE - Click Subscribe checkbox on this screen - Secure Checkout button (again) - Gateway fails - white screen of death (on Safari, 500 error on some browsers) So the problem seems to be if the first subscription box is empty and the second subscription box is checked. (If the first box is checked then the other should not appear.) Commenting out one checkbox seems to cause the same problem. Testing my 6.1.14 store using the same method: The first name and surname are included in the CubeCart mailing list (but no information sent to MailChimp list via the plugin) Error in the site error log : PHP Fatal error: Call to a member function is() on null in /home2/mysite/public_html/mystore/modules/plugins/SFWS_Mailchimp/hooks/class.newsletter.subscribe.php on line 11 If the MailChimp plugin is disabled then the gateway works OK My clumsy workaround was to add "disabled" to the input for the second checkbox and to comment out the label. I'm sure there's a more elegant solution that will keep the mailing_list input visible to CubeCart but invisible to the customer. {if !$USER_SUBSCRIBED} <div class="row"> <div class="small-12 large-8 columns"> <input type="checkbox" id="mailing_list" name="mailing_list" value="1" disabled ><!--label for="mailing_list">{$LANG.account.register_mailing}</label--> </div> </div> {/if} If a guest customer unchecks the subscription checkbox on during signup at checkout, then when address/shipping is updated another subscription checkbox will appear but no label text and not clickable - it looks like a small glitch and easily ignored. What it does is preserve the unsubscribe state from the original signup and so allows the gateway to function without error.
  13. jasehead

    White screen during checkout using gateway

    On further testing, I'm finding that if the first subscription box is unchecked by the customer and the second subscription box is checked by the customer then this causes a white screen of death for the card capture gateway.
  14. jasehead

    White screen during checkout using gateway

    I think that no name is recorded in the mailing list if the only subscription checkbox is the first one shown when the guest is filling out their address details - in that instance only the email address is recorded in the mailing list. The name is not recorded because at that point the customer is not logged in. If the second subscription checkbox shows after the address has been updated and the new customer has been logged in, then their first name and surname are included in the mailing list. However, if I force the second checkbox to show then I end up with the gateway white screen of death and the PHP error from the MailChimp plugin. So how do I fix this and ensure that a new customer's name is recorded in the mailing list (not just their email)? Maybe referenced here:
  15. jasehead

    White screen during checkout using gateway

    I thought that the 0 or 1 value meant checked or unchecked. I understand now that the element contains a 1 value, and that value is stored if the box is checked (am I right)? So, if the value is 1 and the code contains checked="checked", that will result in the customer actually being signed up to the mailing list (ie. the value doesn't need to change because a ticked box is not just cosmetic). Also, what would be the best way to make the checkbox ticked by default for guest signup during checkout, but to show the correct stored value for an existing (logged-in) customer? === Any clue as to why first name and surname might not be making it to the CubeCart mailing list? I've upgraded Card Capture gateway from 1.0.5 to 1.0.6 and PayPal Standard gateway from 1.0.4 to 1.0.8, and the mailing list checkbox code changes above - but that's all. Previously, when I was able to get a subscription during guest signup to work, the names carried through to the list. If I unsubscribe and resubscribe from admin or logged in as the customer then the names carry through to the list OK, just not during checkout. === According to https://www.w3schools.com/tags/att_input_checked.asp , checked is fine. <input type="checkbox" name="vehicle" value="Car" checked> No difference between HTML 4 and 5, only XHTML.
×