Object Oriented Code Generator for PHP-MySQL Web Applications

November 12th, 2007 We are having 2-3 reports of users seeing warnings (not error) using Translator Pro with the latest version of WordPress while posting a comment or publishing a post: Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in .../wp-content/plugins/translator/translator.php(15) : eval()'d code on line 1080 Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in .../wp-content/plugins/translator/translator.php(15) : eval()'d code on line 1080 Warning: Cannot modify header information - headers already sent by (output started at .../wp-content/plugins/translator/translator.php(15) : eval()'d code:1080) in .../wp-includes/pluggable.php on line 391 Paul Hartrick, one of our valued client, discovered that this was caused by Arne Branchold's XML Sitemap generator plugin. You can fix this issue by activating MySQL standard mode for XML Sitemaps plugin.

June 27th, 2008 Arne Brachold's popular XML Sitemap generator plugin for WordPress may report fewer URL than that exists on your website. This in turn means less URL's which you are submitting to search engines for indexing.

November 25th, 2008 The MySQL Query Analyzer tool monitors query performance and quickly pinpoints and corrects problems in SQL code. It promises to "turbo-boost" the speed and uptime of MySQL database applications.

September 1st, 2007 Working with replication systems is not easy. Learning and testing different kind of MySQL replications and fine-tuning it to your specific needs is a time-consuming endeavor.

November 16th, 2007 When you try MySQL master-master replication with two (or more) servers you may often find that in the process of configuring the original master to also act as a slave server (start slave), it fails with the following error: mysql> start slave; ERROR 1200 (HY000): The server is not configured as slave; fix in config file or with CHANGE MASTER TO To rectify it locate and delete the master.info file and restart the mysql server. Now try to start slave and it should work.

August 15th, 2007 I glanced over the Facebook source code for both index and search pages. As an enterprise developer of some experience, source code is always interesting to me as it provides an insight into the health of a company.

May 13th, 2005 Note: My WordPress database name is wordpress. I will use it in the example below.

November 18th, 2007 This is how you create an infinite loop in bash to run a piece of code perpetually at pre-defined intervals. #!/bin/bash while [ 1 ] do # Your code goes here # Modify sleep time (in seconds) as needed below sleep 2 done For example I used this code to write a bash script to monitor long running mysql queries.

April 20th, 2008 Let's look at all the ways to change MySQL password, for root and other users: In MySQL the default password is empty. This is inherently unsafe and should be immediately changed.

July 13th, 2007 This is a very interesting presentation (see below) on the technologies used to make Digg, the challenges faced along the way and how they overcame it. I would recommend it to any Web 2.0 startup architects.

July 20th, 2007 What is auto reconnect in MySQL? The MySQL client library can perform an automatic reconnect to the server if it finds that the connection is down when you attempt to send a statement to the server to be executed. In this case, the library tries once to reconnect to the server and send the statement again.

April 18th, 2008 I am serious. While MySQL is a great open source database, I have full respect to Sun's plan to provide high-end features for paying customers only.

November 27th, 2007 To delete duplicates from a MySQL database table I normally copy the duplicate data first to a temporary table and then use the copied id's to delete from the original table. Delete using the temporary can take two forms.

November 23rd, 2007 In MySQL you can use the GRANT statement to create users and assign privileges to them at the same time. It is extremely convenient and beats create user or directly hacking the mysql.user table.

November 18th, 2007 Monitoring MySQL queries is a favorite pastime of MySQL administrators especially for performance reasons. Here is a simple bash script to monitor long running MySQL queries in realtime using the ubiquitous 'show processlist'.