Tag Archives: database

Disqus Plugin Aftermath: Removing Duplicate Comments

Posted on 30.01.2009 by Stephanie Booth

[fr]Comment se débarrasser de 5000 commentaires à double dans sa base de données WordPress![en]Now that Disqus integrates Friendfeed comments, I could be tempted to give it another try, if I hadn’t spent an hour yesterday cleaning up my database because … Continue reading →

Posted in Social Media and the Web, Wordpress | Tagged comments, database, disqus, duplicate, friendfeed, Geek / Technical, instructions, Kit du blogueur, phpmyadmin, Practical, user/07467067922840649993/state/com.google/read, Weblog Technology, Wordpress | 1 Comment

Invalid argument supplied for foreach() in wp-capabilities.php: Case Cracked!

Posted on 29.01.2007 by Stephanie Booth

[fr]Le problème avec wp-capabilities.php qui fait qu’on peut se retrouver “exfermé” (enfermé dehors) de son blog WordPress (typiquement en cas de changement de serveur) semble avoir sa source dans le contenu du champ wp_user_roles dans la table wp_options. En particulier, … Continue reading →

Posted in Wordpress | Tagged abonné, accent, admin, character, database, dump, encoding, error, foreach, mysql, php, phpmyadmin, rights, role, server, transfer, user, utf-8, warning, Weblog Technology, Wordpress, wp-admin, wp-capabilities.php, wp-db.php, wp_options, wp_user_roles | 34 Comments

Finally out of MySQL encoding hell

Posted on 12.07.2006 by Stephanie Booth

[fr]Description de comment je me suis sortie des problèmes d’encodage qui résultaient en l’affichage de hiéroglyphes sur tous les sites hébergés sur mon serveur.[en]It took weeks, mainly because I was busy with a car accident and the end of school, … Continue reading →

Tagged Code and Markup, conversion, database, encodage, encoding, iso-8859-1, latin-1, mysql, problem, problème, python, rendering, script, utf-8, utf8, vim | 5 Comments

Fixing Newline Abuse in WordPress

Posted on 10.12.2004 by Stephanie Booth

Newlines had crept into some of my old posts and corrupted the formatting. Quick and dirty script I used to solve the problem.

Continue reading →

Tagged corrupt, database, extra, formatting, line break, newline, php, post, Real Live Code, script, Weblog Technology | Leave a comment

Scripts for a WordPress Weblog Farm

Posted on 02.09.2004 by Stephanie Booth

A first step to WordPress-farming: a shell script and a PHP script which allow you to easily install a whole lot of WordPress weblogs in only a few minutes (I installed over 30 in less than 5 minutes). Scripts require adapting to your environment, of course.

Continue reading →