DRMasterChief

Yes, you have to choose a weight-based shipping pricing model OR a money-based pricing model, a combination of both is not possible by default. There are modules for this, but as I've noticed, they usually don't work reliably. Be careful about spending money on it right away. The weight-based shipping pricing model is a powerful tool. Of course, you have to keep your items (weights) up to date and maintain them. But this makes it possible to present a wide range of shipping solutions. You don't have to use the real item weight for this. We have e.g. 0.0001kg for most items plus then the correct weight of 1kg for other (heavy or bulky) items.

I have the same behaviour with bankwire module, most of the text is translated but since my last changes by hand the upper text appears in English again.... ?! Maybe it is a combination of frontend and modules in your case and you have to check both?

sorry, maybe I'm too nervous, but where can I find this?

This error occurred yesterday when a customer tried to renew his password. I only became aware of this today, which is of course very annoying. I don't use any special modules that could cause something like this, there are only the modules that come with the system. What I did now: I called up this customer (from Poland), gave him a new password, checked the customer group, and simply saved it again. I saw that this customer had left an open shopping cart. He probably didn't know his password anymore... The error has now disappeared with the things mentioned. The shop is accessible again without error 500. But what was going on? I'm very worried that this could happen again at any time.

i am sorry, i can also see this NOT in any SQL table... I have now checked with phpMyAdmin and searched all files for this content.

i have this in error log, is this what you are looking for or do you need something from phpMyAdmin? SELECT c.*, cl.* FROM `tb_category` c INNER JOIN tb_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `tb_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 LEFT JOIN `tb_category_group` cg ON c.`id_category` = cg.`id_category` RIGHT JOIN `tb_category` c2 ON c2.`id_category` = 3 AND c.`nleft` >= c2.`nleft` AND c.`nright`

what file do you need? please advise. i just posted the error log here, if this is not enough i am happy to complete it with your advise 🙂

Hi everybody, i get an heavy SQL error yesterday when a customer tried to renew his password. Now the complete site brings an server error 500 and i really do not know what to do. I really look for @datakick for any help, please! Please see this error message: Message: ThirtyBeesDatabaseException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') GROUP BY c.`id_category` ORDER BY c.`level_depth` ASC , categ...' at line 10 Location: classes/Category.php line 360 SELECT c.*, cl.* FROM `tb_category` c INNER JOIN tb_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `tb_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 LEFT JOIN `tb_category_group` cg ON c.`id_category` = cg.`id_category` RIGHT JOIN `tb_category` c2 ON c2.`id_category` = 3 AND c.`nleft` >= c2.`nleft` AND c.`nright` #0 classes/Category.php(360) #1 classes/db/Db.php(235): () #2 classes/db/Db.php(441): DbCore->displayError(string(624): "\n\t\t\t\tSELECT c.*, cl.*\n\t\t\t\tFROM `tb_category` c\n\t\t\t\t INNER JOIN tb"...) #3 classes/db/Db.php(1102): DbCore->query(string(624): "\n\t\t\t\tSELECT c.*, cl.*\n\t\t\t\tFROM `tb_category` c\n\t\t\t\t INNER JOIN tb"...) #4 classes/Category.php(360): DbCore->getArray(string(624): "\n\t\t\t\tSELECT c.*, cl.*\n\t\t\t\tFROM `tb_category` c\n\t\t\t\t INNER JOIN tb"...) #5 modules/blocktopmenu/blocktopmenu.php(603): CategoryCore::getNestedCategories(3, 1, false, array(0) []) #6 modules/blocktopmenu/blocktopmenu.php(1004): Blocktopmenu->makeMenu() #7 classes/Hook.php(833): Blocktopmenu->hookDisplayTop(array(3)) #8 classes/Hook.php(543): HookCore::coreCallHook(Blocktopmenu#1, "hookdisplayTop", array(3)) #9 classes/Hook.php(372): HookCore::execWithoutCache("displayTop", array(3), null, false, true, false, null) #10 classes/Hook.php(242): HookCore::exec("displayTop", array(0) [], null) #11 classes/controller/FrontController.php(332): HookCore::displayHook("displayTop") #12 controllers/front/MyAccountController.php(71): FrontControllerCore->initContent() #13 classes/controller/Controller.php(209): MyAccountControllerCore->initContent() #14 classes/controller/FrontController.php(264): ControllerCore->run() #15 classes/Dispatcher.php(851): FrontControllerCore->run() #16 index.php(33): DispatcherCore->dispatch() and the decoded error reporting has the following detail in Source file: classes/Category.php : 341: (int) $rootCategory.(int) $idLang.(int) $active.(int) $useShopRestriction 342: .(isset($groups) && Group::isFeatureActive() ? implode('', $groups) : '') 343: ); 344: 345: if (!Cache::isStored($cacheId)) { 346: $result = Db::readOnly()->getArray( 347: ' 348: SELECT c.*, cl.* 349: FROM `'._DB_PREFIX_.'category` c 350: '.($useShopRestriction ? Shop::addSqlAssociation('category', 'c') : '').' 351: LEFT JOIN `'._DB_PREFIX_.'category_lang` cl ON c.`id_category` = cl.`id_category`'.Shop::addSqlRestrictionOnLang('cl').' 352: '.(isset($groups) && Group::isFeatureActive() ? 'LEFT JOIN `'._DB_PREFIX_.'category_group` cg ON c.`id_category` = cg.`id_category`' : '').' 353: '.(isset($rootCategory) ? 'RIGHT JOIN `'._DB_PREFIX_.'category` c2 ON c2.`id_category` = '.(int) $rootCategory.' AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`' : '').' 354: WHERE 1 '.$sqlFilter.' '.($idLang ? 'AND `id_lang` = '.(int) $idLang : '').' 355: '.static::getActiveColumnCondition($active, $useShopRestriction).' 356: '.(isset($groups) && Group::isFeatureActive() ? ' AND cg.`id_group` IN ('.implode(',', $groups).')' : '').' 357: '.(!$idLang || (isset($groups) && Group::isFeatureActive()) ? ' GROUP BY c.`id_category`' : '').' 358: '.($sqlSort != '' ? $sqlSort : ' ORDER BY c.`level_depth` ASC').' 359: '.($sqlSort == '' && $useShopRestriction ? ', category_shop.`position` ASC' : '').' 360: '.($sqlLimit != '' ? $sqlLimit : '') 361: ); 362: 363: $categories = []; 364: $buff = []; 365: 366: if (!isset($rootCategory)) { 367: $rootCategory = Category::getRootCategory()->id; 368: } 369: 370: foreach ($result as $row) {

