Older web projects (but not only) tend to have various abandoned folders including, old backups, database dumps and legacy code publically available. A detailed OWSAP guideline. It’s crucial to keep anything private outside of the public_html folder (or equivalent). Some bots scan the website and index such vulnerability. Hackers will get notified about an easy… Continue reading Web folder housekeeping
Category: Uncategorized
ERROR 1709. The maximum column size is 767 bytes
I stumbled upon this issue when importing a large MySQL WordPress WooCommerce database. The solution I found was to check the exact version of the database through phpMyAdmin (or SSH). In my case, it was version 5.7. Use the same version in the local environment in Docker. Strangely, using a newer version also fails the… Continue reading ERROR 1709. The maximum column size is 767 bytes
Update ACF field on all posts programmatically
The script below fetches all posts of type “tribe_events”.Then, it goes through the post instances and updates the ACF field. You need to be careful with it as you can override some fields. The script needs to run only once. Back-up the db before. When creating a new ACF field all the posts need to… Continue reading Update ACF field on all posts programmatically
Installing Composer and Drush on a shared hosting
A number of shared web hosting providers give you access to the server via SSH. Quite often the SSH commands are limited for security reasons – it’s a shared hosting after all. To install Composer: (https://docs.drush.org/en/master/install/) Place the file at the same location as composer.json and run php composer.phar install To install Drush: (https://github.com/drush-ops/drush-launcher) Place… Continue reading Installing Composer and Drush on a shared hosting
Go top button with Scrollmagic
WordPress localhost xampp “Object not found!” issue fix
The homepage usually works fine, however child pages throw an error. Normally this is a problem caused by .htaccess file settings. In order to fix it go to https://wordpress.org/support/article/htaccess/ and copy the defaults (remember not to commit the changes to the live website once you’re done local development). Then go to /wp-login.php and log in… Continue reading WordPress localhost xampp “Object not found!” issue fix
AIB GDPR, requesting personal data from an Irish bank
Since the EU introduced GDPR policy I decided to request my personal data from my bank. Out of curiosity, I wanted to investigate a little what type of information is stored about me. I requested the data using AIB’s online banking account. The process was quite straightforward. After 2 weeks or so I received a… Continue reading AIB GDPR, requesting personal data from an Irish bank
Project management – medium and large websites
Introduction We have recently launched a large Drupal 8 Web system. The purpose of this article is to review and reflect on the workflow. Firstly, I’ll identify the problems encountered, then I’ll continue with their evaluation. Challenges Gathering the requirements and understanding the business logic. Communicating with the client. Graphic design. Prototyping and development. Solutions… Continue reading Project management – medium and large websites
Entering Bolivia without passport entry stamp
When exiting Argentina and entering Bolivia on La Quiaca/Villazón border I didn’t get the entry stamp on Bolivian side. That’s because the two countries have some type of tourism agreement. So technically Argentina grants you permission to enter Bolivia. It confused me especially because my Spanish is quite basic. I got 30 days tourist visa.… Continue reading Entering Bolivia without passport entry stamp