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