Free diff / text comparison utility

TL;DR: FREE diff utility. An online tool that helps you more easily recognise the differences between two similar texts.Or any two texts for that matter

Free online diff utility - quickly assess differences between texts

Free online diff utility – quickly assess differences between texts

Here’s a neat “diff” utility for making quick assessments of where two texts differ.

How is this useful ? Well, for starters, if you are an affiliate, or use paypal, or moneybookers, or amazon… oh, wait, ANY online service, the providers might send you notifications from time to time, in which they show you LENGTHY paragraphs with already complex, legal expressions and terms, that make understanding the terms and conditions even harder. And if you receive just a few of those in the same day… your eyes will hurt if you have to go through a bunch of e-mails just to see what has changed in which provider’s terms.

If you’re an affiliate, the notifications about changed terms and conditions every advertiser, or the networks themselves will send out from time to time, again, will be time consuming to check for differences without a tool like this. So this tool will save you tons of time, and make your life a lot easier.

Simply copy the two texts and paste them into boxes 1 and 2 respectively, and click on “Check differences”.

The differences will be shown almost instantly, with intelligently colored boxes, red being the color of the paragraphs that have been present in the first text, but are no longer there in the second one (or they have been changed), green will be the color of the paragraphs that are new in the text (haven’t been included in the first text, but they are present in the second one), and black on white remains the color of the boxes that have text parts that have not been changed.

You don’t need to reload the page to clear the boxes and do another checking, just click on “Clear the boxes” button instead.

Give this little tool a try, and if you like it, do share this post with your friends. Let me know if you have anything to say about it, in the comments on this post.



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'”.

A part of the Prestahop 1.6 Installation Assistant

A part of the Prestahop 1.6 Installation Assistant

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 at 12% of the installation screen, and get an error message that says something like “SQL error on query Invalid default value for ‘last_connection_date'” . This error simply means that the version of Prestashop that you are trying to install, used to handle some database management tasks differently, then the current mysql server expects it.

Most importantly, in the newer versions of the mysql server, beginning with version 5.6, some stricter data validation and field validation defaults have been implemented. And because of those “new rules”, some older php/mysql based software, and some CMS-es like Prestashop, will fail to install.

To circumvent these defaults, you can either temporarily, or permanently modify the way the mysql server loads on your system (if you have access to the “my.cnf” on Linux, usually located at /etc/mysql/my.cnf, or “my.ini” on Windows systems).

Open a simple text-editor in terminal (on Linux) or notepad if you are on Windows, and open your “my.cnf” or “my.ini” file. Add the configuration directive that will REMOVE the strict defaults enforcement.


If you already have blocks/sections in your config file, sections like [mysql] or  [mysqld], add it to [mysqld].

If your file is the default one, it will probably be almost empty, and end with 2 lines beginning with



Add these two lines then, before the !includedir directives:



Save the file. Restart your mysql server. (service mysql restart from a terminal, if you are on a Linux box, and the Restart Mysql button if you are on a Wamp server on Windows).

Retry the installation by clicking on the “click here to restart” link in the Prestashop installation screen.

Has this how-to helped you ? Please share the blog with your friends on your preferred social media. Still can’t install it ? Leave a comment in the commentbox, with the error message you’ve received, and I’ll do my best to help you.


How to parse HTML files with apache / php7

TL;DR version: here’s how to parse HTML files with PHP hypertext preprocessor on apache 2.4x webserver, and PHP7 on linux

In PHP 7, the newest and ever more popular version of the PHP scripting language, the only files that are parsed by default are the ones that have .php, .phtml, or .php3/php4/php5 extensions. I don’t know who might still be using .php3, .php4 (never seen anyone use this one), or .php5 file extensions, but I’m sure many of you still usually use HTML files, and want to insert some PHP code into it.

Obviously, even though a lot of discussion is against the practice of parsing HTML files with PHP, you might still need this option. Regardless of whether you are a beginner or a pro in the art of website creation, scripting, web programming and alike, you still need to be able to parse files with the HTML or HTM extension, as PHP files, because integrating some PHP code into HTML and viceversa, it’s the easieast way to quickly test out something in a browser. So set aside the “best practices” pride for now, and just accept it as a fact that a lot of people still need this option 🙂

…click here to read the rest

EasySlider tutorial – how to create a slider and add it to a page in wordpress

A customer of mine has asked me on fiverr how she can create posts from sliders and add it to her pages, so instead of just writing a post about it, I created a small how-to video and uploaded it to youtube.

Here’s the clip, it could be useful for someone else, too, not just to my customer

…click here to read the rest

A great stress relief with a free game: HexGl

Once the work-week is over, most people can hardly wait to get home and unwind with some interesting pastime, a game, a good TV show, or just by hanging out with friends and family.

For those that would like to unwind with a free, online game, I suggest you give this new, free, HTML 5 version HexGL a try. It’s very easy to play, and it sure captures attention, the graphics is beautiful, both on smaller and larger screens, I’ve even tried it on 1440×900 large screen laptop, and it looks very nice.

…click here to read the rest

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

The site 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, if you have outgoing links, probably to verify if the outgoing links have real destinations or are just linkbaits. For a regular site, WITHOUT AFFILIATE connections, this probably won’t hurt anyone, but in the case of affiliate sites, regardless of affiliate programs, it’s a disaster.

…click here to read the rest