Jump to Navigation

Things I did not know about MySQL

Did you know that MySQL can join at most 61 tables in one query?

Did you know that table data is by default stored as latin1 with the  latin1_swedish_ci collation?

Things I did not know but should have - as I encountered both issues the same day.

Drupal profile_permissions

Sometimes you encounter a bug which makes you... not so happy.

On the Unquendor site, which is still Drupal 6, I use profile fields extensively. These are basically attributes of users. Not only names and addresses, but also things like visits to events and even a member's payment status is kept in this way. Of course, not everyone is allowed to see all fields, let alone edit them. The profile permissions module should enforce the proper policies.

Drupal project part two

Previously, I complained about the instability of the Drupal project module. The last days, I have been working on and off to analyze where the problems are and to solve some of them. It is now possible to see the list of releases on the project page and most pages do not return errors anymore.

VPN woes

Yet another random wifi network to connect to - this time in a small cottage in Slovenia. It actually allows access to internet, allows me to setup a VPN, so all seems well. Except for one little thingie: for some reason, it blocks outgoing SMTP traffic.

Well, no problem, there. I want to mail from my laptop, and it delivers to the mail server on my server. No problem there, if I route the traffic through the VPN, right? Wrong. After setting up the VPN it is still not working.

Wireless access point

My wireless access point at home is actually a Realtek 2500 wireless card on my server. I use my server as the place to put access policies and as a broker for all traffic (my public IP address is also on it, instead of on the modem in front of it).

Drupal project

I have added the Drupal module project to this website. This should make it easy to host your own software on Drupal. The Drupal site itself is using it, or at least it claims so. Regrettably, there is only an unstable release, and that is now more than a year old. I got it kind of working with the latest git version - but there is no CVS integration, the attached view that should list available releases does not seem to work and it regularly gives errors.


Subscribe to frodo.looijaard.name RSS

by Dr. Radut