How to install Prestashop on mysql 5.7 or newer

TL;DR version: here’s how you can solve the Prestashop installation error “SQL error on query Invalid default value for ‘last_connection_date’”. If you are installing a Prestashop CMS for your e-commerce needs on a server that is configured with a mysql backend with version numbers 5.7, or any of its newer versions, you might get stuck

Read more 

Ahrefs bots are eating your bandwidth ? Here’s how to block them

The site ahrefs.com can purportedly tell any site owner, for prices starting from 99$ / month, who links to them from where, and also provide site owners with other seemingly significant and meaningful data about visitor activity. The problem is, they use software bots to crawl sites, and THOSE BOTS CLICK ON LINKS in your site,

Read more 

Quick apache .htaccess rules writer in PHP

Sometimes it’s good to have a quick .htaccess rules writer for your server / host, to block a larger number of IP addresses from accessing stuff on your site, like spambots, or people (bored kids ?) who try to hack into your site or blog. If you use any kind of statistics plugin on your

Read more 

Trick to use against idiots who try to hack your site

TL:DR version: some examples of how some lifewaster hacker-wannabes try to gain unauthorised access to sites and blogs and how you can simply and effectively block them — Obviously, some people have too much time on their hands, and don’t appreciate life enough in order to do something useful with theirs, so they spend hours

Read more 

How to fix the Gimp floating toolbars bug in KDE/TDE trinity

The TDE Desktop environment is an extraordinary piece of software that allows one to keep working with the computer as KDE used to look and feel like before the switch or “upgrade” to KDE 3 and before that, and as the project’s maintainers themselves state, with ” … a primary goal of retaining the function

Read more 

Debian, Q4OS, TDE = the holy trinity in linux !

Finally, I can say wholeheartedly, that after having tried and tested very thoroughly, more then 200 linux distributions found on distrowatch.com, I have found the best, fastest, simplest, most complete, most user-friendly, efficient, task-oriented linux distro to date ! Last time when I was so excited and so pleased about anything in computer technology, was

Read more 

My laptop is overheating quickly: tips and tricks for better thermal management

[ TL;DR: Tips and tricks for better thermal management on laptops, to avoid overheating ] Some laptops and notebook/netbook computers have a much better thermal management then others, some are silent and cool better, others make a lot of noise and yet, sometimes overheat. Most people think that in most of the cases in which

Read more 

Collection of Firefox memory and config tweaks to make FF a lot faster

UPDATE: See at the end of the article ! I’ve been a Firefox user since its first versions, way back, when the norm for a pretty good computer was a CPU at around 900 mhz and a 20GB HDD was considered huge (around here, in Eastern Europe, most technologies get adopted a bit later 🙂

Read more 

Import chrome/chromium passwords into firefox

There are at least 1.980.000 results on google alone, if you search for the phrase “import chrome passwords into firefox”, or “export chrome passwords into firefox”, “export chromium passwords to firefox” or something similar. Yet, after parsing meticulously through at least 30..40 pages/URL found in the search result pages, and having done that time and

Read more