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
Author Archive for: stefan
About Stefan Helander
I was born a nerd! As a child I was fond of fiddling with all kind of thechnical stuff, discovering how things work and often fixing them. As a 6 year old I fixed my grandmothers 220 volts wiring.
The interest in technical stuff grown even bigger in the teenage years where I got my amateur radio license and developed a keen interest in computers.
Today I am proud to be a nerd. It is a part of my profession.
To all of you nerds and geeks out there - remember that nerd is the new sexy! :)
Entries by Stefan Helander
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> […]
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 […]
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 […]
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 […]
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 […]
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 […]
When you are connected to the Internet through a network with limited bandwidth or restricted data plan it is desirable to reduce the data consumption. In this case, disabling iCloud sync is something you want to do. In Windows, you can easily mark a wifi network as limited by data plan and this will automatically […]
The WordPress plugin Mega Menu has the possibility to display a “down arrow” for a menu item where a submenu is available (i.e. the menu item has “children”). The problem was that the arrow was not displaying. It turned out it was a collission with the theme, Cherry Framework 4. In the settings of the […]
With Microsoft Windows 10 Fall Creators update many users have ran into problems updating becuase their computer was installed with a too small EFI partition (100 MB). I’d consider this a warranty issue with the computer supplier, becuase obviously the computer wasn’t Windows 10 ready. The problem is that the hardware supplier will happily take […]