Thank you for that! And I think it should be like this to keep that turned on (or simply do not have such an code) error_reporting(1);

I send a PM with the files. Maybe this is a bigger thing for a lot of thirtybees users, as most of the themes uses a old schema and as far as i can see most of the users has to update this. Hopefully we can gather some help and solutions here.

I have changed the breadcrump.tpl but i have one problem with the style. Before (with data-vocabluary.org) it has shown the shop title and the menu in a row, that looked great and was exactly how it should be in this Theme. Now (with schema.org), it shows everything one below the other and on desktops it is displayed incorrectly. With mobile devices it is also the case with one below each other, but at least you can see it completely without errors. but that doesn't look good... Help please, i am a totally noob with the breadcrumb / schema.org -thing.... pls. see the picture, the green text is my notice:

Hi, comment the lines in your theme: /themes/your theme/authentication.tpl about line 113 (block class gender_line) and for OPC it is in: files order-opc-new-account.tpl and order-opc-new-account-advanced.tpl Then delete smarty and browser cache too. You can also change gender e.g. to woman/men/others or something like that... Depending on Theme, you can also change the visibility for CSS to hidden or false.

Great, thank you for fast answer! I will check for compatibility with my Theme and will try.

ich habe leider die gleiche Fehlermeldung von Google: "Navigationspfade": "Schema "data-vocabluary.org" veraltet" Kann uns da jemand bitte auf die Sprünge helfen 🙂 ?

👍 pls. see also here, still on the forum: Free Compatible themes and Modules - English - thirty bees forum

i guess so: # robots.txt automatically generated by thirty bees e-commerce open-source solution # http://www.thirtybees.com - http://www.thirtybees.com/forums # This file is to prevent the crawling and indexing of certain parts # of your site by web crawlers and spiders run by sites like Yahoo! # and Google. By telling these "robots" where not to go on your site, # you save bandwidth and server resources. # For more information about the robots.txt standard, see: # http://www.robotstxt.org/robotstxt.html User-agent: * # Allow Directives Allow: */modules/*.css Allow: */modules/*.js # Private pages Disallow: /blackhole/ Disallow: /modules/blackholebots/blackhole/ Disallow: /*?orderby= Disallow: /*?orderway= Disallow: /*?tag= Disallow: /*?id_currency= Disallow: /*?search_query= Disallow: /*?back= Disallow: /*?n= Disallow: /*&orderby= Disallow: /*&orderway= Disallow: /*&tag= Disallow: /*&id_currency= Disallow: /*&search_query= Disallow: /*&back= Disallow: /*&n= Disallow: /*controller=addresses Disallow: /*controller=address Disallow: /*controller=authentication Disallow: /*controller=cart Disallow: /*controller=discount Disallow: /*controller=footer Disallow: /*controller=get-file Disallow: /*controller=header Disallow: /*controller=history Disallow: /*controller=identity Disallow: /*controller=images.inc Disallow: /*controller=init Disallow: /*controller=my-account Disallow: /*controller=order Disallow: /*controller=order-opc Disallow: /*controller=order-slip Disallow: /*controller=order-detail Disallow: /*controller=order-follow Disallow: /*controller=order-return Disallow: /*controller=order-confirmation Disallow: /*controller=pagination Disallow: /*controller=password Disallow: /*controller=pdf-invoice Disallow: /*controller=pdf-order-return Disallow: /*controller=pdf-order-slip Disallow: /*controller=product-sort Disallow: /*controller=search Disallow: /*controller=statistics Disallow: /*controller=attachment Disallow: /*controller=guest-tracking Disallow: /*controller=trigger # Directories Disallow: */classes/ Disallow: */config/ Disallow: */download/ Disallow: */mails/ Disallow: */translations/ Disallow: */tools/ # Files Disallow: /de/adresse Disallow: /de/adressen Disallow: /de/authentifizierung Disallow: /de/warenkorb Disallow: /de/discount Disallow: /de/auftragsverfolgung-gast Disallow: /de/bestellungsverlauf Disallow: /de/kennung Disallow: /de/mein-Konto Disallow: /de/bestellung Disallow: /de/bestellbestatigung Disallow: /de/bestellungsverfolgung Disallow: /de/schnell-bestellung Disallow: /de/bestellschein Disallow: /de/kennwort-wiederherstellung Disallow: /de/suche Disallow: /en/adresse Disallow: /en/adressen Disallow: /en/authentifizierung Disallow: /en/warenkorb Disallow: /en/discount Disallow: /en/auftragsverfolgung-gast Disallow: /en/bestellungsverlauf Disallow: /en/kennung Disallow: /en/mein-Konto Disallow: /en/bestellung Disallow: /en/bestellbestatigung Disallow: /en/bestellungsverfolgung Disallow: /en/schnell-bestellung Disallow: /en/bestellschein Disallow: /en/kennwort-wiederherstellung Disallow: /en/suche

