Joomla Installation Error regarding TYPE=MyISAM

In MySQL 5.5.x the *table_type_option* construct of *TYPE = * has been depreciated and replaced with *ENGINE =* so to fix this error replace keyword 'TYPE' with 'ENGINE' in all the files in /installation/sql/mysql.

For Example for table jos_banner
CREATE TABLE `#__banner` (
`bid` int(11) NOT NULL auto_increment,
`cid` int(11) NOT NULL default '0',
`type` varchar(30) NOT NULL default 'banner',
`name` varchar(255) NOT NULL default '',
`alias` varchar(255) NOT NULL default '',
`imptotal` int(11) NOT NULL default '0',
`impmade` int(11) NOT NULL default '0',
`clicks` int(11) NOT NULL default '0',
`imageurl` varchar(100) NOT NULL default '',
`clickurl` varchar(200) NOT NULL default '',
`date` datetime default NULL,
`showBanner` tinyint(1) NOT NULL default '0',
`checked_out` tinyint(1) NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`editor` varchar(50) default NULL,
`custombannercode` text,
`catid` INTEGER UNSIGNED NOT NULL DEFAULT 0,
`description` TEXT NOT NULL DEFAULT '',
`sticky` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
`ordering` INTEGER NOT NULL DEFAULT 0,
`publish_up` datetime NOT NULL default '0000-00-00 00:00:00',
`publish_down` datetime NOT NULL default '0000-00-00 00:00:00',
`tags` TEXT NOT NULL DEFAULT '',
`params` TEXT NOT NULL DEFAULT '',
PRIMARY KEY (`bid`),
KEY `viewbanner` (`showBanner`),
INDEX `idx_banner_catid`(`catid`)
) TYPE=MyISAM CHARACTER SET `utf8`;

Correct Syntax for this will be

CREATE TABLE `#__banner` (
`bid` int(11) NOT NULL auto_increment,
`cid` int(11) NOT NULL default '0',
`type` varchar(30) NOT NULL default 'banner',
`name` varchar(255) NOT NULL default '',
`alias` varchar(255) NOT NULL default '',
`imptotal` int(11) NOT NULL default '0',
`impmade` int(11) NOT NULL default '0',
`clicks` int(11) NOT NULL default '0',
`imageurl` varchar(100) NOT NULL default '',
`clickurl` varchar(200) NOT NULL default '',
`date` datetime default NULL,
`showBanner` tinyint(1) NOT NULL default '0',
`checked_out` tinyint(1) NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`editor` varchar(50) default NULL,
`custombannercode` text,
`catid` INTEGER UNSIGNED NOT NULL DEFAULT 0,
`description` TEXT NOT NULL DEFAULT '',
`sticky` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
`ordering` INTEGER NOT NULL DEFAULT 0,
`publish_up` datetime NOT NULL default '0000-00-00 00:00:00',
`publish_down` datetime NOT NULL default '0000-00-00 00:00:00',
`tags` TEXT NOT NULL DEFAULT '',
`params` TEXT NOT NULL DEFAULT '',
PRIMARY KEY (`bid`),
KEY `viewbanner` (`showBanner`),
INDEX `idx_banner_catid`(`catid`)
) ENGINE=MyISAM CHARACTER SET `utf8`;

Burning iso Images to Disk on Nero 9

I have been a great fan of Nero and using it since Nero 5.Till Nero 8 User Interface was look alike of previous versions but in Nero 9 there is a slight difference in the user Interface.

I was trying to Burn a Snow Leopard image to disk when I found that there was a slight change as there was no option like Burning Image directly to Disk.After a lot of Research I finally got the way out.

Here it is

1)Start Nero StartSmart Essentials

2)Go to Backup Tab on the top

3)Click Copy Disc

4)Another window opens

5)select "Image,Project,Copy" from the left hand side

6)Select "Disc Image or Saved Project" from right side frame

7)Select your Image File

8)Select your Drive

9)Click Burn..

That's It

Easy just a bit change in interface.

How ever I am still looking at the problem of selection of Fields in Cover Designer in this version?

IT after Narayan Murthy

On August 2011 Narayan Murthy will retire from the Infosys board.

He has given a lot to this industry.Industry would miss him a lot.

It's really hard to digest how industry would work without this great man.

Hat's off to the superb work done and his achievements in IT.