Few drupal 6 backend(MySQL) query results

mysql> select n.title, n.nid, n.vid, tn.tid from node n inner join term_node tn on n.vid = tn.vid order by n.nid;

+--------------------------------------------------------------------------------------------------------------------+-----+-----+-----+
| title                                                                                                              | nid | vid | tid |
+--------------------------------------------------------------------------------------------------------------------+-----+-----+-----+
| Open Source tools                                                                                                  |   3 |   3 |  31 |
| Open Source tools                                                                                                  |   3 |   3 |  32 |
| Open Source tools                                                                                                  |   3 |   3 |  23 |
| Existentialism ...... way of living                                                                                |   4 |   4 |  33 |
| Existentialism ...... way of living                                                                                |   4 |   4 |  30 |
| Existentialism ...... way of living                                                                                |   4 |   4 |  22 |
| Entering and Exiting drupal                                                                                        |   5 |   5 |  29 |
| Entering and Exiting drupal                                                                                        |   5 |   5 |  25 |
| Not too much of indulgence....                                                                                     |   6 |   6 |  30 |
| Not too much of indulgence....                                                                                     |   6 |   6 |  22 |
| Not copyrighted.....  Sharing                                                                                      |   7 |   7 |  23 |
| Not copyrighted.....  Sharing                                                                                      |   7 |   7 |  30 |
| Unlimited task... Unleased                                                                                         |   8 |   8 |  29 |
| Unlimited task... Unleased                                                                                         |   8 |   8 |  25 |
| Some tweaking done in the aqua-harbour theme to get desired result                                                 |   9 |   9 |  25 |
| Some tweaking done in the aqua-harbour theme to get desired result                                                 |   9 |   9 |  29 |
| Some tweaking done in the aqua-harbour theme to get desired result                                                 |   9 |   9 |  34 |
| Having a wysiwyg editor - fckeditor                                                                                |  10 |  10 |  25 |
| Having a wysiwyg editor - fckeditor                                                                                |  10 |  10 |  29 |
| What to live for?                                                                                                  |  11 |  11 |  22 |
| What to live for?                                                                                                  |  11 |  11 |  30 |
| Learn as you go (vs) knowing before hand what you are going to do.....                                             |  12 |  12 |  25 |
| Learn as you go (vs) knowing before hand what you are going to do.....                                             |  12 |  12 |  29 |
| SEu (vs) SE                                                                                                        |  13 |  13 |  22 |
| SEu (vs) SE                                                                                                        |  13 |  13 |  30 |
| Education not just to earn bread and butter but in hard times how to control yourself...                           |  14 |  14 |  22 |
| Education not just to earn bread and butter but in hard times how to control yourself...                           |  14 |  14 |  30 |
| GNU/Linux - State of mind and related stuff                                                                        |  15 |  15 |  23 |
| GNU/Linux - State of mind and related stuff                                                                        |  15 |  15 |  30 |
| Front page for the site                                                                                            |  16 |  16 |  25 |
| Front page for the site                                                                                            |  16 |  16 |  29 |
| Burning the more than 700MB(<=800MB) data data in a 800MB CD                                                       |  17 |  17 |  35 |
| Burning the more than 700MB(<=800MB) data data in a 800MB CD                                                       |  17 |  17 |  36 |
| Burning the more than 700MB(<=800MB) data data in a 800MB CD                                                       |  17 |  17 |  22 |
| Take control of your emotions                                                                                      |  18 |  18 |  22 |
| Take control of your emotions                                                                                      |  18 |  18 |  30 |
| Fatal error: Allowed memory size of 16777216 bytes exhausted                                                       |  19 |  19 |  25 |
| Fatal error: Allowed memory size of 16777216 bytes exhausted                                                       |  19 |  19 |  29 |
| It's some drupal....                                                                                               |  20 |  20 |  25 |
| It's some drupal....                                                                                               |  20 |  20 |  29 |
| lets see the non-commentable blog works or not                                                                     |  21 |  21 |  25 |
| lets see the non-commentable blog works or not                                                                     |  21 |  21 |  29 |
| With google at your disposal Who need friend(s)                                                                    |  22 |  22 |  38 |
| With google at your disposal Who need friend(s)                                                                    |  22 |  22 |  22 |
| With google at your disposal Who need friend(s)                                                                    |  22 |  22 |  30 |
| Thanx to closed source movement to appreciate the open source culture                                              |  23 |  23 |  23 |
| Thanx to closed source movement to appreciate the open source culture                                              |  23 |  23 |  38 |
| Thanx to closed source movement to appreciate the open source culture                                              |  23 |  23 |  30 |
| Wonder why the the new headphones have longer right side wire than the left                                        |  24 |  24 |  38 |
| Wonder why the the new headphones have longer right side wire than the left                                        |  24 |  24 |  22 |
| Filmy version of the Open source mania                                                                             |  25 |  25 |  23 |
| Filmy version of the Open source mania                                                                             |  25 |  25 |  38 |
| Ever wondered how to check the installation date of linux                                                          |  27 |  27 |  24 |
| Ever wondered how to check the installation date of linux                                                          |  27 |  27 |  28 |
| What's important in the arena of FLOSS                                                                             |  29 |  29 |  23 |
| What's important in the arena of FLOSS                                                                             |  29 |  29 |  30 |
| fancy domain names - third level domain names                                                                      |  30 |  30 |  25 |
| fancy domain names - third level domain names                                                                      |  30 |  30 |  39 |
| fancy domain names - third level domain names                                                                      |  30 |  30 |  40 |
| Hierarchical representation of Taxonomy and pathauto                                                               |  32 |  32 |  25 |
| Hierarchical representation of Taxonomy and pathauto                                                               |  32 |  32 |  29 |
| Applying patch to drupal module manually                                                                           |  33 |  33 |  25 |
| Applying patch to drupal module manually                                                                           |  33 |  33 |  29 |
| virtual space of my own                                                                                            |  45 |  45 |  25 |
| virtual space of my own                                                                                            |  45 |  45 |  39 |
| Whoami revisited                                                                                                   |  46 |  46 |  22 |
| Whoami revisited                                                                                                   |  46 |  46 |  30 |
| LIving ForEver - LIFE                                                                                              |  47 |  47 |  38 |
| LIving ForEver - LIFE                                                                                              |  47 |  47 |  22 |
| LIving ForEver - LIFE                                                                                              |  47 |  47 |  30 |
| Other day involved in changing the port of apache                                                                  |  48 |  48 |  24 |
| Other day involved in changing the port of apache                                                                  |  48 |  48 |  41 |
| Grouping and Aggregation capability introduced in views2 of drupal                                                 |  85 |  85 |  25 |
| Grouping and Aggregation capability introduced in views2 of drupal                                                 |  85 |  85 |  29 |
| Testing how the hierarchy is working for the dynamic entry of the tag                                              |  87 |  87 |  25 |
| Testing how the hierarchy is working for the dynamic entry of the tag                                              |  87 |  87 |  29 |
| CKEditor and image uploading feature                                                                               |  89 |  89 |  42 |
| CKEditor and image uploading feature                                                                               |  89 |  89 |  25 |
| CKEditor and image uploading feature                                                                               |  89 |  89 |  29 |
| Bps vs bps                                                                                                         |  90 |  90 |  43 |
| Bps vs bps                                                                                                         |  90 |  90 |  44 |
| Bps vs bps                                                                                                         |  90 |  90 |  24 |
| javascript in drupal                                                                                               |  91 |  91 |  45 |
| javascript in drupal                                                                                               |  91 |  91 |  24 |
| javascript in drupal                                                                                               |  91 |  91 |  29 |
| Jujibuji's of webhosting                                                                                           |  92 |  92 |  29 |
| Jujibuji's of webhosting                                                                                           |  92 |  92 |  46 |
| Jujibuji's of webhosting                                                                                           |  92 |  92 |  24 |
| Jujibuji's of webhosting                                                                                           |  92 |  92 |  39 |
| Removing the title and breadcrumb and disabling the menu in the front-page, removing drupal default footer img     |  94 |  94 |  29 |
| Removing the title and breadcrumb and disabling the menu in the front-page, removing drupal default footer img     |  94 |  94 |  24 |
| how to build testsite on localhost - multisite                                                                     |  95 |  95 |  29 |
| how to build testsite on localhost - multisite                                                                     |  95 |  95 |  47 |
| how to build testsite on localhost - multisite                                                                     |  95 |  95 |  48 |
| how to build testsite on localhost - multisite                                                                     |  95 |  95 |  24 |
| using virtualization of target machine for development assistance - userland guy exploring the land and beyond - I |  96 |  96 |  28 |
| using virtualization of target machine for development assistance - userland guy exploring the land and beyond - I |  96 |  96 |  49 |
| using virtualization of target machine for development assistance - userland guy exploring the land and beyond - I |  96 |  96 |  50 |
| using virtualization of target machine for development assistance - userland guy exploring the land and beyond - I |  96 |  96 |  51 |
| using virtualization of target machine for development assistance - userland guy exploring the land and beyond - I |  96 |  96 |  26 |
| Idiosyncrasies - mode of life                                                                                      |  97 |  97 |  52 |
| Idiosyncrasies - mode of life                                                                                      |  97 |  97 |  53 |
| Idiosyncrasies - mode of life                                                                                      |  97 |  97 |  55 |
| Idiosyncrasies - mode of life                                                                                      |  97 |  97 |  22 |
| Journey from customizable software to hardware - Introspective analysis -> Read                                    |  98 |  98 |  56 |
| Journey from customizable software to hardware - Introspective analysis -> Read                                    |  98 |  98 |  57 |
| Journey from customizable software to hardware - Introspective analysis -> Read                                    |  98 |  98 |  22 |
| picasa-album                                                                                                       |  99 |  99 |  22 |
| picasa-album                                                                                                       |  99 |  99 |  58 |
+--------------------------------------------------------------------------------------------------------------------+-----+-----+-----+
109 rows in set (0.01 sec)

