Jump to content

Robin Somes

  • Posts

  • Joined

  • Last visited

  • Days Won


Everything posted by Robin Somes

  1. 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
  2. Happy to report that the Extension Update notification is now working - whatever has been tweaked at CCHQ has taken effect. Thanks again Robin
  3. 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
  4. 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
  5. 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.
  6. 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?
  7. 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
  8. 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.
  9. 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...
  10. 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
  11. 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.
  12. 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
  13. Can I bump this? PayPal aren't replying to help requests. I am now upgraded to CC 6.2.9, and the 500 error is still occurring. It appears to be impossible to get PayPal Commerce Platform functioning at all, and attempts to get updates to the old PayPal platform extension are just redirected to the new one. PayPal's 500 error help page is useless. So, any other suggestions would be gratefully received. TIA, Robin (currently locked out of the forum a/c from which I posted the original request).
  14. Yes, I can see it working in FF 74.0; still no joy in Chrome or IE.
  15. CC 6.2.5 / All in One Shipping 1.0.11 / Facebook 1.0.0 / PayPal 1.0.8 / Product Addons 1.0.12 / SagePay 1.0.6 www.piscesconservation.com/cube A customer has reported that he's unable to checkout. He has added a (digital) item to his basket; he can see from the top-right corner of the page that there is an item in the basket, but he can't access the basket to begin the checkout process. Clicking on the basket has no effect. I have reproduced the issue myself in two different browsers, Chrome and IE, latest versions. The only effect of clicking on the basket icon is to change the URL from https://www.piscesconservation.com/cube/ to https://www.piscesconservation.com/cube/#. The issue appears whether or not I am logged in as a customer. I have cleared the site cache, and there are no recent entries in the Error Log. We haven't changed anything about the site for months, with the exception of adding a 15% discount code for one item - the item our customer is trying to order. I have tried ordering that item alone, in combination with other digital and physical products, and other products alone; each time the result is the same - clicking on the basket icon has no effect. Now here's the odd part; the site works perfectly in MS Edge. Since it's new behaviour, with no changes made on our part except the discount code, I'm inclined to think it's some hosting company issue; hopefully transient. Anyone have any suggestions for further enquiries? TIA, Robin
  16. I can confirm I've just implemented that change, and it works perfectly. Thanks again. R
  17. 1: Adding columns Is there any way to add a couple of extra columns into the Orders summary page? When I'm doing the monthly reckoning for our accounts, this is the most useful page to get the information from, since the existing columns: Order Number - Customer - Status - Date - Total are all items I need. What would be really great would be additional columns showing which payment gateway was used (in our case, either SagePay or PayPal), and how much VAT, if any, was included. Currently, I have to open each order individually, and check the gateway and VAT amount, which soon gets boring. The Transaction Logs page does at least show me which gateway was used - but doesn't give the customer name or order status. 2: Exporting If I could export the information from the Orders page as a CSV, it would be superb, because with the two additional columns it would be exactly what I require, no more, no less. 3: Alternatively... If the Sales Report function could include an indication of the gateway used for each sale, that too would fulfil everything I need - and it's already exportable. [EDIT: I now see that the data in the exported version of the Sales Report do include VAT, Gateway and many other things besides; what's seen online is a summary only.] Any chance? TIA Robin
  18. 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
  19. 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.
  20. 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!
  21. Good point, and well made. Many thanks R
  22. 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?
  23. Many thanks; could you just clarify what the change is - I'll throw it over to my hosting company. Cheers, R
  24. 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?
  • Create New...