Len Len's personal site: work, cooking, cycling, experiences

It seems that self-pings are bad for Google page ranking. Well, I have never spended too much time thinking about SEO but I find them a bit clutering and thus I’ve decided to remove them. There are some plugins which block new self-pings but none which deletes the existing ones. So here is a mysql command which does just that:

Warning: don’t execute sql commands on your db if you don’t know anything about what sql is, it might ruin your base.

SELECT count(*) FROM {prefix}_comments WHERE comment_type = 'pingback' AND
    locate((SELECT option_value FROM {prefix}_options WHERE option_name = 'siteurl'), comment_author_url) = 1;
DELETE FROM {prefix}_comments WHERE comment_type = 'pingback' AND
    locate((SELECT option_value FROM {prefix}_options WHERE option_name = 'siteurl'), comment_author_url) = 1;

Replace the {prefix} with your db tables prefix.

One week ago I migrated my personal site/blog from Plone to WordPress. As such I’ve decided to write a small comparison of the 2 systems.

Let’s pun things in my context. A few years ago I’ve worked on a custom CMS implementation. The goal was to develop a product targeted for accesibility and simplicity of use. And, as it was the golden age it was decided to implement it from scratch using java. If you are wondering, the project is still used today but it was not possible to evolve as fast as the opensource projects and it lacks most of the sparkling features of today CMS systems.

(more…)

The task ahead was to migrate my old plone based blog/site to a wordpress site. Here was a short list of items to keep in mind:

• plone import content (normal content ~ 600 entries, special:ContentPanels)
• keep old links still valid including RSS !?
• handle relative links in posts
• handle google (sitemap, adwords, analytics)
• design (find theme, modify css, logo/photo, php part)
• others (the photos, favicon, 404 page, pre style for code snippets)

(more…)

Len.ro new generation. Ma tot gandesc de ceva timp sa migrez len.ro fie intr-o versiune noua de plone fie in wordpress. M-am decis sa aleg a doua varianta si sa merg pe wordpress. Asa ca vineri dimineata cum oricum nu puteam sa dorm mi-am facut clasicul todo si m-am apucat de munca distractie. Rezultatul e ce vedeti. Revin cu detalii tehnice in curand. Am reusit migrez aproape tot continutul si linkurile (sper). Vechiul len.ro inca mai e accesibil la old.len.ro.