mysql> select td.vid, td.name, td.tid  from term_data td inner join vocabulary v on td.vid = v.vid and v.name = "Filed in";

+-----+---------+-----+
| vid | name    | tid |
+-----+---------+-----+
|   5 | admin   |  24 |
|   5 | archive |  22 |
|   5 | dev     |  26 |
|   5 | foss    |  23 |
|   5 | web     |  25 |
+-----+---------+-----+
5 rows in set (0.00 sec)

mysql> select nid, vid, tid from term_node order by nid;

+-----+-----+-----+
| nid | vid | tid |
+-----+-----+-----+
|   3 |   3 |  31 |
|   3 |   3 |  23 |
|   3 |   3 |  32 |
|   4 |   4 |  33 |
|   4 |   4 |  30 |
|   4 |   4 |  22 |
|   5 |   5 |  29 |
|   5 |   5 |  25 |
|   6 |   6 |  22 |
|   6 |   6 |  30 |
|   7 |   7 |  23 |
|   7 |   7 |  30 |
|   8 |   8 |  29 |
|   8 |   8 |  25 |
|   9 |   9 |  25 |
|   9 |   9 |  34 |
|   9 |   9 |  29 |
|  10 |  10 |  25 |
|  10 |  10 |  29 |
|  11 |  11 |  22 |
|  11 |  11 |  30 |
|  12 |  12 |  29 |
|  12 |  12 |  25 |
|  13 |  13 |  30 |
|  13 |  13 |  22 |
|  14 |  14 |  30 |
|  14 |  14 |  22 |
|  15 |  15 |  23 |
|  15 |  15 |  30 |
|  16 |  16 |  29 |
|  16 |  16 |  25 |
|  17 |  17 |  35 |
|  17 |  17 |  36 |
|  17 |  17 |  22 |
|  18 |  18 |  22 |
|  18 |  18 |  30 |
|  19 |  19 |  25 |
|  19 |  19 |  29 |
|  20 |  20 |  29 |
|  20 |  20 |  25 |
|  21 |  21 |  29 |
|  21 |  21 |  25 |
|  22 |  22 |  38 |
|  22 |  22 |  22 |
|  22 |  22 |  30 |
|  23 |  23 |  30 |
|  23 |  23 |  38 |
|  23 |  23 |  23 |
|  24 |  24 |  38 |
|  24 |  24 |  22 |
|  25 |  25 |  38 |
|  25 |  25 |  23 |
|  27 |  27 |  24 |
|  27 |  27 |  28 |
|  29 |  29 |  30 |
|  29 |  29 |  23 |
|  30 |  30 |  25 |
|  30 |  30 |  39 |
|  30 |  30 |  40 |
|  32 |  32 |  25 |
|  32 |  32 |  29 |
|  33 |  33 |  29 |
|  33 |  33 |  25 |
|  45 |  45 |  39 |
|  45 |  45 |  25 |
|  46 |  46 |  22 |
|  46 |  46 |  30 |
|  47 |  47 |  30 |
|  47 |  47 |  38 |
|  47 |  47 |  22 |
|  48 |  48 |  41 |
|  48 |  48 |  24 |
|  85 |  85 |  29 |
|  85 |  85 |  25 |
|  87 |  87 |  25 |
|  87 |  87 |  29 |
|  89 |  89 |  25 |
|  89 |  89 |  29 |
|  89 |  89 |  42 |
|  90 |  90 |  24 |
|  90 |  90 |  44 |
|  90 |  90 |  43 |
|  91 |  91 |  29 |
|  91 |  91 |  45 |
|  91 |  91 |  24 |
|  92 |  92 |  39 |
|  92 |  92 |  29 |
|  92 |  92 |  46 |
|  92 |  92 |  24 |
|  94 |  94 |  29 |
|  94 |  94 |  24 |
|  95 |  95 |  24 |
|  95 |  95 |  48 |
|  95 |  95 |  47 |
|  95 |  95 |  29 |
|  96 |  96 |  26 |
|  96 |  96 |  51 |
|  96 |  96 |  28 |
|  96 |  96 |  50 |
|  96 |  96 |  49 |
|  97 |  97 |  55 |
|  97 |  97 |  52 |
|  97 |  97 |  53 |
|  97 |  97 |  22 |
|  98 |  98 |  22 |
|  98 |  98 |  56 |
|  98 |  98 |  57 |
|  99 |  99 |  22 |
|  99 |  99 |  58 |
+-----+-----+-----+
109 rows in set (0.00 sec)