maybe have a look in the Backoffice > presets > pictures , there you can manage the max. filesize for pics.

Hi, not one Chinese yet, so this is why i have these questions..... i have IP´s from MS, OVH, Ionos.... and i am not sure if they are 'real' the Bot's we want to catch.

We have also been using the module for a few days. Approximately every day 1-2 reports arrive via email about a captured bot. I would also like to understand the e-mails better and therefore i am asking for information here. We get the message something like this: Bad Bot Alert! IP Address: 4.2x5.1x0.15 WHOIS Lookup for 4.2x5.1x0.15 ARIN WHOIS data and services are subject to the Terms of Use available at: https://www.arin.net/resources/registry/whois/tou/ If you see inaccuracies in the results, please report at https://www.arin.net/resources/registry/whois/inaccuracy_reporting/ Copyright 1997-2024, American Registry for Internet Numbers, Ltd. NetRange: 4.240.0.0 - 4.255.255.255 CIDR: 4.240.0.0/12 NetName: MSFT NetHandle: NET-4-240-0-0-2 Parent: NET4 (NET-4-0-0-0-0) NetType: Direct Allocation OriginAS: Organization: Microsoft Corporation (MSFT) RegDate: 2021-04-06 Updated: 2021-04-06 Ref: https://rdap.arin.net/registry/ip/4.240.0.0 OrgName: Microsoft Corporation ........ Do I now have to look for who the IP belongs to, for example whether it is from the search engine Bing in this case (Microsoft)? That would be important to index the shop... And: can I change the email address to which notifications are sent? Then we could use a separate address or mailbox for this.

in BO is selected the 5 steps checkout, but this is modified as described here: 3 page checkout (sort of) for Community-Default-Theme - Themes - thirty bees forum Best would be to make this 3PC as 'standard' in thirtybees and/or if a dev can check this problem there.

Thanks for this! People sometimes choose (in our actual shopsystem, not tb) Swasiland for Switzerland 🙂

Yes, have tried this too. At the moment it is like this: {if !$opc} <div id="ordermsg" class="form-group"> <label>{l s='If you would like to add a comment about your order, please write it in the field below.'}</label> <textarea class="form-control" cols="60" rows="6" name="message" id="message">{if isset($oldMessage)}{$oldMessage}{/if}</textarea> </div> {/if} The {if !$opc} makes it only working when OnePageCheckout (OPC) is on. I do not have OPC on, i have changed the cart workflow to the 3-Page-Checkout (3 page checkout (sort of) for Community-Default-Theme - Themes - thirty bees forum), but there i can not find anything which can cause this problem. I have also tried to get rid of the {if !$opc} , but then i get a 500 error. It seems to be a 'deeper' problem than just to add an ID to message or something like that, i´m afraid. Problem is, i can not find anything and i was planning to go live with the shop in 2 days.... working for months on the shop and now this small thing 🤕 - but the comment field is very important for us and customers. Last thing is, to delete the comment field for the moment, but then we have a lot to clarify by e-mail for most of the orders. Not a good option.

Hi, yes it is named message: <div id="ordermsg" class="form-group"> <label>leave a message</label> <textarea class="form-control" cols="60" rows="6" name="message"></textarea> </div> but in the next step i can not see the 'message' anywhere sent to the server. This exactly names the error, but i can NOT fix it with this: https://www.prestashop.com/forums/topic/338036-solved-opc-comments-about-order/

yes, unfortunately! maybe @toplakd can still have a look?

seems to be this problem here: maybe @toplakd can have a look ?!