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 

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