mysql> select t.name,t.vid, t.tid from term_data t, vocabulary v where t.vid = v.vid;

+-----------------+-----+-----+
| name            | vid | tid |
+-----------------+-----+-----+
| admin           |   1 |  37 |
| agnostic        |   1 |  54 |
| anti-agnostic   |   1 |  55 |
| apache          |   1 |  41 |
| arm             |   1 |  49 |
| broadband       |   1 |  43 |
| burner          |   1 |  36 |
| ckeditor        |   1 |  42 |
| domain name     |   1 |  40 |
| drupal          |   1 |  29 |
| existential     |   1 |  33 |
| fun             |   1 |  32 |
| htaccess        |   1 |  47 |
| intro           |   1 |  57 |
| javascript      |   1 |  45 |
| lame            |   1 |  31 |
| life            |   1 |  52 |
| linux           |   1 |  28 |
| Msoft           |   1 |  35 |
| musik           |   1 |  58 |
| random thoughts |   1 |  30 |
| rant            |   1 |  38 |
| read            |   1 |  56 |
| RewriteEngine   |   1 |  48 |
| speed           |   1 |  44 |
| style           |   1 |  53 |
| theme           |   1 |  34 |
| ubuntu          |   1 |  27 |
| virtualization  |   1 |  51 |
| web hosting     |   1 |  39 |
| WHM             |   1 |  46 |
| x86             |   1 |  50 |
| admin           |   5 |  24 |
| archive         |   5 |  22 |
| dev             |   5 |  26 |
| foss            |   5 |  23 |
| web             |   5 |  25 |
+-----------------+-----+-----+
37 rows in set (0.00 sec)

