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

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.

You could use the 'Print Order Form' plugin as your payment gateway This allows the user to buy without actually paying.

I had issues with SendinBlue. I don't recall the exact scenario, but it went along the lines of them rejecting my mailing campaign half way through sending. I quickly spent my credits and went elsewhere. Moosend is perfect for our requirements, although they are fussy with certain address uploads.

i've a customer base of around 35,000. I'd prefer not to load our server, or risk landing us on an RBL. Although I did briefly consider a seperate VPS just for this process.

My email campaign went out this morning. I'm not seeing any problems.

If anyone uses these kind of things, then I found one named 'moosend' A hell of a lot cheaper than Mailchimp. I had a few issues with my data having a few discrepancies, which I had to resolve first but didn't take long and needed doing anyway. I'll update again next week when my email campaign goes out, as to how it performed.

can anyone recommend an alternative to mailchimp. It needs to be simple, intuitive and not have to jump through a thousand hoops to send a simple mailing campaign.

I believe I may have done this before, but only on one site. Thanks again.

Customers are lazy and won't do that They kick off when we send the goods to the incorrect delivery address (quite rightly), then blame thier lazyness on us. Can you find the image name using developer tools or page source ?