Jump to content


  • Posts

  • Joined

  • Last visited

  • Days Won


Everything posted by keat

  1. 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.
  2. 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
  3. 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 ?
  4. 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.
  5. 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.
  6. 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
  7. stand down... my fault, i was looking in the wrong place.
  8. 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.
  9. 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.
  10. 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.
  11. 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.
  12. As from last week, I'm semi retired, i'm only working 1 day per week, hence the delay in responding. Any suggestions how you'd explore the database ?
  13. T-CUT cleans tar from paintwork, if i remove the phase 'tar' from the product description, and perform a new search the cart then comes back with 490+ products. I'd suggest that 480 of them probably don't contain this phrase anywhere. For instance, search tar and the first result (out of 490) is a cable tie. https://www.beal.org.uk/stock-clearance/stock-clearance/cable-ties-bases/cable-ties-762mm-x-9.0mm No mention of TAR anywhere, maybe if it contained the phrase 'guitar' i could understand why it pulled this product. ??
  14. Yes on the double spacing... Quite clearly I did something wrong with the edit, but what ever I did...... I did it wrong twice So I remade the edit, and now the search seems to work for that phrase. But if I search GRN (Grease nipples), it says only 1 product found, yet there are probably 30 or more. Also, If I search TAR (which is a range of tarpaulins) it only bring up T-Cut (which removes tar spots) I'm guessing that it's only searching the descriptions maye, only I've no idea why BPN's show a full range. ................................................. I figured something out. If I search GRN, the results come back with only one product found. This product contains the phrase 'GRN in the description' If I remove this phrase from the product and try again, the search comes back with about 30 results. I can only conclude that the search looks at the description first, and if it finds an answer, doesn't look elsewhere for any other occurances. It's done it's job and stops. ........................................... And then it's even more wierd. I removed the TAR phrase from t-cut. Performed a fresh search for TAR and the results come back with 49 pages.
  15. my line numbers were massively out compared to the ones you quoted. I found the lines way higher up in the 3-4000's. I made the edits but it killed the site.. just a white screen
  16. We don't have a product code 'UNF', so this phase appears in either the prodct name or description. The issue seems to be around product codes. PM sent
  17. @Al BrookbanksDo we need to raise this on GitHub ??
  18. Click the next page, the page flashes (assume a refresh), but nothing changes. web site is www.beal.org.uk Search for BPN (a product code) and see what happens. But search for 'Brake Pipe Nut' and see how the page actually does refresh.
  19. 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.
  20. I disabled the PayPal Commerce plugin and now the gibberish has gone. Re-enabled it and the gibberish is back.
  21. We have 25 products with a product_code starting BPN. If I search BPN only 12 products appear in the results (2 of which contain BPN in the description). The web site would indicate that there are 3 pages of BPN's, which if there are 25+ this would be about right. But if I click to the next page, then nothing happens. Also 'View All' does nothing. This probalem appears to be when searching product codes and not so much when searching words. If I search 'brake pipe nuts' which are BPN's then the search works and will move on to the next page. Any pointers please.
  22. 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)
  23. Excellent as always. Thanks Brian, problem solved.
  24. 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>
  25. 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.
  • Create New...