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 

Smarty template tricks for OG:tags with international charsets

TL;DR version: if you use opencart or prestashop and your shares on facebook don’t look good, you have product images missing or product descriptions missing, read the article completely, to learn how to properly og: tag your templates. – Some of my Prestashop and Opencart customers, especially French and eastern-europeans use in their product and

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 

When the customer says “that damn computer just won’t work”

TL;dr : check these, if you think your customer’s pc is clogged ; Some of the regular challenges of being an IT support person are listening to heavy cursing, accepting some foul language from your customer knowing that it’s directed towards “that damn machine” and not you, and from time to time, cleaning a PC

Read more 

Blogger thinks 2+2#4 (two plus two is not always four !)

I sometimes wonder how is it even possible, that software and service giants like google, yahoo, microsoft, and other companies their size can even exist in a technology world presumably dominated by pure, hard-core mathematics, and yet, fail to respect even the simplest arithmetic rules, such as 2+2=4. Blogger now “thinks” that math should not

Read more 

Closing other services may affect yahoo mail ?

Has closing several of its services started to adversely affect Yahoo mail ? I wonder if the reorganising and closing of several services that is going on at Yahoo, is affecting the stability of its mail services, or it really is, as they just say, a temporary error. I’ve seen this error several times last

Read more 

Disallow visitors with adblockers to see your content

After following a very interesting thread on google plus with regard to people using adblockers while visiting sites on the internet, I’ve realised that so many people simply don’t understand that some of us actually make a living, as humble as it may be, by displaying ads on our sites. And according to some of

Read more 

How to make firefox portable the default browser

[ TL;DR: solution to set firefox portable as the default html handler ] Firefox Portable, and portable apps in general are great, but when it comes to setting firefox portable as the default html handler, or default internet protocol handler, the creators still haven’t found an integrated, in-app solution for doing that. Sure, you can

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 

Paypal error – is paypal becoming just another untrusted site ?

I see that it’s a trend to do facelifts on sites that otherwise were perfectly functional, but haven’t changed in their outlook for a while, and it’s a trend to make changes for the mere sake of making changes, even if those changes break functionality. Yahoo, gmail, even operating systems and desktops like Ubuntu, and

Read more