Tag Archives: mysql

Today is Backup Awareness Day!

[fr]Il y a deux mois, le 24 février, j’ai appuyé sur la mauvais bouton et effacé mon blog. Je ne savais pas de quand datait ma dernière sauvegarde. Tout est bien qui finit bien pour moi (mais ça n’a pas … Continue reading

Posted in Wordpress | Tagged accident, backing up, backup, backupawarenessday, black swan, computer, ctts, data, Events, mozy, mysql, security, time machine, website, Wordpress | 12 Comments

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

[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

Michael Hampton is My Hero of the Day

[fr]En principe, les problèmes de serveur sont résolus. Retour à la normale aussi vite que j’arrive à transférer les données avec la connection wifi très approximative que nous avons ici.[en]Michael Hampton, also known as io_error just saved my life today … Continue reading

Posted in Connected Life, Wordpress | Tagged conference, danahboyd, dreamhost, encoding, Events, Geek / Technical, leweb3, michaelhampton, mysql, Online Culture, paris, php, server, Weblog Technology, Wordpress | 6 Comments

Finally out of MySQL encoding hell

[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

Project With Technorati API

[fr]J’ai un projet de répertoire de blogs suisses construit sur Technorati. Je cherche un développeur pour la partie PHP/MySQL/TechnoratiAPI et un designer/graphiste pour l’interface web. C’est un projet non lucratif mais qui peut rapporter visibilité et célébrité à  ceux qui … Continue reading

Posted in Stuff that doesn't fit | Tagged Announcements, api, blogospherahelvetica, blogs, coding, designer, directory, geek, graphiste, liste, mysql, nonprofit, php, project, répertoire, swiss, Swiss blogging, swissblogs, swissblogs.com, switzerland, technorati, Wanted | 8 Comments

MediaWiki

I’ve installed MediaWiki. Explanation and solution of a bug I bumped into while installing (because of UTF-8 in MySQL 4.1.x) and comments on the method for interface translation.

Continue reading
Posted in Language Geekiness, Wordpress | Tagged Languages / Linguistics, localisation, localization, mediawiki, mysql, Software and Tools, tools, utf-8, wiki, Wordpress | 3 Comments

Problèmes d’encodage MySQL

Un joli mélange de latin-1 et d’utf-8 dans ma base de données. Un script python pour nettoyer tout ça.

Continue reading
Tagged encoding, latin-1, mysql, python, Real Live Code, scripts, Software and Tools, utf-8 | 11 Comments

Scripts for a WordPress Weblog Farm

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
Posted in Wordpress | Tagged automate, automatic, blog, blogs, Code and Markup, copy, database, edit, farm, farming, folder, htaccess, image, install, installer, link, lots, many, modify, multi-blog, multiblog, multiple, multiuser, muwordpress, mysql, php, script, server, shell, symbolic, user, weblog, Weblog Technology, Weblogs, Wordpress, wordpressmu, wp-farm | 64 Comments

Converting MySQL Database Contents to UTF-8

I finally managed to convert my WordPress database content to UTF-8. It’s easy to do, but it wasn’t easy to figure out.

Continue reading
Posted in Wordpress | Tagged command line, convert, database, encoding, error, iso-8859-1, latin-1, max_allowed_packet, mysql, Real Live Code, restart, utf-8, Weblog Technology, Wordpress | 95 Comments