Entries by Stefan Helander

How to convert a certificate PFX file to CRT/KEY using openssl



Your PFX certificate file is protected with a password. It can be converted to CRT and KEY files using SSL: openssl pkcs12 -in certfile.pfx -nocerts -out keyfile-encrypted.key When you enter this command you will be asked to type in the pfx file password in order to extract the key. You will be asked to enter […]

Anchor links does not scroll to the correct position



There are several issues that can cause local anchor links to not scroll to the right position. The first thing to check is if you have an id-tag that has the same name as the anchor. In this case the browser will scroll to the id position instead. The solution is to name the anchor […]

Gogodigital Cookie Consent plugin for Joomla! doesn’t display custom message [solution]



Using Gogodigital Cookie Consent plugin for Joomla! version 3.0.2. In the plugin configuration a custom message and submit label was entered and saved but on the frontend the popup only displays the built in message and button label. Solution: It turns out there is a bug when the message entered has a newline (return). If […]

MySQL not sorting swedish characters ÅÄÖ correct [solved]



Problem: When using ORDER BY or GROUP BY, the swedish characters Å,Ä and Ö is sorted as A and O. Solution: add COLLATE utf8_swedish_ci to your ORDER BY or GROUP BY, for example: SELECT field1,field2 FROM table1 ORDER BY field1 ASC should be changed to: SELECT field1,field2 FROM table1 ORDER BY field1 COLLATE utf8_swedish_ci ASC

RSForm! Pro and reCaptcha plugin not working [solved]



Using RSForm! Pro together with the RS!Form Pro reCaptcha plugin stopped working, the reCaptcha does not show up in the form anymore. Inspecting the page shows errors like “Unexpected token <” on line 2 and further down complains that RSFormProReCAPTCHAv2 is not defined. The Unexpected token error is probably caused by a line in the <head> […]

Error 500 after PrestaShop upgrade from 1.5 to 1.6



Upgrading a PrestaShop 1.5 to 1.6 resulted in Error 500 when visiting the shop frontend. During the upgrade I had selected to disable all non native modules, replace theme with default theme and updating all emails. I tried every trick in  the book, like cleaning the cache, disable all caching and compression, etc but it […]

Mac OSX “El Capitan” software update stuck on “11 minutes remaining”



When installing a software update for Mac OSX “El Capitan” that required a system reboot to install, it seemed stuck on the white screen displaying a text “Installing software update: About 11 minutes”. The solution was quite simple – just wait. It seems the time calculation is really off. After about an hour it stepped […]

Automatic SMS / text message to email forward



Sometimes my clients send me messages as SMS or “texts” on my mobile phone. That might be relevant for an urgent matter but often is being used instead of mail. From my clients view, they just see it as another, non-intrusive, way of sending me a message instead of calling which is polite as a […]

How to add GDPR consent checkbox to Joomla! contact form



It is quite simple to add a GDRP consent checkbox to the Joomla! contact form by using the custom fields feature in Joomla 3. Go to Components -> Contacts Click on Fields in the left hand menu Select Mail in the drop down above the fields list   Click on New to create a new […]

How to migrate Phoca Gallery from Joomla! 1.5 to 3



There are some guides on how to migrate Phoca Gallery from Joomla! 1.5 to 2.5 and from 2.5 to 3 but in my case I had a really old 1.5 site that was going to be migrated from Joomla! from version 1.5 to 3. The process is very similar to migrating 1.5 to 2.5. This […]