Reparo WordPress MySQL Comment Table…Why?

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

May 12th, 2007 Mantis is popular php based defect tracking application which works on top of RDBMS like MySQL and PostgreSQL. Recently I ported our Windows based Mantis installation to Linux.

November 30th, 2007 I like to say that Comment Guard Pro will be the final plugin you will ever need for WordPress comment spam protection. It contains 18 pluglets for protecting you from comment spam, an open API for you to write your own pluglets, detailed live statistics (AJAX updated) and more.

August 23rd, 2007 I was watching the mysql queries using mytop just before our server went down. In a flash I realized the cause of our persistent server load problem.

January 30th, 2008 Type the following as a WordPress comment and see the fun: <a href="http://www.google.com/" rel="nofollow">This is www.yahoo.com link</a> This should ideally cause the whole phrase (This is www.yahoo.com link) to be hyperlinked and pointing to google.com. Unfortunately WordPress sees it as two links and a plain word: "This is" is hyperlinked to www.google.com "www.yahoo.com" is hyperlinked to www.yahoo.com "link" is not hyperlinked at all Did you read about the other hyperlinking defect?

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.

April 27th, 2009 Suppose you want to change and enable the remote access to MySQL DB on your linux server (Debian). By default, you don't get such privileges so you will have to work your way through this.

January 17th, 2009 MySQL stores usernames and passwords in the user table inside the MySQL database. You can directly update a password using the following method to update or change passwords: 1) Login to the MySQL server, type the following command at the shell prompt: $ mysql -u root -p 2) Use the mysql database (type commands at the mysql> prompt): mysql> use mysql; 3) Change password for a user: mysql> update user set password=PASSWORD("newpass") where User='YOUR-USER-NAME'; 4) Reload privileges: mysql> flush privileges; mysql> quit [P.S.

December 24th, 2004 My recipe for getting rid of comment spam once and for all: Install WordPress 1.2.1 or later. Install ImageAuth hack Go to Options Tab.

April 26th, 2009 A comforting day indeed. Matt Mullenweg is the author of the popular blogging software , WordPress.

May 15th, 2006 We are doing extensive work with WordPress, developing plugins, themes and also modifying the code base where necessary. In the process I found it necessary to create a online cross-reference of WordPress source along with capability to annotate / comment (AJAX based) as necessary.

January 24th, 2007 WordPress, a popular blogging software, has released version 2.1 with many exciting features and over 550 bug fixes. The key features are: Autosaving of posts - It has incorporated the features of tw_autosave plugin in the core.

December 4th, 2008 Wordpress Notifier is a freeware application that alerts you when new unapproved comments are posted on your Wordpress blog. I have seen successful admins from internationally popular blogs and believe me its some time too hectic to refresh the page every minute so that you don't miss out on an imporntant comment.

January 17th, 2009 Do you want to recover the MySQL root password. its by no means, easy.

May 5th, 2006 Many of my posts have multiple pages. WordPress today doesn't provide a visible way to add multiple pages to your (single) article / post.