Archive for category Uncategorized

A single song

I’ve been working for maybe the third day when i’ve heard it on some Internet radio station. The song was performed by Mary Hopkin. It’s tracing back to 1920-ies, was banned up to 1950-ies. Anyway Wikipedia knows more about it.

Dude, i’m feeling to old for rock-n-roll ;)

“Дорогой длинною”, Сергей Зыков :

Read the rest of this entry »

Unknown column ‘tplname’ in ‘order clause’

Found an error when deploying GLPI plugin “Generic Objects Management” v 1.1.3 from https://forge.indepnet.net/projects/show/genericobject/

I could add and modify object types, but was unable to add objects. Clicking “Add” button did nothing.

Uh.

Switched GLPI to debug mode and found “SELECT * FROM `glpi_plugin_genericobject_…` WHERE is_template = ’1′ AND FK_entities=’0′ ORDER BY tplname 0.001 Unknown column ‘tplname’ in ‘order clause’ ” near the bottom.
Of course, the was no ‘tplname’ field in the DB.

A quick search in the sourse revealed:
the apropriate database is created when object’s type is created;
the function “plugin_genericobject_addTable($name)” resides in “inc/plugin_genericobject.objecttype.function.php”

$diff -u plugin_genericobject.objecttype.function.php.orig plugin_genericobject.objecttype.function.php

— plugin_genericobject.objecttype.function.php.orig 2009-12-21 00:01:19.000000000 +0200
+++ plugin_genericobject.objecttype.function.php 2009-12-21 00:06:34.000000000 +0200
@@ -251,6 +251,7 @@
`is_template` INT ( 1 ) NOT NULL DEFAULT 0,
`comments` TEXT NULL ,
`notes` TEXT NULL ,
+ `tplname` VARCHAR( 255 ) NULL ,
PRIMARY KEY ( `ID` )
) ENGINE = MYISAM COMMENT = ‘$name table’;”;

‘tplname’ field should be altered in “plugin_genericobject_enableTemplateManagement” function, but for some reason it isn’t.
That’s all.

The site was down. Why?

Actually, it wasn’t down. Just the information was not displayed.

The reason is simple – after a prolonged migration to Atom MoBo, data crash in one of physical discs, loss of some MySQL databases, a new WordPress installation was missing the theme i’ve used. So, quick edit in ‘options’ table, replacing ‘option_name’ ‘template’ and ‘stylesheet’ with walue ‘default’ made the trick.
As you see, the blog is up and running again.

It happens

Meet the Junior ;)

Junior

Junior

Why?

History is just what happens to us.
Now.

I hope this blog will be a cosy place to find some totally useless crap.

Publication in Informatica

More than a year to get this article published. Yet it should be rewritte to make it shorter…