DRMasterChief

PLEASE tell all of us how you solved it, this is how an forum should work 😉

this is one of the questions about this... where can i find these logs?

I use the module on tb 1.5.1 and it has hits every day. I get the message from the module about it by email. But I also get two emails for each hit with the information that there are new warnings in the log files. This is at the same time as the message from the module. Why is that?

Hi, in any case of error 500 you have to turn on Debug Mode for the shop. Usually this is turned off. Copy the file you get with the error in BO then and you can read the problems then in plaintext. Some good descriptions to do so you can find for tb and also for PS via Google. I know there is a tb module for Stripe (use search function here in forum) which will work. A 3rd party thing should be always the last option and then the module developer is also responsible.

ok, maybe i have to set up a new test ecosphere with tb 1.6 🙂 - i thought a short screenshot of this will help us all.

Do you have an picture about this, please? I really want to see this details, as it is interesting for us since a long time and we did not get managed an solution.

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)

Is there an option for that? > i don't think so.

found also this useful hint, it is from user @Mediacom87 : How to apply a different discount to multiple copies of a product on PrestaShop - Mediacom87.fr/en/

a simple overview if found here: https://i.sstatic.net/NvdtU.png and the qty. discount you can find (and set) for each item in the catalogue/items/price > discount price / add discount (and choose from qty. 2 e.g.)

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