Jump to content

Daamon

Member
  • Posts

    80
  • Joined

  • Last visited

Everything posted by Daamon

  1. Hi. A summary of the response from the shop user: - The order status was, until recently, being automagically updated to Processing once payment had been made through PayPal - From there, the status would be manually set to Order Complete - We've had a recent issue arise where PayPal payment was processed but order status stayed at Pending - something to do with an IPN having a brain fart. I've researched it and made some changes from &amp to & only (might evenhave been @bsmither's suggestion). This may have resolved the issue, as it looks like it's now working. Anyway... - The shop user was manually changing the status Processing to trigger emails, then to Order Complete. Then we upgraded to 6.0.12... So we now appear to be at the point where we're receiving orders with the mandatory fields displaying AND the order status back to updating automagically when PayPal payment goes through. Or, put another way, happy days are here again! For now... Thanks all for your help - very much appreciated, as ever.
  2. I'll check with the shop user to see if they manually moved the Status to "Order Completed" on recent (CC608) orders and let you know...
  3. The order with the details NOW "missing" (not displaying) was done when we were on CC608 (entirely - not part way through the upgrade). I say "NOW" as I've been told that the details were displaying OK up until recently - exactly when is hard to say as we get very little traffic.
  4. Yes, I've been advised we're on CC6012 entirely. And the order with the details displaying (i.e. expected customer-entered data in the two CubeCart_order_inventory columns) came in after we'd gone to CC6012.
  5. There's no data reflective of what has been entered by a customer, though there is "stuff" in the 'product_options' and 'options_array' columns which looks technical. Best explained with an example of 2 entries analysed (comments in [] explain the data): 1) A customer has entered data for their motorbike: Ducati, 1199 Panigale, [year] 2013, [registration] REGO1 - this DOES display in the Admin Panel Order Summary CubeCart_order_summary / BLOB (shortened and sanitised): i:55;s:7:"options";a:4:{i:18;a:1:{i:0;s:6:"Ducati";}i:17;a:1:{i:0;s:13:"1199 Panigale";}i:16;a:1:{i:0;s:4:"2013";}i:15;a:1:{i:0;s:5:"REGO1"}} product_options column: a:4:{i:102;s:12:"Make: Ducati";i:103;s:21:"Model : 1199 Panigale";i:104;s:26:"Year of Manufacture : 2013";i:105;s:53:"Rego (NOTE: 1 per order, do others separately): REGO1";} options_array column: a:4:{i:18;a:1:{i:0;s:6:"Ducati";}i:17;a:1:{i:0;s:13:"1199 Panigale";}i:16;a:1:{i:0;s:4:"2013";}i:15;a:1:{i:0;s:5:"REGO1";}} 2) Another customer has entered data for their motorbike: Honda, VTR1000F, [year] 2000, [registration] REGOx - this DOESN'T display in the Admin Panel Order Summary CubeCart_order_summary / BLOB (shortened and sanitised): i:55;s:7:"options";a:4:{i:18;a:1:{i:0;s:5:"Honda";}i:17;a:1:{i:0;s:8:"VTR1000F";}i:16;a:1:{i:0;s:4:"2000";}i:15;a:1:{i:0;s:5:"REGOx";}} product_options column: a:4:{i:102;s:6:"Make: ";i:103;s:8:"Model : ";i:104;s:22:"Year of Manufacture : ";i:105;s:48:"Rego (NOTE: 1 per order, do others separately): ";} options_array column: a:4:{i:18;a:1:{i:102;s:0:"";}i:17;a:1:{i:103;s:0:"";}i:16;a:1:{i:104;s:0:"";}i:15;a:1:{i:105;s:0:"";}} The second example sounds like your second description: "* the {i:## part is still there, as well as the s:#: part, but nothing in quotes? "
  6. @bsmither Hi. P.S. We're now fully on 6.0.12 - front end and database Analysis findings: Order received with expected mandatory data which IS displaying / at Status = Pending: CubeCart_order_summary / BLOB: Contains required data in the "options" area CubeCart_order_inventory / BLOB: Both product_options column and options_array column contain the same, required data in its entirety Order received with mandatory data which now no longer displays / at Status = Order Complete: CubeCart_order_summary / BLOB: Contains data matching expectations in the "options" area - no other way of verifying what was entered, but it looks like what it should be CubeCart_order_inventory / BLOB: Both product_options column and options_array column DO NOT contain the expected data
  7. Sadly, I don't think we have direct server control... Can I do anything through cPanel? Edit: Actually, IIRC, you're not familiar with cPanel... Hey ho.
  8. Hi @bsmither - thanks so much for the prompt reply. I'll get onto the digging... In the meantime, and a complete stroke of luck, we've literally just this minute had an order placed and the required (mandatory) details are being captured AND appearing in the Order Summary View - i.e. working as expected. At present, the order is in a status of Pending. I've already advised my shop manager to track what they do - this is a great chance to try to narrow down what's going on and where / when.
  9. Someone else is doing that bit - I've not done it before, they have. So I'm leaving it to them to get us sorted on that front.
  10. @bsmither Hi... The issue reported above has been working fine for a while - without upgrading to the latest version... ...and now it's happened again. How / where can I see - in the back end somewhere, as opposed to the store admin panel - if this data does still exist and maybe it's a display issue? On a side note, we tried to upgrade to 6.0.12 at the time that the minimum PHP went to 5.4 and the upgrade stalled. We're now on PHP 5.4 but have a 6.0.12 CubeCart with a 6.0.8 database. Not ideal, I know. That's being looked into too...
  11. @bsmither Re $OPT to $option - I've checked and that, as well as your other suggested changes to files, have been made. We're still on 6.0.8 so, if we upgrade, we'll see how we go.
  12. @bsmither Re $OPT to $option - I think I may have made those changes, and I'd hope that they would persist and not, somehow, be overwritten. I'll check it out and double check. Re your earlier question: "Could it be the case where for the three orders at Processing with missing text field option data, that these orders had some sort of minor (and thus, probably completely forgettable) change to the order - but having kept the order at Processing?". Response: "A couple of the orders had remained stuck in 'Pending' even though the PayPal payment had come through, so I changed them to 'Processing' given that they had proceeded to the next level. After that I went in to change the time zone and when I came back out, the mandatory field data was missing. New orders that have come through have the bike data. The back log of completed orders don't." Perhaps a new suspect in this mystery...? But how could changing the timezone have had an impact?
  13. @bsmither: I've asked the question of the shop users to see if there were any changes made to specifically those three orders. I'll keep you posted... I've also recommended the upgrade. Regarding the "can I convince you to at least implement the code changes that solved this issue?" - I'm not sure which changes you're referring to, presumably in the other thread I mentioned but which ones? This post?
  14. Hi, thanks for responding. Yes, still on CC608. I was inspired by your suspicions and have done some analysis: - I only looked at orders since I implented the new mandatory fields - All orders (3 in total) in a status of "Pending" DO have the details captured and stored - 2 of 5 orders in a status of "Processing" have details, the other 3 don't - ALL orders in a status of "Order Complete" have the line entries showing in the Order Overview tab (as do all the others), and these are blank - i.e. no mandatory details captured. So... The weird thing is the issue doesn't appear to be consistent, as per the "Processing" status. Unless there's something at a lower level which differentiates those which do, and those which don't have details captured. Is it just coincidence that all three "Pending" orders have details? There's not enough to be able to have a decent sample set. Does that help any?
  15. Hi, Apologies for the seemingly weird title, but that is exactly what has happened... I'll explain - and like all good stories, I'll start at the beginning to give context and probably some useful info. 1) Back in February, I followed the instructions in this thread (started by me). Specifically bsmither's suggestion of adding textboxes under the Option Groups section - these were added as mandatory fields, and it worked great.We were capturing what we needed. 2) Recently, one of the shop admins noticed that some recent shop purchases which should've been capturing this mandatory datadidn't have it recorded. They looked into older orders, and data which had previously been there (in the Option Groups added fields) was now gone. 3) Wierder still, there are a few orders in recent times which are OK! They DO have the data captured! The only change which has been made in the shop is setting up a timezone to have it correctly aligned to where we are - Australia. I've had a look in the database, but my understanding (or lack of) of the schema / how the data is stored, and basically no knowledge of SQL didn't reveal anything - hence now posting here for help... Thanks.
  16. Hi bsmither, Thanks for picking this up again, and for the detailed instructions. I've made (and saved) the edits to the three files, I also did the "Clear Cache" you suggested - ticking all 4 boxes under "Cache" and then "Submit". Unfortunately not achieving the desired results - not at first, at least, but your suggestions gave me an idea and I had a little play... The outcome: 1) The "Order Summary" tab (new) entries are now "separated" by a \n - I tested out changing this in the "orders.index.inc.php" file to something different, refreshed the page and seen my test change come through. I also tried a /n in case it was a typo - this was displayed too, no "new line" separation. Being curious, I tried <br> instead of \n - and that worked... Woo hoo! It looks good. 2) The "Order Inventory" tab has no entries, as before. However, given the outcome in 1), I reckon the people who are using these changes will be happy with that. The status of the orders I'm looking at is Processing or Pending, none are Order Complete. Could it be this? If we can get this working, it'd be great. Thanks so much for your help - very much appreciated.
  17. Hi. We've now had a "live" customer come through and we are, indeed, happy(ish) with the results. I say "ish" because we are now capturing the information we really need to have, but it's not where we expected it - attached screen shots will explain... - The newly captured data is appearing in an semi-formatted, concatenated way in the Order Summary. It's usable, but not pretty - It's not appearing in the Order Inventory screen - which would be nicer and more user friendly. Given that bsmither "may" have described how to achieve this above, if that's the solution can someone explain it in more layman's terms assuming less knowledge - particularly for the paragraph "To capture custom data ..." onwards, which folders the various files are in, and which files(?) the properties are in? I'm sure I can figure out "how" to change things once I know where those things are... Cheers!
  18. Hi bsmither, Thank you! Superstar! I followed points 1 - 3 and, in the basket, gave me exactly what I was after. But it 10 minutes and I didn't need any PHP coding or setting up new fields / tables in the database - sooooo much easier! Fantatstic! Regarding your info from "To capture custom data..." onwards - I wasn't clear on what that meant and was going to ask for more info, but luckily took a look at CubeCart Admin Control Panel -> Orders -> Inventory tab and the fields are there (blank) for existing orders so I'm assuming they'll be populated now they're in place. Thank you so much!
  19. Hi, My second post and I'm totally new to CubeCart... For a small set of specific products within my shop, I want to have a number of mandatory fields appear when any one of those products are ordered and on a "per product" basis, i.e. if more than any one of these products is purchased in a single transaction these fields appear for each product in the transaction. I want the data captured in these fields to be recorded as part of the order details, not the customer. My questions: 1) Which table(s) in the phpMyAdmin area would the new fields need to be added to? Any tips on some of the more unusual field options (e.g. I get "mandatory", but others?) when creating them... 2) I know I'll need some PHP coding to have the fields appear (getting that sorted) and I think it'd be best to have that occur in the "Basket" stage of the purchase. Which PHP file(s) would be the ones to change the code in? 3) It'd be great if I could have this mandatory data appear in the CubeCart Admin Control Panel -> Orders -> Overview tab - Order Summary. I'm guessing this would be PHP code changes too - again, which file(s)? Many thanks in advance.
  20. Cheers. I suspected as much, but thought I'd check. And thank you for all your prompt and detailed help - very much appreciated.
  21. Hi bsmither. Yes, the PHP Info 'sendmail_path' row has this entry: /usr/sbin/sendmail -t -i Re: cPanel - OK, fair enough. Do you have any comment on: Also, I presume that this thread's suggestion of "insert switch($this->Port){case 465:$this->SMTPSecure = 'ssl';break;case 587:$this->SMTPSecure = 'tls';}" no longer applies as I have CC v6.0.8 - or does it?
  22. @bsmither: An interesting development... In CC Admin -> Store Settings -> Advanced I set the Sending Method to "PHP mail() function" / port 465 and kept all other entries the same. The "Test" function appears to fail with the message "Test failed to execute", BUT... I do get an email received in my chosen destination email address, albeit in the Junk folder (that's the next investigation). Same result for ports 587, 25 and blank. So, does this prove that my host isn't blocking the emails and, further, why is the PHP mail function working and not SMTP with or without SSL? In parallel to this, I've been using cPanel to log into what I believe is the host server - are you familiar with cPanel and what it can access? I ask as I'm not familiar with this back-end stuff and am going by descriptions and what little I know / understand. I can't see anything blatantly for "Here's where you allow authentication for SMTP" have accessed cPanel -> Mail -> Email Authenricaiton and MX Entry and entered gmail.com and smtp.gmail.com into MX entries and also into an enabled SPF setting... Also, I presume that this thread's suggestion of "insert switch($this->Port){case 465:$this->SMTPSecure = 'ssl';break;case 587:$this->SMTPSecure = 'tls';}" no longer applies as I have CC v6.0.8 - or does it?
  23. PHP Info: PHP Version 5.3.27 - Linux ns1.aussiednsserver.com Thanks for all your help. I've got something to look into now...
  24. Thanks. Strangely, it looks like some test emails did get through a few days ago but only 5 on the same day and all within a few minutes of each other. Attached .txt is the full version of one of the emails - any clues there? Host is ns1.aussiednsserver.com right? email_success.txt
  25. Thanks. You say "If a connection to smtp.gmail.com is being blocked, it will be caused by your hosting provider" - as in where CubeCart is hosted I presume? What would I need to ask for to get it unblocked? Any technical settings to quote to them?
×
×
  • Create New...