New Install Issues

After upgrading uddeIM, update your database tables (go to phpMyAdmin and enter following
SQL statements in the SQL box, this will create the missing fields).

When you upgrade 1.2 to 1.3:
none

When you upgrade 1.1 to 1.3:
ALTER TABLE `jos_uddeim` ADD INDEX `fromid` ( `fromid` ) ;
ALTER TABLE `jos_uddeim` CHANGE `expires` `expires` INT( 11 ) NOT NULL DEFAULT '0' ;
ALTER TABLE `jos_uddeim` ADD `flagged` int(1) NOT NULL default '0';
ALTER TABLE `jos_uddeim` ADD INDEX `archived_totrash_toid_datum` ( `archived`,`totrash`,`toid`,`datum` );
ALTER TABLE `jos_uddeim` ADD INDEX `toread_expires` ( `toread`,`expires` );
ALTER TABLE `jos_uddeim` DROP INDEX `totrashdateoutbox` , ADD INDEX `totrashdateoutbox_datum` ( `totrashdateoutbox` , `datum` );

When you upgrade 1.0 to 1.3:
ALTER TABLE `jos_uddeim` ADD INDEX `fromid` ( `fromid` ) ;
ALTER TABLE `jos_uddeim` CHANGE `expires` `expires` INT( 11 ) NOT NULL DEFAULT '0' ;
ALTER TABLE `jos_uddeim` ADD `flagged` int(1) NOT NULL default '0';
ALTER TABLE `jos_uddeim` ADD INDEX `archived_totrash_toid_datum` (`archived`,`totrash`,`toid`,`datum`);
ALTER TABLE `jos_uddeim` ADD INDEX `toread_expires` ( `toread`,`expires` );
ALTER TABLE `jos_uddeim` DROP INDEX `totrashdateoutbox` , ADD INDEX `totrashdateoutbox_datum` ( `totrashdateoutbox` , `datum` );

ALTER TABLE `jos_uddeim` ADD `publicname` TEXT ;
ALTER TABLE `jos_uddeim` ADD `publicemail` TEXT ;
ALTER TABLE `jos_uddeim_emn` ADD `public` INT( 1 ) DEFAULT '0' NOT NULL ;
ALTER TABLE `jos_uddeim_emn` ADD `lastsent` INT( 11 ) DEFAULT '0' NOT NULL ;
CREATE TABLE IF NOT EXISTS `jos_uddeim_userlists` (
`id` int(11) NOT NULL auto_increment,
`userid` int(11) NOT NULL default '0',
`name` varchar(40) NOT NULL default '',
`description` text NOT NULL,
`userids` text NOT NULL,
PRIMARY KEY (`id`),
KEY `userid` (`userid`)
) TYPE=MyISAM;

When you upgrade 0.9b to 1.3:
ALTER TABLE `jos_uddeim` ADD INDEX `fromid` ( `fromid` ) ;
ALTER TABLE `jos_uddeim` CHANGE `expires` `expires` INT( 11 ) NOT NULL DEFAULT '0' ;
ALTER TABLE `jos_uddeim` ADD `flagged` int(1) NOT NULL default '0';
ALTER TABLE `jos_uddeim` ADD INDEX `archived_totrash_toid_datum` (`archived`,`totrash`,`toid`,`datum`);
ALTER TABLE `jos_uddeim` ADD INDEX `toread_expires` ( `toread`,`expires` );
ALTER TABLE `jos_uddeim` DROP INDEX `totrashdateoutbox` , ADD INDEX `totrashdateoutbox_datum` ( `totrashdateoutbox` , `datum` );

ALTER TABLE `jos_uddeim` ADD `publicname` TEXT ;
ALTER TABLE `jos_uddeim` ADD `publicemail` TEXT ;
ALTER TABLE `jos_uddeim_emn` ADD `public` INT( 1 ) DEFAULT '0' NOT NULL ;
ALTER TABLE `jos_uddeim_emn` ADD `lastsent` INT( 11 ) DEFAULT '0' NOT NULL ;
CREATE TABLE IF NOT EXISTS `jos_uddeim_config` (
`varname` tinytext NOT NULL,
`value` tinytext NOT NULL,
PRIMARY KEY (`varname`(30))
) TYPE=MyISAM;
CREATE TABLE IF NOT EXISTS `jos_uddeim_userlists` (
`id` int(11) NOT NULL auto_increment,
`userid` int(11) NOT NULL default '0',
`name` varchar(40) NOT NULL default '',
`description` text NOT NULL,
`userids` text NOT NULL,
PRIMARY KEY (`id`),
KEY `userid` (`userid`)
) TYPE=MyISAM;

Updating 1.1 and below:
There are two new icons "staron.gif" and "staroff.gif" you have to copy into
/components/com_uddeim/templates/<your template>/images/
Except for "noir" these icons are the same for all templates.