the.rampage.rado

Recently I started playing with the embedded SQL manager to make queries that are useful in shop maintanance. I noticed that my products contain information for language ids that are not currently installed (or active). I can't remember if I used to have additional languages in this shop instance before. Currently I have: But this query: SELECT pl.id_product, pl.id_lang, pl.description_short, LENGTH(pl.description_short) as short_description_length FROM tb_product_lang pl WHERE LENGTH(pl.description_short) < 50; pulls the following table: My question is: as I don't have lang ID 3 and 5 could I safely delete all those records (and also every other record, even if larger than 50 characters) for those IDs? Could I use this query for doing so: DELETE pl FROM tb_product_lang pl LEFT JOIN tb_lang l ON pl.id_lang = l.id_lang WHERE l.active = 0 OR l.id_lang IS NULL; If I understand it correctly even if I had let's say Spanish as ID=3 and I remove it and I add it again it will get the next unused langID, not return to 3? In this case why deleting the language is also not deleting all records associated with this ID (products, image descriptions, features, etc.)?

I would like to moderate/remove your message as it's your first here and it contained some bold claims about a company, and nobody here would have time to discuss with their lawyers, etc. For future reference if you wish to be part of this community please keep in mind that you can express your opinions freely, but not as anonymous user that just registered here just to say some 'nice' words against a person/entity. Best regards!

And you have to uninstall the UA module as you will not need it that way.

Thanks for the hint but a merchant permission is vital for this list.

Currently not. You can embed your gtag manually via the Custom Code function. Paste it in "Add extra metas to the header" section. This also works with Multistore (simply switch shop context and add the relevant G Tag).

Or if some products use ASM and some not.

Congrats on updating to 1.5.1 as there are many bugfixes and many security fixes in this release! If you have further issues, please create new thread and we will try to help. 😉

If you are considering those empty lines a way to rule out this is to delete them and then resave your settings in the module. BUT MAKE A DB BACKUP BEFORE THAT!

Try uninstalling/installing the recent posts module and also check your Positions. That is strange.

The core update has nothing to do with those modules. Do you see them installed and enabled in Modules? Do you see the BO menu entry for the blog?

You have to be careful for the type of connection and the ports used. The module works flawlessly. 😉

Could you send me a link?

Probably a discussion that could help you: https://stackoverflow.com/questions/30371910/phpmailer-generates-php-warning-stream-socket-enable-crypto-peer-certificate

If you clear the cache of your browser or open Incognito mode they will not be visible. If you want to clear some more space you can go to /themes/cache and clear every js and css file older than 30 days (or update to edge where this functionality is added in the core). It will not clear lots of inodes but will free some space.

You purchased Tidy module if I remember correctly? In it there is an option 'Set cheapest combinations as default' If you have used this function you will most probably have to go product by product and change the default combination.

There are many options you misconfigured your shipping. Please, post some screenshots of those pages: And also, please describe what you want to achieve? You want fixed shipping for under $ NNN and then free shipping or you want to have steps, etc.?

Could you test the thirty bees module again and check if your settings match mine (I posted them in the other thread)?

Could you post those logs (delete any sensitive info first)?

I'm not using Stripe but just made a quick test in my spare installation and it's showing even without proper keys. I imagine you have checkmarks here: And here everything is enabled for your country-currency-visitor group-carrier combination: The result:

After you add a payment method you have to go to Modules -> Payment and enable this new payment method for the appropriate: currencies groups countries shipping methods Some of the settings are automatic there but some are not. I bet your shipping associations are not active.👽

Oh... now I saw that you're caching on your file system. Clearing the cache at the same page should alleviate some of those files but they will gradually return as people/bots visit your site. You had an issue with something, that was preventing you from updating your thirty bees, if I remember correctly? Because in the newer versions (1.4 I believe) there is another option in this section that allows caching on your server side cache which is faster and will solve your issue.

If they can give you the numbers it would be lot easier if they can say where those files are accumulating. The cache is not your issue.

@led24ee could you describe the bug you experience with translations? You know that currently the save button only saves the section above it (due to large number of fields in this part of thirty bees this was introduced to get around the timeouts that were common). If you translate lets say 3 modules and only click the last button you will save the last module, same with all other types. If you can describe your issue it will be easier to help.

The contents of this folder gradually increase over time if you have that setting ON. The system keeps old combined css and js files to speed the visits of returning customers. If you have FTP client you can easily select all files in the folder and see their number and size.