Category Archives: MySQL

Changes in phpMyAdmin 3.0

phpMyAdmin, the popular front-end to the MySQL database, has issued the first stable release of the version 3.0 series. The basic functionality remains unchanged, but there are some important differences. To begin with, phpMyAdmin 3.0 requires a minimum of PHP … Continue reading

Posted in Books, MySQL, phpMyAdmin | 44 Comments

Adobe releases PHP hotfix for Dreamweaver 8.0.2

At long last, Adobe has released a hotfix for a number of serious issues affecting the PHP MySQL server model in Dreamweaver 8.0.2. Unfortunately, you can’t just go to the Adobe site and download it. You need to contact Adobe … Continue reading

Posted in Books, Dreamweaver, MySQL, PHP | 17 Comments

DATE_FORMAT() problem was with my data, not 8.0.2 updater

When the Dreamweaver 8.0.2 updater came out, I originally reported that it mishandles the MySQL DATE_FORMAT() function in the Test SQL Statement panel. After further testing, and some help from Alexandru Costin of InterAKT, I’ve discovered the problem was with … Continue reading

Posted in Dreamweaver, MySQL | 4 Comments

Confusing changes in phpMyAdmin

I love phpMyAdmin as a quick, easy-to-learn front-end for MySQL, but it’s just broken a cardinal rule of updates by making two changes to the installation procedure in the space of three months. In principle, the changes are well-intentioned. Instead … Continue reading

Posted in phpMyAdmin | 23 Comments

MySQL strict mode problems

Simon Collison does such a good sales patter for ExpressionEngine in Blog Design Solutions that I decided to try it out. Things looked even brighter than his description when I disovered that not only has the price for the non-commercial … Continue reading

Posted in Books, MySQL | 16 Comments