wakabayashi

I am not sure, how many of you are aware, that the core logs can slow down your shop drastically. I am optimizing my site these days and kind of analyze all chains of code. I suddenly noticed, that a huge table (215k rows in my case) of "ps_log" slowed my shop for around 300ms. After truncating this table I have now kind of 500ms instead of 800ms. This is kind of sick 🙃 The reason is mainly this one: https://github.com/thirtybees/thirtybees/blob/main/classes/Hook.php#L564

Great update post @the.rampage.rado

Yes that sounds logical. Cause also here: the warehouse is not the same. Do you want the split up? And why do you have some entries with asm and some without?

Every year again 😅 I finally understood what in my case brought up this order splitting. It's missing entries in warehouse_product_location table. It happened for me, if we are adding combinations or deleting combinations. Not sure, if it's a bug in core or if it came to bad overrides on my side. Maybe someone else can confirm, if he has this issue too due to combinations.

The issue is in public function isParentCategoryAvailable($idShop) in Category Class. IMO it doesn't join the category correctly. I have 3 shops. (id_shop=3 is the default one). But in ps_category I have some entries, that have id_shop_default=1 (don't ask me how I can even controll this as an user). In this case isParentCategoryAvailable($idShop) returns false, even if a category is associated to shop with id_shop=3. https://github.com/thirtybees/thirtybees/blob/main/classes/Category.php#L2427 Should be changed to: ->join(Shop::addSqlAssociation('category', 'c', true, null, true)) This is a very edge case, which explains why I am probably the only one suffering from it 🙄

Thats what I thought. That's why I asked here and didn't open a github issue. I will investigate this further, to understand, why it happens.

Ok likely the id_parent is not always set, when editing a category. Maybe it's related to multistore. 😶‍🌫️

Do you have also issues when saving categories? I had this in my teststore. Now I have it also in the live store. I just saved a category X and now the tree in BO is completly broken. I can't find them anymore there... @datakick is the complexity with level_depth, nleft, nright, is_root_category any good for? To me this looks overcomplex and that's why it's no wonder, that its kind of broken.

Yes, since I use cloudflare turnstile all my spam problems (over the website) are gone.

Well with Matomo there is not so much problems in Data protection as they are always in your hands. But The question remains, how much you give to Google, Facebook and Co. Does Matomo offer a sync to google ads? I don't think so.

I was working on this recently as well. What I do: Only load the conversion pixel on the confirmation page, then submit it and on next page refresh delete all the cookies again. Like that you have the conversions, but you basically don't let the big sites track your users on your site. If this is a clever or a nonsense solution, is up to priority. I also don't know, how negatively it affects retargeting stuff. I believe in general one has to decide, if we want to protect customer data or get the best results from ads. To have both in perfection is probably not possible.

Meiner Meinung braucht man genau das: pro Domain von der man sendet eine eigene IP. Scheinbar kannst du bei Sendgrid solche IPs buchen. Persönlich überrascht mich dieses harsche Vorgehen etwas, aber für uns ist es nicht wirklich relevant 🙃 Hat man alles diesen Scheiss Spamern zu verdanken...

Bist du sicher @Occam? Ich verstehe den Text gleich wie @30knees. Technisch würde ich sagen, dass der reverse DNS zum Problem wird. Da kann man mit herkömmlichen Mitteln (soviel ich weiss) nur eine Domain hinterlegen. Somit wird das problematisch. Aber ok, bin kein Experte rund um Server... Da frage ich mich gerade, ob ich dieselben Probleme bekommen werde als Multishop User trotz eigenem Server 🙈 Naja wird bei mir eh bald Geschichte sein mit Multistore...

