Add this blog to Del.icio.us, Digg or Furl | Create Watchlist for this blog

Archive for July, 2007

Espresso Machine for Take-Away

Tuesday, July 31st, 2007

Espresso MachineMy current favorite is a mini espresso (Italian coffee) machine. It comes with a typical can and a build in electro oven. It’s about 15 cm x 15 cm with 25 cm height and has everything to breed the Italian kind of coffee.

It is able to cook the coffee and keep it warm (not to long - or else it’s getting a bitter taste), so everything I need for long programming nights :-)

The manufacturer is called “Splendida”.

Related Entries Plugin with WP 2.2

Wednesday, July 18th, 2007

When I tried to install WASABI’s nice related entries plugin on my new Wordpress site geekland it failed with the following error:

#1214 - The used table type doesn’t support FULLTEXT indexes

I am not sure if this is WP2.2 related - in the schema creation source I found no difference to 2.1 in the posts table - but I never had that problem with 2.1.

The solution is to convert the wp_posts table to ISAM (MyISAM) by issuing

ALTER TABLE `wp_posts` ENGINE = MYISAM

and after that re-issue the installation script of WASABI what does not more than:

alter table wp_posts add fulltext post_related (post_name, post_content)

Well, on my development system, the WP2.2 database was created in InnoDB format. and InnoDB does not support fulltext-search columns.
That’s all.

My First Drupal Site

Monday, July 9th, 2007

Yesterday I launched my first Drupal project in alpha state.

It’s a project for a customer in the real-estate business and I selected Drupal as CMS because of it’s very well selection of extension modules and - sure - for it’s perfect team editing features.
Drupal is, like Plone, in the leading Tools area for high-end websites with dynamic content. A key-strength for my purpose was it’s possibility to assign different roles to editors with different tasks. So I can keep the power about i.e. the menu-structure but let a story writer do the business content.

Above these business reasons, I am glad to have my first PHP5 and MySQL 5 project now. All other projects I’m currently running are based on PHP4 and MySQL 4, so I hope to make new (good) experiences with this new versions. I have waited very long for triggers in MySQL - needed to do some projects in Oracle, just because of the availability of triggers. And I have heard a lot about the processing speed improvements of PHP5. Well, I am going forward…

Some links for CMS comparison:
Drupal vs. Plone
Wordpress vs. Drupal: here, hier (german) and here.