DRMasterChief

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 ?!

and i have made an test: in order_conf E-Mail which is sent to me i get 'No message' (which is not true)

Dear @yaniv14 thank you for the information. I have this php file and exactly the content of Github, lines 652-663 are exactly like this, but this does not work. In database tb_message column there is no content, nothing. I have tried this in line 661: $msg->private = 0; but also no luck. Can it depend on the Theme?

Hello, when customer is placing an order (with login or as a guest), the Order message is not showing either in the backoffice nor in the customer's history. It is the message, which customer can leave directly in order process after the cart. (e.g. please do not ship before may 4th), I can see this tab in BO and it is blank, even when a customer definitely leaves a message for us. Where do I find some code where the message configurations are stored? I have already looked in the database at tb_order_message and there is no content. Thank you! (for information: we have content there in the BO when a customer leaves a message for an order/item in his customer account, so this works, i find these in database `tb_customer_message`) (2nd: i know that there was a bug with PS 1.6, but can not find any about this, also in 1.7 it was with an bug and they have fixed it, something with AdminOrdersController i think....), @datakick says in this topic, he will include something with the messages in core for the next version, not sure if this is already done or maybe this can be a solution or the problem? see here: https://forum.thirtybees.com/topic/3642-in-need-of-much-longer-order-message-than-core-allows/?do=findComment&comment=31955 and a picture of our BO with NO message showing:

Hello, is there a chance to see a demo of the Bees Blog in a shop somewhere? Content is King. I will check if the Blog can be a good solution to integrate more content to an shopsystem.

Yes, that does happen from time to time and in some countries I'm not sure if they didn't try to do it on purpose...