END

Hosting Co. Upgrade and causality

In the shared hosting environment the hosting providers upgrade the platform/features/environment which will cause certain unexpected behavior(s) as the screen-shot(s) which showed that certain function were deprecated due to upgrading of php to what the hosting company found fit.

a) In the home page the following msg was displayed

"Function ereg() is deprecated in /home/gnum****/public_html/includes/file.inc on line 895"

In the file file.inc the ereg is replaced with preg_match
- elseif ($depth >= $min_depth && ereg($mask, $file)) {
+ elseif ($depth >= $min_depth && preg_match("/$mask/", $file)) {

b) In the qchronicle page a warning msg similar to
"Warning: strtotime()[fuction.strtotime]: It is not safe to rely on the system's timezone settings. You are "required" to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Europe/London' for 'BST/1.0/DST' instead in /home/gnum****/public_html/sites/all/modules/views/modules/node/views_handler_argument_dates_various.inc on line 66"

The following warning regarding date/time was displayed which was resolved by appending the
date_default_timezone_set('Europe/London');
at the top of bootstrap.inc file

<u-09-08-2012>
when edit tab is selected in the drupal's blog section, following msg is displayed
: Function eregi_replace() is deprecated in /home/gnumeno/public_html/sites/all/themes/basic/template.php on line 46.
- $body_classes[] = 'tax-' . eregi_replace('[^a-z0-9]', '-', $term->name);
+ $body_classes[] = 'tax-' . preg_replace('/[^a-z0-9]/', '-', $term->name);
 </u-09-08-2012>

librelab.gnumen.org ---> rev 0.01

 
Creating an impression is not a priority here (as is seen)

The UI has been changed from a single and simple GTA02 device to a more muddled/messier front page which is a sketch form of devices (and its byproduct) lying around the desktop(if it falls in that group). The mere intention of such an approach is not to entice others with a color display rather giving a black and white impression of what its all about and what it gets involved with. Though lot of work is yet to be done hopefully will implement what is needed. Felt better to display the whole scenario which makes the mobile device(gta02) important. Its not a standalone rather most work involves the IA32 machine which deserves mentioning and this is how I felt is/was right. The Idea is to change the image of respective device on mouse hover as well as display the config of device in a tooltip. This is mostly done for and on firefox. Don't have time to do the adaptation work for other browsers.

I made use of PS for slicing and saved it in html format. Vala!!! I don't have to create a table it does for you.
The overlapped text in the tooltip was rectified by specifying the line height , setting it equal to the font size for #tooltip

adding
background: white none repeat scroll 0% 0%; height: 0px; line-height: 0px; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;
for table td messes up with the default drupal settings so add it to table#Table_01 td

Tested on firefox: 3.0.11 and everything is working as expected.

librelab.gnumen.org = E

librelab.gnumen.org is no more hypothetical, could have registered a domain name with any preferred tld like librelab.org/.net/.com u name it. But wanted it to be a part of gnumen and what better than to have a subdomain based site which even google webmaster tool considers as another site hence having total control over the two different site which of course is under one name(gnumen.org). With cpanel at our disposal it's a cake walk to create a subdomain. I wanted it to be multisite but to my disappointment after trying it on my testbed which required emulating the real time setup of a webhosting co when tried to create one in public domain it failed :( thought of enforcing it using the shell account even that was denied.. they say "its out of security reasons".

Libre - the name is also a latin word, neologism .. I hope I am not getting obessed with romantic language.

[EDIT]
Finally decided on registering a domain name librelab.org - Created On:26-Sep-2012 - can be found using whois or http://whois.domaintools.com/librelab.org
[/EDIT]