dimitris kalamaras

Just use the fabulous command REPLACE provided by mysql. The syntax goes like this: update database_table set table_column = replace (table_column, «oldstring», «newstring»); For instance, to replace all occurrences of «modules» inside the linuxformat.gr drupal db with «sites/all/modules» I typed in: update linuxformat_system set filename = replace (filename, «modules», «sites/all/modules»);

Filed under:
Open Source, Web development by dimitris

Name-based virtual hosting enables us to serve different domains from a single server. All we need is to add this line to /etc/apache2/sites-available/default: NameVirtualHost * The * specifies that Apache will serve requests for all IP addresses; optionally we can specify only a certain IP on the server. Next, we create a new for each [...]

Filed under:
Linux by dimitris

That is the lesson I have learned today. Despite my eagerness to update my N900 to Maemo 5 v10.2010, the software update tool kept giving me the following cryptic message: «not enough memory in target location« Wtf? The message was a surprise for me, since I thought the 32GB of my N900 would be more [...]

Filed under:
Hardware, Linux, Open Source by dimitris

Eleni’s pet project (and vehicle to experiment with social cooking), www.supersyntages.gr, has got a new theme. The new graphical theme, designed and implemented by yours truly, plays with the notion of recipe notes pinned on a corkboard. The frontpage ‘carousel’ is still the old one, but it somehow fitted nice.  I am not a designer [...]

Filed under:
Open Source by dimitris

Yeeeeeeeeeeah! I am now yet another proud Nokia N900 owner! This device runs Linux on an ARM Cortex 600MHz CPU, 1GB RAM and 32GB HDD, and it is more a portable computer than a mobile phone, thanks to its 3.5» touch screen (800×480 resolution) and the embedded keyboard. Right now, my N900 is still charging [...]

Filed under:
Linux, Open Source by dimitris