18th
MAY
Posted by Lee under General
At 5:03pm last Friday afternoon whilst demoing a new site to a client I came to see the ever so lovely “too many connections” error from mySQL (or in the case of CodeIgniter - could not connect to database error). I knew what was going to hit me next, the calls from clients who are having problems as well accessing their websites - and sure enough about 5 minutes later they started to come through so I just did a quick restart of mySQL and Apache which cleared the problem, but I wanted to work out how to stop this from happening again.
Read the rest of this entry »
8th
MAY
Posted by Lee under Programming
No I wasn’t late for a meeting due to differing timezones, but it is official I hate dealing with timezones - infact it was from the first day I had to do any programming related to timezones that I hated working with them.
A lot of these problems stem from building websites (more specifically our Breeze CMS) that need to cater for visitors that can visit from different timezones and need to see data being shown in their current time. You can also face issues if your hosting provider is located outside of your timezone. But not to worry - we have come up with some solutions to these problems as I have spent forever trying to get my head around the issues we have faced.
Read the rest of this entry »
7th
MAY
Posted by David under CodeIgniter Libraries
We needed a class that would retrieve a block of data with parent/child relationships from mySQL and store it in an array which correctly represents the three dimensional nature of the parent/child relationships. The class needed to also have methods for add, deleting and moving entries within and between categories.
Read the rest of this entry »