@datakick I am working again a bit on this as my shop relaunch comes closer. Today I checked, how rewrite rules should look like and generated them quickly. This works fine for me: rewrite ^/categories/([0-9]+)-([^\s/]+)/([^\s/]+)\.webp$ /img/c/$1-$2.webp break; rewrite ^/categoriesthumb/([0-9]+)-([^\s/]+)/([^\s/]+)\.webp$ /img/c/thumb/$1-$2.webp break; rewrite ^/genzoportallink/([0-9]+)-([^\s/]+)/([^\s/]+)\.webp$ /img/genzo_portal/links/$1-$2.webp break; rewrite ^/manufacturers/([0-9]+)-([^\s/]+)/([^\s/]+)\.webp$ /img/m/$1-$2.webp break; rewrite ^/scenes/([0-9]+)-([^\s/]+)/([^\s/]+)\.webp$ /img/scenes/$1-$2.webp break; rewrite ^/scenesthumb/([0-9]+)-([^\s/]+)/([^\s/]+)\.webp$ /img/scenes/thumbs/$1-$2.webp break; rewrite ^/stores/([0-9]+)-([^\s/]+)/([^\s/]+)\.webp$ /img/st/$1-$2.webp break; rewrite ^/suppliers/([0-9]+)-([^\s/]+)/([^\s/]+)\.webp$ /img/su/$1-$2.webp break; rewrite ^/products/([0-9])(\-[_a-zA-Z0-9-]*)?(-[0-9]+)?/.+\.webp$ /img/p/$1/$1$2$3.webp break; rewrite ^/products/([0-9])([0-9])(\-[_a-zA-Z0-9-]*)?(-[0-9]+)?/.+\.webp$ /img/p/$1/$2/$1$2$3$4.webp break; rewrite ^/products/([0-9])([0-9])([0-9])(\-[_a-zA-Z0-9-]*)?(-[0-9]+)?/.+\.webp$ /img/p/$1/$2/$3/$1$2$3$4$5.webp break; rewrite ^/products/([0-9])([0-9])([0-9])([0-9])(\-[_a-zA-Z0-9-]*)?(-[0-9]+)?/.+\.webp$ /img/p/$1/$2/$3/$4/$1$2$3$4$5$6.webp break; rewrite ^/products/([0-9])([0-9])([0-9])([0-9])([0-9])(\-[_a-zA-Z0-9-]*)?(-[0-9]+)?/.+\.webp$ /img/p/$1/$2/$3/$4/$5/$1$2$3$4$5$6$7.webp break; rewrite ^/products/([0-9])([0-9])([0-9])([0-9])([0-9])([0-9])(\-[_a-zA-Z0-9-]*)?(-[0-9]+)?/.+\.webp$ /img/p/$1/$2/$3/$4/$5/$6/$1$2$3$4$5$6$7$8.webp break; rewrite ^/products/([0-9])([0-9])([0-9])([0-9])([0-9])([0-9])([0-9])(\-[_a-zA-Z0-9-]*)?(-[0-9]+)?/.+\.webp$ /img/p/$1/$2/$3/$4/$5/$6/$7/$1$2$3$4$5$6$7$8$9.webp break; rewrite ^/products/([0-9])([0-9])([0-9])([0-9])([0-9])([0-9])([0-9])([0-9])(\-[_a-zA-Z0-9-]*)?(-[0-9]+)?/.+\.webp$ /img/p/$1/$2/$3/$4/$5/$6/$7/$8/$1$2$3$4$5$6$7$8$9$10.webp break; You see genzoportallink is just a module from myself, that uses the ObjectModel image definition. Still some stuff left, that need to be fixed: The multistore thing with different themes and with different sizes for same imageType The gathering and include of objectModelFiles that use $definition['images']. Probably other stuff as well, but on my shops things look quite good 😳 😏

Have you checked the error_logs? You need this module "Collect PHP Logs" to be installed...

It happens when something fails. The current_state couldn't be saved. But likely through an expection, that is not related to order states. You should check error_logs.

15959#0: *1869971 upstream sent too big header while reading response header from upstream Found now this in the logs. Which clearly indicates, that you were right @datakick. What confuses me a lot: he has apache selected, so why is there a nginx error? I contacted the webhoster. As it is shared, they refuse to increase any values. Is this normal? Does it mean, that thirtybees and shared webhosting is not really an option? I mean personally I have a dedicated server for multiple reasons, but I always thought, that it's possible to use shared hostings as well. What is your experience with this? Is this hoster total shitty or is it kind of normal to get problems with it? I noted, that it's not so easy to go the next step after shared webhosting. Let's say you pay 2-15$ for shared and often 80$ or more for private managed server. An unmanaged server is no option for 99% of merchants. I see a lot of vps/cloud stuff, but often this is not managed as well. Am I missing something or is it not so easy to get something managed for 35$, that is better than shared webhosting offers?

If this was possible at PS 1.6, then there is some point in your request. I am not totally sure, if it was and if it was intended... https://devdocs.prestashop-project.org/8/modules/concepts/module-class/#name But ok lets get productive. What is the problem in renaming them? I understand that this is no option for a merchant, but I am asking YOU as a DEV. Which modules are you actually talking about, cause in my years I have never seen one with capital letters...

Not worth the time 😅 Sorry, but if you are a module dev you have no reason to use uppercase. It's just not clever. Exactly as naming your module generic "paypal" is also not clever... Luckily I read at the beginning of my coding "life" the book from Fabien Serny about prestashop (modules). He explained this very well... That's why all my modules have prefix "genzo_". @musicmaster Are these really the main issues you have with tb and ecommerce in general? I mean then you are the luckiest dev/merchant around here.

Thanks to @datakick, who submitted a PR and improved some minor issues! In general this module works great for me to block spam. Personally I have none at all, right now. So it was time to make an official release of v.1.0.0. https://github.com/eschiendorfer/genzo_turnstile/releases/tag/v.1.0.0

Theoretically no problem. It's a question of the theme displaying the stuff...

@datakick any idea why this could happen? The server is using cloudflare. I was logged in on his site. Then logged out. Now wanted to log in again. Got the 502 error. Deleted cookies. Login/Logout works without any problem. Unfortunately I didn't test after the 502 error, if I was actually logged in or not 😞 Edit: Somehow I could get the error again. But no idea how exactly. Only worked once to recreate. Either it has something to do with checkout. There I could imagine mollie or loyalty. But both a bit unlikely. What I much more suspect: Could it be, that a deactivated captcha module causes it? If a module has overrides but is deactivated. Are these override still active!? I mean technically I would be surprised, if they aren't. But I have never thought about it...

Ja. Ich kann das bestätigen. Es ist bei mir auch passiert. Dann Cookies gelöscht und jetzt kann ich es nicht mehr reproduzieren. 🙄

Eventuell brauchst du folgendes Modul: Mail via swiftmailer v1.0.0 - von thirty bees

You are right. But ok that's the wrong thread to talk about it. See my new post in: