keat

Mysqld.log is about 7gb in size, so not overly massive, maybe a bit bigger than it ought to be. There isn't really much in it to be fair, and what is in there is pretty consistant throughout the life span. What I have spotted is that the option_matrix table contains prices, which can only come via the mod. The mod runs out of hours. Considering it was fine on Monday evening and not on Tuesday, I can only decduce that the nightly routine screwed up somewhere. So I am leaning towards the mod at the moment.

The mod has been working for maybe going on a year and I've never seen such problem. Devs say that his mod wouldn't affect the matrix table, although I am aware that it references that table to collate product codes. I already checked mysqld.log and don't see anything of any significance

Dev has ruled out anything from his scripts that could cause this. As regards the hosting environment, its a rented whm/cpanel server with full root access. Can you suggest which log file (if exists) may give us some clues ?

we have a huge plugin installed which does something with custom pricing collected from our internal server. Whilst I don't believe it would have caused this, I can't rule it out, so I've also contacted the dev.

I performed a database restore this afternoon, but before I did so, I took a copy of the whole database. I've just looked at the option_matrix table, and where it should have had 4300 entries, I've spotted that it only had 27. So this explains why my products reverted to the cubecart std format, but now I need to understand where the other 4273 entries went.

Any thoughts on why the option_matrix table has defaulted to stock please. Matrix options should have contained the product code, so for example a black pen, would have had a product code of 'pen-black' But this morning, lots of products had reverted to the standard Cubecart default of '-1' so pen-black, pen-blue, pen-red, became pen-1, pen-2, pen-3

stand down... my fault, i was looking in the wrong place.

The 'collect in store' module isn't visible when checking out. Any pointers please ?? stand down... my fault, i was looking in the wrong place.

I applied the code snippet on Friday, my preliminary testing would indicate that it works. I've had no reports of web site issues over the past few days, so it's now just a matter of monitoring over the coming weeks.

Before I implement this snippet, could you clarify the below statement. "Note: In CubeCart's determination, if the visitor has already placed some items in their shopping cart before logging in, then the prior "saved cart" is abandoned in favor of the new cart's contents. " Does this happen now ???, or would this happen after implementing the snippet.

Would this be a fix for future release? Or something that could be done before then ? I've all but retired from work now, so closing this one off would probably be my last.

@Al BrookbanksDo we need to raise this on GitHub ??

One of the phrases in the message headers sent me off on a tangent, and I came across a mailscanner config setting, which i've modifed and seems to have resolved the error for now. Do you want to allow <Script> tags in email messages? This is a bad idea as these are used to exploit vulnerabilities in email applications and web browsers. Value: yes => Allow these tags to be in the message no => Ban messages containing these tags disarm => Allow these tags, but stop these tags from working Note: Disarming can be defeated, it is not 100% safe! This can also be the filename of a ruleset. But reading the description, it sounds somewhat dangerous to allow this. So if it is the PayPal plugin which is causing this, would there be a fix rather than allowing this security setting.

I disabled the PayPal Commerce plugin and now the gibberish has gone. Re-enabled it and the gibberish is back.

My communication isn't coming across cleanly. If I add an item to my cart where a matrix already exists, then there are no issues, the matrix code is passed. If I add an item to my cart where no matrix exists, the standard product code is passed. All Good so far. If I add an item to my cart which has no matrix code, then go back and modify the product and add a matrix to it.... this new matrix code isn't updated in the basket, so the order is passed with only the standard product code, just as it was when I added it to my cart initially. When we first created the matrix 4 months ago, there were loads, I assumed that some form of refresh or the max_gc-sessions timeout would fix it, but 12 weeks on and some items are still filtering through. Is there anything can be put in place which performs some form of refresh or basket delete, preferabbly on a basket older than say 4 weeks. (or any number of weeks post matrix build)

Looking at the nessage source, I found this in the bottom. There is reference to 'PP_Config' and also 'Mailscanner' which is a piece of software running on our mailserver. <MailScannerS= cript29528 script id=3D"pp_config" type=3D"application/json">{"home":{"dom"= :".home_wrapper"},"category":{"dom":".category_wrapper"},"product":{"dom":"= .product_wrapper #main_content form .row .row:last-child"},"payment": {"dom= ":"#checkout_actions"},"cart": {"dom":"#checkout_actions"}}</MailScannerScr= ipt29528><MailScannerScript29528 script> var pp_config =3D JSON.parse(document.getElementById('pp_config').t= extContent) var pp_amount =3D 36.36;</MailScannerScript29528></body></html>

I'm slightly misunderstanding part of your reply. "Your personal experiments could not reproduce an item's purchase that had the wrong product code -- provided the options matrix's product code was available at the time the item was put in the basket. " If I add an item to the basket that doesn't yet contain a matrix entry, then go back and create a matrix entry, this matrix entry is never populated in the basket. I can continue with the order and complete checkout as if the matrix entry doesn't exist. The order is then sent to admin and the customer without the matrix entry. When the order is complete, as an admin I can edit the order, don't make any chnages and just save, the product is then populated with the matrix, but by then it's too late, it's already been posted to admins with an incorrect product code.

I considered that it may have been the email template, but I switched my language to French and the same gibberish appears. I've never meddled with any of the foriegn templates.

It's been noted that the bottom of an order confirmation contains gibberish (see image) Any ideas where to start looking ?

Noodleman thinks that it might be related to https://github.com/cubecart/v6/issues/2466

Its definately related to a chached basket. I added a product with an option to my cart, then closed my browser. Created a matrix for the option and saved the changes. Going back and completing the order and the matrix code is not shown.

Opening the overview tab and choose save/reload did update the product with the matrix code. However,we take about 200 orders daily, so opening each and every order, just to check if the matrix was populated isn't practical. I've been working with Noodleman on a project for the past few months, which is about to go live, if not this week then next. This relies heavily on the matrix codes being correctly passed, so just about all human intervention will be off the cards.

I've not had to make any changes to the email templates, the matrix codes are being passed. I'm pretty confident in sayimg that should I search other orders for this matrix prodcut code, it will have been passed, It's always passed when I try to recreate the issue. My problem appears to be, occasionally some matrix codes are not passed, despite the matrix being populated. So in this instance, 6 items were passed with the matrix prodcut code and 1 wasn't, even though the matrix for this product was populated about 10 weeks ago. The only logical explanation I can come up with is that the customer added this product to his cart prior to me adding a matrix product code. eg: The product could be a glove with an option for XL. Prior to the matrix this would have been passed as GLV1, with a descriptive line stating XL. But siince adding a matrix, this should now be passed as GLV1-XL. If the customer has had GLV1 in his cached cart for weeks, how do I force an update to use the matrix. Is this even possible. ??

I'm still getting orders where the matrix part code isn't being populated on some order confirmations. Customer ordered half a dozen products, some with matrix entries.. most of which worked. But one product didn't pass the matrix product code across, the matrix was applied to this product on the 30th of June. I can accept that maybe this product has been in his basket for 10 weeks or more (before the matrix change), so any thoughts on how I can fix this and force the correct code. We are about to go live with a system that fully requires these matrix items to work.

Does PP Commerce still have the ability to override the customers address details. Al has suggested switching to commerce, but i'm nervous in the respcet that previous incarnations got us in to no end of trouble numerous times. Using his personal paypal account, buyer makes a purchase for work, PayPal over rides the delivery address. We send a pallet of goods to the wrong address. Goods inviraiable come back to us 2 days later, where we have to re-arrange shipment. Customer is not best pleased, as a next day delivery has just taken a week.