Jump to content
thirty bees forum

DRMasterChief

Members
 View Profile  See their activity

  • Posts

    598

  • Joined

  • Last visited

  • Days Won

    13

 Content Type 

Posts posted by DRMasterChief

    Discounted shipping

    in English

    Posted · Edited by DRMasterChief

    the weight has to be seemless,  e.g.  0.001 - 0.23 /  0.23 - 0.55 /  0.55 - 0.87  and so on  (just an example)

    and not sure if you can use  -amount there  (i did not ever tried it)

    Discounted shipping

    in English

    Posted · Edited by 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.

    heavy SQL error and server error 500 when customer tries to reset his password, please help - urgent !

    in Technical help

    Posted

    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.

    heavy SQL error and server error 500 when customer tries to reset his password, please help - urgent !

    in Technical help

    Posted

    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`

    heavy SQL error and server error 500 when customer tries to reset his password, please help - urgent !

    in Technical help

    Posted · Edited by DRMasterChief

    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) {

    Theme "Warehouse": data-vocabluary.org vs. schema.org in breadcrumb.tpl

    in Deutsches Forum - Generelle Fragen

    Posted · Edited by DRMasterChief

    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:

    breadcrumps.jpg

    Disable Cart fields? Home and Work Phone?

    in Theme help

    Posted · Edited by DRMasterChief

    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.

    BlackHole for badbots emails

    in Module help

    Posted

    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
     

    BlackHole for badbots emails

    in Module help

    Posted · Edited by DRMasterChief

    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.

×
×
  • Create New...